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