I have been getting errors with a class object in the code
editor in Access 2000.  Tons of memory errors and others
too.  So I deleted my report and removed all references to
it.  Now I'm trying to delete the VB code that was

I am trying to create a button that find the file location
of the Access database that I am working in and then names
that as a string.  The location I am looking for is the
location that you get if you go to File>Database

When I want to add a record by opening a form with one or
more of the fields taken from a field on the first form
how do I do that? e.g. When the user clicks on the New
Appt button on frmPt it should open frmAppt for an

Using ADO in Access97, I'm trying to use the .Find method
on a recordset. The recordset was opened with adOpenStatic
and adLockReadOnly. My code won't run, it keeps telling
me "invalid use of object", and highlights the "rcs.Find"

I need to get the computer name (the one one can see in the network identification tab) using VBA. Is that
possible?
TIA,

I wrote a program and the customer keeps loading multiple instances of my
program on the same machine.
Is there a way to see if multiple instances of the same program is trying to
be loaded and keep them from doing this?

I have a memo field on a form that contains HTML, what I
want to do, at a click of a button show the contents in a
preview window maybe MS explorer or Netscape.
Can anybody help?

I've got problems in declaring a variable in Access 2002
(part of Office XP) as "Database"
There is plenty of sample code in the help with Database
as type but it produces a compiler-error (and also it