Add record button

[brocsman]

Everything is working now in my first version, just a form, tables, some queries, and the main report, which replicates the original, so all good. Thanks for your help.

Another data question. While testing a couple of the tables I put in dummy values to the first couple of tuples, and have since replaced them with "real" values, but the autonumbering starts from the first number after the deleted dummy records, and I need to reset them to start at 1. How do I do that without deleting and rebuilding those tables?

Thanks again

 

[John Big Booty]

Everything is working now in my first version, just a form, tables, some queries, and the main report, which replicates the original, so all good. Thanks for your help.

...

Good work

...

Another data question. While testing a couple of the tables I put in dummy values to the first couple of tuples, and have since replaced them with "real" values, but the autonumbering starts from the first number after the deleted dummy records, and I need to reset them to start at 1. How do I do that without deleting and rebuilding those tables?

Thanks again

I'm going to quote Bob Larson here, simply because I couldn't put it any better. Pay particular attention to point 2 in Bob's response

1. Yes, you can clear the table and then do a COMPACT AND REPAIR of the database and it will reset.

2. You really shouldn't care whether they are reset or not because autonumbers shouldn't really be used for anything other than generating a unique number for a surrogate key.

3. I have a database reset tool which can clear your tables (and bypass any you select to be bypassed) and reset the autonumbers. It is free and available in the Access Tools section of my website (see my signature).

If you really want a sequential numbering system that starts at one , then have a look at the Dmax() function plus one, and search this forum on the subject of custom auto-incrementing numbers.

 

[nikole95.7]

Yes, absolutely right again, but my form doesn't clear. How do I set it to display with all fields vacant?

If by "my form doesn't clear" you mean that the comboboxes are showing the last selections made in them, you've omitted one or more of the steps given above, possibly #2, which needs to be done for each combobox. You need to go back and step thru the instructions again.

 

[brocsman]

If by "my form doesn't clear" you mean that the comboboxes are showing the last selections made in them, you've omitted one or more of the steps given above, possibly #2, which needs to be done for each combobox. You need to go back and step thru the instructions again.

Thanks - I've solved that problem now

 

[brocsman]

Good work


I'm going to quote Bob Larson here, simply because I couldn't put it any better. Pay particular attention to point 2 in Bob's response

If you really want a sequential numbering system that starts at one , then have a look at the Dmax() function plus one, and search this forum on the subject of custom auto-incrementing numbers.

Thanks for this. I'll certainly have a look at your stuff. I know the sequential numbering isn't significant, however I would like to deliver a "virgin" copy of the new stuff, just for the sake of appearances.

Thanks again for everything.