I have a simple delete query, that I am building and executing through code
(when a button is clicked) to delete the current record (long story, but I am
doing it with a delete query).  Anyway, once the button is clicked, the
current record is supposed to delete out of the ...

I have a DB that uses the Microsoft Outlook 11.0 Library, but this DB is
used by users that has Microsoft Outlook 9.0 Library. This originates
malfunctions on that users. How can i solve this problem?
Thanks

I have an addin db that I am trying to do a codedb.Execute "query string" but
when it runs, i get an error:
You must use the dbSeeChanges option with OpenRecordset when accessing a SQL
Server table that has an IDENTITY column.

I have made a database for a friend and I would like to burn the data on a cd.
Is it possible to make an .exe file, so that the database will install
itself when this cd is used?

Is it possible to create a specification file with VBA, or does it have to be
created as a step in the import/export wizard?
rachael

The following is a sub I created. I am getting an error on
the Select Statement I am using that stats "Too Few
Parameters. Expected 1."
As far as I can tell my Select statement has the correct

I 've a table with linked OLE objects.
Now I moved the files to another location.
How can I tell my ms-access 2000 db to change all location of ole objects
in my table.

I've looked through the past questions but can't seem to take any of the
knowledge from them and apply it to my situation. I must be missing
something. I have a form with a subform that are linked on a date field in
the main form. I am having trouble in that ever time a user ...

I have a query I am exporting to a txt file and I need to
include a header record.
Any suggestions?
Right now I'm putting my header information in it's own

I have created a form which contains the key field, on this form is a button
that calls up another form (one-to-many).  When I am entering data, on the
main form with the key field on it, and I push the button to call up the
subform, I would like it to place the value (key field) ...

I am using this code in VB to save the contents of the
clipboard as an bitmap file.  How can this be done with
VBA since DataObject only supports text?
'Save as picture

I have a msgbox at the end of a procedure which says Update Successful! etc.  
It is set to vbOkOnly.  I click ok and it appears again.  I click Ok again
and this time is works.  This is crazy.  I even set a boolean value to go
around the second time and that didn't work.  I know ...

I need help importing a text file that is 50MB into access. Below is a sample
of the data. There is a pattern to the data. The beginning of each record
starts with "STMTS". There is also a Carriage Return character in front
"STMTS". There are 16 fields in each record. I think ...

I'm trying to programatically (within Access) issue a Net View command.  I
need to obtain and manipulate (for example display in a list) the resulting
list of machines on the network.  Issuing a Shell("Net View > pcnames.dat")
does not redirect the results to a file.  

I want to convert some queries into vba code...  Is this possible?  Is there
a routine that could help me doing that?  Is there a tutorial at least?  Any
suggestions will be better than nothing...
Thanks!