Recent content by George Bowyer

Thanks. This is what I used. Might not be the most efficient, but it worked: strEmail = rs1!fldEMail1 strFullEmail = strEmail & "#Mailto:" & strEmail & "#" rs1.Edit rs1!fldEMail1 = strFullEmail rs1.Update

I have imported a table of contacts from an Excel spreadsheet into a "temporary import" table in my database. That all went fine. I then ran an append query to add the records in my "temporary import" table into my contacts table. The import table has email addresses in a "short text" field...

Yep, that's done it. Thanks. "Switch" is a new function to me At the moment my switch function has 10 clauses. Can I use a range of some sort to shorten it? eg: switch([fldscore] = 1 to 3, "A", etc.

I have records in a table which have a "Score field", with a score from 1 - 10. I want to run a report from a select query that groups the records as Scores 1-3, 4-7 and 8-10. Is this possible - and do I do it through the query or the report grouping? Or do I have to have three queries? Many...

I am using a report to print tickets for clients. Each client gets seven tickets, which I am printing on a "business card" avery set-up which has 10 "cards" per sheet in a 2 across / 5 down format. Ideally, I would like to force a page break after each group of seven, so that the whole sheet...

Presuming that you use a form in the database to send the information to the mailmerge, put a list box on your form in which to select the relevent plan and use that list box as the criteria in the "PlanID" (or whatever) field in your query. Your query will then only return records with the...

Got there in the end: Set rs = Forms.MainForm![subform2].Form.RecordsetClone Of course, now it seems so damned obvious... :rolleyes:

Nope. It just comes up "Object required".

I have a form with two subforms. Pick a record in the form and subform1 shows some options. Pick one of those and subform2 shows more options, or sometimes none. I want to create a button that does different things dependent on whether there are any records in subform2. How can I reference...

Hello, I use the following code to open a mailmerge from Access to word: CreateMergeLetter "C:\Documents and Settings\Compaq_Owner\Application Data\Microsoft\Templates\MarkMerge.dot" This is the CreateMergeLetter Routine: Public Sub CreateMergeLetter(strTemplate As String) On Error GoTo...

Hi, I'm looking for this. Where did you find it? Regards, George

I was about to submit the same question and found this on a search. Very useful. Thanks

Yep, that did it. Thank you.

I have a form on which I change or enter tasks in an underlying table. On the form I have a list box [lstTasks] which displays all of the tasks in the table. When I enter or edit a task, I have a button to click which requeries the list box. I want to be able to double click the list box to...

I have a contacts database where each contact has a memo field in which I record details of letters ent, phone calls made etc in this format: # 01/02/05 Letter sent re XYZ # 28/01/5 Telephoned at 13.26 re ABC # 15/01/05 Letter sent re PQR etc. Every now and then, I mailshot selected contacts...