Thank you both for your answers.
I think that what I need is exactly what Mihail says, a Select Case that goes through all the instruments launching the right report depending on its type.
The problem is that I'm having trouble implementing it and as I still have very little experience with VBA and SQL I can't find the error.
From what I've found googling this is the way to create a recordset from my...
David Scott
Last Activity: May 3 '12, 10:20 AM
Joined: Nov 7 '11
Location:
-
Using different reports for different lines of the same query
Hi all.
In my company we have a database to keep record of measuring and control instruments f.e. Pressure switchs, Thermometres, Gauges, etc.
Each type of instrument has a different form because the type of data we keep from them varies depending of how it works. Al these forms have a common part where we put the name of the instrument, the facility, serial number, etc. and a different one with the especific technical... -
Thank you for your answers.
Finally I could solve it using a simple "trick". Maybe it's not so elegant but it works like a charm. :)
In my query I applied the val() function to the boolean field. As you now as a result it gives back "0" if the boolean is False and "-1" if it's True. The good thing is that when converted to a value it lets me search using "*".
Then I changed...Leave a comment:
-
Query on Yes/No to show all records
Hi all.
I have run into a problem with my database. It seems something that should be easy to do but although I've searched a lot I can't find a solution.
I have a query that takes the filtering values from a form. In the top part I have a combobox for each field which I want to filter and in the bottom part the result from the query. This way when a user selects a value in the combo the query auto updates and shows...
No activity results to display
Leave a comment: