Search results

Hello I have a training log that has 4 tables, the employee table, the training course table, and the department table. These tables all contain the names of employees, training courses, and department in one field and their respective ID codes in the other. The 4th table is the actual log...

I copied the code into a module however my subrpt is still dissapearing in print preview and messing up my calculated fields.

Thank you!! So I insert this code into a "global module" and it will work for any form with subreports?

Hello I have a report with 4 subreports. The report contains calculated fields that use the totals field in the different sub reports. My issue is when one or more of the subreports does not have data in it. The sub report dissapears while in print preview, removing the totals row and ruining...

Hello I have a form with a combobox whose rowsource is a table that contains training course's title (CourseName) and the course's ID number. The form is based on a training record table that is going to record which employees took what course when. This table includes both the Coursename and...

Hello I have query returning decimal values. The decimals are shown in the datasheet view of the query, but are rounded when I look at pivot table and chart view. Changing the data type in the query to a currency shows the two decimal places, but they are also rounded and only show zeros. I...

Hello I have a both a form and a subform that display a message box informing the user they are editing an existing record. Private Sub Form_Dirty(Cancel As Integer) Dim response As Integer If Not Me.NewRecord Then response = MsgBox("You are editing and existing record!" & vbNewLine &...

Hello I must have saved two workbooks to my personal macro workbook. I have it set to open my personal workbook whenever i open excel however those two extra workbooks pop up. How do I get rid of them?

oh this is great thanks. I had no idea you could do this.

Hello I have a quality control database that has a QCEntry table that contains information about each sample the QC technician takes from production. This table has a one to many relationship with the TestResults table, where the tests performed on the sample and their results are stored...

Time is a regular decimal numeric field. It is a record of total time in hours that time entry covers. I am trying to add up those entries for a lot number and compare them to another table where the runtime and downtime are recorded (for that same lot number) and look for discrepancies.

I am now having a problem with the msgbox appearing even if the comparison is equal. Anyone have any insight?

I'm retarded, thanks!

I have this code Private Sub Time_AfterUpdate() If DSum("Time", "Timelog", "criteria = '" & Forms![Timelog Entry Form]!LotNo & "'") <> _ DLookup("RunTime", "Production and Material Usage Table", "criteria = '" & Forms![Timelog Entry Form]!LotNo & "'") + _ DLookup("Downtime", "Production and...

Hello I have a parameter query for looking up a specific lot number in my database. The lot number table has 4 related material tables that deal with material issued, reworked, and rejected for that lot number. They lot number table is in a one to many relationship with the related tables. I...

I am doing this. But I get a ?Name error My report is not finding the sum total correctly.

Hello I have a production report with 4 one to many sub reports (material reworked, reclassified, rejected, and issued). Each of those sub reports has a sum field totaling up the material reworked, rejected, etc for that lot. I need a calculated field that subtracts the totals in each sub...

Hello What event would I attach code to, to have a message box pop up warning the user when that he is editing existing records. I would like the message to appear not as the form loads, or as he tabs to the first control, but right as he makes any changes to the data displayed. Preferably the...

When the user is prompted by the msgbox. I want a Yes/No type field on the form's value to be set to Yes if the user presses the "Yes" button on the msgbox. How would I use an if statement to respond to the "yes" response from the msgbox?

Hello I have this code Private Sub TestResult_BeforeUpdate(Cancel As Integer) If Me.TestResult < DLookup("MinValue", "QCSpecs", "ProductCode='" & Forms!QC2EntryForm!ProductCode _ & "' and TestName = '" & Forms!QC2EntryForm![QC2TestResults subform].Form.TestName & "'") Or Me.TestResult > _...