Search results

Yes, much appreciated the issue is gone. About the images in gallery, some of them are still used by other forms, but some are not. I really forgot which one is using because they migh be similar name. Is there any way to check and remove unused images?

Thank Doc_Man Yes, that Close button was set with "Quick Style". The preset formats are nice, but it seems I have to get rid of them

Hi Everyone When navigating through records, the button Close is appeared with strange bold shadow. When I move cursor to this button, the shadow disappeared. Other buttons have no problem at all. I am using O365 64bit, window 10 Pro (19044.1348) I attached sample db, please help to take a...

Hi Somehow the RecordLock properties of form B is set to All record, that mighe be the cause. I have treid to remove it, it then works well without any error

Hi DB Please find attached db. The code is in form FrmSub_PhieuNX

Tested, it is not dirty

Yes, I am trying to copy a record from A to B. There must be something wrong elsewhere. This is not first time I encounter this problem The screenshot when subform B recordsoursei s not set not NONE Forms' properties

They are 2 different tables. Actually subform A (continuous) bounds to TBLPRODUCT, subform B (continuous) bounds to TBLTEMPNAME. Subform A has controls: Txt_ID, Txt_Qinfo_Code, Txt_Qinfo_Pname hold value of field ProductID, ProductCode and ProductName. Button on subform A is to select product...

No, they are bound controls on other subform (call it subform A). My correction: The button is not on mainform. It is on the subform A.

Hi Everyone I have a continuous subform (call it subform B) bound to table TBLTEMPNAME. There is a button on subform A what is to insert new record to TBLTEMPNAME therefore to subform B. However, before running InsertSQL I normally have to remove the recordsource of subform B to NONE , if not...

Oh, now I understand about OpenArgs, I have never known and used it. A great learning for today. Much appreciated your helps.

Thank Arnelgp I also have other button to open the form FrmProduct not in newrecord mode. Thus, how to differentiate them? Should I make a global varibale so that Load event can perform according. My bad habit is always try to minimize number of global variable unless it must...

Hi Everyone My table TBLPRODUCT have a number of records. I want to addnew record but it requires to open form FrmProduct with full records from table. So I tried with code: DoCmd.OpenForm "FrmProduct" DoCmd.GoToRecord acDataForm, "FrmProduct", acNewRec You can imagine it requires two steps...

You are an expert... it is so simple and effficent

I have tested, it works great.... Thank you very much!

Yes, That is good approach work. I will try it. However, I am really afraid of overlap controls, it might causes flickering, form crash ( i have read it somewhere...), In fact, my form is currrently crashing unpredictably...

Hi everyone I have product table and form to display product detail together with product's images. I intend to copy all product images to a folder path: CurrentProject.Path & "\DAT\Photos\" and names them same at productID, for example: The ProductID=1 will have Image names "1.jpg" It not set...

Actually my VBA code is pretty simple, no special Reference lib. There is only one compiler switch #If VBA7 Then Public Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) #Else Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) #End If Until now, I...

Thank you, Sir. For me, i dont know which version (32 or 64bits) customer using, since I distribute accde file so it is likely I have to have both 32 and 64 bit available...

For those projects have been mixed design using both O365 32bits and 64bits. Can I create a blank project in 64bit then copy whole things from the mixed one? Does that help to eliminate the potential issues?