I can't seem to get the OnDirty event to fire when I edit data in a
continuous form.  Any ideas?

relative novice to Access coding ...bear with me :)
this works DoCmd.ApplyFilter , "" & Combo185.Value & "  =  " &
Combo186.Value & ""
this works DoCmd.ApplyFilter , "[val_pass] = 1"

I have a master form with seven fields named tFeedBack1,
tFeedBack2...tFeedBack7. Each of these fields are found on seperate tabs
within the form.  Each of these fields has a button I use to launch a new
Feedback form that has one field tFBNew. (same form will be used for all)  I ...

I have 18 combo boxes that contain the choice of Yes, No, Partial, N/A.
I have a text box called "YesCount", "NoCount", "PartialCount", "NACount".  
I want each of those boxes to count the number of Yes, No, Partial, N/A
selected on the form.  How can this be done?

dear friends,
i am developing application in access2003 and before distribution converting
it to access97 format  just to over come the problem of library reference /
functions , which may avoid run time errors. is there any sophisticate way of

I have a situation in which there is a parent with many children that the
user wants to see inside of a combobox.  The parent would show as normal in
the combobox but the children to that parent would be underneath and
indented.  The sample below is what the users are looking for ...

I have a problem with FileCopy function.
I need to copy several PDF files from original folder into another
folder and change the name of files.
I expect following -statement1- to copy"102 SPI.pdf" file from its

If you are closing a form and reshowing an invisible form is it better to...
A. Close the current, then reshow the other form
or
B. Reshow the other form and then close the current form.

Operatind system is windows xp
I have installed Access 2007 and Microsoft Office Access 2003 on the same
computer. When I run Access 2007 after you run Access 2003, Access 2007 takes
several minutes to repair itself and vice versa. Open windows installer.

dear friends,
how to get the width of my monitor ?
me.width, me.windowwidth , me.insidewidth . which one plese.
for eg:- i have two cmdcontrols on my form header at exactly 1" from left

I am using the cotnrol tool tip to provide definition of several controls so
the user will be able to hover over the control (actually the label of the
checkbox) and see it.  It worked at first but now the hovering over no longer
works and it is puzzling.  The mdb is made into a ...

I have a database that is being shared by multiple users. In the
database a stored query exists that works without issue over 95% of
the time. As a matter of fact I just counted - it has failed 26 times
and worked over 5,000 times.

I'm using ms access 2000 and have a form whos visible property is set to
false.  When I'm attempting to set it visible in code to true it still will
not show up.   In the debug window the visiblity says False...  When I set it
to visible = True, the forms visible property is ...

Hi ALL,
There are three messages appearing at different condition that i want to
have in my save button. I have the following code and I am having problems
with the if, elseif, else statement (or maybe i am not supposed to use the

I am trying to build a form with 2 checkboxes.  When I use debug to look at
the values of the checkboxes, when I load the form, the value of the
checkboxes are NULL.  Then, I checked one of the checkboxes and the value is
-1.  So my question is if the checkbox is unchecked, ...