P
Paul Menhennett
I have a database that gets updated each year. We update by importing excel
spreadsheets into a new table which we then clean up to get rid of headers
and blank lines and to validate the data. Once that is done we merge the new
data into the existing data. The new data falls into one of hree catagories:
1 it is the same as existing data 2: it is the same data with updated fields
or 3: it is a completely new record. My program steps through the new table
looks for the ID number if it exists it searches for that number in the
existing table. If it is found it compares the fields. If all fields are the
same it moves on to the next record. If there is no ID number it checks by
name to find similar records if there are none it adds a new record updates
the fields and moves on. If there are similar records I want to display the
existing record and the imported record side by side and give the user the
choice to select the old data, the new data or step through records while
they are still similar. The problem is the program continues on through the
loop and doesn't wait for the user selection. I had hoped to use a userform
but that is not available in Access 2002 (updating my version of Access is
not an option at this time). The best I have been able to come up with is to
throw a msgbox with three buttons into the loop. This works but the buttons
are yes no and cancel, not very indicative of their function. I have read
manuals, web pages, MS help files,knowledgebases but haven't found what I
need. Does anyone have any suggestions of things I can try?
Thanks
spreadsheets into a new table which we then clean up to get rid of headers
and blank lines and to validate the data. Once that is done we merge the new
data into the existing data. The new data falls into one of hree catagories:
1 it is the same as existing data 2: it is the same data with updated fields
or 3: it is a completely new record. My program steps through the new table
looks for the ID number if it exists it searches for that number in the
existing table. If it is found it compares the fields. If all fields are the
same it moves on to the next record. If there is no ID number it checks by
name to find similar records if there are none it adds a new record updates
the fields and moves on. If there are similar records I want to display the
existing record and the imported record side by side and give the user the
choice to select the old data, the new data or step through records while
they are still similar. The problem is the program continues on through the
loop and doesn't wait for the user selection. I had hoped to use a userform
but that is not available in Access 2002 (updating my version of Access is
not an option at this time). The best I have been able to come up with is to
throw a msgbox with three buttons into the loop. This works but the buttons
are yes no and cancel, not very indicative of their function. I have read
manuals, web pages, MS help files,knowledgebases but haven't found what I
need. Does anyone have any suggestions of things I can try?
Thanks