Recent content by lipin

Thanks Sarge. Flawless!!

I have a table"AttendanceRecords" with fields: Name - txt IDNumber - num Hours - num AbsenceCode - txt I have a second table "AbsenceCodes" with 2 fields with codes in them shoptrac - txt attendance - txt I need to lookup the "absencecode" field in table "AttendanceRecords" in the systemcode...

Thanks! Works Great!

I have this in part of a select statement that builds a table. "FROM tblHistory " & _ "INNER JOIN tblActiveJobCd ON tblActiveJobCd.JobCd = tblHistory.JobCd " & _ "WHERE EntryDate >= #" & GoalWeek(x).StartDate & "# " & _ "AND EntryDate <= #" & GoalWeek(x).EndDate & "# " & _...

I have a button that opens another form to enter data on. But when I click the button I am getting the error msg: "Can't find project or library." And the debugger goes to the following sub routine and highlights Date in 3rd line(tried to bold). This only happens on 1 user's machine. The other...

I have the following code in a report. I thought it would blackout the two fields in the detail section for the sections where the Job Code is 200. But it is blacking them out for all Job Codes. ( 100, 120, 200, 300, 600, 1500) Am I putting it in the wrong place? Private Sub...

Thanks! That Got It!! Which leads me to another problem. Mgmt wants just 'N' employees in all depts except two. In Dept 100 and Dept 1500 they want all employees. So in the alredy present code is there an easy was to say: If Dept <>100 and <> 1500 then "AND tblHistory.Train = 'N'" Sorry...

I have inherited this DB and need to make changes. The code below is summing warehouse production by Dept for me. It is selecting records from tblHistory and giving me a prior 12 week actuals which is then the goal for the week. Well I only need fully trained people included in the goal...

I tried the following statement in the AfterUpdate event of my txtbox [weekly class] but then when I go to the next record on the form, it clears out. [weekly class].DefaultValue = [weekly class].Value Any suggestions?

Is there a way to have the textboxes in a form header not change between entering records, they will be the same for each record and usually only change on a weekly basis. Basically have the textbox equal whatever was entered first for all entries that follow. Thanks.

Perfect. Thank You.

I am trying to combine two fields into 1 with a query. This is the field in the query. It works fine. However, [HsAbsent]is a numeric field with inputmask = 0.00. So even the whole numbers are in the table with 2 blank decimal points. This is the way I need it. But then when they are...

I have a crosstab query and a make table query that runs off the crosstab. It is run to show the daily data for a week at a time. The user enters start date and end date on the crosstab. I need a report off the table made with the 2nd query that shows each days data. The column names change...

I had to compact to reduce size of db, now any subforms that were working are not. It is subforms that have a query as a record source? What is the problem or the answer?

Ok, I read the help files on the OnFormat event and searched the forums here but am kind of confused on how to do what was suggested. Can you be more specific on how to do?