Search results

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...

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...

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...

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.

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?

I have a crosstab report that runs on dates that are entered by the users ( enter first date, and enter last date). They can run whenever for whatever dates they need. When they run the dates become the column names and the date in the crosstab is a total amount per date. The problem is...

I am using dlookup to see if there is already a record with a date and name that is entered on a form. If IsNull(DLookup("[Date]", "Roster", "[Date]= " & [Forms]![Roster1]![txtDate] & " AND [Supervisor]= " & [Forms]![Roster1]![txtSups])) Then.... I am looking in the "Roster" table to see...

I have a main form with a subform. I need a textbox called "ProductCode" to equal a textbox on the main form called "txtpc1". After I have entered last field in main form I shift focus to the subform that works great, and the first field on the subform is the "ProductCode" so the focus goes...

I have a form with 2 unbound textboxes. One is date and one is Department. Also have a subform based on the department selected on the main form. Is there a way to save the date and department in a table and if say the report has already been run for the Shipping department for a certain day...

I have an application to track employee attendance. On one main form a supervisor picks his name from a dropdown, and they enter the date. On the subform, all of his/her employees show up in datasheet view and the date is included in each record on the subform. There are a couple other...

We needed a way for supervisors to enter attendance for their departments. So a I have a main form with a drop down list of sups. They pick and hit the command button to view a list of the employees they have. This command button on main form runs query of Employees table. Query has 3 fields...

I have an application that tracks attendance for about 400 employees. And if they have a certain # of tardies, missed days, in a last 12 month period then there are certain levels of disciplinary action that are enforced. So I have a query that goes back 365 days. Everythings great. Until...

What is the easiest way to fill in a month textbox based on a date entered in a date textbox? For instance, if the date entered is 1/15/03 then the month textbox should fill with January, if date is 2/7/03 then month = February etc. etc. Should I use if statements or select case or something...

I have run into an unforseen problem I had two tables, one for the main form and one for the subform. A field that was the primary key in main table, had relatiohship to same field in sub table. Turns out that field can sometimes be duplicated in main table. Can I add a "Now" to the field or a...

I have a query that returns a duplicate record for each record it is supposed to return. I have checked the tables over and over and there is only one record, but the subforms that are fed by the query show 2 exact copies of each record they are supposed to show. But even out of the subforms I...

I have a form with a subform, these are used for data entry. When a user does a filter by form on a field in the main form it brings up that record fine, but it brings up all records that have been entered on the subform regardless. So for each record on main form it brings up hundreds of...