Search results

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...

The front end is PHP. Because the IT company installed odbc drivers to interface with ACCESS... is there another way?

Connecting to MS Access, with ODBC driver. System Windows NT PICWEB01 6.3 build 9600 (Windows Server 2012 R2 Standard Edition) i586 odbc ODBC Support enabled Active Persistent Links 0 Active Links 0 ODBC library Win32 ODBCVER 0x0350 Directive Local Value Master Value...

And with " [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. SELECT DATEADD ("day", -2, "{d '2022-02-02'}") AS NextCalibration FROM TblCalibItems;

Seems there is an issue with ODBC date format and DATEADD https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2638/0/qodbc-desktop-troubleshooting---how-to-use-date-and-dateadd-function-in-qodbc I tried: [Microsoft][ODBC Microsoft Access Driver] Too few parameters...

Tried to declare the function (as a query) [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. It doesn't seem to like dateadd? [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. SELECT...