|
| |
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
 |
TextBox: Datatype - 9/29/2005 21:14:30
My data is like that:
I open the "Input" form
there 2 textboxes
search1 => Field name from Table
value1 => value from the table depend on search1 name
it is a filter.
And, this form has "Input_sub" form, because I want to do filter.
// this case is work well
Case1:
search1: Vendor Name
value1: Amy
//Do Again
search1: Date
value1: 8/31/2005
//Do Again
search1: Vendor Name
value1: Jimmy
...
// This case is Not OK, has error
// this one is OK
search1: Date
value1: 8/31/2005
// Do Again, Error come out
search1: Vendor Name
value1: Amy
//Error message appear
"The value you entered isn't valid for this field, For Example, you may have entered text in a numeric field or a number that is larger than the Fieldsize setting permits"
Please give me the direction to solve this problem. I tried many ways, it still be there. I ever change the Datatype of date to be Text of the "Input" Table, then it works, but I want to use datatype of Date to be Date/Time.
Please help.
Thanks. Thanks a lot.
|
|
|
|
BeTheBall
Posts: 6385
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: TextBox: Datatype - 9/29/2005 23:36:33
What does your code look like?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
|
RE: TextBox: Datatype - 9/30/2005 15:46:56
Actually, I upload mdb file. Then you can see. This forum don't allow to upload it. Because I did Not post the message too many. Thanks.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 
