Search results

Hey all ! I had a little problem. I have a query that has 2 fields in it and 6 records. I want to create something like an array ideally that stores the 6 values from one of the fields. I tried this: Set rst = dbs.OpenRecordset("testquery") testval = rst3.Fields("minofmin breaker rating")...

Hey all I've trying for weeks to be able to run SQL statements in my vba program but nothing has worked so far. I've come across all kinds of syntaxes, tried modeling my statements after access' generated SQL for queries, used record sets- nothing has yielded results. I always get a syntax...