I have a split front end/back end system.  However I create a number of
local tables to carry out certain operations.  There is a tendency for
the front end to bloat so I have set 'compact on close'
I think that I have read in some threads (althoug I cannot find them

I am working with the Toolbar and Imagelist control in Access and as hard as
I look, I cannot find it in the list of available References.  Is it listed
as a different control?
I have checked the registry and it and its classes appear to be registered.

Thank you very much.
ming

In a table I have text field A. I would like to replace all the null values
in field A to a real value, let's say 'Test'. When I use Find & Replace and
I search for 'is null' and I press replace or replace all, no null value is
found, so I can't replace anything. However, when I ...

I have an MS Access app with multiple forms.  One of the forms has a Toolbar
(MsComctlLib.Toolbar) and it works as advertised.  I handle the buttons in
the Toolbar1_ButtonClick event.
I would like to be able to control the toolbar from another form.

How can I make a Query that combines tables, so that if table1 has records
"apples", "pears" and table2 has records "apples", "cherries", the query
result will be "apples", "pears", "cherries"?
Thanks.

I was wondering how you handle active/inactive elements in a combo box.
 Let's say you have a combo box to select an employee.  Joe Blow has
been selected for many record however Joe has left the company and has
been flagged inactive.  If you have a filter on the rowsource like

I have a form on which I have a cmdbutton to copy a couple of fields
into another table (MASTER) using the SSN on the active form as
criteria.
In the active form (based on a tables called LIST) the ssn fields is

At work, employees have been using a spreadsheet that I am trying to
import into an access database to make some reports.  The problem I'm
having is that in the spreadsheet, they are storing the same type of
information in multiple cells.  For example, for each machine in the

On my report I am currently using page footer to display some
disclaimer information.  No matter how many records show up in the
detail section, the page footer is always at the bottom of the page.
Is there any way to bring it up to the bottom of the detail section

I've created a SQL pass through query in MS Access which executes a
stored procedure on Teradata.  Is there any way to programatically
modify the querydef for that query?
TIA,

Here is my table design:
tblEmployers
 EmployerID autonum (primary key)
 EmployerName text

I have a subform within a tabpage that will requery/refresh (?) if I
press F9 and it will update the data in the subform, but I have tried
various combinations of Me!SubformName.requery
Me!Forms!Subformname.requery, etc. to put the F9 functionality into VBA

If Variant type is the data type that contains any kind of data type is
there a reason why one would not always use Variant when declaring
variables?
Thanks

I have an Access 2003 database application consisting of a frontend on
each user's desktop and a backend on a network drive.  I have been
asked to move the backend into a folder that the users can't actually
see from Windows Explorer - a folder for which only a few of us have