Recent content by arnelgp

here is a demo, view the code on the Button on form1.

i have just Returned the external drive i purchased, it's made of china and what inside is just like a small pendrive. the drive is 4T. i needed it to backup my files 90G. it copied alright, but the problem is all the copied files are not readable or not in expected format.

if you have already a solution just ignore the sample db. the demo db is for others, who will find your post and will find it useful for them.

here is another demo, the code provided by Mr.DougSteel.

you can add 2 dummy textbox in front of those comboboxes.

test your form and check out the code on AfterUpdate event of txtProductCode.

Oh no.. I will miss my Grand School Teacher. We have many quarrels on the past (even on PMs). But not enough, I supposed for her or Me to leave.. anyway, Farewell my friend (just follow the light and the end of the tunnel..) you will have more time with your Amigas playing your favorite card...

you put it on onedrive or dropbox and share the link, so anybody can try to recover your db. I also have S. Repair for Access.

most that i know are looking for someone who can work on google sheet (with script). so they want their sheet available over the net. plus, if you are very good in making outstanding dashboard in google sheet.

i got the translation from Google translate, so pardon me. i have worked, during my early days, in saudi arabian army in tabuk.

بسم الله هير الرحمن نير رحيم

on the AfterUpdate event of txtProduct, I Activate the Timer Event and on the Timer Event, I clear TxtProduct and Setfocus to it.

When you Requery the form, all Bookmarks are reset (invalidated), and the Bookmark that you saved will not guarantee to put you on correct record.

you call VendorIDBeforeUpdate() again on the DblClick Event: Private Sub cboDefaultVendorNo_DblClick(Cancel As Integer) On Error GoTo cboDefaultVendorNo_DblClickErr ' Populate cboDefaultVendorNo in code MakeFormPick Me.Parent.Name, "frmCrdVendor-Pick", "cboDefaultVendorNo"...

if you can share a trim down version of your db, so we know what is going on.