Results 1 to 4 of 4
  1. 10-18-2011, 03:58 PM #1
    SemiAuto40
    SemiAuto40 is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    41

    RunSQL issue

    I'm trying to use a password login form to upon successful login toggle the checkbox in the tbl_Users to ON. When I do the RunSQL using a wizard generated SQL string as an update query by itself it works fine but prompts me for the username from my login form.

    Question is when I put the RunSQL code in that login form why does the update query still prompt me for the username!?!?

    I know this must have an easy answer... and I'm all out of easy.
    Reply With Quote Reply With Quote
  2. 10-18-2011, 04:15 PM #2
    orange's Avatar
    orange
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Can you show us the SQL involved. And the related vba for whatever event you are using?
    Reply With Quote Reply With Quote
  3. 10-20-2011, 06:58 PM #3
    SemiAuto40
    SemiAuto40 is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    41
    I must have been referencing something wrong or some wrong syntax but now it works as it should.
    Thanx
    Reply With Quote Reply With Quote
  4. 10-21-2011, 09:11 AM #4
    orange's Avatar
    orange
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Glad you got it working.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. RunSQL String Problem
    By Swarland in forum Programming
    Replies: 3
    Last Post: 12-14-2010, 09:30 AM
  2. my first DoCmd.RunSQL
    By broecher in forum Programming
    Replies: 4
    Last Post: 11-05-2010, 09:35 PM
  3. docmd.runsql update
    By Mitch_Aus in forum Programming
    Replies: 2
    Last Post: 10-05-2010, 09:45 AM
  4. Problem with DoCmd.RunSQL
    By Peter01 in forum Programming
    Replies: 2
    Last Post: 09-10-2009, 07:11 PM
  5. docmd.runsql not working
    By Rameez in forum Programming
    Replies: 3
    Last Post: 08-07-2009, 10:07 AM

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