Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: tksayy
- Content: Threads
- Order by date
-
arrays comparision
HI, I guess this is the correct forum for this question i have an array 'validcodes' now i have another array which has two columns from a recordset idno and values i want to check and see if the values in second array are the values specified in teh first array. if they are not then i...- tksayy
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using arrays to get field values
I am trying to use the following syntax to get all the values in a column for a particular field in to an array (astrFields(intIx)) points to the field name varii = (.Fields(astrFields(intIx))) if varii is declared as variant is this enough to get all the field values into varii- tksayy
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
-
Recordset syntax
Hi, Is there anything wrong in this syntax Set rs2 = C:\Documents and Settings\Desktop\Codebook.mdb.openRecordset(strsql2)- tksayy
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
-
validation based on data from 2 tables
HI I have two tables like the following: table1 id variable 1 speed 2 distance 3 acceleration table2 id allowedvalue 1 3 1 5 1 6 2 4 2 5 i want to write a a loop to check whether for a given variable in all tables in the database the values is within the allowed value. THe link for getting...- tksayy
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
