Recent content by &Boom

For the record: I had a form where users are putting in time worked for a company. The actual date and time and company were being entered on a subform, and on the main form they were submitting the data. The data was being sent to a Temp table if they did not hit submit, but when they hit...

How foolish. You're brilliant. You saved me from a very big headache. I want to thank you very much. I don't have much experience with Access, and have learned most of what I have learned from this forum and doing it myself, so thanks for being understanding. Thanks again, MC

Oh! I see now. I tried this: If DCount("*", "ServiceTempTbl", "ServiceTempLOB_ID = 35" And "ServiceTempStaffID = " & Forms!InputHoursFrm!StaffId) > 0 Then MsgBox "Please correct all lines of business." I am getting a "Type mismatch" error.

So, a DLookup for Staff_ID and a DCount for LOB_ID = 35? I am getting confused on how to execute it. I am not very good with VBA at all. I can conceptualize it, but not code it. So if an Employee_ID has a Count > 0 of LOB_ID = 35 then "Error" for and only for that person Else Submit..

I tried this and it did not work: If DCount("ServiceTempStaffID", "ServiceTempTbl", "ServiceTempLOB_ID = 35") > 0 Then MsgBox "Please correct all lines of business."

Paul, I may (or may not) have another issue with this. Now, the end users are inputting hours and companies for different people, whose information is also being stores in the TempTbl. If John Doe has all legitimate companies, but John Smith has one "?????" .. It will still throw the error to...

Paul, it appears with the DCount function I don't even need that new form to open. Simply putting that code in VBA behind the Submit button seems to work. Thank you - very much.

Paul, I examined the usefulness of DCount , and I am not sure I quite understand it. Here is the code I used. If DCount("*", "ServiceTempTbl", "ServiceTempLOB_ID = 35") > 0 Then MsgBox "Please correct all lines of business." End If Now, when I correct the "?????" entries and...

I fixed my first issue. Now, when I open all records from the table with "?????" in them, the appear in a new "UnkownFrm." This makes it easier to locate records that need to be fixed. However, when they are clicking "Save/Close" on the "UnknownFrm" signifying that they have fixed all "?????"...

Unfortunately, it contains users names which I can't disclose. I will attach screen shots to help, which I hope they do!

Paul, that is the direction I went. However, I am not familiar with DCount(). I have a "Check Company" button that opens a new form with all Companies ID that match "?????".. Which is fine, however - stick with me here. On the original form where they are inputting hours and selecting company...

I have a form with a subform. The form has 2 controls, Preview and Submit. The submit button moves the records users are entering (Date, Company, Hours) from a Temp table to a ServiceTbl. The users are allowed to select "?????" in company in case they don't know it at the present time. At the...

Okay, it works. As a Summary for any future references.. **I added a field in the StaffTbl -> "InactiveDate" Went to the Subform, added a textbox (InactiveDateTxt) with control source of the InactiveDate field (also added it to the query) Used the code : If Me.CheckBox = -1 Then...

Gotcha.. It was a linked table on a different drive, so I was seeing if there was a work-around. Obviously there wasn't, so I added the field on the drive and refreshed via linkted table manager. So now the code should work eh? Will let you know! Thanks

I decided to delete that Sub form and re-make it. The only issue I am currently having is when I add the date to the "Actiondate" text box after the Inactive is checked, it is putting the date into all of the "Actiondate" text boxes.. How do I make sure it's only 1 at a time?