Search results

Hello all, I have search the forum for two days and can not find anything about this promble so any help would be good. I am using a linked picture i have then browser setup and works ok but my issue is that i can not get the picture to refresh its self, with out going into design view and...

Cheers Rich for clearing my stupid thought

I belive this is the answer to your current needs, you will find the text under Query1 in the attached database. Alastair

Rich Iif([Sex]="M","Son ","Daughter") The Daughter part of the code will that asum that all other letter except "M" are Daughter. Just checking my understanding.

can you give me an example of the text and i will have a look for you.

No promblems

Have a look at this simple database and you should see how to set it up at your end. If you need any more help cry out and i will answer Alastair

No i would put into into the field name.

updated message this worked for me: Test: IIf([Sex]="M","Son ","") & IIf([Sex]="F","Daughter ","")

you could try a query that will transfer M to Son and F to Daughter the expression should look some thing like this: iff ([Sex] = M,"Son" & iff[Sex]=F,"Daughter") Not sure if this will work but you could give it a go. Alastair

Hello All, It has been a while since i posted and answered any posts. I am have a problem with a subform that has a picture on it, the problems is how to get the frame to refresh upon change of the picture. I have tried the normal me.refresh with no joy, just thought one of you master minds...

Thank you for your help Kodo, will have a look at the link you have supplied

I am currently updating a database and would like to know how easy it is to incorporate Sql into my database i understand that this is the fastest way of reteiving information and is best practice when working with servers and desktops. Any information will be gratefully recieved and tutorials...

Good point Brian, I still think that men can multi task, just women do not see it, also men like to get the job done properly and not fast and half a job.

You can set the Top, Left, Width & Hight under the relivent report heading (ie Details), but i think you can not delete the standard sections. You would need something like:- Me.Top = (Your Number)cm

Looks you you need to have a look at the relationship you have with in your query, if you have duplicates this is one reason? Alastair

I take it that the two combo boxes are link to each other? If they are then right click on your combo box and select properties, then on event tab select the after update by clicking on the ... click code builder then in the code selection insert Me.[ComboBox name].refresh or requery.

Is it a toolbar you have made your self or one already made by access?

I think you got the subform name wrong, funny i cannot remember

You may need to change the Access field name to memo and try. Alastair