sendkeys

[Jay]

I have Main.mdb database and a Cell.mdb database. Main database is having Main form through which user can navigate to the cell database. When the user clicks command button on the main form of main database its calling the macro 'sendkeys'
"%FC %FO c:\xxx\yyy\Cell.mdb~%DC"
The above macro opens the similar main form in the other database and then related database form successively. The action takes place like this %FC- closes the current database (which has its own menubar)
%FO c:\xxx\yyy\Cell.mdb~ - opens the Cell database through Ms-Acess-menubar and opens main form of the cell database %DC-opens the related main form of the cell database
The above macro is working fine in Access2.0 but not working in Access-97. Its opening the Main form in the Cell database but not the required form. the macro is not sending key values after '~' mark in Access-97
requesting solution
Thank u
jay

 

[cpuSmoker]

Suggestion

Have you thought about importing the cells.mdb table/forms collections into the main.mdb file? Then you wouldnt have to use the sendkeys function.