Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Paste Multiple Fields into an Access Form

Posted on 2007-10-10
4
Medium Priority
?
2,050 Views
Last Modified: 2013-11-29
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.

0
Comment
Question by:wharrison359
  • 2
  • 2
4 Comments
 
LVL 15

Accepted Solution

by:
Simon Ball earned 2000 total points
ID: 20054958
interesting question.

i am not sure i agree that access is more pwerful than excel :) just different tools fo different jobs...

for instance - it might be possible to use excel to link to whatever webpage is supplying this data...and then use access to link to the excel file as if it were a table, and have a query append the data from a linked excel sheet to your access table....

You could have a form with a text box where you paste the popped-up data, which then manipulaes the string, replaces Tab with "|" pipes and uses the data in an append query usin ght e vb RUNSQL command...

then again it might be possible to use access to connect to your webpage directly... rather than using the pop up and copy paste...you could perhaps use ODBC to connect to the web database which creates the popup?

also - you could use access to create a browser object which navigates to the relevant webpage, and collects the text from the popup - manipulates it into an append query and inserts it into your database.

I think you need to provide a little more data about how and where this popup comes from in order to get a better more defined solution from an expert...

How are you copying the data from the popup?  do you want this to be a manual process for your users, do you have any control over the web application?  does this process run lots of times in one day, does it all need to be automatic?


0
 

Author Closing Comment

by:wharrison359
ID: 31408122
Thanks for your indepth comment. I would like to learn more about using access to create a browser object. I'm not sure if it will work because it is a secure website and I don't have access to the backend. We are just one department out of hundreds  that are using this application. So for security reasons only the inital developers have access to the backend.
0
 

Author Comment

by:wharrison359
ID: 20288378
Thanks for your indepth comment. I would like to learn more about using access to create a browser object. I'm not sure if it will work because it is a secure website and I don't have access to the backend. We are just one department out of hundreds  that are using this application. So for security reasons only the inital developers have access to the backend.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question