473,657 Members | 2,862 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How do I make a button open an image in access?

1 New Member
I have an access database that I need to open scanned jpegs from. I don't care if it opens "in" access or if it just invokes the native application for that file type. I need the button to look at the "Circuit ID" field in the form, locate a matching file name in a specified directory and open the file. Can anyone tell me how to do this?
Mar 10 '07 #1
3 3613
MMcCarthy
14,534 Recognized Expert Moderator MVP
I have an access database that I need to open scanned jpegs from. I don't care if it opens "in" access or if it just invokes the native application for that file type. I need the button to look at the "Circuit ID" field in the form, locate a matching file name in a specified directory and open the file. Can anyone tell me how to do this?
You need to look at creating an OLE Object datatype field.

Mary
Mar 10 '07 #2
robertoathome
20 New Member
You need to look at creating an OLE Object datatype field.

Mary
Can the answer include beginners please? I've been reading/using about using OLE ( and it only works with bitmaps) but it bloats large databases.

I've been trying to learn how to create a button that runs a macro to open a pic ( from ono of the column of a table ) in a picture box but my brain is about to fry.

Any help?

Thanks.
Mar 29 '07 #3
MMcCarthy
14,534 Recognized Expert Moderator MVP
Can the answer include beginners please? I've been reading/using about using OLE ( and it only works with bitmaps) but it bloats large databases.

I've been trying to learn how to create a button that runs a macro to open a pic ( from ono of the column of a table ) in a picture box but my brain is about to fry.

Any help?

Thanks.
OLE objects can work with any type of image including jpeg's. Linking rather than embedding the images wouldn't bloat the database as much.

To link images directly into an image window at runtime would be a very heavy load on the database. I'm not aware of an ActiveX object for viewing images in Access but I'm sure there is one. Maybe someone else can help further.

Mary
Apr 1 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

8
9765
by: Alpenvrouwtje | last post by:
Hallo, Does anyone have a (simple?) javascript code for me to prevent that people take the photo's of my website while they use the right mouse button. I know that there are ways around this and people can still get the picture, but in that case it is much less easier and only the handy people can get it then. That already helps.
3
3603
by: mitsura | last post by:
Hi, I have included a small listing. The test program opens a panel and show a bitmap. What I want is to when the mouse is over the bitmap panel, I want to trap the left mouse click. The purpose is to get the position of the mouse pointer on the bitmap. However, for some reason, the left (I also tried right) mouse clicks are not intercepted. I new to Python and wxWindows so any help would be greatly appreciated.
2
3232
by: Randall Parker | last post by:
Short of generating my own icons is there a way to get the appearance of a button on a form but with behavior that is like a regular link? In particular, I want to be able to right click on a "button" and choose "Open in new tab" or "Open in new window" (given that the user's browser supports either of these options). The handy thing about HTML buttons is that they can have their visible text value set and then the buttons can have...
7
2951
by: Stewart Saathoff | last post by:
Hello, Does anyone know how to open an Internet Explorer URL with a specified Path when someone clicks a URL?
14
4960
by: Kevin | last post by:
A couple of easy questions here hopefully. I've been working on two different database projects which make use of multiple forms. 1. Where's the best/recommended placement for command buttons for things like delete, save, edit, cancel buttons - in the footer, or on the form detail section? 2. If in the footer, how do you add them to the tab order?
2
1887
by: AccessPro | last post by:
Hi, I am creating an image-management database. I want my users to be able to double-click on an image (a preview of what exists in a network subfolder), and for the code to open the image in its associated application (say, Microsoft Photo Editor), then wait for the user to close the window before continuing code execution. I know I can shell out to whatever application I need, but Shell doesn't seem to have a "wait" mode on it. I...
2
4853
by: conckrish | last post by:
Hi all, This is all about ASP.NET WEB APPLICATION... I have a Button and when i click that button... i need to open the File Dialog through Which i have to select the Image Path... And When i press the OK Button of the File Dialog ..... i have to get the File name selected and set it as TextBox Text and also Show Image Preview...
4
4793
by: John Smith | last post by:
I have a continuous form. there is a command button with the following code for the OnClick event: DoCmd.OpenForm "frmPlants", , , "PlantsID =" & Me!PlantsID I click the button and frmPlants opens up with the record that corresponds to the one on the cont. form. I put that same code for the OnClick of an image control (i.e. the user clicks a little icon to open the form instead of a button) and frmPlants
3
4515
by: glbdev | last post by:
Hi. I have a gridview in which each row has an image button attached. I have each button in each row set up to be associated with a DB field. When I hover above the button it shows me the correct value of the DB field in a tooltip, so there is no problem there. But ...how do I access that value? When the user clicks that button I will redirect him to a new page and I need to use the value as an ID in a querystring, but cannot figure...
0
8821
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8723
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8502
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,...
0
5632
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();...
0
4150
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...
0
4300
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2726
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1941
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1601
bsmnconsultancy
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...

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.