Results 1 to 3 of 3
  1. #1
    ghnogueira is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2014
    Posts
    8

    Question Can't link a VBA function to a button in a Form

    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:


    1. Find a way to link an item in a web form to a VBA function
    2. Find a way to insert the regular form inside the web form "Principal"
    3. 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):

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    web apps don't use vba - this link may help

    http://www.devhut.net/2014/01/26/int...web-databases/

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Form : Query button not function
    By suzeq in forum Forms
    Replies: 2
    Last Post: 03-10-2016, 03:43 AM
  2. Replies: 7
    Last Post: 10-09-2014, 03:06 PM
  3. Form command button to do something/call function
    By shubhamgandhi in forum Programming
    Replies: 2
    Last Post: 07-27-2011, 04:45 PM
  4. Replies: 4
    Last Post: 12-21-2010, 11:32 AM
  5. Create an RDP link button on my form
    By BDP in forum Access
    Replies: 1
    Last Post: 09-14-2010, 02:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums