I have an obscure problem with a simple Access 2003 database that
probably has an obscure cause.  The database consists of a main form
with a subform.  I have used the subform instead of a tab control.
The Sourceobject of the subform can be any one of 5 different forms.

My employer has asked me to create a database that will keep track of
the employee attendance. Time off / Time earned, excused / unexcused,
etc.
At my company from the 6th month of employment to the second year you

I am getting the following error after hitting a command button that I
have on a form to sort information on the screen:
"The expression you entered has a field, control, or propertyname that
Microsoft Access can't find.  Error Number 2424"

If I close and reopen the form I lose its changes even if I set acSave
to yes when closing.
So I'm trying to keep the form open throughout but making it visible
only when necessary.

I need to group multiple tables in to a pivot.
Could some body help me.
Thanks in Advance,
Thyag

Within the form “frmIncidentForm” I have a textbox and a command button.
I would like to disable the “AddIncident” button when the “IncidentID”
textbox is NOT empty. If possible I would like the code in the Forms Event
“On Current”.

I have always just got a count on records and put up a box at the top
of the entry forms saying something like 1 of 500 and updating it as
you got to 500 of 500.
I have never thought of this as meaning anything just a reference.

I have a managers menu, which I would like 2 managers to open when
they want to update some tables with new users etc.
I was thinking of putting a message on the button to say that if you
are not a manager then you should not access that form, then close the

This is a strange one. Would anyone know of a strategy for querying a
table, looking for nulls in a particular field, then filling those
with a sequential number starting at the one after the last number.
e.g.:

Who is the creator?
(40:64) Allah, it is he Who has made for you the earth as a dwelling
place and the sky as a canopy. and has given you shape and made your
shapes good (looking) and has provided you with good things. That is

Greetings all!
My problem is this.  I've installed a new printer on my computer.
This is the "default printer" for access.  Now, some of my reports,
which were working fine with the old printer, are now showing up with

I'mtrying to apply a validation rule to a form field where all
characters and numbers are allowed, along with these:    . ( ) * '
-
However, despite extensive Googling and reading, I'm unable to locate

I have a form whose rowsource is a single table, i.e. 'Datasystem'.
I use a combobox to search for records in that table based on the
value of a single field, i.e., 'systemname'.
I use a multi-select listbox to filter the form on a different field,

I have used CreateObject("Scripting.FileSystemObject") to get the disk volume.
Is there any other way of get the disk volume other than using the FSO.
Thanks

I'm trying to open a PDF file from a form in access 97.
I've tried followhyperlink a few different ways, and I tried hard
coding "hyperlink address" into a form label.  The only result that I
get is that the reader opens, then immediately closes.