wharrison359
asked on
Copy data from a table into multiple fields of an access form / message box...
I work with an application that provides user data over the web. The data comes up in a small popup box which when copied into excel looks as follows:
Column 1 Column 2
-------------------------- -
Name doe, john
id 1 01010101
id 2 01010101
id 3 01010101
address 555 number street
phone 900 765 4321
etc...
The database I need to append with this information is in Access. I use a query to bring up just the necessary fields that needs to be appended in the database and add the users info at that time. I'm trying to automate this process with VBA.
Is it possible to make an Access form that looks like a data entry message box with two blank columns, one on th right that will hold the unneccary information of column 1 above and then the other to the left that would hold the users data?
The point of this question is to see if there is a way to copy all the information from the popup web page and paste it in one swoop to the access form.
Further Note:
When I initially tried to copy the information from the webpage into an access table it made all the data in one row appear in a single cell, aka column 1 and column 2 were all in cell 1. When I pasted the information into excel, it seperated the data into seperate columns, which is what I want, but I'm trying to stay away from excel because all my client data is in access and access is more powerful.
Column 1 Column 2
--------------------------
Name doe, john
id 1 01010101
id 2 01010101
id 3 01010101
address 555 number street
phone 900 765 4321
etc...
The database I need to append with this information is in Access. I use a query to bring up just the necessary fields that needs to be appended in the database and add the users info at that time. I'm trying to automate this process with VBA.
Is it possible to make an Access form that looks like a data entry message box with two blank columns, one on th right that will hold the unneccary information of column 1 above and then the other to the left that would hold the users data?
The point of this question is to see if there is a way to copy all the information from the popup web page and paste it in one swoop to the access form.
Further Note:
When I initially tried to copy the information from the webpage into an access table it made all the data in one row appear in a single cell, aka column 1 and column 2 were all in cell 1. When I pasted the information into excel, it seperated the data into seperate columns, which is what I want, but I'm trying to stay away from excel because all my client data is in access and access is more powerful.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.