Page 3 of 3 FirstFirst 123
Results 31 to 37 of 37
  1. #31
    lawdy is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    172

    I would like to send it in to be analysed. The front end is 47 mb and the back end is 148 mb's. I could eliminate most of the data in the back end but how can I get the front end down to size?

  2. #32
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Selection of libraries is db specific. Selection in one does not carry over to another. Must be done in each db. In the case of split db, must be done in the frontend. Have you done that?

    Otherwise, run Compact & Repair then zip the files and upload to a fileshare site such as Box.com and post link to the file.
    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. #33
    lawdy is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    172
    Since ItsMe's changes work on my computer, I must assume that I am doing something wrong. It seems like simple code. So if I could ask for you to look at the simple database which I have attached, and again tell me what I am missing. I have also attached a picture of the library referencees since that seems to be an issue. It looks ok to me.
    Attached Files Attached Files

  4. #34
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Still have not selected "Microsoft Office 14.0 Object Library". It DOES NOT show in the image.

    Must select library reference with that EXACT wording.

    Can't be more specific than that.
    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. #35
    lawdy is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    172
    Please don't give up on me, I have to solve this. I must not know how to reference it. The picture show the 2nd object is checked ant that object is 'Miscrosoft Office 14.0 Object Library'. If that is not selected, how do I select it?

  6. #36
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    The second item checked shows Microsoft Access, not Microsoft Office.

    Just scroll down the list until you find "Microsoft Office 14.0 Object Library".
    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. #37
    lawdy is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    172
    Thank you very much. It works now (not that my right click problems are all solve). I really appreaciate you help.

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Print Preview Custom Shortcut Menu
    By Swatskeb in forum Modules
    Replies: 2
    Last Post: 05-22-2014, 08:02 PM
  2. create menu problem
    By jinz in forum Forms
    Replies: 1
    Last Post: 12-10-2012, 07:02 AM
  3. Unable to create new record in Forms
    By escapades_access in forum Forms
    Replies: 5
    Last Post: 03-16-2011, 03:23 PM
  4. Replies: 0
    Last Post: 01-27-2011, 09:58 AM
  5. custom shortcut menu help!
    By ninachopper in forum Access
    Replies: 5
    Last Post: 09-05-2010, 06:27 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