I am trying to create an Import Form to "Map Fields" for importing many
different tables into 1.
The form I created has 2 columns of comboboxes ( A - AA) thru (J - JJ).
The rowsource for comboboxes with the double letters "AA" is the table

Has anyone encountered a situation where your Access report will be
printing just fine and then one day you run the report as usual and
instead you get a small image of the report scaled down to about 1/2
the size of the paper?

I'm trying to create a standard "hidden" table. However, using this
code, my tables are not displayed in the database window *even* when I
choose to show Hidden and System objects from the Options dialog:
                   tdf = theDB.CreateTableDef(OptionsTableName)

i try to copy data from excel into my MySql database which runs on a
linux.
i use MS Access to access the database. i need to optain the unique id
number, and this is where i have some troubles.

Hello. Is the a way to have a command button in a form which would
print a particular (always the same) MS Word document?
Thanks a lot,
Sandra

I'm new to Access and am trying to create a form to use to bill
clients.  One of the boxes is a "COURIER" box and what I want to be
able to do is type in the cost of the courier package ie.$10.00 and
have it automatically mulitplied by a set amount ie. 1.5 (50% markup)

I have a probelm with connection to SQL from Access. I've seen same
advices from you, but I steel have a problem.
I need select some data form SQL Server using access's visual basic.
Please give me a example (some pice of code).

Is there a way to open and/or print a saved file (.doc, .pdf, .xls, etc)
using VBA?
something like...
   Call Shell(strInvoicePath, OpenFile)

This is an interesting problem...
I'm using MS Access for the backend for a simple task list web
application. (I know, I know, but Access is all my Web Host will allow
without killing me in hosting fees...)

When my app starts up, it creates a temporary database.  This temp database
is created from a 'model' database that is in the same folder as the
application.  Because there is a model, the creation is essentially to just
copy the 'model' database and give it the name of the ...

I am writing to a text file the records in an access table that is to
be loaded into an Oracle system.
However, I have been told that the date fields in the records I have
exported to the text file that are not compatible with oracle.  The

Please help I've been working on this for over a day.
The following code will run the GetComments function from a shortcut
menu.
         .MoveFirst

I have an Access 95 database. This database has run for years and now is
giving me a problem. When opened, the switchboard works fine and the
database functions. However, when I close the switchboard and try to open a
table, query or report, the tabs show up for table, query, report ...

Microsoft Access 2000 has a problem with the Tools menu.  Periodically,
all commands on the Tools menu will become disabled, making it
difficult to use its menu commands (such as Relationships, Database
Utilities, Options, SourceSafe integration).  I have encountered this

What is the correct syntax for querying the first 20 characters of a
memo field?
I'm trying to
SELECT CAST (varchar(20) fieldname) as newfieldname