Recent content by jessiep

How do I change an AutoNumber that will output 1, 2, 3 to output 0001, 0002, 0003?? Thanks Jessie

I have a button that will do two different functions 1 to open a form and 2 input data into the classType field. In order to do this would I need to use a Macro with setValue? How do I do this?? When the button is clicked input “CPP” in to the classType field of the EqTable. Please Help!! Jessie

I need to change the background color to yellow if the ECDate is 2days or less from today's Date. how do i calculate the two dates? what will be returned? (2 days or 48 hours) Thanks, Jessie

I am using Dlookup to look up LastName, I have AssignBy = DLookup("[LastName]", Employees, "POC =" & Me.Combo22) I am getting an ERROR ""You entered an invalid argument in a domain aggregate function" I need AssignBy = LastName from Employees Table where POC=what is selected in Form for...

I am using Dlookup to look up LastName, I have AssignBy = DLookup("[LastName]", Employees, "POC =" & Me.Combo22) I am getting an ERROR ""You entered an invalid argument in a domain aggregate function" I need AssignBy = LastName from Employees Table where POC=what is selected in Form for...

In a form I have created a button to send an email. I am trying to write code to fill out the email fields To, Subject, and Body The information on who to send the email to is on the Form how do I take that information and lookup the email address. Also i need to lookup the First/Last Name to...

I am trying to add 3 new fields to my report. The 3 new fields are from a different Table. I am getting an error " Type mismatch in expression" MainTable TaskID -AutoNumber Status - Memo OnTarget - Yes/No Expected Completion Date - Date/Time POC - Text Description - Text EmployeesTable POC -...