User Profile

Corey Smith · Dec 14 '11, 06:01 PM

I don't have an issue attaching the database for you guys to look at.

But first, over the last night I was thinking that maybe our approach to accessing the images is what is giving the headaches. Right now we have a separate table linked in that has the category code and the images are stored in an attachment field ... which for whatever reason, we cannot figure out how to check whether it is empty or not using VBA code.
...

Corey Smith · Dec 13 '11, 10:34 PM

Now I'm pretty convinced that I don't have things set up correctly. I have tried to do something very similar to that, and it kept giving me the error about not being able to find the field.

Would it work any differently using the On_Format event, as opposed to the Form_Current one you have used?

Let me look at a few things and I will report back.

Corey Smith · Dec 13 '11, 10:14 PM

The more I think about it, and after doing some looking into that table ... they are stored in there as attachments.

Which could be why things are not working as expected.

Corey Smith · Dec 13 '11, 09:18 PM

It has been a struggle ... really only with this one little thing, though. haha

The good thing is ... they said that if it won't work, then they can just make a supplemental brochure type of thing to put the advertising it ... I was just hoping to come through with this piece for them.

I'm gonna give the IsEmpty a try, though.

Corey Smith · Dec 13 '11, 08:55 PM

S7 ... that is pretty much exactly how I thought I would tackle this when I was very first looking at it, Using IsNull ... except instead of adjusting the height I was going to just make the section not visible if it was Null.

But when I just reference the Image field as [Image] ... I get the error message of:
"Run-time error '2465':

Microsoft Access can't find the field 'Image' referred to in your expression"...

Corey Smith · Dec 13 '11, 06:04 PM

I'm not having success getting that code to work either. I'm beginning to think that I have set it up incorrectly, initially. Whatever code I put in the On_Format section, I get the space there for the image whether there's an image or not.

How should I have the image control set up? Should I have it's size set initially to 0x0, or set it to the size that all of the images will be (they will all be the same)?

Also, If...

Corey Smith · Dec 13 '11, 04:36 PM

Thanks NeoPa.

We have 2010 here, and it has both Format and Paint. I've been trying through Format thus far.

I'm about to give what you have above a run and report back!

Corey Smith · Dec 12 '11, 11:14 PM

There actually will be a record for every Code. That is why I need to be able to check that field to see if it has an image, or not.

It's this way because the categories that will have an image attached varies from version to version.

Corey Smith · Dec 12 '11, 09:55 PM

I'm stumped on how to refer to the field I need to check for null. Am I supposed to create a variable in order to use an IF statement to check for null?

Because when I just refer to it as it's name, I get nothing.

Corey Smith · Dec 12 '11, 04:16 PM

NeoPa - Sorry about that. The name of the image control is "Image39".

Sierra - The thing that I dont' know how to do is ... at least can't get to work ... is to check for a null value for the image field it'd be based on.

Corey Smith · Dec 9 '11, 11:27 PM

Code:

SELECT [Catalog Import].Code
     , [Catalog Import].Description
     , [Catalog Import].[Item No]
     , [Catalog Import].ID
     , [U][B][Advertising Images].Image[/B][/U]

FROM   [Catalog Import]
       INNER JOIN
       [Advertising Images]
  ON   [Catalog Import].Code = [Advertising Images].[Catalog Group Codes];

The field is "Image".
I used the Image control from the report design tab.

...

Corey Smith · Dec 9 '11, 10:37 PM

Did as you suggested and added the image field to the query. Worked great.

What I need to figure out now is how to get the section that I have used the image in for the report to not be visible if that image field is NULL.

How do I reference the field so that I can us IsNull on it?

Corey Smith · Dec 9 '11, 05:37 PM

Definitely worth looking into. Let me give that a run.

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Displaying an image conditional on an Access Report

Publisher | Modifying Catalog Merge