Search results

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?

Oh God, I did not know that. In fact, I have developed most form, report, queries and VBA code on O365 64 bit. After crashing occurs oftenly, i try to search and ppl saying that 32 bits version is better. Therefore, I install 32 bits version which is currently using. However, there were 2-3...

I have a project on Access 365 (32 bit) which there is one form crashing most of time when I go to form design or typing code in VBA editor, confirmed it also happens on O365 64 bits... Will try to narrow down. It is really anoying. My currrent solution is go to virtual machine and work with...

Cbx_F_MaVT = Nz(Forms!MainFrm.SubFrmTable.Form!Txt_Qinfo_ProductID, 0) ' MAVT_Criteria_Str = "P.ProductID = " & Cbx_F_MaVT My concern is: whenever Txt_Qinfo_ProductID is null, it reassigns to productID 0, what if my db has productID 0? Then I talk to myself: productID is autonumber...

Dear CJ_London Thank you for spending your valuable time reviewing my code. The working principle is: There are 3 parts in main form: + Filter (on middle top) to allocate exact product that user want to find (I think about list of 1000 products, it hard to manually allocate..) +...

Dear CJ_London, Sorry for inconvenience. I have fixed compiling error by removing undeclared function/variable, I also replaced the attachment in 1st post As mentioned, I am newbie so it is poor design....sorry about that In fact, I dont really know what the role of database relationship is...

Dear CJ_London I have filter elements so that en-users can seek exactly what they want, however they can also reset the filter, in that case, all record should be shown, likely you remove all filter excel sheet.

Hi, The first file was exceeded file size limit, I have compress and attached it again

Hi Everyone @Edit: Attached the db file I am actually an electronic hardware engineer. I dont have much experience in IT field. I have been learning Access since 2020, Anyway, my fisrt access program was sent to my friend last year (at that time, I did not even know to compile and split db)...