I have an Access 97 which contains some local tables and links to 3 SQL
tables.  This database has been in use for years and now I’m getting an unual
error message:  Function isn't available in expressions in query expression
'KeywordCat = 'VM Sub-Category' AND Left(Keyword, 2) = ...

I am using the following code and the API call code from Ken Getz,
DoCmd.TransferDatabase acImport, "Microsoft Access", TestIt, acTable,
"MasterSheet", "MasterSheet"
when I run the code I get a Run-time error, "3001" invalid argument.  any

How do I write code to insert a field into a table and then the field type

How to add new item on combo box using after update event?

In my current access programs I am using business objects (class modules)
that handle access to the database. This is a lot of repetitive work. Is
there any Object Persistency product that you could recommend for Access or
are there none in existence?

I have a text box that i want a value to automatically generate when i click
upon the box or on a button.
I am trying to use the MAX function to find the Highest "Part No" (8 digits)
and where  "Group" = "........" (The value for Group will be choosen in a

How can I transfer data from and Access database to an Excel workbook, in
different worksheets?  Shall I first create an "empty" workbook with those
worksheets and then how? (i have already created the required queries)
Please help.

Can anyone advise how I use the File Dialog API call to retrieve a folder
name instead of a file name?
Cheers,
Steve.

If the cursor is on a certain textbox when I press a command button I want
the system to perform a certain task.
However how can I check in VBA if the cursor is on that textbox?
Thanks in advance

I need the code to get rid of the items in the drop down menu or the entire
menu on a reports "Print Preview" window i.e: "If you right click on the
report's "Print Preview" screen, it will give you a menu with "Page setup",
"Print" etc.

I have: a table with data
I want: to populate the first record with the field names.
Any suggestions?

I am using MSA 2003, and am trying to format dates in my tables/queries in
the following format:
ddd","mmm dd","yyyy
The results that I am looking for are, for example, SUN, Feb 12, 2006.

how to create new item using after update event, also the combo box can using
to search the recorded records.

I am trying to use the DoCmd.TransferSpreadsheet method to import records in
an Excel 2000 spreadsheet file (has one sheet) but it is not working and
would appreciate your expertise.  Error msg I'm getting indicates either key
violations, or data types/field sizes not matching, ...

Using CreateField Method(DAO) I want to create new Acess tables from Word
VBA code, see following example
Set dbsDB = OpenDatabase(myDataBase)
Set tdf = dbsDB.CreateTableDef(myTable)