Hvordan opdateres Unbound Object i rapporter?

Have you had success showing a Visio document in an Access report?

If you already know the name of the file which you download and the destination file, then why do you need to update the source doc?

Youcould try opening the report in design mode then using code alter the Source doc and then save the report Then open it again in  normal mode.


P.S. Dont forget you still have another question opened

Hi Terry
I have altered Source Doc, but it doesnt kick in? I guees that where the problem lies...

Hi
"Have you had success showing a Visio document in an Access report?"
If you have the Visio document on you rlocal PC and alter the source doc manually, does it work? I've never tried working with Visio doc in Access so I just want to know if you have had success with this?

I'm off very shortly but will take a look later today.

Yes - I can see the diagram without any problems - just cannot update it according to the value in the next row.

amd

No - After having inserted the visio file the first time, it kinda snaps to the same file no matter what I do with the source doc.

If I understand the problem correctly you are trying to show a number of records and you want to be able to show a different visio document for each record (row)?

If so then I think waht you want is a field which contains the file name of the Visio document you want to show. So the field in the report will be BOUND.

Hi Terry. Been on vacation.
This is what I have allready done, but the report doesnt update the Source Doc value once its set in the first record. Meaning that I can only import the first record, the rest of them are "over writed" by the first one. Make sence?

Hope you had a good vacation.

Is it possible for you to send an example of your db with the table containing the path to visio documnets etc and also the report. And a couple of visio files?

Sure thing. I'll try to create a dummy database with files etc. tomorrow. Send it where?

ekspertenATsanthell.dk
AT=@

I may not have too much time tomorrow but I'll take a look as soon as I can.

Can CreateReportControl be used?

I'm not sure why you would want to use CreateReportControl. The report and control already exists so we need to find out why a BOUND object doesnt show the right file.

If you can send me an example then I'll take a look ASAP.

In your mail...

Hi Terry
I'm pretty sure that by using CreateReportControl it could work - but my skills are not good enough.
I'll try and explain what i'm thinking:
Use CreateReportControl to create the object and assign prober values. Delete it againg, create next, delete etc.

What do you think?

I'm not sure but the way I look at it is like this.
When a control is added to the detail section of a report there is only ONE control and that is used for all records. So using CreaReportControl only (I think) creates one control which you give one set of values.
If the control is undbound (at least in a form) then changing the values effects all records. I must be honest but I'm not sure if this alos applies for unbound controls in a report. I seem to recall that it may ne be, but I'll take a look.
But even if it is possible to alter the values then we need to find and event which is fired (performed) for each detail record and then chnage the values. In an Access version < 2007 it seems that the format event can be used for this, but in your dB in 2007 it deosnt seem to get fired for each record. So it isnt possible to change the values.
In a BOUND control it shouldnt be necessary to alter the values in code, but I couldn tget it to work in your dB although I'll keep trying.

Why do you want to delete the control again, wouldnt you just end up with one control showing the last set of values?

lukker