Search results

Totally agree with Shep. Personally I would avoid using an autonumber field for "meaningful" data. However I have seen it used as such in the company that I work for (a couple of us access newbies), which is why I found out a fix for this. :) but as you point out the best way to avoid these...

Absolutely brilliant. I also see that I have go back to the books with DAO! Many thanks again.

Hi all, I would be grateful if anyone could enlighten me. The database I'm writing is to hold information on the technical specifications on components of products used by the engineering company I work for. There is one table per specification document, and one table linked by a one-to-many...

I've asked around on this before also. The best answer I was shown was to use an insert query specifying the number that had been deleted in the particular field. I guess that you could write code which opened the recordset and used with rec .addnew !field = 3 (where 3 is one of the...

As Brad points out this will be covered in Access VBA books. I'd recommend reading about Data Access Objects which covers how to create records, tables, relationships, even databases at runtime using code. For your question I'd try something like the following to create a new entry in the...