Search results

Thanks, sorry for my late acknowledgement.

Hi, I made some minor changes to my login form and I am having a problem when user key in invalid username/password, it will prompt me an error message (run-time error '3201': No current record.) I tried testing with the followings correct username, password and account is active, is working...

How do i do a back end password protect?

I dont want them to edit the backend data directly. If they want to edit, they can edit at the frontend through the form which require them to login. And it capture which user login so there is an audit trial.

Yes, they can see the data on frontend

No, is not on shared folder. Was thinking of creating a virtual encryption folder.

Sorry they can add record from the front end. But i do not want them to see the backend table and data

Hi, I would like to share an Access file with my classmates. They can add data through the form. However, I do not want them to see the backend data. I changed the access form to modal setting and create an accde file. But is there any other way to prevent them from seeing the backend data...

Thanks. I think is a little too complicated for me as I have very little knowledge one Access

Hi, I got an edit form where user can edit the saved record. May I know how do I use macro to update the record and save a log of who edit and when the user edit? The user will need to login to edit and I already have set a tempVar to store the username with the login details. I created a...

Oh, i see

Sorry, I just realised there is an attach file button. Previously, dosent seems to have. But for conversation, there is no attach file button. Thanks

How to upload attachment file in the post?

Edit: Thanks, is working already. I changed the multiple select from simple to extended. Not sure why after the change, then it works.

I tried and is not working. Maybe i do it wrongly. Do you have any image example?

No there is no default selection defined

How do I add a null value in the list box?

I have a macro to clear my forms (cbo, txtbox). Recently, I added few listbox to my form and the clear button wont work. Anyone can advise? My current macro is using runmenucommand > UndoRecord

Ok thanks. Only 1 user can login at one time

Sorry, for this Me!Label1.Caption = Tempvars!tvarUserName.Value I placed = Tempvars!tvarUserName.Value into the unbound textbox (default value). Not sure if it is correct, but the username is as per login