G
G. Edwards
One of our Access users has a question he has posed, for which we are still
struggling to answer.
Let's see if I can explain his goal as clearly as you would need:
He has a table in Access, with many columns and hundreds of records.
One of the columns in the table contains data that is now mostly obsolete.
The first two columns are titled LEFT and RIGHT. The data in each record for
LEFT and RIGHT should consist of the following data: The LEFT field should
contain the leftmost character in column four of the same table, and the
RIGHT field should contain the rightmost character in column four of the
table that is associated with that specific record. As soon as the LEFT and
RIGHT columns contain the relavant data, column four can be deleted.
He does not want to manually type this data into the two columns. The
character set is the entire range of viewable characters including special
charcters such as # and $, underscore and so on. We have tried using VB to
write a routine, but I am unable to figure out how to run the macro so that
it will increment records (or rows) after inserting the characters in the
first record. Selecting the leftmost and rightmost character, copying it,
then pasting it into the other field is not working well either. So, I'm not
sure a macro solution is going to work - but that may just be due to my lack
of experience in writing VB macros for Access.
Thanks in advance for your help.
struggling to answer.
Let's see if I can explain his goal as clearly as you would need:
He has a table in Access, with many columns and hundreds of records.
One of the columns in the table contains data that is now mostly obsolete.
The first two columns are titled LEFT and RIGHT. The data in each record for
LEFT and RIGHT should consist of the following data: The LEFT field should
contain the leftmost character in column four of the same table, and the
RIGHT field should contain the rightmost character in column four of the
table that is associated with that specific record. As soon as the LEFT and
RIGHT columns contain the relavant data, column four can be deleted.
He does not want to manually type this data into the two columns. The
character set is the entire range of viewable characters including special
charcters such as # and $, underscore and so on. We have tried using VB to
write a routine, but I am unable to figure out how to run the macro so that
it will increment records (or rows) after inserting the characters in the
first record. Selecting the leftmost and rightmost character, copying it,
then pasting it into the other field is not working well either. So, I'm not
sure a macro solution is going to work - but that may just be due to my lack
of experience in writing VB macros for Access.
Thanks in advance for your help.