Search results

I know that. But what if I want to open the default program? (Like Windows Photo Viewer or whatever.)

I can't just make it open the default program for opening an image?

It finally worked. The controls did have the same name. Access creates those names automatically when adding fields. Not very handy then. :)

Yes they are. It should work. But just doesn't. I can show both fields separately. Just not combined like this.

=[tblOverige].[Straatnaam] & " " & [tblOverige].[Huisnummer] Then when opening the Report it shows a small popup Parameter Value. When I leave it blank it shows either #Name or #Type. I have tried with and without table name in front of the field name. With a period and with an...

How do I tell it to open the image? It is shown in the form a smaller version of it. And I want it to open the image when this smaller version is clicked.

I Tried that but that doesn't work. It gives a green triangle in the corner of the textbox and when viewing the report it gives "#Type!" instead of the Streetname and Number. Both fields in the database are normal text fields.

I don't know if this is talked about on the forum anywhere. I don't know how to search for it, what words to use. I have an Access 2010 database with addresses in it. I have separate fields for the street name the number and additions. But when making a report I have to make the street name...

Is there a simple way to tell access to open the image in the default program when the image is clicked in the form? Thanks again. :)

It works fine. Now I'll have to integrate it in my current DB. Thanks again. :)

I hope you can find something. Thank you very much. :)

Okay, I got the 64bit error fixed, but now the 'Set' button doesn't work. I didn't change anything to that code so I would be surprised if it does work for you. When I click that button it does nothing. But when I empty the field and click it then it removes the location of the image-file from...

When I open the main form the error in the visual basic window says: Compile error: The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute.

Thanks for your efforts gbnz but that doesn't work on a 64 bits system. And it looks pretty complicated too. Is it that hard to have a simple image selection tool in a form?

Yeah I figured storing pics outside of the db. But my VB skills are really bad. I usually copy paste code from websites like this one. Hahaha Thanks in advance for the help! :)

Hello, I want to give the user the ability to add 1 or more pictures to the record in the form. The user should be able to click a button then select a image file then the image should show in the form and saved in the database. Hope someone can help. Thanks. :)

In the Query I switched the two ID fields around and put the Overige ID field first, then it works.

It's an auto number. And yes I know of the space. I found out it uses the ID from an other table while it clearly is pointing to the Overige table as seen in the code. Why doesn't it 'listen'?

I'm trying to print a label from within a form I'm using the following code but some how it doesn't select the right record to print. Private Sub cmdLabelPrint_Click() On Error GoTo error If MsgBox("Verbind de DYMO 400 printer voordat je door gaat!", vbOKCancel + vbInformation, "DYMO Labels...

Isn't it possible to use the FollowHyperlink option? Then somehow loop through the database and get the emails?