Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Sep 2005
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts
    When you run this Access Application and hit the Review Drives button - the correct form opens up but there is nothing showing in the list box. If I open this same form without going through the link it shows everything just fine. I am sure i am missing something simple but can't seem to figure it out. Any suggestions? Database attached[attachment=86455:Copy of Drives.zip].

    Thank you in advance.
    LKR1219
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    In the ViewAll procedure in the code module of DriveListReview, change

    Code:
    DriveList = cusVar & _
      "ORDER BY Drives.DriveNo;"
    to

    Code:
    DriveList = cusVar & _
      " ORDER BY Drives.DriveNo;"
    Note the space before the word ORDER.

    (When I click Drives Review, I get a message box saying "You are not allowed to use this area".)

  3. #3
    Lounger
    Join Date
    Sep 2005
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I knew it would be simple - thanks for your help!

Posting Permissions

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