Results 1 to 4 of 4
  1. 05-15-2017, 11:46 AM #1
    jo15765's Avatar
    jo15765
    jo15765 is offline Expert
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    672

    VBA To Save To Desktop


    What is the Access VBA Syntax to save to the logged in users desktop?
    Reply With Quote Reply With Quote
  2. 05-15-2017, 12:10 PM #2
    aytee111
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    The logged in user is Environ("username"), not sure about the rest.
    Reply With Quote Reply With Quote
  3. 05-15-2017, 12:12 PM #3
    jo15765's Avatar
    jo15765
    jo15765 is offline Expert
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    672
    I googled from your response and found this syntax which works!
    Code:
    Environ("USERPROFILE") & "\Desktop\"
    Reply With Quote Reply With Quote
  4. 05-15-2017, 12:16 PM #4
    aytee111
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Thanks for posting the solution.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. VBA Code to PDF & save Report then open PDF and save as Word.docx
    By Mick99 in forum Access
    Replies: 2
    Last Post: 07-15-2015, 08:35 PM
  2. How to export Query data to Excel with save as dialogue box to save in directory
    By arunhalyal in forum Access
    Replies: 5
    Last Post: 02-03-2014, 03:06 AM
  3. Subform with Attachments Control - Add/Remove/View/Save As/Save All Buttons Disabled
    By dipitiduda2 in forum Forms
    Replies: 15
    Last Post: 01-28-2014, 12:20 PM
  4. Problems with saving the record - some fields don't save until another edit and save
    By epb in forum Forms
    Replies: 8
    Last Post: 09-27-2012, 11:12 AM
  5. Save items from listbox selections to display on another form and save in table
    By taya621 in forum Forms
    Replies: 9
    Last Post: 01-20-2011, 02:22 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums