I try to use this command to import a spreadsheet
"DoCmd.TransferSpreadsheet acImport, 8, tablename & " -tbl", DIR &
"Book2.xls", True"
and it errors out.  If I try to import that same spreadhseet with menu

I have an Access2002 database that needs to connect to an Oracle
Database.  I connected to my Oracle DB in a simple VB6 app using no ODBC
data source.  How do I do the same thing using VBA in Access?
Below is the code I used in the VB app to connect to the Oracle

I am writing code to get a subset of table records, but it is not
looping properly through the fields, it keeps getting stuck in some
sort of infinite loop and I have to be able to walk the whole
recordset.

I'm building a database of students whose hearing will be tested. I had
a main table set up of all of the student data and then a test table
linked to the main table by a student ID.
The way that the testers use the database is that while they are

I have 2 text fields in a report coming from a recordset. I want to
have a third field which will contain the result of some complex string
manipulation of the 2 fields. How can I achieve this? The idea is like
that:

I have an app that has one small component that uses a reference to MS
Outlook 9.0 to create an email. Now we have users on 9.0 and 11.0,
sometimes it causes the reference to switch and this causes the missing
reference issue. What is the best way to get around this?

is there a way to send an e-mail to a customer, using ms access?? or some
kind of automated mail merge, so the user only has to review the body, and
click send?
ive got a customer table, with a field called email address, where the

I have read in a bunch of files and saved the filename in the table
along with the idnumbers and names.
Thing is they sent us some files that have to be changed now
figures    LOL

In VB6 I have this code for returning data to a recordset via 2
Selects:
1. Select * from MyTable (98 rows of data are here)
rs.recordcount returns "98"

I created a query based on query.  I am creating a new field in the
query called "Series".  The field is created as follows:
Series: IIf([ITEM_NBR] Like "11-2*","11-2XX")
For all ITEM_NBR that are 11-201 or 11-202 etc make the value in the

I am wondering if anyone can help me out. I have an Access Database that
has been running since forever. Now when I try to open a form I get the
"Run-time error '6' Overflow message and a window asking me to debug or
end. Here is what i see on debug:

I am wondering if anyone can help me out. I have an Access Database that
has been running since forever. Now when I try to open a form I get the
"Run-time error '6' Overflow message and a window asking me to debug or
end. Here is what i see on debug:

i've got a price of code, which checks to see if a film is on rent, or
available.  but how can i actualyl make the cancel button do somthing?
because, the cursor gets stuck on the filmID field. this is wat i've got so
far;

Access XP would seem to have a bug. A report which is imported into another database cannot be further modified if the report contains a linked image. I saw that one about a week ago.
I think I'm seeing another permutation today where a report is simply not showing up in the list ...

I have a "Launcher" application that does version checking. It will
copy a newer version from the server if needed, and then start the
main application. I believe Tony Toews "Auto FE Updater" serves a
similar purpose. My app calls ShellExecute to run the command line