Search results

Thanks Trevor G I will need a macro to do this, I've included an example of what I need, it works up to the point of copying the Plan name opposite the Number & going over to the 2nd sheet, finding that number & pasting the plan name in an adjacent column. Hi Brian, I thought it would be...

Hi I have a workbook with 2 worksheets, wksht1 & wksht2. 'wksht1' has column "A" which contains numbers (Long) with duplicates. 'wksht2' has the summarised column of numbers from wksht1, no duplicates. I want to select a number in wksht1, find the value (String) that is 10 Columns to...

Thanks mcalex & missingling mcalex, I'm not sure how your solution will work as there's only one field called 'Cost' so to aggregate it, i would need to use 'Sum(Cost)' to sum any value under any record ID to display a total in the unbound text field. I did start with Sum([Cost]) which works...

Thanks msalex I was hoping to use a formula in the unbound text box rather than use vba code. You're correct as to the source of the cost, the user simply types them in & the total automatically increases for that 'Owner'. Do you know if it can be achieved using something like...

Hi I have two fields on a form, one is Owner (Text) & the other is Cost (Currency). Each record will have a Cost value entered & the Unbound Text box should sum these amounts for that Owner as they are entered - There will be a separate Text box for each Owner. Does anyone have any...

Thanks again "Is this the best Access can do for this process?" means I would like to see a drop down list straight ffrom the parameter query which Access can't do. Cheers

Thanks Beetle I think you have answered my question as I had the expectation that I would see a drop down box available from the query prompt itself. Instead, I realise the user will see a report format once they select an option from the form. So what I've done so far is; Created a...

Hi I have read about the need to create a form with an unbound field reading the values available to do this, but does anyone have a working example? The steps I've taken; Create the query Create a form with an unbound field that has the options available as a drop down I leave that form...

Thanks for this Brian, I didn't post the first date/times completely (as you probably guessed) as I was playing around with Text to Columns to split the date from the time. Thanks again, it works well !! Peter

Hi I have 2 spreadsheets in one workbook, one spreadsheet has the date & time in 2 columns in the following format; Worksheet 1 Date Time 31-Dec 11:20 PM ------------------- Worksheet 2 Date Time 31/12/2011 23:20 As you can see, one spreadsheet...

Thanks Paul I thought I'd already tried that but you're right, that was it, Cheers

Hi I'm trying to add a '0' to a phone number field but cannot get my code to work & was wondering why it doesn't. Here's the code; ------------------------------------------------------------------ Sub add_zero() Dim i As Integer Dim j As Integer Dim k As Integer Dim l As...

Hi Again Sorry, I should clarify my answer in case anyone wants to use this. The below loop will create a string of email addresses with an ';' between each. ----------------------------------------------------------------------- With rst Do While Not .EOF...

I discovered that I can use Set outmail = outapp.CreateItem(0) multiple times to open new e-mails, thanks for your help.

Thanks but I've done that, I want to know how to open a second e-mail on top of the first one & add the next 70 recipients. I want to keep the emails open until the user looks at them & sends them on. Currently as I use the below; Set outmail = outapp.CreateItem(0) This creates the first...

Hi I have a database that will send emails through Outlook (Office 2007) based on a queries results. I want to limit the number of recipients to be added to each new email so it doesn't exceed the allowed number. There could be 100s of recipients & I'd like to split them up. Has anyone...

Great, Thanks again

Here's the answer if anyone needs it, Cheers :) Add this function to a module [code] Function CheckQuery(queryName As String) Dim qryLoop As QueryDef Dim dbs As Database Dim exists As String exists = "No" For Each qryLoop In CurrentDb.QueryDefs If qryLoop.Name = queryName Then exists =...

OK, is this what you mean? -------------------------------------------------------------------- Option Explicit Sub mail_merge(print_records_where As String) Dim qdftemp As QueryDef Dim QueryDef As Recordset Dim mail_merge As QueryDef Dim rst As Recordset Dim db As Database Dim wordapp As...

Hi I have some Mail Merge code which works fine, but when I go to run it again, it recognises the query object previously created & errors err no 3012 - object already exists. I want to know how to have the error handler delete the query although sometimes the query would not have been...