Search results

Hi All, How to avoid generating sequential ID if before update event took place? below is my codes in the Before update event and Save button: Private Sub Form_BeforeUpdate(Cancel As Integer) On Error GoTo ErrorHandler Dim strLinkCriteria As String Dim strMessage As String If...

First of all thanks for your prompt response, I meant by Barcode value is that, to get a unique reference from a built in function or some how to reference my Barcode, unfrtuantly if I use the PK then there will be a missing numbers because of reverting in data entry process. Any further...

What is the best approach to set a Unique number for Barcode values? To be used reference our customers files may one customer has many files depends on account type. The minimum value would be the best. I heard about algirthum is it ok to use? Thanks in advance! Sent from my HUAWEI...

Thank you so much it's working :)

Hellow, try to save two records or more by choosing deferent departments and go previous and next then you will see that the ( Sent to ) disappear but in the table ( tblDeptReg) will not be affected.

I am so sorry to bother you with my problem. Kindly check it now.

Yes, it's a data entry form and it supposes to be like that.

Could you check the below attached? You will not get this error again.

I am still waiting for a solution to below post: https://access-programmers.co.uk/forums/showthread.php?p=1622910#post1622910 Your prompt response would be highly appreciated.

Any further suggestions are welcome ASAP.:) Thanks a lot in advance!

Sorry, I did a mistake. Please ignore the previous attachment and use this instead.

Sorry by the way I am struggling :banghead: with to get the easiest way when I have an update to an existing front-end database and I want to distribute it to our users in the organization through a shared folder (Local network) it's very difficult for me to do it for every user's machine I...

It's the startup form: frmDeptRegSender

Please find my db attached.

No, there isn't any code. I guess because of the requery in the dept combobox, when I enter two records for an employees from the same department no problem but when I select an employee from another department then the previous records will empty the employee combobox. I think maybe I have to...

Yes, it is.

Hi everyone, I have got a two comboxes (cboDept) employee department requery a (cboEmployee) employee in a data entry form. The issue is when I finished my entry and try to see my records go previous I got the cboEmployee become blank. How can I avoid the cboEmployee to become blank? Thanks...

What is the best approach to achieve a splited database in Microsoft Access to generate an approval workflow forms dynamcly among the departments with a capobolaty to add a new forms from the back end database? Thanks a lot in advance! Sent from my HUAWEI NXT-L29 using Tapatalk

I thought the vba can do this trick. Thanks a lot! Sent from my HUAWEI NXT-L29 using Tapatalk

Thanks a lot for your earliest response as usual. I will try your suggestion and I will let you know. Thanks again! Sent from my HUAWEI NXT-L29 using Tapatalk