I have two text boxes that ar epopulated by the the user's Windows log-in,
and their name, which is matched to their log-in via a table.  Is there a way
to have the two values (Person's name and NT log-in) be entered into fields
on a different table?  Currently I have this code ...

I am having trouble with my form fields with currency format.
When one chooses "currency" in the format property of a field it pics up the
regional settings of windows (with is euro in my case).
Running the form the formfield shows 1,00 € for instance.

Is there a way to forcibly save the main form before
user clicks on the subform???
Any ideas are greatly appreciated. Thanks.

I've created a function that first checks to make sure if a form is
open and then if the form is open returns the value of an option group
on the form.  The function is run in a crosstab query which uses the
returned value to filter.  However, when the function is run I get a

I have a data entry form with several combo boxes, text boxes, ect.  For one
of the combo boxes, if "NONE" is selected, i wanted to know how to restrict
data input (gray out) all other fields on the form to restrict data input.  
How can I do this?

I am having problems being able to track when CTRL and C are pressed at the
same time.  I have added the following to the keydown event of my Flexgrid
control:-
If KeyCode = vbKeyD And ((acCtrlMask) <> 0) Then

I have a table which contains contact information for individuals. The fields
in the table are Nbr, Name, Address1, Address2, City, State, Zip, Zip+4,
Phone_Nbr, Fax_Nbr, and Email. On the form, there is a combo box which
contains the Name for the users to select, and if they ...

i can capitalize a word or set of words with
StrConv([ControlName],vbProperCase).
However names like O'Connor are imporperly capitalized.
An obvious solution is a reference table of names which might be subject to

Dear Group,
I've got a rather bizzare bit of control behavior that I need help to
understand.  
I have a form with two controls, a textbox called txtList and a toggle

Hi everyone!  Using A02 on XP.  Not a programmer, but loving learning.
I have a form that imports a .txt file and then pulls few bells and blows a
few whistles to spit out a .xls file to send to a client.  Each table is
named the contract number that has been selected on the form. ...

Basically I have 5 forms open, FormB and RostYA1 to RostYA4. Now when I
reach RostYA4 I need to close all forms except FormB. When using docmd.close
acform, name, acsaveno it closes all the forms I want except RostYA4 (Which
I'm currently in)

Can anyone tell me how to set up a form tht filters  tables.
I have a form for inputting data into a table, I want a virtual copy of the
input form and use this as a search form where users can type in criteria and
filter the records, for example one of the input fields is name, ...

Hi1  I know there are many postings on refresh & requery but I have not made
my program to work.  
I have main form & and subforms.  Within one subform(datasheet) I have
dropdown field called "Program", if user want to add new program I have

I have a form with a search box,  when I type in a policy number the policy
number will appear in the txt box  next to my search box.  For every new
record I will assign a user thru the combobox, but I want to do some sort of
batch process.   For example -  I like to continue to  ...

How do I filter a lookup field (call it 'Brand') by first specifying a
product in a previous lookup field (call it 'product')? - ie. If I select
'Microsoft' in lookup field one, the values of lookup field 2 changes
accordingly.