I build a query, and find that when I close, and go back to it later,
the query is wrong.
For example, if I use 8 fields, it loses the correct field references,
and instead has 8 occurrences of the first field I select.

There is a file of students in Outlook (located in Contacts).
These students are also used in my MS Access 2002 program.
But we have to type everything (all the student information) in again into
Access.  Is there any way to access the student information from the

Thank you in advance for any and all assistance. It is GREATLY appreciated.
I have a ckPrint box that is used to select print items. I would like to know,
how I can programatically uncheck ALL the checkboxes, once all the selected
records are printed? I would also like to know if ...

I recently made a very simple little function:
Function x()
   Dim Tbl As TableDef
   Dim fld As DAO.Field

I am trying to export a report straight to RTF.  At the moment when I click
on export an output to box appears asking which format (HTML, Excel, MS DOS,
RTF, Snapshot).  I want to skip this and save to RTF automatically.  I have
searched and can't find a solution.  My code looks ...

I ran my Access 2002 program, but the .csv files were not available.
Is there anyway of the program telling you with a message box that it could
not find the .csv files?  The .csv files contain data which are read in by
the program.

As an apprentice developer I have a question.
In an application I have the tables Accounts (with columns AccountID,
LandID, etc.), AccountDocuments (with columns AccountID, DocumentID, etc.)
and LandDocuments (with columns LandID and DocumentID). When in the form

I have a form with a Collection variable to store several objects with
WithEvents children, to have all controls of a certain type behave
alike. This has been working for the last day, since creation.
Suddenly I cannot open the form in normal view anymore. "the OnOpen

i'm still a newbie in using MS Access and in VB programming.  I am
using DAO connection from my VB to access the entries on my MS Access
table.  I am having trouble in editting and deleting entries from my
table because it becomes slower and slower when my table is getting

I find that ADP does not support any Stored Procedures that use the 'CREATE
PROC spHAPPY' syntax.
CREATE PROC syntax is listed in books online.
This syntax should be supported

Hi all again,
Maybe, I'd better try to do this:
How can it programmatically get/return the "Row source" or Rowsource
property of a generic Table in a generic Access 2K database???

Here is my code:
   Dim appData         As New Access.Application
   appData.Visible = True
   appData.OpenCurrentDatabase "c:\test\test.mdb", False

TMALSS: Task With maintenance of Access Database I did not develop,
don't ask about non-commented code problems or where data dictionary
is (LOL).
Have table with Inventory data for all Publications held,

I'm using MS Access 2003.
Bare with me on this description....here's the situation: Imagine insurance,
and working out premiums for different insured properties. The rates for
calculating premiums are dependant on the country in which the client is in.

Thank you in advance for any and all assistance. I'm trying to create a report
that will work similar to the label wizard in Access. I have a premade form I'm
attempting to fill with data from the db. I can manually make the information
fit, by making the report the full 8.5" x 11", ...