Posted on 1997-12-22
I am working in Access 97 and I have created a function that will query records based on user input and then create a new database. I then export the new querydef and data as a table to the new database using the TransferDatabase method. I am also exporting a report to the new database. This report uses a custom menubar. My problem is this; when I export the report, the menubar does not go with it. Is there a way to transfer a menubar that is not a macro? I know it can be done from an open database using the 'Get External Data' selection from the file menu. But I need to export not import. Any suggestions?