Search results

its working, thank you kindly

wait i think i got my x's and y's mixed up 2 seconds..

i got chriso's code to work however it only runs through once, rather than the amount of times needed. even without the -1 it does the same thing code as follows field = UBound(FieldArray()) If field > UBound(editedField()) Then editedvalue = UBound(editedField()) For field = 0 To editedvalue...

not exactly i want item 1 in array one to match to item 1 in array 2 then item two in array 1 to match item 2 in array 2 and so on until the arrays have finished (both arrays have same number of values)

Sadly that didn't work. well it did work just not what i wanted it to do. it is comparing the two this only collects the last value in the first array and compares it to the index value of the second IE it will compare say String19 (last value in the array) with 0 String19 (last value in...

yeah. basically the form needs to make sure that they're both running in sequence and checking to see if one field is the same as the other. However only one loop runs through. Would it matter what they are declared as? i currently have them set to variants. One loop runs fine but the second...

i've been trying to nest 2 For/Next loops however i've had a number of problems with it, the main one now is that one loop gets cycled through once and then ignored and the other works fine (which mean when the loop compares the two values it keeps comparing one value with a different value...

is it possible to run 2 for loops alongside each other for example can you set one loop to loop through one array while another array is doing the same then compare the two like if array1val = arrayval2 then message box array is equal else message box array is not equal

Sorry i didn't make it specific in the code, what i'm being asked to do is when the user clicks the save button the button will update the table (called Twentyfieldtable) with anything thats been edited in the record and what has been edited will go to the edited table (called project2) which...

Hello, i'm new to the forum and i've been working on this problem for the best part of a week. So far all was going well until i came to this issue. I've recently started a new job which involves using access 2003 and VBA and was given a few tasks to do, as follows find or create code that...