Search results

Whew! I was able to correct the issue by building the ApQuery from scratch... Not sure what the difference was, but it works now... The only issue I have remaining is some calculations... Is there an expression or operator that will prevent the calculation from executing if the field value is zero?

Quite an unwieldy ApQuery to be sure... However, the data is coming from the cloned form from the original table. My thought is that it is one or all of the combo boxes, and the ApQuery is trying to insert text into a number field from the drop down box, however my attempts to work around that...

Here is the ApQuery- INSERT INTO tblOperatorReports ( CustomerID, SalesOrder, [Date], WorkOrder, ItemNumber, Rate, Speed, MachineID, OperatorID, [RAW PART NUMBER1], [SUPPLIER ROLL NUMBER1], [BAR CODE1], BarCodeComments1, Variants1, [ROLL NO OFF1], GoodFootage01, GoodRollFootage01...

Microsoft Access can't append all the records in the append query. Microsoft Access set 0 field(s) to Null due to a type conversion failure, and it didn't add 0 record(s) to the table due to key violations, 0 record(s) due to lock violations, and 1 record(s) due to validation rule violations...

Steve, This looks like it could work for the problem I'm trying to solve. I'm just not quite sure how to wield this tool. Could you expound a little further? Respects, Chris

Hi guys, I have a db where the main table/form is OperatorReports. I have sub-forms that allow users to review the reports by WorkOrderNumber/Date. The challenge I now face is allowing the user to open a new Operator Report that has the header fields autopopulated by the information on the...

Hi, My name is Chris. I have been working in Access for about 15 years. I am really good in forms and tables... So so in queries and reports and just a babe in basic. In addition to db development I enjoy reading the Bible, playing mean blues guitar,(Youtube>KidStratocaster>TheKidInNashville)...