I'm having trouble continuously page numbering a large report in MS
Access. The report is made up of three separate Access reports which I
join together at the end.
In the past I have opened the reports and viewed them to see how long

I want to achive the same in MS Access 2000
How to do this in Access
Select Companyname,Counter = IDENTITY(int, 1, 1) into Custmoers2 from
customers

hello, i have a question about compactin/repairing a database at
runtime.
i have code that will do this, but when it runs i get the error "You
can't compact the open database while running a macro or visual basic

An access 2000 database is used by a number of users on a windows xp
professional machine. Users logon to the machine  using their own
individual windows login name and password.  The database is in a
folder acccessible by all users. One of the users reported that the

I am stuck with a problem in MS Access which does not occur in SQL
Server and I have been banging my head against the wall for a couple of
days now trying to resolve it.  Namely, when I execute the following
query in Access not all records that fit the condition are returned,

Hi Friends,
Hope you're doing great. We are looking for Software Professionals
with about 7 years of experience and willing to work for the World's
Biggest Software Company - Microsoft.

I have a backend and frontend. A client of mine compacted the backend and
some one tried to lock in ( I think this is what happened)  and now we can't
compact it anymore.
I believe the problem is a registry setting.  Why, because if we move the

SendMailPlusWithOE Subject, Message, Recipients, Files, "08"
I've seen the above syntax used to call the sub SendMailPlusWithOE
Is it correct/incorrect/good practice/bad practice or just a matter of
personal preference?

I have noticed that whenever I set a form's RecordSource property
in code it launches the form's OnActivate event.
In one of my application I set a form's RecordSource to zero lenght string
during the form's OnClose event

I have read that using the database splitter is good because it allows
multiple users to access the database simultaneously. However, is it
trully necessary to have multiple FE MDE files or can everyone just use
a single MDE file that is located on the network drive?

I'm getting the error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Disk or network error.
This error started from nowhere, from one moment the web sites were working,

I enter some data in access via ASP which records some goods that are
purchased.....only their quantities.....not rate of purchase or
anything else. Those goods go for manufacturing at rate 0. Later on
when I get an invoice for those goods I enter their price / rate / etc.

I am using a form with a textbox and a cmdbutton to search for records
in a table. The result will be displayed using a form.
This is the code behind the txtbox:
DoCmd.OpenForm "myform", acNormal, "myquery", "", , acNormal

I have a textbox on a form with an input mask for SSN.
A cmdbutton runs the query and if the record is found, it opens a form.
The SSN field I am searching is in a table called myTable and has the
format 000-00-0000XY (meaning 13 characters).

I'm trying to calculate the food allowance for the household employees
in the diplomatic mission where I work.
For each employee/month I have a subform with a maximum of 3 records
for Breakfast, Lunch and Dinner.  For each type of meal, the subform