Recent content by travel4u

BUMMER! :) That came to my mind earlier, but didn't try... IT WORKED PERFECTLY! Thanks.

I have following IF function in Macro (Field3 is text field): IF [Field01]=1 And [Field2]=0 And [Field3]="12" Question: [Field3] has 3 valid values: "12" or "1" or "2" I have tried this in function, but did'n work correctly: IF [Field01]=1 And [Field2]=0 And [Field3]="12" Or [Field3]="1" Or...

THANK YOU! :) I just changed write permission for that C:\\Users folder and NOW this works! :)

When I link that file on Access it shows path to that file like this:

Came to my mid as well, as C:-drive is under "Admin" (even I am Admin in this lap-top). Should I have to change that ActiveUser.txt file to D: drive?

See my earlier post minute ago :)

I changed semicolons to commas in this: Now I got this error: Clicking DEBUG it shows this:

Hey. I assume it is comma (,) in VBA as I tried to change then to semicolon (;) i got this errot:

Forgot this: I saved that VBA code with name modSaveActiveUser:

Thanks Arnelgp, I copied that VBA code to Access - it seems to run okay as no errors. I added RunCode in to Macro that runs after user is granted to open application: Pic #1: Something is not correct as Macro stops with following infos: Pic #2: Note: In Europe we use ; instead of , in above.

Thanks Arnelgp for this. I am not much done VBA's so not so familiar with this.... So this ActiveUser.txt file is already in each PC and code should just overwrite existing ActiveUser.txt with current user [LogInUserName] from Log-In form. Should I replace in your code pstrTextFile with...

Hello, I have kinda log-in form where is unbound field (LoginUserName). If access is granted I need macro(?) to save that LoginUserName in to local drive (C:\Users\ActiveUser.txt) file, as Access is reading that file data later. This ActiveUser.txt file has only one line of text (6 characters)...

THANKS! That solved this :) :)

Sorry no.... In European version of Access we use ; instead of comma :/

Hello PRO's, How to format to get results I want from Currency field? I need with leading zeros and without cent separator total of 8 digits: [CurrencyField] -> What I want to see on separate (unbound) text box: 15,29 € -> 00001529 1458,80 € -> 00145880 etc.? I have tried...