Recent content by Alephu5
-
A
Data type mismatch in criteria expression
Adding solved the problem. Thank you. -
A
Data type mismatch in criteria expression
I am working on a fairly ancient manufacturing database that identifies items using a combination of letters and numbers. The usual format is to have a letter (which suggests something about the item type) followed by a sequence of numbers. I am trying to write a query that looks up all the... -
A
PivotChart View - Events
I've been trying to do this all day, and have now got a working solution that doesn't rely on screentips. The following code goes in the form/subform that contains the pivotchart. If you're using a subform, ensure that you set the default view to pivotchart. Private Sub Form_Click() Dim...- Alephu5
- Post #3
- Forum: Modules & VBA
-
A
Outer join query returning #Error rather than null
I've managed to isolate the field in a sub query that is causing the data mismatch error, but I am still unsure exactly what the problem is. The field 'qryReprocessedBatches.BatchNumber' is generated from a query (although I've made a table to eliminate the influence of sub-queries) with the... -
A
Outer join query returning #Error rather than null
It displays a list of all the records that are present in 'qryFBatchMakeup.BatchNumber' without any problems, it is identical to SELECT qryFBatchMakeup.BatchNumber FROM qryFBatchMakeup; -
A
Outer join query returning #Error rather than null
I have been battling with this problem for hours, and would be incredibly grateful if someone could enlighten me as to what I am doing wrong. I want to build a query that displays identifying records from one query, excluding those that are in another query. Internet research and the unmatched...