Recent content by wpilgri

Thank you for all your help. A lot of good options I am going to try. I guess my Acess 2000 Developer's Handbook is incorrect. It clearly listed that adcmdTable or adcmdTableDirect are both acceptable for queries as well as tables. It doesn't seem to work, but that's what it says. Thanks...

Now I have tried the following code, taken from "Access 2000 Developer's Handbook": Set rs = New ADODB.Recordset Set rs.ActiveConnection = CurrentProject.Connection rs.CursorType = adOpenKeyset rs.LockType = adLockReadOnly strQryName= "qryRelatedPartNumbersForCurrentMainDesign" rs.Open...

This is not a parameter query...just a simple select query. I've tried several variations of: rst.Open "qryRelatedPartNumbersForCurrentMainDesign", CurrentProject.Connection, adOpenStatic, adLockOptimistic, adcmdTable I've varied adcmd*, adlock*, adopen* and I always get an Error...

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...

That appears to work for "Filter by Form", but I am using the Form.Filter event and it does not fire for the "Filter By Selection". Any suggestions on how to catch a change when using filter by selection? Thank You

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 wonder how much a background in Java will help, if at all, in learning VB.Net? I spent about a 1.5 years getting to know Java. I like the syntax of the langauge and the OO part of it, but the GUI toolkit (swing) leaves something to be desired. Amazing how similar C# looks to Java. Having...

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...