How create serial number of record in report created from query

My form has code that prevents the saving of a record until a certain control
is filled in.
When a user runs a spell check on another control, my error message is
displayed indicating it is trying to save the record. Is this the case and if

I am importing an excel spreadsheet into access and I get an error
message"Subscript out of range"

I am working on some checklists (7 versions to be exact). Each of these
checklists has a butt load of checkboxes. They are set up in pairs. For each
pair, only one of the checkboxes can (well, currently, should) be checked. So,
if you check one, the other should uncheck, and ...

In my form a user choose Tools-Spelling with cursor on the first character of
a control. Sometimes I get a message 'Spelling Check complete' with position
on the same record. Sometimes the spelling check goes off the current record
and onto another record. What determines this? ...

I am running a query on a current table. This query renames the titles for
the fields to eliminate spaces. What I am wondering - can a query create a
table that constantly gets updated. I understand there is an 'update query'
but it does not factor in new entries, or at least ...

I'm trying to use a Sub Procedure with optional arguments but I keep getting
an error when I call the procedure excluding the optional arguments. I've
tried overloading the procedure but I get another error.
The error I'm getting is "Run Tim Error '19': Object variable or with ...

I'm trying to create a form that automatically fills in the City and State
fields when the user enters a zip code. I have followed microsoft's
directions for creating an AutoLookup query. I have studied the Order form in
Northwind. It works in Northwind, but my creation is a ...

I have a database which exists on a server. I want to query out a part
of it into ACCESS based on the week. The dates will change every week.
Is there any way to automate this?

I need to manage quite a few resumes - is Access a good tool for this?  If I
am searching for a medical front office manager, can it sort through all of
the resumes and pull up just those that have those key words?

I was wondering if it is possible to setup multiple tabs in a access form. I
would like to set it up where I can enter a employee stats such as call time
productivity and Utilization. I tried to set this up already and it seems
each tab has the same information that is entered in ...

I need to make an Access report that lists across the top of the page
(columns) the names of the months of the year.  In the rows, I need to count
the number of  services delivered by staff members and I need the count to
display under the  appropriate month name.  So:

how do i create a query which will pull up a list of matching records. for
ex: If i enter "main street" in the address field it should list all the
records that contain "main street".
then i want to create a form to display this data?

I was poking around in the design view of my forms and aparently I turned
something off - that I need turned back on! When I open my Forms now I can't
get into the design view anymore. I looked on the internet and help files and
it says to hold the shift key down while opening ...

I've created a form and I want it to open to a new blank record, but still
allows for users to enter data in any field that then returns matching
records. I have used a database in the past that did this but I'm not sure
how to make it work myself. I'm mostly self-taught on ...