Search results

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)...

I silently checked my login-form. Somehow, it bounds to tbl_User accidentally, it could be my intention in the past. But textboxes dont bound to any field. Therefore, I dont have "delete all" record issue. But for safety, I have removed bounded table from the form. :)

I have found this thread after mine posted... https://www.access-programmers.co.uk/forums/threads/send-message-to-specific-user-in-access-multi-user-based-system.314141/ Downloaded arnelgp example code, if i am not wrong, it only can check the new msg at the momment of form opening. So, what if...

Hi everyone, I am designing an access program that shares BE for multi-users on LAN... I currently dont know how to push a message to specific user. For example, an inventory user has just made a goods delivery request via his FE into system. At this time, the FE of accountant-user should...

Thank you, It is clear to me. so SQL server with Access is helpful to by pass Access limitation of of 2G BE size, SQL server might handles conlision better than Access... But at the end, Access BE and SQL server is not a good choice to go "online app". Thanks again for your clarification

Hi everybody I am not a database guy, my first Access program was built and delivered a year ago, I had learnt everything myself from our forum and internet. Until now, I can completely build an small access program for single user/PC. I am learning to share the BE on network drive and mutiple...

Yeah, I saw your update, as statistical theory: The larger sample size is always give the better result. Thank very much for your efforts. Unfortunately, yes, update every second. Let me remove the "second"

Oh, yes, my form having timer to display current date time on top of header section...But your form doesn't. Flickering happens on both my form and yours. I have tried to use Application.Echo but no helps. I remember I have asked someone in our forum a year ago, he tested my form and no...

Impressive test! What makes difference btw constant "1" and "*" ? However, my feeling is DCount* meaningful to recordcount.... it just counts whatever :))

Yeah, I have studied the design, One continuous form and most of controls are placed in its header section. Therefore, it looks like split-form. My current project is almost same concept but the continuous form is in a subform, so that I can save its left or right side area for other things...

I just downloaded. It is great demonstration. I will "Ctrl +H" my VBA code now :))

Split form of Access is not flexible enough. Yes, my subform is not updateable, it is to only display the product list. Why dont you ultilize the mainform to shows the detail? What is benefit of using second subform? btw: When design the forms in this way, both forms are using same data from...

I did not know that, so far. So it sweeps through all row and add 1 to the result?