Linking text boxes

[vbaInet]

I used the above code but changed the references relating tool no# to the image "image 33" but it says runtime error 438 object doesnt support this property or method.

Nice try, but you shouldn't be needing to do that.

Where is the image stored? And how is it linked to a record on your form?

 

[jer]

The filepaths to the images are saved in the table that the form works off of. And i use a code in the on current event of the form and after update event of the textbox that stores the filepath to update the image for each record..

 

[vbaInet]

No code is needed. Just set the Control Source of the Image control to the field containing the path.

 

[jer]

in the report? when I click the picture it is blank uder the data tab.

 

[jer]

in the report i do have a textbox that contains the filepath for the picture of the tool and this works fine. I just cant get the picture to change! the filepath does but the picture does not! any ideas?

 

[vbaInet]

Why do you have tabs in your report? A report is just meant for displaying and printing data. If you have layers it will only print the top layer.

So instead of using a tab control, put the sub reports on after the other.

 

[jer]

No code is needed. Just set the Control Source of the Image control to the field containing the path.

I meant that i clicked on the actuual image in the report to change its control source which is under the data tab but it was blank and there were no options.. My report has no layers.. sorry for the misunderstanding.

 

[vbaInet]

Oh alright. If you can't see any selections in there, then your report is unbound. The report needs to be bound to a query or table. That's what drives it.

 

[jer]

and is it possible to bound a report or do i have to create a brand new report based on the table?? Once i set the control source of the image to the field containing the file path,do i have to put in code in the reports on open event?

 

[jer]

I just created a mock report using wizard and based it on the table the form uses but the data part of the image control is still blank...

 

[vbaInet]

Like I mentioned before, no code.

Create the query and set the Record Source property of the report to this new query.

Drop an IMAGE control on the report.

I would advise that you play around with the wizard just to get familiarised.

 

[jer]

im using an image control, not a bound or unbound object frame.. does that make any difference?

 

[vbaInet]

im using an image control, not a bound or unbound object frame.. does that make any difference?

Upload the db as it is.

 

[jer]

create a query using the forms!formname!textbox.value reference?

 

[vbaInet]

Up to you. If you put the reference you don't need to pass it in the OpenReport command. If you don't put it in the query you pass it through that command.

 

[jer]

the system wont let me upload my db

 

[vbaInet]

I'm sure I gave you the links with steps on uploading a db on here.

Compact & Repair, Debug > Compile. And I only need relevant bits.

 

[jer]

its not that, it says something about a security token.
Either way do you know anything about this. I tried putting the following code into the detail part of the report, on format event

Me![Imageframe].Picture = Me![Imagepath]

But then when i save the report an error comes up when i try to enter the form saying that the report does not exist and or something is spelled worng, yet before i do any of this the report and form work. And during all this i dont touch or rename the report at all! do you know whats goins on?

 

[vbaInet]

I keep saying you don't need code. It just won't work.

 

[jer]

ok i will upload the db as soon as i can