We are constantly scouring the WEB for items for sale,
copying and pasting descriptive information about the
items into text and memo fields of MS Access tables.
To date, we are going back to the browser page from
the database program to hilite 'n copy the URL from the
ADDRESS line of the browser, then back to the database
again to paste the specific URL in the designated table
field. That's getting old. Everybody thinks that two steps
are not necessary and that we shouldn't be copying text
describing product from browser to database in one step
and then copying URL from browswer to database in a
second, redundant step.
I've been asked if I can automate the process in 32-bit
windoze OSes so that when the user pastes the lines of
text in the form's product information field, the last URL
accessed in the browser is read and the string is auto-
matically pasted into the URL textbox control on the
form. Truth is - I haven't got a clue.
Suggestions please? 7 1449
MLH wrote: We are constantly scouring the WEB for items for sale, copying and pasting descriptive information about the items into text and memo fields of MS Access tables. To date, we are going back to the browser page from the database program to hilite 'n copy the URL from the ADDRESS line of the browser, then back to the database again to paste the specific URL in the designated table field. That's getting old. Everybody thinks that two steps are not necessary and that we shouldn't be copying text describing product from browser to database in one step and then copying URL from browswer to database in a second, redundant step.
I've been asked if I can automate the process in 32-bit windoze OSes so that when the user pastes the lines of text in the form's product information field, the last URL accessed in the browser is read and the string is auto- matically pasted into the URL textbox control on the form. Truth is - I haven't got a clue.
Suggestions please?
Investigate the Microsoft Internet Transfer Control. It's an ActiveX
control (the "More Controls" icon on the Form's Toolbox commandbar [a
wrench & hammer, crossed]). I'm not sure if it comes w/ regular Access,
but I know it comes w/ VB 5 & up; also, in the Office Developer's Edition.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Thx for reply. I have MSOffice97 Developer Edition Tools, v8.
However, I'm doing this in an Access 2.0 app. Can the ActiveX
control you mentioned be used there? Probably not.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Thu, 03 Mar 2005 02:51:51 GMT, MGFoster <me@privacy.com> wrote: MLH wrote: We are constantly scouring the WEB for items for sale, copying and pasting descriptive information about the items into text and memo fields of MS Access tables. To date, we are going back to the browser page from the database program to hilite 'n copy the URL from the ADDRESS line of the browser, then back to the database again to paste the specific URL in the designated table field. That's getting old. Everybody thinks that two steps are not necessary and that we shouldn't be copying text describing product from browser to database in one step and then copying URL from browswer to database in a second, redundant step.
I've been asked if I can automate the process in 32-bit windoze OSes so that when the user pastes the lines of text in the form's product information field, the last URL accessed in the browser is read and the string is auto- matically pasted into the URL textbox control on the form. Truth is - I haven't got a clue.
Suggestions please?
Investigate the Microsoft Internet Transfer Control. It's an ActiveX control (the "More Controls" icon on the Form's Toolbox commandbar [a wrench & hammer, crossed]). I'm not sure if it comes w/ regular Access, but I know it comes w/ VB 5 & up; also, in the Office Developer's Edition.
MLH wrote: Thx for reply. I have MSOffice97 Developer Edition Tools, v8. However, I'm doing this in an Access 2.0 app. Can the ActiveX control you mentioned be used there? Probably not.
Probably not since ActiveX was developed after Access 2 was. Why not
use Access 97?
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
"MLH" <CR**@NorthState.net> wrote I've been asked if I can automate the process in 32-bit windoze OSes so that when the user pastes the lines of text in the form's product information field, the last URL accessed in the browser is read and the string is auto- matically pasted into the URL textbox control on the form. Truth is - I haven't got a clue.
What you can do is automatically copy information from the clipboard into
fields within Access.
Say the user copies the URL first. That data is copied into the URL field.
Then they copy the description, Access recognizes that something new has
been copied into the clipboard and pastes that data into the Description
field. The process continues until the user makes a mistake, at which point
in time he backs up a little and starts again. Its not a complicated
process. You can use the Clipboard Object, which is either listed in help or
somewhere on MS's support website, support.microsoft.com.
Do the words "they're cheap" come to mind when you are asked "Why Access 2?"
I'd be hesitant to get involved in an A2 database if for no other reason
then there not much remaining in terms of a support structure should you run
into any problems. Suggestions please?
Run. There is other work to be found.
Mike
Now there you go. That's what I'm talkin' about. I like it - not even
having to go back to the database app at all after copying some
text to the clipboard. Any copied text that starts with "http" can be
automatically inserted into one field and all other text can be put in
the other field. I'll look into the "Clipboard Object" and try to
determine if Access Basic can peek at it's string each time it changes
value. Appreciate further input from all willing.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxx
<snip> What you can do is automatically copy information from the clipboard into fields within Access.
Say the user copies the URL first. That data is copied into the URL field. Then they copy the description, Access recognizes that something new has been copied into the clipboard and pastes that data into the Description field. The process continues until the user makes a mistake, at which point in time he backs up a little and starts again. Its not a complicated process. You can use the Clipboard Object, which is either listed in help or somewhere on MS's support website, support.microsoft.com.
Do the words "they're cheap" come to mind when you are asked "Why Access 2?" I'd be hesitant to get involved in an A2 database if for no other reason then there not much remaining in terms of a support structure should you run into any problems.
Suggestions please?
Run. There is other work to be found.
Mike
I have the following 2 files which can be called from Access
97. Forms 2.0 is an ActiveX component that allows text to be
pasted from your Clipboard into a TextBox or ComboBox. Does
anyone know if something remotely similar exists for Access 2.0?
Directory of C:\WINDOWS\system32
07/11/1997 12:00 AM 1,138,688 FM20.DLL
07/11/1997 12:00 AM 36,864 FM20ENU.DLL
MLH wrote: I have the following 2 files which can be called from Access 97. Forms 2.0 is an ActiveX component that allows text to be pasted from your Clipboard into a TextBox or ComboBox. Does anyone know if something remotely similar exists for Access 2.0?
Directory of C:\WINDOWS\system32 07/11/1997 12:00 AM 1,138,688 FM20.DLL 07/11/1997 12:00 AM 36,864 FM20ENU.DLL
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
That Forms collection works w/ other Office products (Word, Excel,
etc.). I believe Access' forms are completely different (though you can
use some of the Forms 2.0 controls in Access 95 & higher (test each one,
they can be persnickety). Again, I doubt they can be used with Access 2
since they are ActiveX components.
Does Access 2 have VB modules & the Tools > References menu option?
Maybe you can add the reference to the Forms library.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQidUJ4echKqOuFEgEQKQAgCfXKRyJTQU6OlRP0/h4Wr1aGvURQUAnRWy
xz4vsIC/Pi3fkK5PYqdF89rD
=s5dC
-----END PGP SIGNATURE----- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Sandman |
last post by:
Just looking for suggestion on how to do this in my Web application.
The goal is to keep track of what a user has and hasn't read and present him or
her with new material
I am currently doing...
|
by: Guru |
last post by:
Hi
I have a table which contains number of rows. I want to fetch the
last 5 records from the table. I know for the first 'n' records we can
use FETCH FIRST n ROWS ONLY command. But i want to...
|
by: Jenni |
last post by:
Hi again,
What I need to do is get an entire table from access into excel. It
would have to over-write the existing data on the spreadsheet, and it
should not run unless it is asked to. (this is...
|
by: Henro V |
last post by:
I made this table in which we registrate our working hours
It is in fact quite simple:
DayOfTheWeek Date StartTime Endtime Lunch Travel ... ... ... Total
WorktimeThisDay
This would look...
|
by: Ryan Liu |
last post by:
Hi there,
I got a NullReferenceException when delete last row in a datagrid.
I had hard time to solve since it does not occur in my own code.
I put a datagrid in my inherited user control,...
|
by: tshad |
last post by:
If I am using FormsAuthentication, is there a way to check who is logged in?
I want to be able to check at any particular time, not just how many people
are logged in, but who they are.
One...
|
by: Adrian |
last post by:
Hi
I have a JS program that runs localy (under IE6 only) on a PC but it has
a memory leak (probably the known MS one!)
What applications are there that I could use to look at the memory usage of...
|
by: l3vi |
last post by:
I have a new system Im building that stores entries of what people are
searching for on my sites.
I want to be able to keep records of how many times a keyword was
searched for daily, and from...
|
by: MarcJoseph |
last post by:
I have a database that is shared my multiple users who enter and update
records on a weekly basis. Is there a way I can add a field to my main
data table that will automatically generate the...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |