Results 1 to 4 of 4
  1. #1
    IsaacRCCL is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2019
    Posts
    10

    First Time Access User (Need Help)

    I'm new to Access, I use it as a basic database but my job asked if i can solve a problem from a retired employee that created a Access Macro filled exe.


    I tired to fix it, but ended up creating a new one. The new one only works if a txt file is present on my C drive. I cant get it to work if those conditions are met.



    I'm thinking of creating a new Access exe which looks to see if that txt file is present, if that txt file exists, use ACCESS 1 if it doesnt, use ACCESS 2.

    How would i start? I'm using ACCESS 2019.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    When you say Macro, are you talking about Access macro or just VBA?
    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

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Isaac,

    Can you tell us in plain English -minimum database jargon - what the database is about. If you give readers a general overview and then zero in on the specific issue, you may get more focused responses.
    It would also be helpful if you could copy some of the source code and paste it into the body of your post.
    Remember we know nothing of you, your environment, the current issue.....

  4. #4
    IsaacRCCL is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2019
    Posts
    10
    Access Macro

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access is only allowing one user at a time
    By msouriya in forum Database Design
    Replies: 7
    Last Post: 01-13-2022, 04:31 PM
  2. Replies: 1
    Last Post: 05-21-2016, 08:51 AM
  3. Replies: 2
    Last Post: 03-18-2015, 07:34 PM
  4. Replies: 5
    Last Post: 09-04-2014, 01:52 PM
  5. Replies: 1
    Last Post: 09-21-2013, 10:42 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