Search results

Can you show me an example of an IF statement using my info?

Are you saying I can put my IF statement in the image ControlSource property?

I'm using an image and the source is an unbound field with the path of the image file. And i have an IF statement that fills in that image path based on value from another field.

I've tried to put the code every where, no luck.

Thanks for the explanation. The control is in the detail area.

But my code works in a command button. What is different about what you are suggesting?

8 different possible images

Both Report View and Print Preview are doing the same. Nothing.

Sorry, it is on Load

I have a report that has a graphic field which based on a value in an unbound field. The code works. But when I put that code on open of the report, no value get put in the unbound field. If I put that same code in a command button, it works fine. So, I'm guessing some kind of time issue...

Do you know of any example db's out there?

I have a report with a command button that creates a pdf and sends it to a specific folder. Is there a way to be able to choose where the pdf goes instead? Maybe a drop down with different locations? Thanks.

Got it! Thanks.

I think I got it working the way I want now. Thanks to all!. How would I write the following? Test: DCount("*","Query2","Field1>0.5 and <=1") I'm trying to return a records that are greater than 0.5 and less than or equal to 1. I used the above but get an error?

Yes, in another query. Will try.

DCount("*","Query2","Field1<5")

yes, 893 is the correct count but it repeats with 893 for 5000 records? How can I just get the 893 returned, one record.

So, this seems to work: test: DCount("*","Query2","Field1<5") but it gives number of records that meet the <5 (893) but for 5000 records if repeats 893? How can I just see the count?

Will give it a try

That's what I was thinking. What would it look like looking for records <5 using DCount()?