473,325 Members | 2,805 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Pasting table data to web page

Question
I'd like to know specifically how to select another window outside of
Access
(a web page) and paste cells from my database.

I've used a macro program to do this before. I've read that I need to
find
the calls in the User32 dll to focus on windows outside the Access
shell and
paste to those controls.

A subtle question - will I be able to call these web page controls by
name?
I know Roboform pastes information according to the controls name (ie.
last
name control matching the last name control on the web page).

Thank you,

Christian

Feb 8 '06 #1
2 1676
You can use our Macro Program, Workspace Macro Pro. You can get more
information and free trial download from
http://www.tethyssolutions.com/macro-automation.htm

Alternatively you can also use our more advanced automation software,
Automation Anywhere. You can get more information and free trial
download http://www.tethyssolutions.com/automation-software.htm

Automation Anywhere has many sample tasks about how to transfer data
from Access to Web page etc.
http://www.tethyssolutions.com/autom...mples.htm#data

Tethys Solutions, Expert Services Group
http://www.tethyssolutions.com/ask-the-expert.htm
SMART Macro & Automation Solutions

ch************@yahoo.com wrote:
Question
I'd like to know specifically how to select another window outside of
Access
(a web page) and paste cells from my database.

I've used a macro program to do this before. I've read that I need to
find
the calls in the User32 dll to focus on windows outside the Access
shell and
paste to those controls.

A subtle question - will I be able to call these web page controls by
name?
I know Roboform pastes information according to the controls name (ie.
last
name control matching the last name control on the web page).

Thank you,

Christian


Feb 8 '06 #2
We're looking for field mapping.

So I want to be able to say:

AccessDB.[Last Name] -> WebPageDB.[LastName]

Roboform can do this internally. Using macros to do this is completely
tedious.

Thanks,

Christian

Feb 8 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Michael Shell | last post by:
Greetings, Consider the XHTML document attached at the end of this post. When viewed under Firefox 1.0.5 on Linux, highlighting and pasting (into a text editor) the <pre> tag listing will...
0
by: Simon Kirk | last post by:
Hi, In Access 97 I used to be able to copy data from Excel 97 and then paste it directly into the tables database pane. It would then ask if the first row contained column headings, and then...
3
by: Mike | last post by:
Using MS Access XP standard install (no Jet or MDAC updates applied yet) as front end, MySQL 4.0 as backend and MySQL ODBC connector version 3.51. When pasting multiple records into the database...
7
by: MLH | last post by:
I have a several hundred contact info entries in an MS Word document (name / addr / phone / email / website) - the usual sort of thing. I want to put the data into an A97 table. In my Word...
2
by: steph | last post by:
Hi all, I have an Access2002 form in in datasheet view. Column "CMP" is locked to user input, instead it is filled automatically by this function: === Private Sub Form_BeforeInsert(Cancel As...
13
by: Henry Townsend | last post by:
I hope this is on-topic in c.l.c - it's about the C preprocessor more than the language per se, more generally about the K&R behavior, and most specifically about the Sun cpp which is why I've...
3
by: Bobby | last post by:
Hi, I have an application which uses Access 2003 as both the FE and the BE. However, for a number of good reasons, I am in the process of converting the BE to SQL server 2003. I am not converting...
1
by: Grant Smith | last post by:
I've got an application that I can copy some text out of the RichTextBox control. I would like to keep the formatting so I'm able to copy it to the Clipboard with RTF formatting. I have no...
5
by: exhuma.twn | last post by:
As many might know, windows allows to copy an image into the clipboard by pressing the "Print Screen" button on the keyboard. Is it possible to paste such an image from the clipboard into a "Text"...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.