When i wrote DIM BDD as i don't get any proposal.
Thanks for your help
JPB

I am trying to use the transfer database action in a macro
to import a table from an MDE into the mother MDB file.  I
am prompted for the MDE password and it appears to run
without errors but when checking my tables there is no

I have an Access database that I created long back in Office 97, and then
continued using in Office 2000, but a peculiarity has developed following my
recent upgrade to Office XP.
The database includes a "startup macro" to open a front-end form containing

The error number is 13 : compabilit? de type  that i translate in TYPE
INCOMPATIBILITY
on the line
Set RST = CurrentDb.OpenRecordset(strSQL)

I would like to create a simple database of people and
after they are entered I would like to run a code that
will randomly select a name and then move on to the next
name.  Once the name has been selected I will not want to

I have a macro that I need to execute each time a record
is inserted, removed, or updated in an access table.  
Records are being inserted and edited through active
server pages meaning I can't rely on an event, control or

I have a macro running a series of queries.
I would like to code some of the responses to the query promts in the macro.
I have tried, unsuccesfully, to put the data in the Condition field of the macro.
How can this be done?

Access is defaulted to save any change updated to records, however, I want
to write a VBA which user must click the "Save" button in order to save or
update the records, if user did not click the "Save" button, the new change
won't update to the Database. How can I do that?

I use a macro called SpellNumber in Excel that takes a
numeric number from a specified cell and converts it to
text.  I would like to use that same macro in an Access
report but I'm not smart enough about Access to figure out

I have set up a macro to compact and repair an Access 1997
database that works fine.  Now I'm trying to get the macro
to work w/the Acess 2000 version of the '97 database and
the compact and repair macro isn't working.  I've checked

I have created some reports in Access, and want to create a macro that
will open and run and then export to excel.  How do I do this?  
I have started the macro by writing OpenReport, and naming the report.
I get stuck when it comes to exporting to Excel.  Do I need to go into

how can show a form for certain time and then close it automatically. e.g.
popup a form for 5 seconds and then close by itself

Is there a way to set up autokeys to take multiple
characters, ex:  CTRL ABCD
It will take ^A, but ^AB errors out.

this is probably a simple question for most of you out there
but this problem has me totally stumped...
Intro: My database consists of five tables and ten different
forms (two forms access the same table but only different

I have used the macro commands OpenQuery and OpenTables to
automate the conditional opening of a query and a table
respectively in datasheet view. The problem is that both
of these commands open the corresponding query and table