Counter Number and Tab index for form footer

[Raveen1609]

I am developing a billing application for my small business. I have following couple of issues in Access 2016.

1. AutoNumber for Invoice ID is not working well, so I have created a field for counting Bill numbers. I use
Private Sub Form_BeforeInsert(Cancel As Integer)
BillNo = DMax("BillNo", "Invoice Table") + 1
End Sub


On loading the new form new record, I setfocus on Clock1 Field. OnExit the clock1 field, the bill number is adding +1 and it is working fine. Now the problem is when I click goto previous record navigation button, the counter is adding another empty record with the next number and then going back to previous record. Another record is created without datas and only with the BillNumber.

2. In the sales receipt after selecting and entering the required products in few rows, I need to set focus to the printing command button in the Form footer section, which I am not able figure out. Everytime after completing the receipt, I need to use mouse to click on the button, whereas I need to use tab / Enter Keyboard, for directly going to the cmdPrint button. so that I can use entirely keyboard to complete the invoicing. Avoid using mouse to speed up invoicing.

Thanks

Kindly help

Edit Post Reply Reply With Quote

[Gicu]

Without seeing you db it is almost impossible to give you an answer for the question number 1. As for the second one just set the Default property of the cmdPrint button to Yes and it should act as you want.

Cheers,

[ssanfu]

1. AutoNumber for Invoice ID is not working well,

Not sure what this means. The autonumber field is not providing a unique number for each record?
Please explain.....

[Raveen1609]

The autonumber field is jumping numbers, so not consistent. So I created another field and use dmax function. I have used this function in the BeforeInsert event. When the form is opened, the value is 0. To activate the form, I use the clock1 field to default value of Now() on exit. and set focus to a field in subform.
Me.[Clock].Value = Now()
Me![Invoice Details Query1].Form.[ProductName].Enabled = True
Me![Invoice Details Query1].Form.[ProductName].SetFocus

All the above are working fine. But the problem is whenever I exit the form to goto previous record another empty record is created automatically with the next number.

[Gicu]

I think that is happening because you are dirtying the form by assigning Now() to a control programmatically. Again, hard to say without seeing your form(s) but I suggest you try to remove the code from the Exit event and set the Default Value for the Clock control to Now() instead.

Cheers,

[Raveen1609]

Thanks for your reply. I have attached the sample db. Yes after setting Now() as default value is working ok. But I need another field to setfocus on open to activate form??

[Raveen1609]

Regarding the setfocus, on the cmdprint command, the default property is set to yes. After entering the datas in the subform, how do I set tab goto the CmdPrint by enter keyboard. It is not moving, do I need to do any programming in subform for the tab to move

[Gicu]

Sorry but I can't see your db anywhere, you may want to attach it again (look at the top of the page for a How To Attach Files button).

Cheers,

[Micron]

Sorry but I can't see your db anywhere, you may want to attach it again (look at the top of the page for a How To Attach Files button).

Cheers,

Added to first post by the look of it.

[Gicu]

But in a different thread all together that I was not even aware of , seems to be exactly the same questions.....

[Micron]

But in a different thread all together that I was not even aware of , seems to be exactly the same questions.....

Well I confess that I didn't try any of those 3 links in post 1 but that's what I was referring to. You're saying they are elsewhere and not here, or they are in both? Doesn't matter I guess.

[ssanfu]

1. AutoNumber for Invoice ID is not working well,

The following used to be a page at UtterAccess, but they changed their site and I can't find it anymore.So I'll just paste part of it here:

Autonumbers--What they are NOT and What They Are
Please note that I did not write this. The name on the post at UtterAccess is Jinky.

What they are NOT:
1. Row (record) sequence numbers.
2. An "order of entry into the table" number
3. A "gapless" series of numbers.
4. Editable numbers.
5. A series of (necessarily) always increasing numbers (see note 1 below in the attached file).
6. Intended to be viewed/used by end users of the application.
7. Predictable (as to what the previous or next one in the table is/or will be).
8. Reassigned, once deleted or discarded (exception: see note 2 below in the attached file).
9. A predictor/indicator of the number of rows in a table.
10. Intended to be used to "rank" or "sort" or "number" rows returned from the table (see note 5 below in the attached file).
11. Necessarily used to determine the default order the rows may be returned from the table (see note 6 below in the attached file).
12. Indicative of or related to any TimeStamp field that may also be in the table row (see note 7 below in the attached file).

What they Are:
1. Unique numbers used to identify individual rows in a table.
2. Automatically created by Access when a new row is "instanced" by Access (see note 3 below in the attached file).
3. Great/Outstanding/Essential for use as the Primary Key of a table.
4. Great/Outstanding/Essential for use as "link points" by Foreign Keys in other tables.
5. Unchanging, once assigned to a particular table row (exception: see note 4 below in the attached file).


There is more - but it is quite long, so I attached a text file


Also check out Microsoft Access Tables: Primary Key Tips and Techniques