Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Possible to build on a linked HTML table?

Status
Not open for further replies.

ddelport

Technical User
Jan 24, 2004
27
ZA
Hi,

I am working on a database to manage, and make incoming faxes available on a network server. The faxes come in on a fax machine on a standard landline. It also has a network adapter that sends these faxes as .tif images to an e-mail address. Or so I think it works. Then there is what I will call a "propriety interface or desktop" that logs these incoming faxes. You may set the size of the log to a max of 999. In my environment this is impractical because I want to assign certain properties to the faxes e.g. customer name, employee, summary of content etc. You may select where the desktop software safes the images once it is moved out of the log. In the same folder I found a handy HTML table that contains critical info as well as a hyperlink to the image. The problem is that as the images is added the HTML just grow.

The idea is to link the table in access, but access doesn't allow you to edit or add anything to this table. Importing the table is not practical and just wouldn't work with a database that has to be a up to date as possible and is shared by several users.

Would a certain query be the way to go, I am open for any suggestions.

Is there a way to hack into the fax machine?
 
No suggestions yet?...Well, I have explored other avenues and have decided to rather work in 3 phases. Phase 1 - limit the amount of faxes in the desktop/user interface to 10 or less. Phase 2 - run a "compare unmatched query" on a second table that resides in my database with the HTML table within a combobox. Once selected phase 3 steps in - moves and renames file to seperate folder and establish a new link to the new filename that equals an autonumber field. Now I can indulge in a image preview and add info to my heart's content.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top