Recent content by kevmc

I have created a form and want to photographs on that change with each form ie employees. I have managed to get an icon on the form which changes with each form but when I click on one I get a full screen size photo instead of one that will fit into the image box. I got the icon on by putting...

dcx693, thanks for that it worked a treat. Sorry for being so stupid. Pat & Rich, I have also tried your ways but, creating the combo and list boxes is ok, I just don't know what to do from there to create mailing labels. I would be interested to know. Thanks to you all. kevmc

First of all I would like to thank you all for your help. I may have confused the issue a little, I will try to clarify. I am entering more than one name in the Last name column of the Query eg: "Robinson" Or "Brown" Or "Smith". So I am getting a table with eg 3xRobinson, 2xBrown and 4x Smith...

All I wanted to do was run a Query from the Employees table, then create mailing labels. If you put Smith in as a name to be returned, it returns multiple Smiths. I want to extract the correct Smith. I don't really know how the multiselect list box would work, apart from it would have to be in a...

It's not necessarilly the first instance of a surname, it may be the middle one of three for example, I just need to extract the surname with the corresponding first name. I can't put a first name in the first name column as this would omit other records. The ID field is the key field, that's...

I am running a Query from a Table which contains info about employees. I want to create mailing labels, but I get multiple records containing employee names ie a lot of Smiths, and I only want A.Smith. So I tried using a Not operator in the ID field. But used it with the Or operator eg...

sorry to inform you, but that doesn't work either. I've put the formula in the criteria row of the Retake field in the Query. I'm getting as sick of it as you are now. Thanks for your help. kevmc

Sorry, I can't send a copy of the database. The value in valid is 5. This would give a course lifetime of 5years. I think I have managed to get it to work on a form by adding the formula to the Retake control in design view. Now I can't get the conditional formatting to work. A Query would be...

namliam, I have created a query with the Fields, Last Name, First Name, Course Description, Date Passed, Valid and Retake. When I run it I just get one row with no entries in it. The Date Passed field is Date/Time, the Valid field is Text and I entered the formula...

I'm very sorry if this is boring you namliam, but as I said, I've only just started using Access. All I need to know is, where do I enter the formula:- dateadd("yyyy",[years valid],[Taken]) ? Thanks and sorry kevmc

Sorry about the delay, working away. The tables are already joined. Is that a formula that needs entering somewhere, if so where. Thanks for your help. kevmc

Sorry about that. The database contains 3 tables, Employees, Courses and Courses Attended. The sub form contains the fields, Emp ID, Emp Name Last, First, Course ID, Course Description, Units and Date. I need to flag up when a course is due to be retaken. I hope this is enough info, if not...

Is there any way I can flag individual records so it shows when a course needs to be retaken? I have only found a way that will format all records. I need idividual records for each individual. Thanks for your help, kevmc :confused:

As I am limited in my knowledge of Access, could you tell me how to combat these problems. Can you only append from one table to another, one at a time or should all corresponding records be appended to all tables Thanks for your help kevmc :confused:

Sorry about the delay in replying - I've been away. The problem I'm having is, when I click cancel on the dialog box, the image box disappears too. Also if I insert a photo into the image box then type in 'none', I get a message 'can't open file 'none''. As I said, I only have a basic...