I have a form that contains one WebBrowser Control. In this WebBrowser control I interact with the Google Maps API to produce a map.
I would like to save the contents of the WebBrowser Control (Google Map) to an image file. I have not been able to figure out how to do this.
The WebBrowser Control takes up all the space in the form. Perhaps the contents of the entire Form can be exported to an Image?
I have the following code which displays the correct URL, and populates the fields, when going thru in debug mode but loops when running normally. Somehting simple I guess but I cannot see it.
Private Sub Command1_Click()
Me!WebBrowser0.Navigate "https://www.lexisnexis.com/PowerInvoice"
Loop1:
If Me!WebBrowser0.ReadyState = READYSTATE_COMPLETE Then
Me!WebBrowser0.Document.signinForm.webid.Value = "????"
Me!WebBrowser0.Document.signinForm.Password.Value = "????"
Else
GoTo Loop1
End If
End Sub
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...
View 7 Replies View RelatedI 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.
View 3 Replies View RelatedI 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.
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?
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
Hi,
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?
Thanks in advance!
I need to migrate the contents of a table from Access Jet or Ace to SQL Server.
The table has 2 fields, an integer and a BMP image ex
Field1 Field2
1 BMPimage
2 BMPimage
3 BMPimage
4 BMPimage
If I manage to export the images to files like 1.bmp, 2.bmp, 3.bmp, 4.bmp etc I can then import them into SQL Server.
I have a continuous subform which queries a table of attachments. I'm using Access 2007 but not using the Attachment datatype; this DB will grow considerably and I don't want to waste precious space by filling it with bulky files. So instead, I have code which makes a copy of the attachment and adds the hyperlink (to the copy) to the table instead.
Now - I want to add a control to the subform to display an icon / image reflecting the file type of the attachment (Word doc, Excel s/s, PDF etc.)
But not sure how to go about it.
I was thinking I could use FileSystemObject.GetFileExtension at the point in the code where the attachment is added, and add a new field to my attachments table (i.e. translate "*.xls*" to "Excel", etc.) Then store / embed a handful of images for the core types I would expect and use an image control on the subform to display the image based on the value of that field.
But is that even possible / feasible?
Or, is there a handy API which can retrieve the icon associated with a file type based on what has been installed on the local machine (even if there is, there's still the problem of setting up the image control to display the appropriate icon specific to each record...)
Or, is there another control available which would be better suited to something like this than an Image control?
How can i control what happens when a form is closed.
Say for example if no order lines have been entered on a sub form, the record is not saved.
Also how do you remove the default access error messages about null fields, and replace it with something more user friendly.
Hi,
I am a first time user to access groups, so I am hoping for a
good experience.
I have a form which has a calculated control. But the calculation
shows on the form but is not storing in the record.
On the property sheet, the name is charge and the control source is
the calculation (=[source1]+[source2]...)
Why is it displaying but not storing? I do not know Visual Basic, so I would
like a solution that is simple if there is such a thing.
Thanks in advance,
Trainjoan
I have a simple application where a user clicks on the name of the person he wants to update from a drop down box.
The record is then retrieved and the fields are filled on the form.
The user will then enter a value in the # in household field.
The user is then required to click on the save button to write the record for this person.
I do not have strong users and they invariably forget to save the record and go on to the next person, resulting in the record not being updated.
I coded a message box as part of the save button which displays "person was successfully updated" and then instructed the user to make sure that they see this message before they go on to the next person. They still fail to update correctly.
My question:
Is there a way when the user selects a person from the drop down box and it is loaded on the form, to warn the user that they have NOT updated this person, before they go to the next person?
I don't know what else I can do with these users. They are all volunteers and elderly and the application is for a Food Pantry.
I have a query that has a pivot chart, i need to be able to save this as an image so i can insert it into a html email but i cannot find anything, I am using access 2010 ...
View 3 Replies View RelatedI seem to be having an issue with a split form I've been working on. I created this split form on Monday and it was working just fine but today, I have added a couple minor text boxes. Since then, I can view the form contents in Design View but when I switch to "Form View" or "Layout View", it's all gone minus the logo in the top left corner and the title for the split form.
View 12 Replies View RelatedI have a field on a form that is the results of a dlookup to a table.field. I want the value to be updated when I execute a button that is running a macro. How do I do this automatically, and not have to hit the refresh button?
View 5 Replies View RelatedAccess 2010:
The database I'm working on stores label images, or better stated, it stores file paths where the label images are stored. These paths are used in reports and forms to view the label images within the database. What I'd like to do is to create a "save" or "email" button that will allow the user to select a location to save just a copy of the image in jpg format. I realize that it is possible to imbed the jpg image into a report and export it as a pdf. What I'd really like to do is find a way to save the image (perhaps by copying it from the path in the database and simply relocating it) and preserve the jpg extension if that is possible.
I am also aware that there are third party applications that will convert pdf reports into jpg files however network restrictions keep me pretty limited in my ability to download third party software.
I am trying loop through a datasheet so that I can copy the contents of one field into another form.
I have tried using the bellow code to do this on a button click event. However when i run it I get an error telling me that the object doesn't support this property or method. Im not quite sure what this means.
Dim rst As DAO.Recordset
Set rst = Forms![Roll Out - Site Form]![Roll Out - Sign items pick list].RecordsetClone
Do Until rst.EOF
[Roll Out - Sign items added].Form![Code] = [Roll Out - Sign items pick list].[Form]![Item Category]
Loop
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.
Help!!!
Hi guys,
I'm in desperate need of help and want to know if it is possible to load an image on a form once a hyper link is created.
For example, I have a form with a hyper link to an image created, currently, when you click on the hyperlink, it opens the picture in the browser, can you change it so that it loads teh image embedded into the form instead of loading it into a browser?
If so, how?
Thanks
I have been tasked to scan family pictures in such a way so they are available to older family members to identify people younger family members dont know. My solution is to scan each photo, name them 1.jpg, 2.jpg. about 4000 images. Store them in a directory (H:Family). I then want to create a form that will use the PK which is an auto number to pull that numbered picture into the form where someone can enter the other fields. I have fun with Access but this is well above my knowledge level!!
View 7 Replies View RelatedHi,
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 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.
Thank you for your time.
T.J.
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.
Thank you for ANY assistance you may give!
PS: All images will be same type and size!
I am working on a form as a user interface. I have added an picture to the form and it will change, according to the selection in the combobox. It looks small, and not clear because of the size, and each image has different sizes. I would like to know if there is a a way that will allow me to click on it, and then it will open in another window so it is bigger with the right sizes. I was thinking that it could be something in the on click event.
View 7 Replies View Related