In my query, I have a function call to get the current fiscal year (getFisYear()). It works in access report. If I publish this date access page on test server it have two errors when I open it.
"Data provider failed while executing a provider command."
"Undefined function 'getFisYear()' in expression".
Do you know how I can define this function in data access page?
Thanks....
leucine
Last Activity: Apr 6 '07, 07:06 PM
Joined: Oct 30 '06
Location:
-
How to make muti records showed in one Data Access Pages
Hi,
I am making the reports using the Data Access Pages Wizard. It only shows one record in one page then goes to the next record by using navigation arrow. Does anyone know how I can change it to show a few records in one page? What property should be modified?
I appreciate if anyone can help me. -
Thank you very much. I know how to write a function to return a value now....Leave a comment:
-
Get a Function call from a query
I have a function wrote in a module that will return fiscal month of our calendar as following.
Function getDueMonth(Due Date As Date)
Dim DueMonth As Integer
Set fd = New clsFiscalDate
fd.SetDate = DueDate
DueMonth = fd.MonthNumber
'Debug.Print DueMonth
End Function
The print value is correct by using Debug.
I want to use this function in... -
Unlock the table
I have a table which do not allow me to modify it. Error message is
"A query or form bound to the table is open, you may not have permission to open this table to design view, or another user has the table open."
I am sure no form is open and no other user is using it. Does anyony know how I can unlock this table?
Thanks -
Update Query
I have two update query as following.
UPDATE Grade SET Grade.Variance = [Plan]-[Actual]
WHERE ([Score]<>0);
UPDATE Grade SET Grade.Variance = 0
WHERE ([Score]=0);
Is that possible that I can merge above two queries into One query to finish the job?
I apprecaite you can help me with this.
No activity results to display
Leave a comment: