Page 5 of 5 FirstFirst 12345
Results 61 to 65 of 65
  1. #61
    Edgar is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Dec 2022
    Posts
    271
    Ah, you're storing the file names with the extension, remove the


    & ".docx"
    from the code.

  2. #62
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    The same error returns when I call it from the form.
    As you said. If the control name on each form is the same, and the field name in every source is the same. Even though the field name and control name differ, I can use the same phrase from the Module.

  3. #63
    Edgar is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Dec 2022
    Posts
    271
    Same error with post #61 applied? I opened your form again and you're storing files as filename.docx, since the code also adds .docx, it was trying to open filename.docx.docx, which is wrong

  4. #64
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    That is fantastic. It works. Another lesson learnt. You may marry my stunning 35-year-old daughter now.

  5. #65
    Edgar is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Dec 2022
    Posts
    271
    Haha, I appreciate the offer, let me know what else I can help with, I'm glad it works now

Page 5 of 5 FirstFirst 12345
Please reply to this thread with any new information or opinions.

Similar Threads

  1. General module calling public function in an open form
    By GraeagleBill in forum Programming
    Replies: 3
    Last Post: 09-30-2022, 02:08 PM
  2. form onload event when calling standard module sub generates err
    By Synergy.ron@gmail.com in forum Access
    Replies: 6
    Last Post: 04-16-2021, 03:29 PM
  3. Calling a module into a form
    By CraigR in forum Modules
    Replies: 3
    Last Post: 12-12-2018, 08:04 PM
  4. Replies: 5
    Last Post: 11-25-2017, 03:45 AM
  5. Calling A Module Function To Open A Form
    By orcinus in forum Modules
    Replies: 3
    Last Post: 09-29-2010, 04:43 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