Access 2007 - Call import file wizard for switchboard

[Rhomium]

I had an Access 03 database that used the switchboard, from there the import
file wizard was called using "FileImport" in the switchboard manager. Is
there a similar way to do that in Access 2007? Now that I have switched
over, that part of the switchboard doesn't work.

Thanks in advance,

JP

 

[Maurice]

JP,

What's the code behind the button that's actually being run in 2003. I can
take a look for you but I need to know how it is started in 2003.

 

[Khanyisile Mthombeni]

How to create a combo box that will search for the record in the database and display the results in the report using Microsoft Access.

 

[Rhomium]

Maurice,

In 2003 I used the switchboard manager. In the switchboard item window I
have "run code" for the command, and FileImport for the function name. That
would bring up the Import Wizard window and all worked great. Doesn't work
in 2007.

Thanks,

JP

 

[Maurice]

Well unless you have some user defined function for that it won't work
because I can't find FileImport within the Built in Functions from Access.

So could it be possible that you use your own function here? If not the
functionality from 2003 won't work indeed.