Recent content by jxwd

Ahh yes prefect this looks like the right kind of thing!... I have the ACCDE file... But haven't seen the accdb ... One is complied from the other?

Hiya the "transfer functions" are between the Access databases. I am trying to remove the derived database, and use the first database directly... but in order to do so I need to better understand the relationship between the two...

It has customer logins... but I could share it one of them (the smaller derived one there are transfers both ways) privately if that is possible?

where would I find the VBA code if it exists?

Hi The "Transfer Functions" were mentioned in passing by the previous engineer... who has retired... this is literally all I know... But I do have a copy of the company system on my PC.

Hi I have inherited a system which I am converting from Access to SQL. The customer has 2 access databases. The second is derived from the first, using "Transfer Functions"... I would like to see the functions to understand the relationship. Can someone point me in the right direction? I have...

Success this ran, I think 'm' not months, or mm and with the single quotes... : SELECT TOP 10 *,DateAdd('m',-2,now()) AS NextCal FROM TblCalibItems; Thank you all :-)

And it definitely knows DateAdd as it doesn't complain that it's not defined... feels so near but so far! :-)

Sorry confusion with ODBC != qodbc... gotcha... I did find this that suggested it's doable with ODBC https://bytes.com/topic/asp-classic/answers/57197-dateadd-sql-statement-not-working

No but, I am working toward NextCal as the sort order too IE SELECT DateAdd(\"month\", NoOfMonths, DateOfCal) AS NextCal ORDER BY NextCal; NoOfMonths could be 1 or 120...

It needs to be sorted by the calculated result. So I will need to run ksort / asort after this... and TblCalibItems has a lot of records... IE SELECT DateAdd(\"m\", NoOfMonths, DateValue(DateOfCal)) NoOfMonths is an integer variable...

I wish! :) it's not practice as the company has many inhouse systems still using access... the only sticking issues is this one! and as the article suggests is should work... !

NB this is a temporary solution... The next phase is to remove Access... and replace with mySQL

yes I can get access to the backend if I need... but I have never used it.

It is from what I can read see here: https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2638/0/qodbc-desktop-troubleshooting---how-to-use-date-and-dateadd-function-in-qodbc The issue seems to be the ODBC date format. Unfortunately it needs to be sorted by the new...