Recent content by TomKat

Brian, I see it now, the me.datein should have the "Date" there... must have been left out.

That's fine, if it moves to the next row and saves what is in that row, that is perfect. Then when they hit the button, it will update the main tables which is exactly what I want them to do.

Oh, I just put the one line that contained that data vice the whole If statement. I still struggling to get this to loop through each record to verify each field is validated based on the IF statements, if not then cancel the update and return to the form. If all is good, then update the data.

IsNull(Me.Prior_User) And Me.DateIn = Date And (Me.Type = "Desktop" Or Me.Type = "Laptop") Criteria: if the field "Prior User" is empty and the field "DateIn" equals today, then notify the tech. IsNull(Me.EmployeeID) And Me.DateOut = Date Criteria: If the field "EmployeeID" is empty and the...

DateIn and DateOut are fields. If the date in "DateIn" or "DateOut" field is equal to today (Date). Then do whatever else is stated. That is the only way I saw that works or told is to use the "=".

How do I toss that into working directly with the Temp table? is that tossed in some event on the main form?

The data is in a temp table. Once the techs update the information and hit the save/update button. It updates the main tables and clears the temp table. The whole idea is when they hit the button, it should cycle through each record and verify the necessary data is filled in. If it is missing...

Ok, next problem on this is that this form is a continuous form. Right now, it will not go to the next record to check for the missing or empty fields. It only runs on whichever record in the form the cursor is on. I would like this to go to each record and check for what is in the If statements...

Ok, I see now. If you have the same field but need to list it with two different types of possiblities. Then enclose those in parantheses. Thanks... I will try that when I get back to work tomorrow. :)

Ok, how do I use the parantheses? Current way: Me.Type = "Laptop" Or Me.Type = "Desktop" Correct way?: Me.Type = "(Laptop, Desktop)"

I have an ElseIf statement. If the field is left blank when the tech hits the save/update button. It prompts them that the field is empty and to fill it in, then takes them to that field. Problem is that if the field is filled in, it still pops up the prompt and will not allow the tech to...

I have an append and an update query. I would need to use it in both. In the query itself, where does those go? Field? Table? Append to? INSERT INTO (FieldName, ...) SELECT CorrectName([LastName]), ... FROM TempTable I have the following: Fields: FirstName Table: User Import table...

Hello, I have a macro that dumps employee names into a temp table, then dumps them into the main Employee table. Yes, I could probably dump them straight into the main table. The temp table is used in another query as well. My goal is to fix the names in the query by using the "CorrectName"...

DKinley you are the man! that worked. Appreciate your assist!!!!!!!

I got it, there was an extra ")"