Foodlady,
You will need to change the data type of the field on the new table from Auto-Number to Number,Long Integer. Append the old records to the new table then change the data type back to Auto Number. This will allow you to keep the old numbers. As I said before, I never repeat myself.
It's usually a field formatting issue or bad data on the Excel spreadsheet. Try to copy/paste (make sure not to just select the whole sheet but only the data you want to copy)to a new spreadsheet then import the new spreadsheet. If that doesn't work, you might want to run Text to Columns on each...
Having fun with adp's. Using Ms Access 2002.
I have a login form called frmLogin which has two combo boxes cboStatus and cboResource. I am trying to select parameters from the combo boxes then open a form (frmTaskList -which uses an inline function query) with the Record Source qfctTasks.
My...
I have on ATAPI (generic) CDR and a SONY CDRW. When I boot up the machine I see that it recognizes these two drives but after startup I can't see them as logical drives!!!
When I go to the Add hardware wizard I get the following error.
Windows cannot start this hardware device because its...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.