Creating a form for a Password
I have created a Password form that will secure another form. Once the
password is entered it will open the form that has the list of reports. On
the form I have a text box that accepts the user's password and I have 2
command buttons one is OK and the other is CANCEL. Can anyone tell me how to
make these buttons work to open the form of reports?
On Wed, 10 Oct 2007 13:52:00 -0700, mrsgwen wrote:
> I have created a Password form that will secure another form. Once the
> password is entered it will open the form that has the list of reports. On
> the form I have a text b...Adding data from one form to another
Working in MS Access 2003
I have one large table (Truck) that has at least four separate
delivery addresses per record.
(E.g. four fields, Deliver1, Delivery2, etc...)Also in this table are
text fields that have special instructions such as on what days these
addresses make deliveries. Theses days vary by address.
I need to separate out these addresses into a single record in a new
table (Location) and enter its delivery days. (Thus potentially, the
one record in the Truck table will result in 4 records in the Location
I have the master form (TruckForm) designed so that the truck num...Report can't print form field
My report heading contains a text box with the following data source:
="Transactions since " & Forms!frmPrintTran!txtDate
The on-screen preview shows the date fine, but on printing, this textbox
The form remains open during print.
Happens with both Access 2002 and 2007, DB structure A2000. What gives here?
This usually happens when there is code in the On Close of the report that
closes the form.
Microsoft Access MVP
> My report heading contains a text box with the following data source:
> ...Forms Check Box cell link
I am using a check box created with the Forms menu. I created a box over
cell D4. Using the Format Control box, I linked the check box to cell D4. I
want to copy the check box in cell D5, D6, D7,.... and I want the cell link
to integrate in the same mannor; check box in cell D5 should link to cell D5,
and so on.
Is there a way to accomplish this short of going into the format control box
and manually editing each cell link after I have copy and pasted several
check boxes? I have NOT entered the link using an absolute cell referense.
I got the idea for this from Dav...Customizing Forms Wizard
It is possible to control or customize details of the way the wizards creates
For instance, we have internal naming standards for controls and I would
like the wizard to name each control according to our standard.
I know I can use a form template for the forms created without wizards, but
what about controlling the creation of the ones done via wizards too?
Thanks in advance,
See if this helps:
Román Valoria wrote:
>It is possible to control or customize details of the way the wizards creates
>For ...Form Menu : Check Box
I am trying to enter 300 or so check boxes onto and Excel spreadsheet.
I find that I can link the 'return' cell using the right click / Forma
Control / Control tab / Cell Link option but I need to do this for eac
Is there a way around this ? Whereby I can create one Check Box an
then drag or copy it down
jagstirling's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=110
View this thread: http://www.excelforum.com/showthread.php?threadid=50634
Maybe you could jus...Access-Forms-VB links
After years in software development/database programming mostly on
Unix/Oracle I'm tasked to change some Access forms to use redesigned
tables. I'm having trouble with the relationship between forms and VB.
For example I'm looking at some VB code that frequently references the
Me class which I assume to be the default reference to the current
(form) class (like this in C++), but I can't see how/where the class
is actually defined. Can someone please provide some links that
provide concise explanations of the relationship between Access and
VB. My googling has only turned up pag...can a form display current table field names?
I need to create a form that will display the current field names resulting
from a make-table querythat can change from audit to audit. This way the user
is always aware of the "current" field names in their dataset.
Currently, a form displays the structure from a linked (text formt) table
that I have to manually export every time the make-table query changes and
I'd like this to be generated from a macro or from code.
I thank you,
This article illustrates how you can list the field names, types, and
descriptions for a table:
...Sinking MS Access form events from MFC console app
I'm trying to sink MS Access form events using technique described in <<HOW
TO: Handle Events for Excel by Using Visual C++ .NET
Of course I did do all the needed code substitutions etc.
All works rather well, I mean I'm getting to MS Access form
But the last code line -
hr = m_pConnectionPoint->Advise(m_pAppEventListener,&m_dwConnectionCookie);
doesn't work and returns hr = -2147220990.
Here is MS Access form events interface ID I use:
const II...Excel template to load automatically as the default template?
Is there anyway to set an Excel template to load as the default template.
Place it in your XL Start folder.
>Is there anyway to set an Excel template to load as the
...Linking Form and Report
I have a Main Entry Form for the entry of installation data. I have a
Report set up to be used as an Audit tool. I would like to have the Audit
Report pop up for review when the Save & Close button is depressed. The Form
and the Report are linked by Folio No, unfortunately I have not been
successful, when you push the Save & Close the form opens but its blank. I
have checked the underlying tables and the data seems to be there. Is there
something unusual about trying to attach a Report to a Form at all.
Private Sub btnSaveRecord_Click()
On Error GoTo Err_btnSa...Passing Values between forms
I am trying to link to forms. I have a button on the main form
(frmCompanies) that needs to open another form when a button is clicked. The
new form that opens is frmScheduledActivities. When it open it needs to check
to see if there is an existing record (scheduled activity) for the company
and if there is no scheduled activity be set to add a new record.
When the button is clicked on the main company form (on the on click event)
this code runs:
Private Sub cmdCallBack_Click()
On Error GoTo Err_cmdCallBack_Click
Dim stDocName As String
Dim stLinkCriteria As String...Return Value from Form
I need to return a value from a form displayed modally.
Many years ago, if I used VB classic, I could create a public method that
took care of any arguments, displayed the form modally, and then returned
appropriate return values. Something like this:
Public Function GetValue(Args As Integer
m_Args = Args
m_Result = DefaultResult
GetValue = m_Result
However, it appears Access VBA doesn't support this. For one thing, there's
no Show method (and so it certainly can't have a modal argument).
I like this approach because ...Display Query from form in Foreground
I have a form upon which the user selects display, filter and sort fields.
He then clics the submit button and a query is built and then displayed with
the following code:
DoCmd.OpenQuery "Queryname", acNormal, acEdit
The query works but shows up in the background and cant be clicked on until
the form is closed. The idea was to create a form on which the user could do
adhoc queries until he gets it right and then click another button to do the
Excel extract. Is there a way to show the query in the foreground?
On Tue, 22 Jan 2008 17:54:27 -0800, rmcompute wrote:
> I ha...User Form Security Question
I'm creating a form, which onces completed transfers the data over to
the spreadsheet. But the guys in work don't really pay much attention
to what they have entered , so i was wondering is there any way to make
the user double check every entry?
I was thinking, once the user clicks ok, a msgbox would appear giving
the user the value they entered, click ok if correct or cancel to
Is there a easy way to do this?
harpscardiff's Profile: http://www.excelforum.com/mem...I did do an update today form Microsofts update page #2
If I can remember correctly, it was 2 new items that came
out today for the OS. Could that have casued this. But it
worked Ok afterwards. Nothing else installed in the last
...My Project Templates Not Showing
This was posted this in m.p.vstudio.general but didn't get a
response. It needs to work or a lot of effort might be wasted.
I created a project template. When I go to File/New/Project or
File/Add/New Project the template doesn't show. An added item
template shows and works correctly. For backup purposes, the
my template directories are in the same directory as the project
directory, not the default. In both casesVS placed the template
..zip files both in my directory and the ...\My Documents\Visual
Studio 2005\My Exported Templates directory. My similarly
confi...Receipt template for Epson U220PD
Where I can get a receipt template for Epson U220PD in RMS. The customer
complains of a waste of paper as there are many line spaces and the paper
feeds an extra lines.
You need to modify the margins on the receipt.
Advanced Computer Systems
Please tell how.
"Jason Hunt" wrote:
> You need to modify the margins on the receipt.
> Jason Hunt
> Advanced Computer Systems
SO Manager | Database | Registers | Receipt Formats | 40 Column Receipt |
Properties Button of the Sales line | Don't remember the...How to I stop the form from resetting
I have a table linked to the header of my form. The table has for records.
Here's what happens. When I choose a record (say record 3) record 1 ALWAYS
The form is meant to be printed out.
Can someon please tell me how I can get the record I choose to print out?
Thanks in advance!! :o)
Although it is possible to print a form, it is not advised. You will get
better results if you create a report and print the report.
Dave Hargis, Microsoft Access MVP
"Printing only filtered data in a form" wrote:
> I have a table linked to the header of my form. The table h...Pass Through query with criteria on a form
I have a Pass Through query that looks like this.
sd_term_name_loc as 'Location',
sd_term_city as 'City',
sd_term_st as 'State',
sd_term_cntry as 'Country',
from detail (nolock)
-- ***** The dates below refer to the date and time at which the
transaction was loaded to PRM.
-- ***** The number of pings which have occurred BETWEEN those dates/times
will be counted.
-- ***** Enter the date/time in the format '09/16/2007 14:00:00.000...issue with serial port on module, updating form
Ive created a serial port instance on a module. In the same module I have
the sub data_received.
Now I'd like to update a control in a form, how can I do it?
Thanks in advance
You need to use Control.BeginInvoke or .Invoke to update the UI via a
Delegate. You can download the VB2005 Terminal example from my website,
which illustrates this.
Richard Grier, Consultant, Hard & Software 12962 West Louisiana Avenue
Lakewood, CO 80228 303-986-2179 (voice) Homepage: www.hardandsoftware.net
Author of Visual Basic Programmer's Guide to Serial Comm...How can I put photos in Microsoft Access Form
I used the information BobLarson said in putting photos in Microsoft Access
Form but it's not working. My computer keeps asking for Form1, which I
deleted because nothing was happening the way I wanted it to. What I would
like to know is there a online video that can show how you can do this
procedure. And how can I get my computer stop asking for Form1.
"Helen" <Helen@discussions.microsoft.com> wrote in message
>I used the information BobLarson said in putting photos in Microsoft Access
> For...Template site will not allow me to download
When attempting to download a template from the MS website, after the terms
of agmt page, I am told I do not have Publisher and cannot download the
I have downloaded Word & Excel templates with no problem. I have Publisher
2003 which came installed on my computer. Windows XP, Office 2003.
More details (don't want to get flamed):
Running Publisher 2002 not 2003
My specific question is: How can I get the website to recognize my .exe so
that I can download templates for Publisher?
> When attempting to download a template from the...This form Requires Word
I am reasonably up to snuff on Outlook and have used it for as long as it
has been around. I am running Windows 2k Pro and Office 2k Pro and Outlook
is configured to use Word as the default email editor. It does so quiet
well both composing and reading email, except when email is receives from
one particular person, one out of hundreds. This lady <the sender> is also
using Outlook 2k pro and windows 2k pro and word as default editor. When I
receive mail from her and try to open it I receive the message
"This form requires Word as your email editor, but Word is eith...transfer publisher template to word
i have a made a greeting card from a template a friend has offered to print
them out but does not have publisher on his computer but has word on his
computer is there any way to change the format so he can open itv in word??
paul 1 wrote:
> i have a made a greeting card from a template a friend has offered to print
> them out but does not have publisher on his computer but has word on his
> computer is there any way to change the format so he can open itv in word??
You would have to copy/paste the template on your computer, by opening
the Publisher template, then opening Wo...