Search results

Thanks very very much! I knew it was something simple. Problem solved! Cheers, Dave

Morning All, Using Access 97, I'm trying to bind a text box to an existing form and I just can't seem to do it. Looking at the help index is absolutely no help as it recommends clicking the "record list" button (which is greyed out) or setting the "Record Source" property which isn't a...

Steve, Cheers for the email. Unfortunately I can't send you the database as its full of government information and I don't think they'd be terribly impressed. I've managed to get the data into a new table that has exactly the same field formatting as the existing table (typical) minus the...

Hiya, Yeah I am trying to populate a new database which I didn't write (unfortunately) but it does already contain entries which were copied across from a previous database. Thats half the battle, I don't know how the database was set up so I'm having to 2nd guess everything and my access...

Steve, No good. The only other thing I can think of doing is making a note of the relationships to the other tables, then deleting the relationships, deleting the autonumber, putting it back in and then putting the relationships back in. Not 100% confident with doing that though, what do...

Hiya Steve, I've tried importing it as a new table and it works fine. I suspect it won't let me import because I may have set some sort of formatting for the autonumber by accident. Is there any way of undoing that format so that it counts up sequentially again?

Hi All, Thanks for the replies on this, a bit of an update though. This morning I have exported the access 97 table into excel with the "save formatted" option ticked. I've then copied into this excel sheet the information I want to eventually end up back on the Access table. After doing...

Hi All, Not sure whether this has been previously covered, but hey ho. I'm having problems importing an excel spreadsheet into Access. It comes up with the generic "There was an error" error message and then thats it. I've been playing around with the data in the excel sheet importing it...