Recent content by Mark Drayton

Hi, I'm trying to update a table from an Update Query. In summary, I want the user to enter the full manager's name and an Expression to populate a separate field with their first name. I have managed to separate the first name, but am having problems in getting it to update the table. This...

Thanks neileg. I wanted to get the first name from a full name string and you put me on the right path. For example: John Smith (Full Name str) wanted to just get the First name .... hey presto... Left([Full Name str],InStr([Full Name Str]," ")) :) Ta Mark

Hi I'm trying to edit a record within a table based on a selection made from a combo box on a form. What I'm trying to do..... In Form 1: a) From a combo box select a home name b) Click on a command button to edit details relating to that home within another form, Form 2. In Form 2: a) Amend...

Thanks Mile-O-Phile, I'll try that. The reason I want to a form is to provide the 'user' with a front end for the reports - make it look sexy ;) or something like that! Ta Mark

Hi, This is another easy one, as long as you know what your doing! I want to use a form with: Date options ie between date 1 & date 2 Status options ie an issue is either open, closed or pended Assigned to option ie a person's name ... to drive what is shown on a report. I realise that the...

Thanks Kodo - it worked a treat! :) Many Thanks Mark

Hello! I've searched on previous date questions but to no avail - so here goes... I'm creating a issue/question logging Db with "Issue raised by" & "Issue Answered by" fields. I have set up a Combo Box on the "Issue Answered by" field listing names of people. When a name is selected I would...