Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Returning to main screen of Database (2000)

    When l click on the Exit button in Excel for some odd reason it takes me back to the list of macros in the database rather than the main
    menu of the database.
    If you see the attachment you will see what l mean.
    This works fine in another spreadsheet.
    Attached Images Attached Images

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Returning to main screen of Database (2000)

    Excel? Spreadsheet? I might be useful if you explain how you end up in Excel from your Access database.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Returning to main screen of Database (2000)

    I have a button which l click on which takes me to an Excel spreadsheet.
    When l click on Exit in one spreadsheet it takes me back to main screen of database but not on the other spreadsheet.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Returning to main screen of Database (2000)

    Do you open both spreadsheets from Access?

    What is the code behind the button?

  5. #5
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Returning to main screen of Database (2000)

    "E&xit" is the code behind the button that works.
    This is the same as the one that does work.

    I am baffled as to why one spreadsheet is working and the other is not?
    Any ideas?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Returning to main screen of Database (2000)

    E&xit is not code, it's a caption.

    You wrote "I have a button which l click on which takes me to an Excel spreadsheet". What is the code in the On Click event of that button? Is the code to open the one spreadsheet the same as the code to open the other spreadsheet?

  7. #7
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Returning to main screen of Database (2000)

    I checked the code and it was wrong.
    Thanks once again Hans.
    It is now working fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •