I have many forms with the same controls and to advance the forms one by one;
the forms are listed in a table in viewing sequence.  One control advances
the forms by looking up the form number and adding one (I made it originally
one sub for each form, then changed it to a ...

Whenever I try to execte a delete query using a sqloledb connection I get the
following message:
“The column prefix ‘WEBAPPS.DBO.MDUCMPLX_RANGES_VID' does not match with a
table name or alias name used in the query”

I am having an issue of updating a record that has been extracted out of a
text file. I am using the ADO Addnew and Update methods. My code:
If CN.State = adStateClosed Then
       CN.Open "DSN=Traffic_Data;UID=traf_data1;PWD=traf_data1;"

I'm very familiar with VBA programming in Excel, but not in Access.
I need to:
1) Drop a given table, call it "tblData"
2) Import a delimited text file to recreate the table, call it "tblData.txt"

I need to insert data to table intermod and write code in cal button click
event. Unfortunately It takes time  more than 20 seconds. I try many times
and belives that "Insert into...." in M2FSql1 take almost of time.
How to write code to reduce time.

I would like to inform you that this question is not for novices...
I have an Access query that uses a VBA public user-defined function (reside
in an module) to calculate one query's field. When I directly run the query
everything is ok. BUT..when the query is run from outside the ...

I'm using a Access 97 to export a query with the transferspreadsheet command:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97,
"qryCBGandPendingReclaims", Destination & FileName
I think the limit to the destination path (Destination & Filename) is 64

I have a select query that returns a list of records of the following kind:
Field1   Field2
A             8
A             7

When I execute this -
DoCmd.TransferText acExportHTML, , "tblCOTClaim", "C:\temp\COTClaim.xml", True
I get -
Runtime Error '3027' Cannot update. Database or object is read-only.

I have some Linked tables that are in Oracle and when executing this code I
get ORA-00972 - Identifier to long.
RsPort.CursorType = adOpenKeyset
   RsPort.LockType = adLockOptimistic

I am sending a query as .xls in a mail, using the following code.
DoCmd.SendObject acSendQuery, strReportName1, acFormatXLS, Me![To], , ,
Me![Subject], Me![Message], False
I would like to get the xls-file that is created as landscape instead of

Im sorry ... I may be somewhat thick here, however I am looking for a way to
compress csv files after I have imported them to access... I have found and
read the topics here and downloaded emandos code as suggested previously from
http://www.mvps.org/emorcillo/download/vb6/xpzip ...

I have a query "salary total"(2 tables) , I would like to create a function
to calculate the salary but it does not work, code as follows. Appreciate for
your expert help!
Function dailysalary()

help files say that "DoCmd.SetWarnings" will enable/disable "System
Messages".
What are all the messages that are considered "System Messages"?
In Access>Tools>Options...>Edit/Find tab>Confirm group, there are 3 items:

I added code to the switchboard so I could open queries, and that works
great. Got the info from
http://www.accessmvp.com/JConrad/accessjunkie/switchboardfaq.html#query
My problem is that if I cancel the input query, I get the msg:  "There was