Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saidev
Posting Yak Master
101 Posts |
 Posted - 2006-09-20 : 12:02:49
|
| Hi Guys,I have a field called Time in one of the Table, In the Design Property if i just mention this fields i am getting the start time from 12 AM. I want to get the Start Time from 6 AM . Can you guys help me how to do this. Appreciate your helpThanks |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-09-20 : 12:17:23
|
| Could you possibly explain this a little clearer? When you "mention" a field, you get a start ime of 12 AM? But you want start time of 6 AM? None of that makes any sense whatsoever. When I mention what time I'd like to leave work today, I'd like to get 2:00 PM, but unfortunately I keep getting back 5PM.- Jeff |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
|
|
saidev
Posting Yak Master
101 Posts |
Posted - 2006-09-20 : 13:07:11
|
| Ok Guys,In the Access Design Form there is a field called Time. By Default it starts from 12 AM. What i want is to start from 6 AM. Is it clear now or do you need more info.?THanks, |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-09-20 : 13:58:06
|
| I still have no idea what you are asking. You have a textbox on the form called Time and it has a default value of 12:00 AM? Then just change the default value property to 6:00 AM.- Jeff |
|
|
|
saidev
Posting Yak Master
101 Posts |
Posted - 2006-09-20 : 14:25:00
|
| Hi,For that text box the Control Source is coming from the Table which is Time. That time by default starts from 12 AM. I want that time to start from 6 AM. Is this clear..?Thanks,Vamsi |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2006-09-20 : 14:47:07
|
| Can you change the values in your source table to reflect the times you want?Be One with the OptimizerTG |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-09-20 : 15:02:35
|
| To change the default value for a column in your table to 6:00 PM, just edit the table and change the default value for that column to be .... 6:00 PM. Does this make sense? (thanks for being so patient with me, you are explaining everything very clearly in perfect detail I must just be a little slow I guess.)- Jeff |
|
|
|
|
|
|
|
|
Start Time Issue