Search results for query: *

Thanks kjv1611 and Locoman for responding! Last night, I just made the fields 'required' and customized the system message to inform the users to populate the required fields. This method is working. Thanks again!

Hi - Thanks for the modified code. I tried kjv1611's solution first since I was reading the thread from the bottom up. I changed my code to what you suggested, but here is the weird thing that is still happening. Once the user receives the Msgbox and tries to correct the problem (enter Task...

Hi Kjv1611! Here are my answers: 1. Access 2007 2. It's actually a bound combobox 3. It's checks to see if both items are completed when the users clicks on a Save botton. 4. The Trigger is VB Code: Private Sub cmdSaveTechWorksheet_Click() If...

I have a form that allows users to enter their tasks and hours. The fields are: Task (list box for users to select a task) Hours for each day of the week (allows the users to enter the amount of hours with associated task – HoursSun, HoursMon, HoursTue, etc.,) The form is a Multiple items form...

Hi there - Thanks to all who responded!! :) Perfect!! Page 9+ was EXACTLY what I needed. I need to 'normalize' the data a little more. Thanks again!

Hello - I would like to know if I created a table correctly. I have a main table where data is stored for Ta 0ask and Time tracking system. I have several small tables: Analyst - list of Technicians Week Date - list of Dates for each Week End Then..there is a large table (Hours) that stores...

Yay! You Rock!! Thanks again for your help on the db.

Another quick question about this issue...I would say I promise, but that may not be true. :) If I need to check for another field on that form (Worksheets) and display a message box, is this correct? I am just loading the Worksheets form and if the WeekEndingDates field is blank, I wwant the...

Hey TheAceMan1 - Well, you have done it again. Reading from the bottom up on replies, I tried your code first and it worked. You were right, I was trying to access Status before the form was open. You would not believe how long I have searched for a solution to this issue. :( Thanks again...

Ican't figure out why the Msgbox does not appear. What am I doing wrong? If the Status field on the Worksheets form is set to 'Approved', I want the form to open, but I also want a Msgbox informing the user that they can't edit the form. Here is my code: If "Worksheets.Status" = "Approved"...

Sorry..I sent the code twice.

Private Sub Login_Click() Dim StrPriv As String 'Check to see if data is entered into the UserName combo box If IsNull(Me.USername) Or Me.USername = "" Then MsgBox "You must select a User Name.", vbOKOnly, "Required Data" Me.USername.SetFocus Exit Sub End If...

Ok....don't laugh. This is my first database so be gentle... Private Sub Login_Click() Dim StrPriv As String 'Check to see if data is entered into the UserName combo box If IsNull(Me.USername) Or Me.USername = "" Then MsgBox "You must select a User Name.", vbOKOnly, "Required Data"...

Hi - well....when the password is wrong,I have an error message to display - "Password Invalid. Please Try again". Is that the correct thing to do?

Hi - Great! I didn't receive any errors. Thanks!!!

Hi TheAceMan1 - Ohhhh....hmmmm. How can I have it ping on both UserName and Password?

Hi - I read from the thread from the bottom up so I used Randy700's code. It worked perfectly!!!! :) Thanks so much for all replies!!

Hey TheAceMan1 - Yes, we should check for both username and password. I am stuck in meetings for the rest of the day (who has meetings on New Year's Eve???!!!). I will try some of the suggestions later today and let you all know what happens! Thanks for the replies!!!

Hi! Thanks for the response. Ok, so I ran the code and received the following error: Run-Time error '2102': the form name 'Privilege FSS Technician Login Dialog' is misspelled or refers to a form that doesn't exist. 'FSS Technician' is the privilege listed in the Analyst table and 'Login...

Hi there - Please help, yes I am begging. I am using Access 2007 and this is my first db. I created a login form for Analyst to enter Access to enter the work hours and tasks. The table (Analysts) consists of: Username, Password and Privilege Now, when a user logs in using their username...