Search results for query: *

Hi Tony Thanks for your reply and your help. I'd would want them sent as an attachment but not saved once they had been sent. Hope that makes sense. Best Wishes Angie

I would like to be able to send all open Word documents to an Outlook email. Any help would be appreciated. Thank you.

I'm trying to send a record from MS Access to a Word Document and open the Word document from MS Access. Could anybody point me in the right direction. Best Wishes Angie

Hi Thank you both for your help. That's brilliant. Best Wishes Angie

Hi Thank you for all your help. Here is the coding I have used: SELECT tbl_schools.YP_unique_identifier, Max(tbl_schools.School_start_date) AS MaxOfSchool_start_date, Max(tbl_schools.School_name) AS MaxOfSchool_name FROM tbl_schools GROUP BY tbl_schools.YP_unique_identifier; Many thanks Angie

Hi Yes you're quite right my coding does look exactly like that. What I get when I run the query is for instance if I had a Person ID of 678 and I had two entries against it ie 01/07/07 Heath School 10/10/07 Special School I seem to be getting something like 10/10/07 with Heath...

Hi I have a table which I need to find the latest entry date for each record where there are multiple entries for some of the people in the database. I'm using a query but it doesn't seem to be working correctly. The fields are: Unique Person ID Name of School Attending Start Date of...

Thank you for all your help. That's brilliant. Best Wishes

I'm fine thanks. I'll try it and let you know the results. Many thanks for your help.

Hi Thank you for your reply. Here is code I'm using Private Sub Combo15_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Name] = '" & Me![Combo15] & "'" Me.Bookmark = rs.Bookmark End Sub It's the line...

Hi I've created a combo box to search on a form which works fine. However, some of the names in the drop down list have apostrophies ie O'Conner which when selected comes up with a run time error. I don't know how to overcome this error and would be grateful for any help. Many thanks.

Hi I'm trying to put multi data into a single field to enable me to search on more than one criteria. In other words, I would like to be able to pick from a number of items but be able to select more than one item stored in a single field. Many thanks.

I've recently got a new laptop which is running on Windows XP. I need to install the driver for Visual FoxPro but unfortunately I've search and Microsoft site and can't find it. Has anybody else had the same problem and managed to locate this particular driver. I can find the drivers for...

Thank you for your help. That's an absolutely brilliant place to start. Didn't realise the link was available. Many thanks. Angie

I'm trying to put information into a Word template and link the information fields with Access ie type information into Word fields and then for the information to be stored in Access fields within the database. Anybody done a similar thing or got any tips please?