Search results

Mmmm, ok, well for future reference of others... Couldn't get this working, so instead took an approach of setting up a graph object bound to a temporary table of 6 columns (5 series plus the time series for the X axis), and just had my VBA procedure populate the temporary table and set the...

Have a look at the Scripting class made available as part of the Microsoft Scripting control (I'm on 2007 but I hope 2003 is similar, if not identical). There are various methods for navigating file system objects, folders, files and so forth - hopefully none of them constrained to local file...

Not sure whether there is a clever way to do this in a simple update query with functions in them, but (personally) I'd probably do it quicker by just programatically doing it with 2 recordsets, reading from your source table, performing the split function on the field as normal and then...

I think I've about exhausted my Googling on this issue and so am ready to do the inevitable and start a thread! I'm programatically creating a graph on a form in Access 2007 using the msgraph 12.0 control and, in general, it's all working fine. On the form the user selects some criteria and...

Thanks ;) I will try and return the favour and contribute something back to others in the future!

I did a little bit of tidying up and tried it as follows :- SELECT tabHSE.id, tabHSE.title, tabHSE.location, tabHSE.inspectionDate, getReviewDate(tabHSE.inspectionDate,riskFactor*likelyhoodFactor) AS calcReviewDate, tabHSE.type, tabHSE.status, tabHSE.riskFactor, tabHSE.LikelyhoodFactor FROM...

Hi Paul, Function getReviewDate(lastInspectionDate As Date, priority As Integer) As Date ' Rules for calculating the review date based on the last inspection date and the priority ' if pri = 0 then a last inspection date has not been entered, so let's get it done within the next 7 days ' pri...

Hi all, I'm not quite sure how to skin this cat; there are several possible approached mulling over in my head which mean it's hard to narrow it down to a particular area of the forum or a search (I've done some searches on critical keywords but having browsed a few of the umpteen hits, I'm not...