Recent content by Fran Smith

Ah!! So simple! I obviously hadn't done multiple possibilities for an If..Then statement.:rolleyes: Thanks!:D

Hi all, I've been going pretty well :), googling for answers, but this one stumps me. I have a combobox displaying 6 value list items. I'm using an If...Then statement to find out which option the user chose in order to,firstly, ascertain whether it is a valid choice when coupled with another...

Hi vbaInet, Sorry about the late reply (weekend away ). Perhaps dot points might work. 10 people displayed on the form from the same table (People). Each person has a group of controls displaying a picture, name and their position in the family (mother, grandmother, child etc). It's a bit...

Hi vbaInet, Thanks for your reply. I didn't ignore Gina's reply. I did follow the tutorial (in fact I discovered that image controls in Access 2007 do not appear to accept .jpeg images - a bit of a worry:eek:). And I did thank her for her help. The fault is probably mine - I probably didn't...

Hi, I'm a newbie learner who has learned DAO (somewhat), but not used control source (I was told not to), but in this instance, I'm simply looking up an image to display. This is my expression: DLookUp("[People]![Picture]","People","[People]![PeopleID]=txtIDMother") I'm wanting to retrive...

Hi, I have a field in a table which I would like to populate my attachment control on my form with. Actually, I'm not even sure if an attachment is the right field type. I want the user to be able to select and save an image, but I also want to be able to populate user's saved images on the...

Ah! Thought it must have been something simple! Thanks to you both :-) Cheers,

Hi, :) I'm a newie at VBA, but here goes. The bit after the Else statement is the problem. I did read various other people's threads attempting to make a textbox invisible using the Null statement, but I'm doing it another way - populate else make invisible. This all, of course, works if the...