Sorry for the double post but i recieved no responses earlier and am running short on ideas.
I have recently spent countless hours building, tweaking, and perfecting numerous forms and they all are working fine now and i'm nearly done...now all i have to do is put them as Web Data Pages, put on server and our networked database in in place. However, as a went to save my Form as a Data Page...i recieved an error.
"Microsoft...
believeinblue44
Last Activity: Jul 27 '07, 07:33 PM
Joined: Jun 15 '07
Location:
-
Unable to create Data Access Page??
-
Unable to create Data Page
I have recently spent countless hours building, tweaking, and perfecting numerous forms and they all are working fine now and i'm nearly done...now all i have to do is put them as Web Data Pages, put on server and our networked database in in place. However, as a went to save my Form as a Data Page...i recieved an error.
"Microsoft office access is unable to create the data access page"
"The file does not exist,... -
Thank you, that removed my 3070 error. Now i'm recieving errors on my report but...i think that may be related to the filter itself. -
Thank you! My error's gone, i'm getting calculation errors but i can handle those i'm sure. Thanks for staying with me on thatLeave a comment:
-
Ha ha...well thanks for the help, thought it was going to work but i still got the exact same error: Not accepting x or y as fields or expressions. I have a feeling it isnt in the code but rather access not wanting to read variables.Leave a comment:
-
EDIT: I tried your above post with shortening the inputbox code and same error occured...Leave a comment:
-
I'm not entirely sure what you mean by that? I can use the x and y values in other expressions (i did that to make sure my input box was reading the values i type in).Leave a comment:
-
I've tried all different ways of putting x as a val, using val of the string and all return the exact same error. I just attempted your idea of x = Val( etc.) and it again returned that x isn't a valid field or expression
I dont understand it because when i just enter values like 20 and 30 instead of x and y it comprehends and runs the where expression, how is x=Val any different than just a typed in constant numberLeave a comment:
-
Input Boxes not valid for Where Expressions?
I'm new to VB and attempting something (seemingly very very basic by normal standards) and I can not seem to get my Where expression to read values from my inputbox. This is what i have and i am recieving an error sayings "The Microsoft Jet Database engine does not recognize 'x' as a valid field name or expression"
Dim x As Integer
Dim y As Integer
strFirstvalue = InputBox("Enter Starting Value",... -
Sorry for a slow response but i just returned from a short trip to Mexico and finally catching back up with other tasks. But...I'm still recieving an error stating
"Run-Time Error 3070"
"The Microsoft Jet Database Engine does not recognize 'x' as a valid field name or expression".
Perhaps with it linking to access, access does not read variables as values but rather i need to put x,y into a table...Leave a comment:
-
Where expression not reading Inputbox?
I'm new to VB and attempting something (seemingly very very basic by normal standards) and I can not seem to get my Where expression to read values from my inputbox. This is what i have and i am recieving an error sayings "The Microsoft Jet Database engine does not recognize 'x' as a valid field name or expression"
Dim x As Integer
Dim y As Integer
strFirstvalue = InputBox("Enter...
No activity results to display
Leave a comment: