How to view image in browser

[Ambre]

Hi,

I have a database that tracks Customers. Associated with this database are a series of folders, one for each customer, that hold various image (.jpeg) documents.



I would like to be able to select a document for the current customer from a dropdown in Access and show it in a browser, but I have no idea how to go about doing this.

I would really appreciate anything you could share.

Regards,
Ambre

[moke123]

various image (.jpeg) documents.

If by "document" you mean strictly jpg images, you would use an image control, not a browser.

[moke123]

Here's an example. You need a reference to microsoft scripting runtime and microsoft Access xx object library.
It shouldn't be too hard to figure out what it's doing but ask if you have questions.

Select a folder and click list files. You can then select a file from the list to display in the image control.
The example is filtered to return only these file types - ".jpg,.jpeg,.png,.bmp" You can add or remove filetypes as needed.

[Micron]

Maybe "browser" means an actual browser app. FireFox, Edge, whatever?

[Amicron]

How about this: Images

[Edgar]

By browser, do you mean the browser control?

[Ambre]

The files are all images. Some of them are catalogue pages and are very small print. I want to open them in a browser so that the user can use the expand/contract, cut and paste, and print functionality available in a browser.

[Ambre]

I do mean a browser app. The user then has all the browser functionality to manipulate the image.

[Ambre]

I am new to Access. What is the 'browser control'?

[Edgar]

Access has a web browser control, but it's not what you want to use here. The browser control I referred to is for displaying websites, or html/css/js documents.

There are two options here, the easiest is to just trigger the opening of the folders that contain the images with the explorer.exe application that is native to Windows.

The harder option is to create a form that looks into all the folders associated and shows all the images in those folders, creates a temporary table with each filepath and a subform with a continous form displays all of the pictures. With that, you will need to program the features you need. Which is not going to be quick, because Access itself does not have a file browser integrated with all the features you need.

[moke123]

Why not use whatever the native app is to open the file types? Picture viewer for pictures, pdf viewer for pdf's, word for word doc's, etc.

You can use code like this to open any file in it's native program. http://access.mvps.org/access/api/api0018.htm

A slightly modified version of the code in my example will list the files in a folder to either a list box or a combo box depending upon which control you pass to it. Then in the afterupdate, double-click or some event of the control, you use the fHandleFile code to open it in its native program.

another example reflecting the above attached

[YAroslavDah]

I have a text file with 267 coloumns. When trying to import via access, the coloumn will be auto truncated at from 256 coloumn onwards. Anyone can advise on how to import all coloumns from these text file into 2 tables in the Access? tks in advance.

[Welshgasman]

I have a text file with 267 coloumns. When trying to import via access, the coloumn will be auto truncated at from 256 coloumn onwards. Anyone can advise on how to import all coloumns from these text file into 2 tables in the Access? tks in advance.

Please DO NOT hijack someone else's thread.
Start your own with a relevant title.