Recent content by wildsyp

I have been adding these manually which is fiddly and time consuming. I need some code which will add the new column onto the end without opening the query and making the change myself. I will be handing this over to non-techy people who won't have a clue about amending queries etc. Thanks Paul

Ha, sorry! Meant to put: Sum(IIf([Tbl_AbsenceMain]![01/11/2014]>0,1,0)) AS InstNov2014 :)

Hi, this is the code: I would like to add Sum(IIf([Tbl_AbsenceMain]![01/10/2014]>0,1,0)) AS InstOct2014 to the end. SELECT Tbl_CostCodes.[Opex Level 1], Tbl_CostCodes.[Opex Level 2], Tbl_CostCodes.[Opex BGX], Tbl_CombinedEmployeeData.LM_Payroll, Tbl_CombinedEmployeeData.LM_Name...

Hi, I am looking for a way to add a calculated field to the end of an existing query using VBA. Is there an easy way to do this? The data I receive from an external supplier shows monthly data split by column with a new column added in each month. I then need to reflect this by adding a new...

The data is made of of several columns of unique identifiers which link to other tables (which I join to other tables in the query), but the data I need to manipulate is made up of 12 separate columns (by month) in the raw table. The structure of the data isn't in the greatest format which...

Hi, I hope somebody can help me. I need to create a query which will dynamically calculate a YTD Total from 12 separate monthly columns based on a month selected by the user on a form. For example, if the user selects August 2013, the query will return the total individual columns from...

Hi, I have a frustrating problem trying to save a record on a form. I basically have two forms, the first is the primary form which is linked into my main table where most of my data is scored. I have a secondary form which the user would use to input data into the first form (I do this...

Kafrin, Worked first time! Thanks for your help. Cheers Paul

Hi, I have a bit of code I use which opens an existing Excel workbook and saves it as another workbook depending on a variable determined from a form. When the workbook is saved, it may or may not already exist. If it doesn't exists it works fine, but if it already exists it asks me if I...

I had a similar problem, but there is no real easy way around it. The Link that pbaldy has posted was one way around it, but had issues with security (I work for a very large blue chip company). In the end I ran the script through a old networked Windows 2000 PC (where this security measure...

Hi, I hope somebody can help me. I have a very simple bit of SQL code I use to append data to a table from within VBA. Everything works fine apart from the date which automatically reverts to a US format if the current date is within the first 12 days of a month (ie 05/01/2009 will change...

This is perfect! Many thanks for your help and time. :) Regards Paul

Hi, I am not sure how difficult this is, but I need to send an e-mail for each record of a query (typically 5-6 records). Is there any way I can loop through each record and send an individual e-mail to each. Each record will have unique information such as invoice number so will need to be...

It all makes sense now. The # around dates has also resolved another niggling issue I have always had as well!

Solved! Thanks for your help. Paul