Hi there. I need some help in Access 2013.
I have used an example DB from within Access to be able to control assets. The example DB created pretty much everything I needed, except for a few things I adapted along the way.
One thing I need to create is a VBA routine to automatically import data from an Excel sheet to a table inside the DB. I already have that code, so that is not the problem.
My problem is the way this example DB was created (a kind of "Web form" or something like that - which I do not have too much knowledge of), whenever I choose a button (or any other item) inside the forms (on this case, the form "Importar2") and go to the Event tab, there's no option to link it to a VBA code (link "Event procedure"). The drop down menu is blank. I can only click the three dots and go to the macro creator.
I have tried creating another form ("Importar"), with the standard design, and I could link the button to the VBA code normally. Thing is I can't seem to add it inside the main menu form ("Principal"). It only accepts those web forms, which do not accept a direct link to a VBA code. So I'm kinda stuck here.
I have attached the DB here, and would gladly accept any help to achieve my goal on this DB, be it either:
- Find a way to link an item in a web form to a VBA function
- Find a way to insert the regular form inside the web form "Principal"
- Create a macro to import the contents of an Excel file to a table inside the DB
Or any other way you guys might know of I haven't thought about.
Thank you very much in advance!
Download links (I couldn't use the built-in because it is 1.5 MB big):