No announcements
Found 2729015 threads
-
0 VotesUndefined function 'GETDATE' in expression (Ms access connection)
Hi , I am using an Ms access database , with this Function I whant to get dates which happened to day, But I ...Answered | 4 Replies | 1265 Views | Created by Bajtitou - Monday, February 25, 2019 8:23 AM | Last reply by Bajtitou - Monday, February 25, 2019 5:38 PM
-
0 Votes
Error massage : undefined function 'Dcount' in expression - in ms access
, it worked correctly, but if I test in Access 2013 web app, and I got the error “The expression you entered has a function name that Microsoft ...Proposed | 2 Replies | 1198 Views | Created by Wenkket - Friday, August 21, 2015 3:57 PM | Last reply by Edward8520 - Monday, August 24, 2015 2:46 AM -
0 Votes
Undefined Function in Expression
what is causing the "Undefined function 'Depreciation' in expression" error. Hopefully, someone can point me in the ...Answered | 6 Replies | 1234 Views | Created by Robert Valentine - Monday, August 3, 2015 4:16 AM | Last reply by Paul P Clement IV - Monday, August 3, 2015 1:11 PM -
1 Votes
Undefined function Date in expression
I have an error in this expression under Access 2016 which worked fine in Access 2007 Assign ...Answered | 2 Replies | 9077 Views | Created by Joreli - Tuesday, August 2, 2016 11:44 PM | Last reply by Chenchen Li - Wednesday, August 3, 2016 6:22 AM -
0 Votes
Undefined function 'Replace' in expression
Hi I am using an OleDbCommand against Access to run an INSERT query with Replace function in it and I am getting an 'Undefined function ...Answered | 1 Replies | 879 Views | Created by Y a h y a - Saturday, November 17, 2018 4:25 AM | Last reply by Tom van Stiphout (MVP) - Saturday, November 17, 2018 4:27 PM -
0 Votes
Access 2007 undefined function 'nz' in expression
getting an error "undefined function 'nz' in expression". When you launch my app and click a couple buttons all is fine. Then click one ...Answered | 2 Replies | 3246 Views | Created by Joe A - Friday, December 9, 2016 5:59 AM | Last reply by Banyon Data - Thursday, June 28, 2018 3:49 PM -
0 Votes
Undefined Function 'Replace' in Expression
([Material], 'IDA', 'Singtel') from [DataHistory]" However faced this error 'Undefined Function 'Replace' in Expression' Please advise how ...Unanswered | 1 Replies | 5278 Views | Created by Tj Tay - Tuesday, July 26, 2011 2:11 AM | Last reply by Rod Gill - Tuesday, July 26, 2011 3:37 AM -
0 Votes
Undefined function 'FileLen' in expression
Undefined function 'FileLen' in expression I checked the references by going to the VB window tools>references. ...Answered | 4 Replies | 1107 Views | Created by Andichamy GA - Tuesday, October 28, 2014 1:18 PM | Last reply by Dirk Goldgar - Tuesday, October 28, 2014 9:07 PM -
1 Votes
Undefined function in expression
Give us a look at your expression! MonthName is a VBA function, so it should be "found" in desktop apps. peter n roth - ...Answered | 11 Replies | 6140 Views | Created by Y a h y a - Friday, April 22, 2016 7:12 AM | Last reply by Edward8520 - Wednesday, April 27, 2016 1:56 AM -
1 Votes
undefined function left in expression
I have a Access db where I import queries from another Access db, One query is giving me the error Undefined function "Left" ...Answered | 6 Replies | 8630 Views | Created by RSNoobie - Tuesday, April 5, 2011 2:47 PM | Last reply by RSNoobie - Tuesday, April 5, 2011 5:34 PM -
1 Votes
"Undefined function 'Format' in expression"
in it that call the Format function, do they work or do they give the same error? Dirk Goldgar, MS Access ...Answered | 5 Replies | 13610 Views | Created by jazcatMS - Thursday, June 21, 2012 4:22 PM | Last reply by accessbob-pdx - Thursday, June 21, 2012 10:46 PM -
0 Votes
Undefined function 'left' in expression (Windows 10/Access 2016)
Undefined function "left" in expression, you could also try to uncheck the ...Proposed | 5 Replies | 6482 Views | Created by Cheryl2.0 - Thursday, September 21, 2017 4:26 PM | Last reply by TR Boston - Friday, May 24, 2019 7:36 PM -
0 Votes
Undefined function 'Hex' in expression
numbers as string. When I want to run the query the system tells that: Undefined function 'Hex' in ...Proposed | 18 Replies | 410 Views | Created by plajos1 - Friday, March 23, 2018 8:02 AM | Last reply by Paul P Clement IV - Wednesday, March 28, 2018 3:14 PM -
0 Votes
Undefined function "format" in expression
Daniel Pineault, 2010-2018 Microsoft MVP Professional Support: http://www.cardaconsultants.com MS Access Tips and Code Samples: ...Unanswered | 1 Replies | 400 Views | Created by Dinesh S. Guleria - Thursday, June 6, 2019 9:04 AM | Last reply by Daniel Pineault (MVP) - Thursday, June 6, 2019 9:44 AM -
1 Votes
Undefined function 'Format' in expression
the VB Editor to check. Incidentally, there's no need to use CStr in conjunction with Format: the Format function returns a string, so ...Answered | 12 Replies | 7885 Views | Created by Vinicius Allil - Monday, April 4, 2011 2:30 PM | Last reply by Douglas J Steele, MVP - Wednesday, April 6, 2011 1:41 PM -
0 Votes
getdate function
Hi, In Access when declaring a new date field it is possible to set the default date value using =Date(). In SQL ...Answered | 2 Replies | 5494 Views | Created by Andrew Mercer - Tuesday, January 6, 2009 10:57 AM | Last reply by Andrew Mercer - Tuesday, January 6, 2009 3:33 PM -
1 Votes
getdate function
I would like to return todays date using the getdate function, the date should be returned in the following format: dd/mm/yyyy any help is most ...Answered | 3 Replies | 4448 Views | Created by Cire1507 - Sunday, March 28, 2010 6:38 PM | Last reply by Dave Ballantyne - Sunday, March 28, 2010 6:59 PM -
0 Votes
Undefined function in expression, patch needed
Undefined function in expression' error on a brand new pc. A while back I had the same error on another new pc and it tuned out that a VBAAnswered | 7 Replies | 2241 Views | Created by Y a h y a - Thursday, March 22, 2012 6:55 AM | Last reply by Y a h y a - Thursday, March 22, 2012 10:15 AM -
0 Votes
Undefined function 'Trim' in expression. HELP
error occurs everywhere the "Trim" function appears? Help would be appreciated. Hope it's a simple fix as I use this function ...Answered | 4 Replies | 4392 Views | Created by Dick Patton - Wednesday, September 17, 2014 12:53 AM | Last reply by Mark18991230 - Wednesday, September 17, 2014 8:10 PM -
0 Votes
GETDATE Function
Getdate() and Now() will indeed only give you the current date. If you want to get the datepart from a date in a column you can use datepart() and concatenate ...Unanswered | 4 Replies | 13618 Views | Created by brianm888 - Tuesday, March 8, 2011 3:33 PM | Last reply by Saqib Ansari - Friday, March 18, 2011 7:53 AM - Items 1 to 20 of 2729015 Next ›
No announcements
