I have an Access 2002 database that was converted from Access 97. It appeared
to be operating okay until I split the database (front-end and back-end). Now
I am getting a runtime error message 3219 Invalid Operation.  When I run the
debug, it points to a module that was converted ...

I have a field in a SQL Server table defined as smalldatetime.  In my access
database I link to that table and have the following code, but am gettting a
type mismatch.
DoCmd.RunSQL "UPDATE dbo_Anesth SET fldExported = Now() " & _

I am attempting to run the command
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
and I am getting the error messge,
The command or action 'SaveRecord' isn't available now.

I have converted an MDB to an ADP because it was too big for the PC. However,
I can't see how to port the code that I used to generate SQL queries. As far
as i can tell, 'views' do not have an 'SQL' property.
Where do I go from here?

I'm having a problem using UBound with a dynamic array.  Basically, I want
to check the upper bound (size) of an array.  But the array has no dimension,
so I keep getting an error.  But I can't find a way to catch the error, and
set the dimension of the arry to 1.

Friday I moved data from an Access 2003 application to SQL Server and am
linking to the DB.  My main form for data entry had several subforms.  In
testing, I've encountered one problem.  When I move to make changed on a
different subform, I get the following warning.  

Is there a setting somewhere that would make what ever I am typing, into the
code window, to be formatted differently than what I am typing?
As an example when I go to comment something with  ' the application will
move the ' over and start putting everthing I type in front of it, ...

I am trying to save a report that has some formatted text and a few images.
When I export the file as a RTF the file saves okay but the images are
missing. Any ideas? The same thing happens when I send the report to a Mail
Recipient.

I am using Access 2k3 to automate letterwriting (statements and invoices).
I have a word document built as a mail merge base file.  It's data source is
linked to a Jet/ODBC oject stored in a sprcified location.  The data source
is an MS Access 2k3 .mdb file bearing only tables for ...

When linking certain tables to SQL Server programmatically via the VBA
command DoCmd.TransferDatabase, the tables link correctly. However on linking
the user is prompted to "Select a Unique Record Identifier" to ensure data
integrity. The table fields are provided. Is there a way ...

I have a form where people select a customer from a drop down menu.  This
then selects a prefix (which is unique to the customer) and the user must
then enter a 4 digit tape number.
The tape numbers are all 6 digits long, the first two being unique and the

Have this code fragment.
When I click on the delete command button when on a new record, instead of
the error being handled by Err-DelRec_Click, I just get the access error
window referencing error code 2046.

I am trying:
Dim DBName, NewDBName as String
DBName = "C:\Files\ExampleFile.mdb"
NewDBName = "C:\Files\NewFile.mdb"

I need to retrieve data from my Favorites folder using Access.
Using Scripting.FileSystemObject, I can get the names of files and
sub-folders, file sizes and dates.
But I can't get the Internet Shortcut, the value of one of the properties of

I made a table with just one address line, and some people want a 2nd line
for Apt or suite, or PO box.. Rather than add another field to the table, I
would like to have them separate the 1st & 2nd address line with a special
key, like an asterisk.