Search results for query: *

PH, Array??? Oops, I have been misreading what documentation I could find on the ADO Seek method and completely missed the note that the argument is an array. Consequently I was setting myself out to do a lot more work than necessary on an approach that was doomed to fail. Many thanks for...

Skip, It looks like that is the direction I will have to go - opening a recordset with a where clause for the relevant values. An alternative approach someone in another forum suggest was to use Dlookup to search for the relevant values. Do you know offhand, how this approach would compare, in...

the generic algorithm that access uses to calculate a composite key ??? As I understand it the seek method requires as its first argument a value of the key you are looking for in the specified index. That's no problem when you have a single field key. However with a composite key, the index...

In this specific case the two fields are both long integers. They are actually foreign keys in a junction table for a many to many relationship. Together they make up a unique index so that there can be only one instance of any particular pair of value one and value two. So, typical values in...

In order to use the ADO Recordset Seek method, it is necessary to provide the search value as the first argument. This is simple enough for a single field key. But how do you determine the value to use when you want to seek using a unique muliticolumn index?

I'm looking for a reference source that would summarize the differences between Visual Basic .net standard edition and the developer versions. I'm using a tutorial book to teach myself the language but occasionally run into problems that I am unable to determine whether there is an error in the...