I have this question posted on the ESRI forums as well but with not much help
yet so I thought I would look for input here as well.
post at ESRI:
http://forums.esri.com/Thread.asp?c=93&f=992&t=215526&mc=0

have converted an Access97 to Access2003 (in 2000 file format) - much is
working ok but some command buttons are throwing the error:
Error Number 3420 - Object Invalid or no longer set
Have browsed around becoming educated on that....have looked at:

I am not sure where to post this question as it applies to multiple areas
here. I am having a problem with record numbers being duplicated. I am
calling a piece of code from a module to create a new sales order number
based upon a sql query of max(sono) from my sales table. This ...

I am using the code provided at
http://www.accessmvp.com/DJSteele/DSNLessLinks.html to link to a table in an
Informix database.
It works up to this line:

This is my SQL query
.Execute "DELETE * FROM tblData WHERE ([StaffName] = '" & mystaff & "'
And [Date] = '" & startDate & "'"
comes out as a run time error

I have the code that looks like below.Actually i have to update the table
iwth certain conditions.
If Ptyp field in the table is "PGR" then it should grab the next row's [strt
tm] value and put in the current row [end tm] value if not it has to do some

Someone knows how do this:??
1.- Start Access at specific time lets say 20:00
2.- Run a make table query
3.- Exit Access

I want to use a DSum function to calculate a total of a field in a specific
table.  Each table has a unique name.
I want this to be on a form. (multi record view).  
the syntax would be something like

I have this code which appends data to an Excel worksheet.  After the
appending is done the cursor location is at the end of the last record
appended in the worksheet.  How can I programmatically move the cursor back
to let's say cell B2?

I have a table with one field in it and I wont to draw one record so
I created a form and I created a loop to go to the next record
randomly the whole table and then every second minute I  stop the loop
and I

I have a table with one field in it and i wont to draw one record so
i open a form and i created a loop to go to the next record randomly
the whole table and then every second minute I  stop the loop and i
got the winner means the record where the loop stop in it

I am running a simple transferspreadsheet command for multiple excel files.
Each of the files have a password attached and this command won't allow me to
import them without first opening them with the password. I get an error
"Could not decrypt file". Is there a way to feed the ...

I have a table with that include fields 01 02 03 04 05 06 07 08 09 10 11 12
for the months of the year.  I have a form where the user picks 2 months.  
For example the user picks 03 and 07 which means for all the records in the
table I want to sum fields 03 through 07.  I cant ...

I have some forms were the users are able to use a filter-by-selection,sort
either by AZ-ZA. The users then want to see the results in the report exactly
as they are on the form after the filtering and sorting is done. Any idea on
how to accomplish this?

I have a query with a field called Fabric.  I want to create a column
in the query that returns Yes if any part of the Fabric field has the
letters "cot" in it.
So I naturally thought to put asterics around the word ("*Cot*") and