Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Update query prompt (Access 2000)

    I have created a simple update query to fill in a couple of new fields in a client table by concatenating the contents of some other fields, but when I run the query, an "Enter ClientId" parameter entry prompt appears . I tried entering * (for all) but I get an error message. Where is this prompt coming from, and how can I get the query just to run and update all the records in the table?

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

    Re: Update query prompt (Access 2000)

    Please do the following:
    - Open the update query in design view.
    - Select View | SQL.
    - Copy the SQL text to the clipboard.
    - Paste it into a reply to this thread.

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Re: Update query prompt (Access 2000)

    Thanks for your reply. Here is the code.
    UPDATE Clients SET Clients.Username = [Name1] & [Family name], Clients.[Password] = [Family name] & Int((99-10+1)*Rnd([ClientId])+10);

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

    Re: Update query prompt (Access 2000)

    Are you sure that ClientId is a field in the Clients table, and spelled exactly like that?

  5. #5
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Re: Update query prompt (Access 2000)

    Oops! Thank you, yes, I copied this from another query, and needed to specify a different field for the random seed.

Posting Permissions

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