Search results

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 ")"

I get a Compile error on this line: If Left(Me.SerialNumber, 2)) = "CN" And Not Len(Me.SerialNumber) = 24 Then

That is my delima, different parts with different serail numbers and length. For the most part I left it a certain free length field. Just need them to realize that a serial number is missing some digits, "bring it to their attention", so they can see and fix/update. I tried this and what...

I would put that valid control if all the serial numbers were one format. Unfortunately, it is not that way.

No, its not 100% consistent because there are other serial numbers that do not meet that criteria. They could be all numbers or mixed number and letters. For the most part, those are OK. Just the serial numbers with "CN" that need to be corrected or obtained and updated.

I have a field that has Serial numbers from computer equipment. There are some that the serial number is incomplete. When the tech opens up the form to view the computer information, I would like it to popup a msgbox and inform the tech that the serial number needs completed. This will let the...