I have an Access 2002 database in which I have about 100 queries.
Most of them are used infrequently, and a few are used very
frequently.   While in the database window, I'd like to highlight the
frequently-used queries by changing the color of their names or the

I'm making a data entry form that i would like to have display the
operators name.
So far i have a preceeding "Login" form in which the operator inputs
his/her employee number into a text box "txtopnumber".

I have 3 tables (table1, table2, table3), all of them contain same
columns ( id, code, date1, date2, date3) and I need to get out by
'code' field all records that:
1. are in all 3 tables (this is easy - simple join query)

I need to create counter query based on dynamically generated value.
value = 52
some query: select * from table
some result 1

Hi, i have created a database to store contractors invoices. I have
approximately 9 tables and 3 forms. One of my forms(frmContractors)
has all the contractor details and this also contains a sub form which
includes cost details. In the sub form i have included a button which

This is something I can't test (don't have 2007) and found no definitive
answer, but a few conflicting ones.
Will a 2003 database work correctly in Access 2007?
Don't want to do any design work, just execute and use the database in 2007.

I've dealt with blue screens that frequently occur while developing in MS
Access (really bad in Access 97, not quite as bad in later versions of
Access). Finally, I had a blue screen that mentioned a driver: Vetefile.sys,
and I tracked that down to CA Anti-virus. After searching ...

I decided to install Office 2003 Service Pack 3 on my home computer to test
(in full knowledge that there may be some issues with it). After installation,
I have noticed that with a small database I wrote for home, the combo boxes
and listboxes no longer display the bound column. ...

I've developed an app that allows the user to choose a text file to link to
using the TransferText method.  It works fine but I want to mitigate for the
user choosing the wrong file.  I thought I'd do this by testing the linked
file for the existance of a certain header (field) ...

I am creating a database form that has a date field and a check box.
When a user enters a date then I want the check box to automatically
be null and if no date is entered I want the check box to be ticked.
I am quite new to access to please only easy solutions

I would like to know if there is a way in ms access 2003 to add
consequtive numbers to a new column to 'count' the records. This count
should start over by every by variable. for example:
I have a table:

I am trying to run a report using a parameter for where the user chooses a
month from a combo box. Then on the report, I want it to compare the month to
a date field and choose only those dates with the month chosen from the
parameter form.

I am writing a routine to email bills to clients.
The method which works other than a timing problem is this
Run a query on those clients with emails
Create the invoice (This is quite complex) and in order to preserve the

How can I show only the data that is not null without suppressing
the record containing the null data?
My Table (Driver) looks like this:
ID   ID2  ID3   Color    Car     Name

Is there a way to have in 'Match' field in the Find and Replace
window
to have something other than 'Whole Field' as the default.