Search results

Where is it? I am using A365 and could not find it in Access Option. This one?

Yes, exactly it is here. Just more curious: Only on this form, the default "Use theme" property is No. How to set the default to Yes? Try with ChatGPT help but I could not locate Use Theme (in step 4). I am using A365

That's what i am doing now

Hi everyone My default button style is somehow changed when I create a new button. I want the right-side style. How to get it back? Thank you

It works. The script quits without throwing an error msg to user. I think that is fine

Yeah, indeed I only see one account named Admin.

It does not help. Same error happened.

Furthermore, when I quit Access, VBS prompts this error:

Hi Arnelgp. First of all: It works What did you ask ChatGPT? I am not sure why keeping "script running to keep Access open" could solve the problem...

Hi all I have a VBS file to run Access app. My Access app writes few values to registry under HKEY_LOCAL_MACHINE, thus it is required to run with Admin privilege. My PC has only one account: Admin, no passwword and i am using this account. However I still have to use argument "runas" as below...

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