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 1470
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:::mgf0 0 <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.
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxx
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:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
"MLH" <CR**@NorthStat e.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.microso ft.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.
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx
<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.microso ft.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\syst em32
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\syst em32 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:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQidUJ4echKq OuFEgEQKQAgCfXK RyJTQU6OlRP0/h4Wr1aGvURQUAnR Wy
xz4vsIC/Pi3fkK5PYqdF89r D
=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 this by aggregating new content from all databases into a
single indexed database and then saving a timestamp in the account database
(for the current user) that tells me when the user last read items in the
aggregated database.
|
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 fetch last 5
records. Can any one help in this...
|
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 why the linked table or
MS Query method will not work.)
Is it possible to make this code write directly to Excell instead of
to the new table?
|
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 like:
Tuesday 01-01-04 ... ... ...
|
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, then put this control on a
form.
I use DataAdaptor to fill the data table and update database.
| |
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 thing I want to do is not allow someone to log on from one browser and
then log on again at the same time time from another browser. Or to prevent
someone from using the same login at the same time.
Thanks,
|
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
each object within my JS app to help locate my problem?
Thanks
|
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 that I can calculate weekly and monthly.
At this point I have one entry per search phrase with the number of
hits the search phrase has gotten, and the last time it was updated.
As I start to take the program out of testing and move in more...
|
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 create date or last
modification date for each record?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |