Thank you in advance for any and all assistance, it is greatly appreciated.
I have an application I'm migrating from AC97 to AC2003 and the copy macro I
created in AC97 won't work in AC2003. Is there a way to copy and paste in
AC2003 that's built in?

When I use the standard "Filter By Form" button, each control is usually a
combo box with the preset choices of "Is Null" or "Is Not Null". But
sometimes a control will be a combo box with the preset choices of every
unique value that exists for that control in the unfiltered record ...

ich habe mir ein Formular gebaut, in welchem ich durch die Datensätze
einer
Tabelle navigieren kann. Dafür habe ich einen rechts und einen links
Button mit Hilfe des Assistenten angelegt.

I need some help please!
I've created a query to use the AutoLookUp feature, this almost works
fine and well. I have a form to add a new record. On this form the
autolookup feature works, as I select the company, the contact name is

I'm trying to import a range of cells from an Excel spreadsheet into a
table in access.  The first row contains column labels, but I cannot
use those as my field names, both because of their format (number,
space, text) and because I've got a whole bunch of similar tables and

I want to design a database which I then want to use on a website were
users can search information by postcode. Example if they enter TW9
6LB then the database should bring up information regarding
hotels,restaurants,pubs,bars ect for that area. Any help on this as

Is there a way to make the Mouse Wheel have no effect in a Form.  I can
put an event procedure on it, but I am not sure how to make it inactive.
Thank you
Brenda

I've got such problem:
My database is stored on MSSQL Server. I have to write reports for it in
MSAccess. I've got a problem with creating a query which will select records
from MSSQL table with date and time values from given range. The difficulty

You guys are my last hope, despite spending money on books and hours reading
them I still can not achieve the results I need.
I have designed a database in Access 2000 based on 1 table, all has gone
very well with one exception. The table is based on applications made by

I work for a tool & die shop, and we have an Access DB that captures
work performed on each job we do.  Each job could have 5 or more
entries for work performed on it.  I am trying to create a query that
will only display the last activity performed, for each job.

I have a form that has a subform that has a subform.
The subform loads a record based on a combo lookup box in the main form.
I'm trying to set a value in the subform based on a value in a subform of
the subform.

Does anyone have any idea why creating a table link across a network should
be so slow? My front end app follows these steps when opening:
* Retrieve all linked tables in the current database as a recordset from the
MSysObjects table.

Windows 2000
Access 97
I am working on an issue tracking DB, where I need to link (not attach
due to size)screen prints of various system errors.

What is the difference between an intranet and a network? Can a split
database be put on an intranet?
Thanks!
Sue

   Is there a way that I can set the startup form to be invisible?
Many thanks,
Mark