Connecting Tech Pros Worldwide Help | Site Map

Access 2003-DTPicker

Member
 
Join Date: Feb 2007
Posts: 41
#1: Feb 26 '07
Hi Everyone,
I am using Access 2003 to design a DB. I had a DTPicker data type to get the date from a user but I recently converted it to a text box. However now when I try to call the new date from the text box it throws an error. Do I need to specify the new date as a long type or can i still use the Date type. Thanks in advance.
-Todd
NeoPa's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 15,691
#2: Feb 27 '07

re: Access 2003-DTPicker


Sorry Todd but I'm not following your question.
What do you mean when you say :
Quote:

Originally Posted by ToddW607

... when I try to call the new date from the text box...

I can't make any sense of that :(
Member
 
Join Date: Feb 2007
Posts: 41
#3: Feb 27 '07

re: Access 2003-DTPicker


Quote:

Originally Posted by NeoPa

Sorry Todd but I'm not following your question.
What do you mean when you say :

I can't make any sense of that :(

Sorry, I meant the date entered from the text box
NeoPa's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 15,691
#4: Feb 27 '07

re: Access 2003-DTPicker


Quote:

Originally Posted by toddw607

Sorry, I meant the date entered from the text box

But '... when I try to call the date entered from the text box...' makes no more sense than '... when I try to call the new date from the text box...' did.
Does it make any sense to you if you read it back to yourself?
I don't think this is just me being thick.
Rabbit's Avatar
Expert
 
Join Date: Jan 2007
Location: California
Posts: 3,835
#5: Feb 27 '07

re: Access 2003-DTPicker


What's DTPicker? I've never heard of this.
NeoPa's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 15,691
#6: Feb 27 '07

re: Access 2003-DTPicker


I've only heard of it on here but, from what I can gather it's a Date/Time Picker - a sort of calendar control that lets you select a date.
Member
 
Join Date: Feb 2007
Posts: 41
#7: Feb 28 '07

re: Access 2003-DTPicker


Quote:

Originally Posted by NeoPa

I've only heard of it on here but, from what I can gather it's a Date/Time Picker - a sort of calendar control that lets you select a date.

The DTPicker is an ActiveX control letting you select a date from a list. i just went ahead and wrote a seperate program running off a command button to select and display a date. Thanks anyway.
Reply