I have a query setup in Access that selects certain records. I need to run the query and get the records it returns in an ADO recordset so I can do further processing in code with the results of the query. I have tried:
rst.Open "qryQueryNameInAccess", CurrentProject.Connection, adOpenStatic...
I have a simple form that shows approx 20 fields. Our users can filter using the "Filter By Selection" or the "Filter by Form" feature.
What I would like to do is be able to highlight any field that is part of the active filter. The problem we have now is that it is not entirely obvious...
I am currently using VB6 for simple applications. I am an engineer, not a professional programmer, and use it for relatively simple data acquisition applications where it talks to a USB board. I am interested in updating to VB.NET but wonder how much time I am looking at to become "reasonably...
I have a database that is built as follows:
query1: gather all size info(numbers) for all parts
query2: Using query1, find average size for each part
query3: calculate tolerances for parts
query4: Use query2 and query3 to combine avg size and tolerances
query4 then gets used for reporting...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.