Page 2 of 2 FirstFirst 12
Results 16 to 24 of 24
  1. #16
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,822
    Hi Kelly

    Is the attached what you are aiming for?

    The Green Coloured button on the Subform allows you to Navigate to the File Location and the Path to that Folder is displayed in the Doc Path Control.
    Attached Files Attached Files

  2. #17
    MustbeAweful is offline Novice
    Windows 10 Access 2021
    Join Date
    Nov 2024
    Posts
    21
    Quote Originally Posted by mike60smart View Post
    Hi Kelly. Is the attached what you are aiming for?
    Unfortunately, I keep getting a Compile Error. Is there something I need to do before viewing it?

  3. #18
    June7's Avatar
    June7 is offline VIP
    Windows 11 Access 2021
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,772
    I click green button with + sign and code works just fine, no error message.
    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.

  4. #19
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,822
    Hi Kelly
    You may be missing a Reference.

    To check hold down the Ctrl + G Keys to open the VB Window

    Select Tools - References

    Make sure that Microsoft Office 16.0 Object Library is selected

  5. #20
    MustbeAweful is offline Novice
    Windows 10 Access 2021
    Join Date
    Nov 2024
    Posts
    21
    Quote Originally Posted by mike60smart View Post
    Hi Kelly
    Make sure that Microsoft Office 16.0 Object Library is selected
    Heyo Mike,

    I did what you said. "Microsoft Office 16.0 Object Library" is selected.

    Here is the error in full:
    Click image for larger version. 

Name:	Compile Error.jpg 
Views:	18 
Size:	23.8 KB 
ID:	52968

    I hope this helps.

  6. #21
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,822
    My PC Uses Office 365 32 Bit with Windows 11

    If you can it would be best to uninstall Office 365 and then download and Install the 32 Bit Version.

  7. #22
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 11 Office 365
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,879
    The other option other than installing 32 bit is to use 64 bit compatible Api's.
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  8. #23
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,822
    Hi Everyone
    The OP contacted me by PM and it would appear that the database was on One Drive.

    I pointed out that this was a No No

  9. #24
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,569
    Quote Originally Posted by mike60smart View Post
    Hi Everyone
    The OP contacted me by PM and it would appear that the database was on One Drive.

    I pointed out that this was a No No
    Bitness still applies.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 09-18-2020, 09:06 PM
  2. Replies: 5
    Last Post: 07-10-2020, 12:41 PM
  3. Replies: 18
    Last Post: 12-05-2019, 07:21 PM
  4. Replies: 3
    Last Post: 11-25-2014, 01:14 PM
  5. Replies: 1
    Last Post: 07-26-2011, 06:10 AM

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