Search results

I finally managed to get some time on this (I'm moving across to a Cognos TM1 developer role) and get this working using ADO parameters... Took some inspiration from the following thread.. http://www.access-programmers.co.uk/forums/showthread.php?t=219149 Seems to work quite well.. although...

Worked... thanks

Will give that a try but thought JET uses '*', Whereas SQL Server uses '%' ??

I'm quite confused by this.. I am testing if a sql recordset contains records.. normal stuff.. The WHERE statement is based on input parameters and will insert either 'LIKE' or 'NOT LIKE' condition on the 'Role' field... When copying the built SQL into a query and running, both return a...

Use an array... dim varFolder(2) as string varFolder(0) = "C:\Users\User\Documents\ invoice" varFolder(1) = "C:\Users\User\Documents\cofc" varFolder(2) = "C:\Users\User\Documents\despatch

So i could never get this working without closing the bound form frmProfiles first.. Cheers VBAInet for your help.. I can't upload a copy here as it will be flagged as a security breach.

Filepath length over 250 characters ?

Security related issue ? Is it a trusted document/ location ?

Try .Parent.WindowState = xlMaximized

I tested the code with Office 2003 (don't have 2010 here)... As long as Excel Object Library is added to the list of references, code works fine here. Suggest maybe an install problem.. try another machine..

If you comment out.... .WindowState = xlMaximized

So if you comment that line out the code runs fine ?

That line is not part of the code posted by vbaInet

Why not download the postcode data and then validate against real data..

Have you tested with a blank workbook instead of WorksPrice.xlsx?

Does this help you? http://www.eng-tips.com/viewthread.cfm?qid=19576

Firstly rename the subform control as 'frm_Main_Sub'.. To do this, put the main form in design mode and right click on the subform to go to properties. Set the name of the subform object in the 'Others' tab. To refesh you need some code like this Forms!frm_Main!frmMain_Sub.Requery

This is now fixed... Turns out the code was working, it was an issue with the excel output code.. sorry for wasting your time guys... Marked as solved..

What happens when you run this yourself on a test environment, changing the output paths etc... By "Overnight" are you implying this is a triggered batch job somehow called from a scheduler or is it being run by a user? Does the user/ account running this have permissions to write to the...

Yes its all in the same module so is all in scope... I have stepped through the debugger... Like I say, the parameter pudtOutputRows within mOutputToExcel does not contain any data when loaded.. Here it is.. Public Function gblnProcessData(ByRef pobjConn As ADODB.Connection) As Boolean...