Oh, I did not know about this. I changed the module name to Module1 and left the function name as it is00 'PG'. Saved it and ran the function but still get the same error message. :-(
First time I get this error message. Next time when I click "!" on the ribbon to run the query, a line appear on the bottom saying "The action or event has been blocked by disabled mode."
I am utterly confused......
blackdogharry
Last Activity: Oct 10 '07, 03:21 PM
Joined: Oct 5 '07
Location:
-
The SQL view of the query is as follows:
SELECT BATCH.B_id, PG([B_status]) AS Batch_Progress FROM BATCH;
This is the same as typing in "field" in the Design View I believe...
Batch_Progress: PG([B_status])
I tried modifying SQL to
SELECT PG([B_status]) AS Batch_Progress
FROM BATCH;
But no success.
I also found the following help in MS web page. It says...Leave a comment:
-
Thanks for the reply. But the change does not solve the problem.
I also tried As Integer instead of As String because the PG output is supposed to me numbers that I will need to do some further calculation later on.
I also looked up the tools-reference in the VB editor to see if any library appears missing but could find none...
Could anyone please give me some advice on how to proceed?
Thanksin advanc...Leave a comment:
-
"Undefined function '--' in expression" Error message
Hi,
I am a novice VBA user.
My access version is 2007 on Windows XP PC.
I need to create a query that will take pre-existing text values of the B_status field (such as "Received_Email ed", "Processed" etc.) and return the numeric value depending on the value of the B_status value.
So I would get 2 in the new field if the value of B_status is "Received_Email ed" and so...
No activity results to display
Leave a comment: