Solved

cannot run function in query grid in access query

Posted on 2016-10-26
2
28 Views
Last Modified: 2016-10-26
I wanted to make an isnumeric test but access wont let me and i am not sure why.

in fact if i try to call any function in the grid it fails saying compile error.



am in access 2016

the vb references are here
ref
0
Comment
Question by:PeterBaileyUk
2 Comments
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 41860078
can you use the function in the immediate window?
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 41860242
do a compact and repair and from VBA window do a DEBUG >Compile and correct any error raised.

(post back if you get an error on debug > compile)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now