I use ADO.Recordsets constantly to query data from external sources
and append the results into tables in Access databases. A number of
the queries I deal with bring back in excess of 50,000 records and as
many as 700,000 records. It takes hours to sometimes to load the

Hello fellow programmers,
I am trying to run an append/update query from code, a command button
on a form initiates the queries.
the format i am using is;

I have multiple reports in one database, on one form.  I need to know
what reports were run when, and by Network User ID.  How do I do that?

Is there a way to have new data entered into a combo box update the
row source table it is connected to?

I have just sent a demo database to a client.  They are using a new PC
with a fresh install of Office XP.  One of the main forms of the
database is not showing any of its textboxes - just a blank form.  The
database was written using Access 2003 and I have sent them an mdb,

I have a module that appends a table with a report name when that
report is run.  The problem that I am having is that I don't know how
to get and pass the report name to a variable.  Right now, I have it
hard-coded and that is no way to run a railroad!!

I have this database I converted from Access 97 to Access 2000. Front
end on the PC, back end on the server. It works fine, except for one
thing: one of the reports is extremely slow (20-25 minutes to process
less than a thousand records), and even crashes Access sometimes. Yet

When using forms are you best to use SQL or run VB code to load the
data from tables. Or is it just personal preference.
Anyone that can shed any light on this, would be appreciated.
TIA

On a form I have a listbox that is retrieving data in the form's
On_Load event. Now I have two textboxes that will change the listbox's
content. How can I send data in the new, updated and changed listbox
to a report?

I have, essentially, two table structures in the same ms access
database file. Both are of the parent-child format, one parent table
with personal details, then multiple child tables keeping specific
information, all child tables being linked to the parent in a 1-to-1

Main report contains one large graph in the detail band (no detail records).
Subreport snakes just fine (5 columns) when opening by itself.  When I add
it to the main report (in the report footer), it shows just 1 column and
spills over to 5 pages.

I have a forms problem.
Bakground:
I have created a number of tables. Of these, I have a main parent
table (Personal Details) and a number of other child tables (Tax file

example is I'm finding the max number within a certain criteria, and then
adding one to that.  However, most IDs are something like K00001 or R00223
So I want the next ID to be either K00002 or R00224
Unfortunately Access is stripping out the leading 0s leaving me with an ID

Hello everyone and thanks for your help in advance.
I have gotten myself in a muddle with security.
I was playing on a database and set myself up as a user.  I didn't
enter a password but every time i open any database now it asks for

I have a module, when I run it the module does exactly what I want it
to do.  However, in my macro I use "OpenModule" in the action column,
and I put the module name and procedure name in there.  I get no
errors, it just doesn't seem to run the module.  I have tried it with