I'm trying to add a control to my form that I don't know how to do.
On my form, I want the user to be able to click a button which will open up the standard file open dialog box. The user then will be able to browse through the appropriate directory and select an image file which will be saved on that specific record.
Attached is a strip down database as an example.
How can I do this? Any help would be greatly appreciated - I'm trying to do this for my work.
I know everyone is going to say DONT PUT IMAGES IN YOUR DB< PUT LINKS TO THEM IN!
I am not at liberty to change the structure of what my boss wants, he wants the images stored in the DB so that is what I am giving him.
My problem is this: I have a single form for entering data into my Table, and I want to add a control that will let the User Browse for the right image, and them add that image chosen into the DB with maybe an upload button or something.
Now, if it is VERY VERY poor design to do it this way, and it is SOO much better to do the link to image way, if you could please detail how it works in both ways, I may be able to talk my boss into changing. My problem is I am not very good at this DB Designing and such, and have no experience using OLE type fields.
i would like to create an browse button on my form so i can find the pictures i would like and then to been shown on the picture field on my form. i tried the northwood code from help but i could manage nothing woth it. do you have any idea to help ,me please??
Hi all , Can anyone tell me about how to embedd image in image control using imagelist. I added the 5 images in imagelist at design time and added the following code. image.picture=imagelist.listimages(1).picture but iam getting error.error no :2110,cannot open the file . thank u, Siva
i'm trying to put a button on my form to browse throw the files and when select a file loads the path and name of the file into a variable on my form, but i cant find the button "Browse". anybody knows were the hell is that thing... THKS.
Is it possible to use the "Browse To" macro within a subform on a Tab Control (Not a navigation form). I am trying to set up the "path to subform control" in a "Browse to" macro. I am not using a navigation form but instead am using the Tab Control feature. On my third tab I have two subforms; one that displays all of the records within a related document set in datasheet view, and a subform that displays each of these records individually. I want to be able to click on a record in my datasheet view and have it populate the main form.
I am just trying to figure out what the "Path to Subform Control" should be. All of the examples I have found are using Browse to on a navigation form and not a tab control. My Main form is called "BRC Form", The form in datasheet view that I want to make my selection from is called "Biomarker SubFrm", and the form I want the data to populate into is called "Copy of BiomarkerQry"..In the "On Click" event, I have added a browseto macro.
Here is the macro I am trying to mimic from the Contacts Web Database. Here is what I have so far. As you can see I am trying to figure out the proper code for my Path to Subform Control. again, this is not a navigation form so I need an extension that will work within this tab control.
I have a field in a form to which I wish to be able to browse to a particular PDF file. This location is then to be a hyperlink that when clicked upon, it will open the chosen file.
I have seen a thread already for file browsing, but it said to look at the VBA code, which I have no idea what it means :(
(Referring to this post (http://www.access-programmers.co.uk/forums/showthread.php?t=75790) by ghudson)
Hi,
This post was very useful, it really helped me out, but I do have one question. My database will be used by multiple users and will be stored on a mapped network drive, just as the files that I want to link to. Now unfortunately not all machines are configured the same, so the same network drive can have different drive letters depending on the machine and this might cause problems. Is there a way to modify the code to get the absolute network path instead of the drive letter?
I'm having a small difficulty in using the code example ghudson posted for Browse [Find a directory or file]. First off, the code works great. Thanks a lot for posting it!
The problem I am having is when linking a folder via dBrowseDirectory. The folders I am linking are on a shared network drive and I am trying to figure out how to set the initial directory to default to the networked PC. This way the user doesn't have to navigate to the shared drive every time. All they would have to do is navigate to the particular folder to link (2 clicks instead of 10+).
The dBrowseFiles function allows to set an initial directory, however I cannot figure out how to set it for dBrowseDirectory. Is there any way to do this by altering your code for dBrowseDirectory?
I am creating a database where I want to be able to browse to a file, select it and import it into a table. I am able to do this. BUt what I want to do is create a log of these imports and haveit include the path of where the file was inported from.
The field I am having issues with is the capturing the path of the file.
Below is what I am using to browse and import a file.
Private Sub Command5_Click() Dim dlg As FileDialog Set dlg = Application.FileDialog(msoFileDialogFilePicker) With dlg .Title = "Select the Excel file to import"
I have created a form to send emails with attachments. The attachment path is specified in an unbound field which I have called [ToAttach] Rather than typing in the path, I want to use the browse function. I have inserted a browse button and can browse for the required file using following, but can't figure out how to place the file name in the unbound field as a string.
Code: Dim f As Object Set f = Application.FileDialog(3) f.AllowMultiSelect = False f.Show
I have a field on a form which the user currently has to manually type in the file path to a specific picture on a local drive. After the file path is entered, the path is linked and the picture is shown in an image box. I did this because I didnt want to bog the database down with attached files.
I wondered if I could have a browse button, which when pressed brought up the browse window to allow you to locate the image (using the standard windows browser). Then when you clicked ok, it writes the filename into the correct field on the form.
What I would like to do is create a form that lets the user browse for an excel file, then will click an "import" button which then imports all the fields in excel into a table.
I have a form displaying records. I would like the user to be able to select a button, browse for a file on a shared drive and link it to that record.
I have been exploring hyperlinking, which works for the most part, although I need it to display the share name rather than the drive assignment for that user. Such as drive1folder rather than C:folder.
Hyperlinking also unfortunatly requires the user to right click on a field select edit hyperlink then browse.
I want a user to click a button, have the file open dialog open, they select a spreadsheet, and then it imports into a table. The problem is the filename can be different every time. The table name will remain constant.
Here is the OnClick:
Code: Private Sub Command8_Click() On Error GoTo Err_ImportSpreadsheet_Click DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel2Xml, "Table1", "T_Staff.xls", "Yes"
I am going crazy!!. I want to use .jpg images in my Access Form (Access 2003). All the tutorials and forums talk about using Image Control to display .jpg images. But I can't find the Image Control on the toolBox??? Where is the Image Control?? I am currently useing Unbound Image Control but that only allows me to display .bmp images.
I have a global function which I have hooked onto the onClick event of controls. Currently I am using commandButtons as my control of choice. In my function I can then reference Forms.ActiveControl which is no problem.
However, for lots of reasons I really need to use Image controls. Now, my problem. Image Controls have an Onclick Event, but they do not get focus so the Forms.ActiveControl will not work.
How can I identify the image control that has generated the click event if the control itself does not get focus and so cannot be referenced by ActiveControl? Working on a possibly work around, but could do with the best brains in Access on the case!
I have a database that was built by some users, long before I came to my current job location (oh yes, one of those fun issues), and have run into an error that is involving a 3rd party tool, and is tough to duplicate.
There is an ocx control named "Kodak Image Thumbnail control" the path is C:winntsystem32ImgThumb32.ocx.
This is an active x control, that on the double click event, opens up the correct corresponding .pdf file. It works correct for me, on my machine. It works correctly for 3 other people on their own machines. When we had a user it worked correctly log into a user who it does not work correctly, it then worked correctly for them (appears to be user rights, and not machine specific). It does not work correctly for another 2-4 users (not sure the exact number).
But, the rights were gone over with a fine tooth comb, and nothing was found different from each user.
What is weird, is how the error occurs. There are 59 records in the database, with a linking .pdf file displayed in this .ocx control. For those users in which this does not work, the first two records open the .pdf correctly. After this (records 3 to 59) they receive the following error:
"Microsoft Access can't open the file containing the OLE object.
- You may have specified an invalid file name or an invalid unit of data (such as a range of cells from a worksheet) when the file for the OLE object. - The file you specified may not be available because it's locked by another user or you don't have permission to use it.
Try one of the following: - Make sure the file is available and that you used the correct file name. - Check the OLE server's documentation for information about the syntax to use when specifiying an OLE object's data."
[OK]
Since this is a third party tool, that I have never used, and do not even have on my machine (yet it works correctly for me) I am not sure what else I can do to track down the error. I just wanted to see if anyone else has run into this error, and if so how they had fixed it.
I have a text box [txtTrafficValue] that is a calculated field of two short times. I want an image to be visible if the value is >= 0.0104 (15 minutes). I have in the after update of the field:
if me.txtTrafficValue >= 0.0104 Then Me.imgWarning.visible = true Else Me.imgWarning.visible = false End if
but when the field does the calculation and updates the image is not appearing.
I've searched a lot and couldn't find an answer to my problem.
I want to have a field in my form that allow me to paste an image from the clipboard to, for example, a Paint field. Then, I want to save that image to a file on a specific folder in my computer via VB.
The reason for this is that I don't want to ask the user to open paint by himself and save the file, probably in the wrong location and with the wrong name.
The first approach was creating an OLE Object directly from the Insert menu and that worked partially. It allowed me to paste the image but there wasn't a way to save it to a file, neither a method for that. It was an incrusted object, and I think that is the reason for that.
Then I tried to create the object by myself via VB, with the instructions:
Dim objeto_perfil As Object Set objeto_perfil = CreateObject("Paint.Picture") 'IT STOPS HERE
And with the variation:
Dim objeto_perfil As Object Set objeto_perfil = CreateObject("Paint") 'IT STOPS HERE
And neither worked. The error message says it lacks an object.
Then I followed an example from msdn that used a bound frame (view here (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac11/html/acproClass_HV05187062.asp)). The code is:
visor_perfil.Class = "Paint.Picture" ' Set class name. ' Specify type of object. visor_perfil.OLETypeAllowed = acOLELinked ' Specify source file. visor_perfil.SourceDoc = "C:RealPathimage.BMP" ' Create linked object. visor_perfil.Action = acOLECreateLink 'IT STOPS HERE ' Adjust control size. visor_perfil.SizeMode = acOLESizeZoom
It stops in the action assignation, an says "error 2753 there was an error trying to communicate with the OLE server".
I google a lot and could find much of the Paint.Picture Class.
Anyone has any ideas to overcome this issue? What am I doing wrong?
I have an Image control on a form which I want to examine programatically. It seems there used to be a way of doing it using Point and PSet from info I have seen online. Is this contained in any of the libraries available under References in Access and if so which one...
On open I change the Picture property of an image control to another image. I do it 2 places. Access crashes on the first change or on the second. In about 50 % of the cases.
One of the fields in my database stores a path of an image that I want to display on my form. I used the following code in the "On Current" event of my form to achieve this effect:
Private Sub Form_Current() If IsNull(Me.text1) Then Me.ImgPic.Picture = "C:UsersharrDesktopCupCake.jpg" Else Me.ImgPic.Picture = Me.text1 End If End Sub
It works great with the exception that the image doesn't update when the path is changed. If I update the path, I have to navigate to the next record and then back again in order to see the new image. I've tried a couple of things to try to requery the image after the text control is updated, but so far none have worked. This is my most recent attempt on the after update event of my text box:
Code: Private Sub text1_AfterUpdate() Me!ImgPic.Requery End Sub
How I can refresh the image after the text box control is updated?
I haven't worked with access in about 2 years, so I'm a bit rusty. I was wondering, what is the easiest way, if any, to output an image stored in an OLE object field to a file, like a bmp to be edited say in paint or something via VB code?
I have a linked table in ms access and it has a column as details. in ms access when i click on this button i will go to another form. i want to assign a picture (for opening a form) to this column but i don't know how i have to do this. my form opens as a datasheet view.
