so I have two combo boxes in a form and I need to be able to look up data
with either one or both, meaning i need one to have an "all" option (or just
be null).  I tried putting this in the rowsource:
SELECT DISTINCT [SNM Data].[SNM Type] FROM [SNM Data] UNION Select Null as

I have a form frm_notes with two sub forms: sfrm_noteAdd and sfrm_noteList.  
The sfrm_noteList displays all the notes ever added to the project.  The
problem is that frm_noteAdd has a save button the user clicks when done
entering a note.  The new note is saved and the ...

So I'm almost ready to wrap this up and I'm wondering about the process.
Is this right?
1 Change db file format from 2000 to 2003
2 Compile

I'm looping every form and each control in it.
Then I'm looping the properties collection of the control.
Through code, I would like to know if a property of a control in a form is
an event one, or format or data or others (I need event properties only).

This seems like such a simple, basic thing, but I cannot get it quite right.
I have an employer form(main form) with a position posting(subform).  I have
added a "cut" command button and just want it to display a msgbox telling the
user that if he/she is in the main form, he/she ...

In my main form I have several subforms under different tabs.  Currently
they're all set up to share a global query so that if a user filters the
records in one subform, all the others will produce the same results
automatically.  Unfortunately I never included a procedure to ...

I have a question about disabling the mouse wheel.  I have used the
MOUSEHOOK.DLL procedure from Stephen Lebans in the past and it does work (I
have the file in the same folder and the module in the database) but I am
looking for an alternate way.  I recently changed companies ...

I want to add a cmd control that returns the user to the previous record
they viewed.  So, I presume that I need to store some indicator of that
previos record (while it's still current) into a variable, and then use that
as the bookmark when returning to it...

I trying to set up a Main Form command button that will allow end users to
open an Excel file "W:\Public Access Folders\Misc\SURFACE DEPARTMENT MAXIMO
REPORTS\Availability Calculator.xls". I have tried a few different methods
that I found in the Community Forum with no luck. ...

I have a calendar form that our employees are using to enter in vacation
days, sick days, etc. My question hopefully has a simple answer.
How do I prevent a user from changing information on a past date? They
should be able to edit future dates where they may have scheduled a day ...

I am scanning a value into a field on a form via a parameter box. There will
be occasions where a particular item had been previously scanned. In such
instances, I'd like the form to show the previously entered data in the form
and allow me to update another one of the fields on ...

I'm getting an error that I don't know how to deal with.
I think the error has something to do with the coding in my
AfterUpdate event of combo28 which is as follows...
Private Sub Combo28_AfterUpdate()

I have a form that when is opened executes a parameter query.  The user Types
in a date and poof the record set selected and only returns the desired date.
 Once the parameter query has been established about 5  different queries
that are based on the original parameter query ...

Do any of the events that trigger when closing a form (unload, close, etc)
fire when you put a form into design view?  I have a main form that is
basically a switchboard, and on load I have docmd.setwarnings false (this way
all subsequent actions have no warnings).  On unload of ...

Worked in older versions. Formula builder would allow us to creat formula in
result column: OnUpdate(column1 - column2) This would put the difference in
the result column and it was in the same table and it was a current and
accessable column of data. I need to automate this and ...