Recent content by ohappyday

Hi - Yes, you are correct. I used JPaulo code to get me started, but I tweaked it a little to make it work for me. Thanks so much for responding!

Hi JPaulo - Happy New Year! I just used your code in the sample database and it worked just fine. Thanks so much for your help!

Can't get it to run with your example, but I think I may know why?.... I have a field 'Privileges' that I also wanted to incooperate along with username and password. I want the code to verify the username and password are correct. Based on the username, I want the code to perform a dlookup...

Hi JPaulo - If your 'Identificacao' was String instead of an Integer, how would you change your code? I am getting type mismatch errors. Thanks

Thanks for the response. I will take a look at the db you sent.

Ok, I have searched and searched for the answer to my issue and I can't find a previous thread that will help.... My code is not working... :( I created a login form for my Access 2007 db which requires each user to login. Once they are logged in, I want them to have access to certain forms...

I think I found some dialogue with 'bob larson' and another user that may help with my question. HiTechCoach - Thanks again for your response.

HiTechCoach - Thanks for the TIP, but I think I was using the correct terminology. My reference to SQL was referring to the BE.

Hello - I need some advice on how to share a db with mutliple users across the WAN. Each user will access the db to input their work hours and tasks. I am not sure of the best way to share without major issues. I was thinking of splitting the db into FE and BE and placing the BE on a...

Thanks!! I tried the solution this week and it worked!! Thanks so much!!!!!

Thanks for your help. I keep getting #Name? in the field on Subform 1. I am using 2007, is rowsource actually control source in 2007?

Hi - I have 2 subforms (sub 1 and sub 2). I would like to link a field that is populated on sub 2 and have the value appear in a read only field on sub 1). How can I do this? Thanks!

Thanks!! It worked!!! ...I would have never figured that out. :D

I can? How do I reference the field on the other form? Would I use the following code? Me.AllowEdits= Not (FormName?.Status = "Approved") Me.AllowDeletions = Not (FormName?.Status = "Approved")

It will allow me to edit on the subforms, but it may be something I am doing wrong. Thanks again for your help!