N
NOE
I am working on an Access database that will facilitate our main company
database and our distribution center’s database. I have looked at many
posting and can not quite find the answer to my problems.
In Access I have a product form. The text box which contains the complete
name (which can be rather lengthy sometimes) of products we offer. The other
2 databases which this information will be exported to have character count
limits; 55 characters for one and the other is limited to 30. On my form I
have set up several tabs for the various types of information kept on the
products.
Here is my area of concern. On one tab, I have included 2 text boxes for
shorten descriptions (55 and 30 characters in length). How do I automatically
have the two text boxes update once the main description is keyed in? Right
now in the AfterUpdate I have Left(ProductName, 30). I’d like the fields to
update automatically. Next I need to be able to modify the shorten names and
save that information in the table. Yes I know I would be saving redundant
information, but it needs to be this way for the time being.
Thanks in advance for any advice.
database and our distribution center’s database. I have looked at many
posting and can not quite find the answer to my problems.
In Access I have a product form. The text box which contains the complete
name (which can be rather lengthy sometimes) of products we offer. The other
2 databases which this information will be exported to have character count
limits; 55 characters for one and the other is limited to 30. On my form I
have set up several tabs for the various types of information kept on the
products.
Here is my area of concern. On one tab, I have included 2 text boxes for
shorten descriptions (55 and 30 characters in length). How do I automatically
have the two text boxes update once the main description is keyed in? Right
now in the AfterUpdate I have Left(ProductName, 30). I’d like the fields to
update automatically. Next I need to be able to modify the shorten names and
save that information in the table. Yes I know I would be saving redundant
information, but it needs to be this way for the time being.
Thanks in advance for any advice.