Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    In the VBA Editor click on New Module



    Click image for larger version. 

Name:	NewModule.png 
Views:	16 
Size:	21.0 KB 
ID:	45772
    Then write the global declaration.
    Click save it will prompt you for a name for the module, call it anything you like but NOT the name of a function.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  2. #17
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Quote Originally Posted by Minty View Post
    I think I have seen a demo of Drag and drop in Access somewhere on the Interwebs.
    I'll have a poke around and see if I can steer you towards it. I suspect it wasn't very easy to code...
    This is what I found - not simple...
    https://www.youtube.com/watch?v=aPtCyNpmErM
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #18
    Blings's Avatar
    Blings is offline Competent Performer
    Windows 10 Office 365
    Join Date
    May 2020
    Location
    London, UK
    Posts
    125
    Quote Originally Posted by Minty View Post
    I think I have seen a demo of Drag and drop in Access somewhere on the Interwebs.
    I'll have a poke around and see if I can steer you towards it. I suspect it wasn't very easy to code...
    If you find something that would be really nice!

    Edit: I posted before I saw the above YouTube link.

  4. #19
    Blings's Avatar
    Blings is offline Competent Performer
    Windows 10 Office 365
    Join Date
    May 2020
    Location
    London, UK
    Posts
    125
    This line of Code should create a folder on the Server - can anyone see where I am going wrong.

    Code:
    sFolder = Application.CodeProject.path & "\" & sAttachmentFolderName & "\"

  5. #20
    Blings's Avatar
    Blings is offline Competent Performer
    Windows 10 Office 365
    Join Date
    May 2020
    Location
    London, UK
    Posts
    125
    Solution:

    Code:
    sFolder = ("\\REPLACE-THIS-WITH-SERVER-LOCATION") & "\" & sAttachmentFolderName & "\"

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

Similar Threads

  1. Replies: 3
    Last Post: 08-06-2021, 06:27 AM
  2. Re-Link to backend data on network attached storage
    By GraeagleBill in forum Access
    Replies: 6
    Last Post: 06-11-2018, 05:10 PM
  3. Parsing HTML Tables for Storage in Access
    By Stopwatch in forum Import/Export Data
    Replies: 8
    Last Post: 09-22-2014, 03:36 PM
  4. Replies: 4
    Last Post: 09-05-2013, 08:02 AM
  5. Replies: 2
    Last Post: 03-21-2011, 12:55 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