Search results

Also how many charcters should it be trimming off? why does it need to trim off characters?

I am having troubles with it. On some records it will work and the report will display the relevant record. however some records do not display. Can anyone tell me what is going on here?

i changed the 17 to 10 and it works! I dont understand the logic, BUT IT WORKS! Thanks

Thanks for your help Paul I have taken the space out of Id no and now it is IDno however now when i press the button it brings up a box asking me "Enter Parameter value" ID _________ Also i dont understand your reply about the cleanup and 17? Thanks for your help

oh forgot to mention: My list box is called LstFindings

Hi, I am working on a simple database where i would like the user to select records from a multiple selection list box and then based on what the user had chosen a report displayed for just those records. I have some code from a sample database but i cant get it to work. I have 2 fields...

How can i determine if there is no picture in the images folder? If i put IIF [ImagePath] = "" then ImageFrame = "" this doesnt work becuase Every record has an imagepath but may not necassarily have an image in the images folder? hope that makes sense

Can you tell me how to write the IIf statement please? I am new to VBA Many thanks

I am new to VBA, i want to display images in a report however if there is no image for a particular record then i get an error message. I think i need some sort of If statement such as If there is no image then still display the report with the information but not the image. This is how i...