By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,685 Members | 1,031 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,685 IT Pros & Developers. It's quick & easy.

Installed new office - functions work in vba but format of it different in access que

P: 3
I installed office 365 on a new pc. My MS Access applications now have issues with functions built-in queries. The same functions work perfectly in the VBA code but not in queries.

Example: The hints provided by access in VBA versus the query looks as follows for the format function:


Expand|Select|Wrap|Line Numbers
  1. format(Expression, [Format], [FirstDayOfWeek As VbDayOfWeek = vbSunday], [FirstWeekOfYear As VbFirstWeekOfYear = vbFirstJan1])
In a query:

Expand|Select|Wrap|Line Numbers
  1. format(expression [format] [firstdayofweek] [firstdayofyear])
Note that there are only spaces between the options and not commas as would normally be (for the query). The function then does not work. Trying to complete the function gives the error: The expression you entered contains invalid syntax. You have entered an operand without an operator.

I know I had this same issue previously with a new install on a new machine but cannot remember where I found the solution. Any ideas, please?

May 31 '19 #1

✓ answered by NJelcheck

SOLVED - Was a separator not set in regional settings.

Share this Question
Share on Google+
2 Replies

P: 3
From trying to find solutions on the web, it seems that references might be the issue? The VBA code however works. What references do the MS Access queries use? Is there not possibly an error there that I can try to resolve?
May 31 '19 #2

P: 3
SOLVED - Was a separator not set in regional settings.
May 31 '19 #3

Post your reply

Sign in to post your reply or Sign up for a free account.