DZ
I am starting to see that this is not simple matter and I was looking for simple solution.
But for the sake of finding out what do in this case let me just give you the details.
Detail 1: This a preset table with, preset field columns. So seperating the text out from the first field is...
DZ,
Thank you for your response.
I didn't mean to confuse the question.
No, the new data is not on a spreadsheet. I am trying to get it to seperate the same way it would as if on a spreadsheet. I am not importing I am simply pasting text into fields on a table. Each text string is unique, and...
PLEASE HELP WITH:
Cutting and pasting one text string (seperated by spaces) into multiple fields in a table.
WHY:
Excel seperates the cut results of an AS/400 query into seperate columns, depending on the spacing.
Access pastes all the informaton into one field.
How do I stop it from...
That code helps a little bit, It gives an option. I can work with it - thanx for the tip and code.
However, I do need the fields, to be the same. Sort of like entering a Zip code in a database and having the city and state auto populate, which I found a code for, during my search. The...
I am trying to make an auto-fill form or table (mainly working with the table) It has a refrence number and the refrence number has associated fields.
This refrence number and its fields are in Table 1.
I am updating information in Table 2. ( the one I am trying to create). What I want to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.