Results 1 to 9 of 9
  1. #1
    Ramses800 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2013
    Posts
    5

    Access VBA UserForms give File Path error with container controls(Frame/Multipage)


    Using Access 2010(32Bits) on Windows 7(64), I have a problem with using control containers(ie Frame or Multipage control) on a VBA Userform when using the ACCDB-fileformat.
    Adding a Frame/Multipage works in the VBA IDE but when I try to run it, I get an error and the form crashes.
    The error is:
    Path/File access error

    Then after I click OK I get this error:
    Run-time error '75': Could not find the specified object

    The funny thing is that if I use the older MDB-file format the form works as it is supposed to.
    Using container controls in the other Office 2010 VBA environments(Excel, Word, Powerpoint, Outlook) works as it supposed to, it is only in Access that the file/path error shows up.
    I also tested on different computers(also running Windows 7(64)) but to the same result.

    Anyone seen anything like this?

    Example of Frame/Multipage control
    Click image for larger version. 

Name:	Container control.png 
Views:	15 
Size:	36.0 KB 
ID:	14208
    Last edited by Ramses800; 10-29-2013 at 12:48 AM. Reason: Added screenshot

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Never heard of frame/multi-page. Want to give a little info on what they are for and how to create? Then maybe I can do some testing/analysis of issue.
    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.

  3. #3
    Ramses800 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2013
    Posts
    5
    Updated first post with a screenshot

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    That is image from Access 2003? Was the db created with 2003? What you show as Frame and Multi-page controls I know as Option group and Tab controls.

    Cannot replicate the issue with 2010. Have you tried running the db with 2010 on another computer?
    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.

  5. #5
    Ramses800 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2013
    Posts
    5
    Quote Originally Posted by June7 View Post
    That is image from Access 2003? Was the db created with 2003? What you show as Frame and Multi-page controls I know as Option group and Tab controls.

    Cannot replicate the issue with 2010. Have you tried running the db with 2010 on another computer?
    The UserForm and database is created in Access 2010.
    This is VBA UserForms, not Access Forms, which are is not the same.

    To add UserForms, one need to enter the VBA IDE(easiest done by pressing ALT+F11) and then insert a new UserForm into the Project(usually, one need to customize a new menu shortcut .
    Click image for larger version. 

Name:	Add_UserForm_1.png 
Views:	14 
Size:	28.9 KB 
ID:	14211

    Click image for larger version. 

Name:	Add_UserForm_2.png 
Views:	14 
Size:	15.2 KB 
ID:	14212

    After that, it is easy to add a new UserForm.
    Click image for larger version. 

Name:	VBA Project explorer.png 
Views:	14 
Size:	23.8 KB 
ID:	14210

    As you can see, there are different kind of objects(MS Access Class Object, Forms, Modules & Classes) in the Project.
    Access Forms is a MS Access Class Object which differ from a UserForm object.

    And yes, I tried another computer.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Sorry, never used UserForms, wasn't even aware of. Why are you using?
    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.

  7. #7
    Ramses800 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2013
    Posts
    5
    Mainly because I want to open multiple instances of a popup form(ie select an item in one list, open it into a popup form with details of selected item and then be able to select another(or any number of) item and show that items details in another instance of the same popup form at the same time as the first one maikng comparison of items easy.

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Allen Browne offers a method to manage multiple instances of Access forms: http://allenbrowne.com/ser-35.html
    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.

  9. #9
    Ramses800 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2013
    Posts
    5
    Yes, that approach works, I found it a couple hours ago and are using that now.

    I´d still like to find out what´s the problem with UserForms though, I will probably want to use that for some other stuff later.

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

Similar Threads

  1. Handling Error Message when file path does not exsist
    By brinehart in forum Programming
    Replies: 2
    Last Post: 06-04-2012, 12:33 AM
  2. Replies: 2
    Last Post: 12-08-2011, 02:27 PM
  3. Replies: 2
    Last Post: 04-28-2011, 07:30 PM
  4. path /access error 75 is dispalyed
    By PRASANNA in forum Forms
    Replies: 0
    Last Post: 04-27-2011, 04:24 AM
  5. path\file access error 75
    By PRASANNA in forum Programming
    Replies: 2
    Last Post: 04-25-2011, 04:50 AM

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