Search results

Thank Arnelgp and CJ_London The demo of Arnelgp works like a champ. That is what i have been looking for druing last 2 weeks. I stucked there, in fact I have to build a popup form instead of using cacading combo's. CJ_London's demo is even better, I will study carefully. Very happy now, thank...

Hi Arnelgp It works great but for new record only. If user changes Group of exising record, Subgroup does not filter out its rowsource.

Hi Arnelgp What if ContactPurpose combox's record source depends on selected value of Group? i.e: Group = A then ContactPurpose dropdown list = A1, A2, A3 Group = B then ContactPurpose dropdown list = B1, B2, B3, B4 Any idea please?

Just to fix Arnelgp's demo overlay issue. Bring txtDummy to forefront, set its background to normal (not transparent).

Hi June7 Your code closes form DialogGetDate as soon as it loaded. So, User has no chance to make any date selection on the form DialogGetDate? In my own code, FormB is closed right after it is opening.

Tempvar can store a string only, while I want textbox instance

Hi June Yes, that is what I am trying to do. After you selected value on form B, you make form B invisible in Keypress event. Which event on calling from (formA1, formA2...) trigger the data retrieving? In other words, when do you call this code 'user prompt for entry of logout date...

ChatGPT suggested me using Eval too, I tried it and I think we get same results :) btw, about this code: Set MyProductName = Forms!FrmA2.Txt_ProductName "Forms!FrmA2.Txt_ProductName" is actually value of the a textbox. Do you think you could assign it to a textbox instance? I tried it but no...

Hi Edgar Yeah, I also think about this way, but I was hope there is a better way without using a global variable. My understanding is that global variables could be reset if a runtime error occurred, so I avoid using it.

Yeah, it could be ProductID. I tried to study but I dont really understand your code, and i have doubt if you got my meaning in post#1. It like Edgar mentioned in post #4: when formB is opening, it's passed OpenArgs contains information about where it is opened from (form A1, A2 or A3...), it...

Hi all. I have forms A1, A2, A3... that contains subforms, and on these subforms I have textbox named Txt_ProductName It could be located at: "Forms!FrmA1.Form.Level1subA1.Form.Level2subA1.Txt_ProductName" (I assigned this string to Arg_str1) or "Forms!FrmA2.Txt_ProductName (assigned to...

Yes, user has permission to read/write to the folder. In this case, records are not being deleted since they are back in a while or back when we restart app.

Hi everyone My customer is evaluating my small Access project. Splited BE is on a network folder "\\data\accessDb\BE.accdb", Two users have their own FE on their desktop PC. These desktop PCs are joined to domain. Most of time, the system works fine as expected. About my app: + FE has...

Thank you. I have to convince my customer using window server then...

Hi all I am using shared folder on LAN to store BE file, but i saw this setting limit to 20 users only. My customer wants about 50-70 users install my Access app. What if there are 30 users opening Access app at same time? Is that possible to increase simultaneous users to around 50-70 user...

"L_TBLUSER_CURRENT" is on FE, and I also have a separate log in table that records users's login/logout on BE. "Remember me" is feature required by customer that I can avoid. Since each user has their own computer that dont share to others, they said they want "Remember me". Anyway, thank you...

Hi Pat Current user log (on FE) is only be cleared when user click on "Logout" button. Without logging out, next time they open the app, it will bypass login window (assume Remember me is ticked). So when user starting application, on AutoExec code, I do check: If DCount("*"...

Hi Pat Yes, that is more reasonable. I forgot about using Dcount... Code to set current active User Public Sub User_SetCurrentActiveUserID(loggedID As Long, Remember As Boolean) On Error GoTo ErrorHandler Dim rs As DAO.Recordset Dim DeleteSQL As String 'Just clear table first...

Thank Pat, Appreciated your suggestions. Yes, I understand about orphan record, and I have been trying to manage them like your guideline. However, in this case there is only one row in this table (this table locates in FE) to tell current logged-in user in this machine.

Yeah, it's exactly the point. My careless