images in continous forms

[paulevans]

Hi
I would like to be able to create a continous form that different type of inage depending on values set in a given field. I have found that if I put an image field in my table and use this idea it works ok. The problem I am getting is to change the image based on the value in the given field. To make this easier to expalin. record one is a yes or no value record two is an image value that could be image one or image 2. I tried storing the images in a seperate table. Could someone help with making this work with vb code.

Thanks Paul

 

[neileg]

You should join your two tables in a query and base your form on the query. You don't need code.

 

[paulevans]

ok still new to this so what type of query do I use for this is it a straight forward query or do I use append, update. Thanks for any more help.

A simple example would be great.

Paul

 

[bonekrusher]

maybe this can help

http://www.vbaexpress.com/forum/showthread.php?t=8009

 

[paulevans]

Well guys thanks for your help but I do not seem to be getting any where is the .picture a reference that needs to be included in my DB.

To see if you can help further I have included a simple version of what I am trying to achieve. I check if there is a postcode and what should happen is if there is then the three books are shown if there is no post code the book is open.

I can not see where I am going wrong.

Any help again would be great

 

[neileg]

Try this. As I said, no VBA needed, just a select query.

 

[bonekrusher]

try this
http://support.microsoft.com/?kbid=210100

 

[paulevans]

HI Thanks again both.

Neil this is just what I want it to do I am not sure how automated this is for an end user unless I am missing something (Very probable).

why can I no longer enter values in my form? I can only do this is another form

Thanks paul

 

[neileg]

Mmm...

I've inadvertently created a non-updatable query. I'll have a think and get back to you.

 

[paulevans]

Thanks Neil
I have had a better look this morning and I now think I under stand how it works. So any way the user can update figures and run that query will be brill.
Paul

 

[paulevans]

Nick

Again I have looked at what you have done and think I could use this by having a setup form. From there I can run query 1 and 2 then start a second form which is bond to query 2. I am unfortunatley still new to all this and find that if I run the query in vba then the results are displayed. What I would like to happen is for them to be run in the background or another way?

Thanks for help
Paul

 

[paulevans]

Hi Neil

Sorry I posted your name wrong in my last post must really apologise for that.

HAve sorted this now by runing a setup form that runs query in the back ground can post sample if you would like to see.

Paul

 

[neileg]

I understand what you are suggesting. I am now completely stumped as to why my original solution doesn't work.