Here is my situation.  I have a combo box on a form.  The combo box is
linked to a qry (qryCustomers) and the form is linked to tblOrders.
The way I currently use the combo box is to place the CustID number in
to the table tblOrders.  My question arises in that I would like to

Hi all and thanks in advance,
I have a frontend/backend scenario where the backend has a tendency to bloat quit a lot over a period of about 5 days. Once compacted, there is not problem but it needs to be done on a regular basis. From the administrator form, I can set the value of ...

I have recently migrated MSAccess Tables (nearly 120) to MySQL. To test
successful migration I want to compare all tables. I have linked MySQL
tables through ODBC connection.
I want to create a report that compares all records between all tables in

I have a simple function - a case statement that returns a numeric
value.  I would like to use that same function in an Excel
spreadsheet.  Has anyone done that before?  I have pasted the
information into the VBA Editor.  How do I call it from a cell in the

This has really been my day for wierd problems sorting one of my forms (a
subform actually)...  so here's another one.
I am now receiving the following error
            Run-time error '-2146500594 (800f000e)':

I compacted a database of about 15MB in Access 97 but failed.  The
error message was "Record(s) can't be read; no read permission on
'Database Path'.".  The database was not set any security and/or
permission on a NT4 file server.  I repaired the database successfully

Hi.  I want to sort the records on my form (using either a continuous form
or a
datasheet) by the unbound "description" column in a combo box on the form
(or in the datasheet.)  Here's a rough text representation of what I'm

Can any one help me with the syntax to calculate the totals of a field? There
are three fields in the query; [XFER/ORDER] which contains the data "O" or "T",
the other [TOTAL LINES] which contains (total lines of "O" or "T") for a
specific [DATE]. I want to display in text boxes the ...

We have just put a new samba server on the lab premises and upgradede all
workstations to 100 MB/s, in order to avoid using 10-mile radio link, hoping
that this would enable us to operae our MsAccess based LIMS database over
the network. While a standalone version, with both program ...

I an using MS-Access in order to build a site.
I have this item that can have upto 10 pictures (might have none)
I want to design a dynamic table which has the ID of the item at the
first cell (primary key) and then upto 10 cells of file names of the

Hi !!  I have been browsing around but have not been able to find a
simple, lucid solution ... or maybe I'm just too confused. I know this
has been asked before by many ... but pls bear with me.
Step 1:

I have read the other posts on this topic, but didn't find an answer
specific to what I need.
I have a main form:  frmFeeInput, which contains 2 subforms:
1) sfrmFootnotes

I've got what should be an easy automation problem, but the solution
simply isn't coming to me.
I've got several public variables set up for automation as follows:
Public gappExcel As Excel.Application  'ADO Object for Excel

Hello..I hope someone can help me with this little that I've been
having for a while. I have a form..which has many fields. one of them
being a test #. what I need a combo box with only certain
numbers[called OOS Numbers] that match that particular test#. One

Private Sub Hide_ShowChangeRegister(val As Boolean)
   Me!ChangeRegister.Visible = val
   Me!Save.Visible = val
End Sub