Search results

you said you already has a resulting query? you only want to group them? create an Expression on your original 90 days query: Expr1: Date() - InitialDate now create new query to add the Group: SELECT [90daysQ].ID, [90daysQ].InitialDate, [90daysQ].FN, [90daysQ].LN...

suggested on post #2

the code came from Ai. first the printer must be set (default) to a real printer (not pdf). you open the Report in Report View and there is a "little" button that user can click if he want to Print or Save to PDF. Open ReportDemo1 in Report View.

there is an old Chinese story: a Chinese man complains to the court: "me no come" "wife no come" "baby come, how come?"

maybe Increase the Lockfiles and use Transaction on your update: Dim db As DAO.DBEngine Const maxDefault& = 9500 Set db = DBEngine ' temporary increase the lock files db.SetOption dbMaxLocksPerFile, 20000 db.BeginTrans With rs If Not (.BOF And .EOF) Then .MoveFirst End If Do...

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.