Recent content by BlueStarBrite

Let's see if I can clarify my question, I think I got confused myself when I added in the ApprovalDate: PersonA: Approval Date = 7/7/2008 Expiration Date = 7/7/2009 Today's Date = 4/8/2009 Today's date (which is 90 days prior to the expiration date), PersonA should appear when I run the...

Thank you - I will give this code a try today. I didn't even think to use both functions together. And the Reminders link you sent is exactly what I am looking for once I get pass my code problems. Thanks! :D

Ok, so I need help figuring out a DateDiff/DateAdd solution. I have been searching the forum but havent come across exactly what I need. I have 3 main variables that I want to use in my calculation: 1)Today's date 2)ApprovalDate 3)ExpirationDate I know how to calculate 90 days prior to the...

Thank you! Thank you! Thank you! Worked perfectly :D

Ok, I have searched the thread on how to print the contents of a listbox, but not found a viable solution. The solutions I found do something totally different than what i want. I am a newbie to access, but I know this can be done with a simple solution. I have a form that has a start and end...

Ok, I could not get it to work. I keep getting an error message: Run-time error '3075' Syntax error (missing operator) in query expression " '&me.ClientID&' I looked up the error, but cannot figure out what's wrong. Any suggestions? :confused:

Yes, this is essentially what I want my Table2 to be. I will give this method a try and let you know how it goes. Thanks!

In Table 2 I just want to store a clientID and a DateChecked/Unchecked Date. Ex: Client123 12/01/1999 03:22:00PM Client123 01/15/2000 04:25:00PM Client234 03/01/2006 07:51:52AM I need to do it this way b/c I eventually will need to create a report that calculates the time between...

Ok, I have another newbie checkbox ? I have a checkbox that once its clicked or unclicked, I want to do 2 things. For Table #1: I want to update the Yes/No Field and text to flash to a label (This part I know how to do) For Table #2: I want to insert the date EACH time the checkbox is...

Just thinking out loud -- would it be easier for me as a newbie to just create a subform that list the clients actions that have been completed and add combo boxes that would populate the subform? :confused:

Thanks Steve. To capture the user that clicks a checkbox, I'm thinking I would have to do something like an audit trail. I'm searching the forum for info on that now. I'm still lost a little: For question #2 (Question #2: Once the checkbox is checked for each step, how do record that action...

Ok, lets see if I can explain my issue clearly. I need some guidance in the right direction. I'm a newbie to Access, using v2003. I have a table named ActionSteps with 2 fields: ActionID & ActionDescrip I have another table named ClientActions tied to the ActionSteps table. I want to create...

THANK YoU! THANK YOU! THANK YOU! That worked perfectly :D

Ok, so I have a login form in which has username and password fields. I am wanting to collect the logintime and the logout time for each user. Initially before I added the password code field, it was tracking the login/logout just fine. However, now its not. I am not sure where I went wrong and...

Thanks! That worked perfectly :D