Ok folks- I’m a first time poster, and I need help, because this problem is
driving me bonkers.  I’ve tried DoCmd, SendKeys and requery method (over and
over), reviewing all the previous posts, and all does not seem to be working.
My subform is not refreshing with a button press ...

Hi  I would like to create a [Colour] field in table that would turn the
row/record into the colour based upon the value of the [Colour] field.
Meaning if the word "red" is type into the [Colour] field, the whole
row/record textcolour would turn red. And if value "blue" is type into ...

Hello NG!
I integrated two subforms (Sub1 , Sub2) in a Masterform.
In Sub1 I have basic informations of different suppiers (e.g. Name, Street,
Tel,.)

The error message require data for these two fields.  How do I tell the app
to re query and close if the two fields have values?
strTitle = "Change Composite Data"
   strStyle = vbOKOnly + vbInformation

I have msWord as an embedded object on a tabbed form, the 1st time I click
on its tab the change event fires the below code and opens word in edit
mode. If I click another tab it automatically exits word from edit mode. But
the next time I click on msWord's tab, it does not open ...

I have a form that is used over and over each day.  The first time it is used
is frome scratch but the rest of the day (10-15 times a day) it is pulled
from the Sent Items folder.
First thing I do is to see if they want to resubmit the form.  If they reply

Is there a way to hide the control box for the main access window?
(I'm not interested in hiding access - I know about that option)
I have a nice new custom menu for my reports that only has a close button,
but some users still want to click the main access window close button ...

I have the proper references set up so that I can create new WebBrowser
variables and see their members via auto-complete lists, but I can't
figure out how to get access to realize that the "object" on my form is
indeed a control it can recognize. Consequently when I address my

I have a simple question, but lack the coding.  I need to copy the value
from one control named Date to 15 separtately named controls and assign a
macro button to do this.  Could somebody please help?
Thanks much,

I have a main form that has a listbox on it, and a subform that displays a
lot of data.  How can I get the subform to go to the record that is selected
in the listbox?
Thanks in advance!

Can someone point me to a source to help me build a validation process.
I have a form where the user is required to enter a [disposition]. I want
the user to either pick one from the list (simple part), or enter a number &
letter sequence (this is the difficult part) that must be ...

I need to show a blank in my calculation field instead of #Div/0! when one of
my numbers is a zero.    The code below was given to me and I do not
undertand it.   Please explain how to do this in Novice level, please!
2/10 = .4

My form has a button to allow a user to view or add a record if one does not
exist in an associated table.  Coding for the button is shown below.  It
works fine if there is a record and "works" to the extent that it creates a
new record, but does not display grantee and address ...

Using MS Access 2003 Pro
On a form I have a command button set to print selected records.  On a data
input form, there is a check box (default is checked) that identifies the
record(s) to print.  When the button is clicked, all records with a check

I have just added a new record with ShowName = Int'l Lingerie Show
After my save this shows up in my combo but when I select this entry I get an
Syntax error (missing operator) in expression
rs.FindFirst "[ShowName] = '" & Me![Combo43] & "'"