Results 1 to 3 of 3
  1. #1
    alexjose is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    6

    How to open a form on doubleClick event - please help

    Hi,



    I'm totally new to Access and sharepoint. Its my understanding building a database with access is much different than building a sharepoint database with access so I dont really know where to turn. I have a simple database with a datasheet form displaying all parts inventory, and I have another form that displays individual records (parts) and their details. What I want to do is double click on the record in the datasheet form and have it open the record in the individual parts form. Can I do this with a web database? I kind of did it with a macro but it didnt work on sharepoint after synching the databases.

    The forms names are "Parts_List" and "Parts" and the Primary key is PartID

    Thank you!


    Alexander

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    I do not know much about sharepoint but I have heard that event handling is not that great. I don't know how true it is but I have heard that you can not use code either. Have you tried creating a button and making the ON CLICK event of the button the macro you have been running successfully on the non-sharepoint version of the database. Buttons and click events may be perceived differently by sharepoint than try to use a doubleclick event of a form object.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    AFAIK, web databases cannot use VBA, only macros. That's essentially the reason for introduction of Data Macros in Access 2010.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Change Text Box Data Source On Open Event
    By mcktigger in forum Programming
    Replies: 1
    Last Post: 01-18-2013, 12:24 PM
  2. Replies: 4
    Last Post: 10-06-2012, 04:45 AM
  3. Replies: 1
    Last Post: 08-24-2012, 06:50 AM
  4. On Open form event not working
    By SPE_NY in forum Forms
    Replies: 2
    Last Post: 10-05-2011, 11:53 AM
  5. Replies: 5
    Last Post: 03-03-2010, 12:03 PM

Tags for this Thread

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