Search results

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!

Woohoo!! Thanks! That worked perfectly! Could I also use the same code on subforms that are related to the Main form by a field (Work Log ID)? Thanks again for the quick response!!

I have a table "Work Logs" that contains fields pertaining to an employee's timesheet. The fields are (Analyst Name, Week, Status, Hours, etc). The table and fields are linked to a data entry Form " Tech Work Log" that allows the employee to submit their information. After the employee...

Hello - Sorry for the delay in responding... Ok, I totally understand adding the code butt, but you are way over my head regarding references the fields. Once the button is selected, I want the user to enter data in fields on the Travel form (linked to Travel Table). The Travel Table...

Thanks for the quick repsonse! It's almost like your #2, but adding a new record just adds a new record to the table. I want all of the locations that the person entered for that week to link to the Tech's ID and WeekEndingDate. On the form, I thought I could have something like this...

Hi - I have searched the Threads for a possible answer, but since I am not sure what the process is, I don't know what to look for. Here's where I need help... I have a db which documents a technicans visit to various locations for support. There are is a main form and subforms (Hours...