I have a global variable "db" declared in a module, and then in the first
bits of code I execute "Set db = CurrentDB". As the rest of my program runs,
I suddenly have a problem that "db" is nothing. It has been terminated
somewhee and I don't see where.

I haven't posted here before, but I'm not exactly a newbie.
I am getting an error message saying I can't email atable
using:
subject = "Top 20 for London"

I use Access 2000 for a very simple database of members.
I am reasonably confident with generating queries and
reports showing me lists of e.g. male or female members,
or of cities where members live, but what I would like to

Hello Group.
I have a form (frmMain) and on that form I have used the tab control- pge1,
pge2, pge3.  On these pages I have subforms.
I would like the a checkbox on the subform on page1 to make the tab (pge2)

Is there a maximum size for an Access database? If so, what is it and what
should I do when my database reaches that size?

Is it possible for me to import a virtualization skin from my windows media
jukebox to power point and use it as a background while being able to show
words and text in front of it all at the same time? and, if so how can I do
it/

I have a form that displays the clients details when the clients name is
selected from a combo box.
When the form loads the cbo box is empty but the form displays the first
record in the table.

Is there a way to import into ms access, ms outlook tasks?
We are using office 2000
Thnks

Anyone know why this error message would occur when trying to print a form?
I've searched the KB but it doesn't seem to find any explaination.

I created a query by using Access 2002 and opened it by
using Access 97 at another computer and I got a error
message " Unrecognized database format 'a:\name.mdb'. My
question is: can I open a Access 2002 database at Access

I have a form  with all the fieds like ID,Name,Company in
the form header.When I click on the 'History' command
button,a subform will open in the form detail with all the
records of the specific name.(That means the main form and

I have a query which sorts by the user entered
parameters,
between [Start Date] and [End Date]
However, most often, but not allways, I use the same

A2K
I need to set the RowSource of my ListBox to match the recordset on another
form, with a filter applied. How?
Currently the code below works to match the recordset, except when a filter

My clients are having problems connecting to a database in
a share I created. It appears that only one client at the
time can connect but I need multiple clients connected.
I have placed the tables with all my objects on the same

I am trying to make a database form that will allow me to
update data in more then three tables. for some reason
access doesn't like that.
I need to have the following tables updated: