Hi all, Thank you for taking the time.
I have a database with 45 tables on it. 44 tables are linked to a main
table through a one to one relationship.
My question is, is there no way i can have a query that will pull a

I'm trying to set a tabledef object from a form object's RecordSource in
Access 97. This is the code:
Public Function EditSubjectForm(ByVal frm As Form) As Boolean
Dim db As Database, tbl As TableDef

I know MDM.EXE (Machine debug manager) is important in debugging scripts, and that it is
installed with MS office. However does it have to be on the startup menu? That is, does it
have to be started when the system is started, or does it also automatically start when
any of the ...

Where in Access are the features to run SQL queries and view tables on an
Oracle server?
Thanks.

I wrote the following code:
DoCmd.OutputTo acOutputTable, "tmpWorkSheet", acFormatXLS,
"C:\WS.xls", False, ""
   Set oWordDoc = CreateObject("Word.Application")

...or lack thereof...
I use Access 2000 which I own as part of Office 2000 Professional. I've had
enough trouble with glitches to ask if these are common occurrences -
1. Sometimes the "Help" system won't start. Sometimes it will. It starts

Here is my situation. I have multiple labels on a form but only
certain ones will become visible while using the form. Depending on
which check box(s) you pick, on another form, determines the labels
that appear. I have that much working as of now. What I need to know

Thank you in advance for all of your patience and assistance. It is greatly
appreciated.
I know there's a way to bookmark a record in code, but for the life of me can't
remember it, nor can I find it on Google. Anyone help with this simple problem?

I have an Access 2000 MDB with the Usual FrontEnd/BackEnd Arrangement.
The program depends on being able link to "Inbox" in Ms Outlook 2000.
This is easy enough to do from the FrontEnd and has been OK while me
and the missus have been using the program ourselves.

I am writing a database that handles all of the information for
courses offered at a school.  Each course  id is unique based on
school year id and course id.  I need to duplicate the course names,
and other related infor for the next year.  How can I best accomplish

Sorry to ask a silly question, I am 'self taught' in using access vb and  I
came trying to use fIsAppRunning to see if excel is running in the
background but when I try and compile the code I get a compile error 'Sub or
Function not defined'.

ACCESS 2k
I need to design a report based on a rota system for staff at various
shops.  The data is effectively stored in a single table, along the
lines of:

I cannot figure out how to synchronize 2 replicas using VB code.
I have tried many variations, and there are surprisingly few examples
in the newsgroups.
The synchronization is working perfectly using the

Thank you in advance for any and all assistance, it is GREATLY appreciated. I
was wondering if there is a way, with code to create a query for every table?
Or can you use a naming convention in tables and use a wildcard to create a
query for any table meeting that criteria?

Hi People,
Does anyone know how to start a mail merge with ms access to ms word?
At the moment i select the records i wish to merge with a query, get
the results, then select Office Links from the menu that goes through