Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old March 2nd, 2012, 06:19 PM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Update Query Using Autonumber Value from List

I have created a button that activates an update query. The update query updates a date field in my database with the NOW date function. The update query's criteria is the ID field from a list I made in a form referencing the same table that the date is in. The ID field is an autonumber.

For some reason, the update query works for any other criteria columns in the list, eg. style number, team, etc. but it will not update if I set the criteria to ID.

Is there some rule in Access that is preventing me from using the ID criteria?

Thanks,

Alex
Reply With Quote
  #2 (permalink)  
Old March 2nd, 2012, 07:20 PM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Update/Solution

The update query will only work for the bound value in the list. My list had several different columns, but the bound value was set to 1, which is the first column, "style #", which is why style number worked and nothing else did. I changed the bound value to 5, the column of my autonumber, and it worked.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update query doesnt run when Select query does (In MS Access) rmccafferty SQL Language 3 February 11th, 2010 04:54 AM
Retrieve Autonumber field and update it carrie09 Access VBA 3 November 2nd, 2007 07:32 AM
Autonumber Query Brendan Bartley Access 2 July 16th, 2006 02:14 AM
Autonumber in a query crisan Access 2 May 11th, 2005 07:58 AM
Table Autonumber Update chloe Access 7 February 27th, 2004 06:48 PM



All times are GMT -4. The time now is 08:06 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.