Change order numbers

Author	« Topic »
Marshall Ecommerce Template Guru USA 1916 Posts	Posted - 07/30/2018 : 09:10:45 How do you change the order number in Access? Seems all methods I have tried have failed. Any help appreciated. Marshall CENLYT Productions - ms designs Affordable Web Design Custom Ecommerce Designs Responsive Websites Cenlyt.com
Andy ECT Moderator 95440 Posts	Posted - 07/30/2018 : 09:25:13 Hi Marshall I'm pretty sure there isn't a way of doing that in Access. Andy Please feel free to review / rate our software
Marshall Ecommerce Template Guru USA 1916 Posts	Posted - 07/30/2018 : 09:37:26 Believe me, I tried. The only way I can see of doing it it open Access and keep hitting Add or Insert, whichever it was, until you reach the desired number. Thing is, I want to bump it up 200 numbers. Marshall CENLYT Productions - ms designs Affordable Web Design Custom Ecommerce Designs Responsive Websites Cenlyt.com
dbdave ECT Moderator USA 10468 Posts	Posted - 07/30/2018 : 09:48:21 I have this info - Let me see if I can locate it.
dbdave ECT Moderator USA 10468 Posts	Posted - 07/30/2018 : 09:51:00 Ok, make a backup of the file before attempting. I did this for Judy a few years ago, and I had changed another, so I know it works. Copy the db locally and work with that. Open with Access (I'm using 2003) and create a new query against the Orders table. Switch your view to SQL and replace any code with the code below, replacing 1999 with the number just before the one you want to be your next order number. INSERT INTO Orders (ordID) VALUES (1999); Run the query then open the Order table. You should find the last record ID is 1999. Go ahead and delete #1999 record and upload the db to your site but first make another copy or rename the live db. In this example the next order that is created will be #2000.
Marshall Ecommerce Template Guru USA 1916 Posts	Posted - 07/30/2018 : 10:12:06 Have Access 2007 and could not find anything like you described. Thanks though. Marshall CENLYT Productions - ms designs Affordable Web Design Custom Ecommerce Designs Responsive Websites Cenlyt.com
dbdave ECT Moderator USA 10468 Posts	Posted - 07/30/2018 : 10:37:13 If you wanted to send me the .mdb file, I could do it for you. Any version of access would have the ability to run a query on the database. https://www.google.com/search?q=how+to+run+a+query+in+ms+access+2007
Marshall Ecommerce Template Guru USA 1916 Posts	Posted - 07/30/2018 : 17:39:01 Leave it to YouTube - https://www.youtube.com/watch?v=hiWqqlT0G2E Get video and it works. Marshall CENLYT Productions - ms designs Affordable Web Design Custom Ecommerce Designs Responsive Websites Cenlyt.com
	« Topic »