Recent content by CoffeeGuru

Hi cyanidem Trouble is JobRefNo is created at runtime so I can't create a query to include it then. My form - frmtelesales is interactive and used to select the records I want to see and is based on a single unbound box that runs through all my fields to get a list. i.e. I could type in...

Hi and apologies if this is not in the correct area. I have the following built in access macro ExportWithFormatting Object Type Form Object Name My List Output Format Excel Workbook (*.xlsx) Output File Auto Start Yes Template File Encoding Output...

Well how does this work... It works perfectly for my needs 3 days of trial and its 1 line of code Application.FollowHyperlink "D:\MyPath\AnyWordDoc.doc" http://www.access-programmers.co.uk/forums/showthread.php?t=185914

OK So I added in the Microsoft Word 14.0bject Library Saved and closed and reopened my database but I still get the same problem No merged documents.. :confused:

Hi I have a word document that has been set up to pull in a mail merge from Access 2010, this has worked fine for a couple of months now. I now need to get Access to open the word document for me, But all my attempts all fail. When the word doc opens this way it does not include the SQL...

Well that appeared to work...can you shed any light on why!!

Hi Anyone have any idea why I get this message: I am running an Append query which basically looks for records in my OPPORTUNITY table where the EVENT DATE is this month and the STATUS = invoice and INVOICED is False What I want to do is to copy these to my INVOICES table ready for a mail...

Eh..How does that work I just get an error.. UPDATE <Destination table> A INNER JOIN <Source table> B ON A.aaa = B.aaa AND A.bbb = B.bbb AND A.ccc = B.ccc AND A.ddd = B.ddd SET A.aaa = B.aaa AND A.bbb = B.bbb AND A.ccc = B.ccc AND A.ddd = B.ddd This works as an INNER JOIN but if I Just change...

I have been advised that Pass-through stored procedures return read only results. This is why I cannot pivot within Access - really! So I have to put my SP code into a query in order to pivot it into a chart and risk SQL injection. Hmm can this really be right.

Hi I have some code that I need to produce a pivot chart from. This works fine when I have the entire code as a pass through query but as soon as I call the same code as a stored procedure from within SQL server the pivot drop zones become grey out and unusable. Has anyone any ideas why this...

I am attempting to pass a SQL statement from Access to SQL Server The tables are SQL temporary tables and this query should drop then build the table [TopStores] The code appears to run as there are not any errors displayed, however the table is not created The temporary tables which this is...

Whoa! That is an exemplary answer. It goes way beyond what I was asking for but I very much appreciate your time and effort and will certainly look at this. I could then use it in all my reports (even if just for laughs) Martin

Thanks both of you, I just needed the extra missing steps

Hi guys I have some vba that ends with a text box being displayed that says "file created" I would like to add to that text box how long it took. My initial thoughts are to add to the start of the code a variable that stores the current time (stTime) and at the line before the...

Hi ya That is the whole thing I need to amend it (in access) to pick up a user entered variable/parameter from somewhere (possibly a text box) so that it reads Select Top (@Parm) ....... Martin