Beginning a transition from Office97 to Office 2007 (installed on
Windows XP). We have numerous Access97 MDBs distributed as runtimes to
client PCs. For Phase I testing, on one client PC I have removed
Office97 Standard and have installed Office 2007 Standard, retaining

Is there a way to have a command button that when selected opens a form to a
specific tab control page.  The form that is opened contains multiple tabs
with with corresponding pages.  Unfortunately, I cannot use the OpenArgs of
the docmd to set focus because this form is the main ...

I've used recordset.open <query string>, CurrentProject.connection to run a
query on a table.  How can I save the results of such query?  I would then
like to show the query results in a listbox and so I'm trying to write the
results to a query which is already a data souce of ...

I have an application that some people will use with SQL Server and others
with Access.  There are a few differences I need to cater for with SQL Server
such as stripping off the dbo_ from the front of linked tables.  Is there a
way to check a linked table to decide if it is ...

What does this error mean and how do I fix it?

I have the following field in a query.
DLookUp("gl_perod_id","ingres_gl_perod_tbl","[gl_perod_stdt]<=" &
Format([BegDate],"\#mm\/dd\/yyyy\#") & " and [gl_perod_enddt]>=" &
Format([BegDate],"\#mm\/dd\/yyyy\#"))

hi does anyone know how i may be able to retrieve ONLY the fields in two
identical tables that do not contain matching values? i currently have a
database that i need to log user changes. i am appending the original record
to a table using the beforeupdate event on a form. And i ...

I'm trying to use the following code to determine whether I need to drop an
old view prior to creating a new one. Can anyone tell me why it fails?
   Application.RefreshDatabaseWindow
   DoEvents

Using Office 2003 and Windows XP;
I have set up this sort of thing before without issue and now I'm clueless
(I must be losing it) as to why the following function in a standard code
module generates an error (item cannot be found in the collection

I need to expand a TreeView Node in the Browse for Folder Treeview with
sendkeys.  Right now I can only select the drives and folders that are
visible in the Treeview - I can drill down into subfolders.
Does anyone know how to do this?

My issue.... I am trying to determine the overall status of a record
based on seven status categories.
STAFF
DEVELOPMENT

I have a formA with a sub form, and the main formA has a field named
PackingNo.
Now I would like to duplicate all records in formA and it sub form several
time, (exp. 5 times) and the number of time to be duplicated is written in a

I'm trying to determine if a number is a multiple of another number.  
For instance, I have a table set up that shows the following:
Widget     Increment
A            5,000

hi, i am writing an upgrade for a legacy access 97 application.  My new
application (written in .NET) will upgrade the existing access 97 app to 2003
upon completion of the installer.  I have been successfull in converting the
97 database using the application ...

I am trying to script removal of a field from a BE:
Dim FilePath as String
Dim db As DAO.Database
Dim tdf As DAO.TableDef