Go Back   Computer Forums > General Computing > Hardware
Click Here to Login
Join Computer forums Today

Thread Tools Search this Thread Display Modes
Old 02-22-2006, 02:06 PM   #1
Baseband Member
Join Date: Jun 2004
Posts: 26
Default Microsoft Access plz help!

I am creating a database and wish to use a default time while using a lookup list for a table.

I have the times i entered using the lookup wizard 09:00, 09:30, 10:00, 10:30 upto 22:00, but when i try to enter 09:00 as the default value, it says it is invalid syntax.... what should i enter to get that as default time or is there any other way to get round this??

cheers Jon

jonworth is offline   Reply With Quote
Old 02-22-2006, 04:45 PM   #2
Golden Master
joxley1990's Avatar
Join Date: Oct 2005
Posts: 7,846
Send a message via AIM to joxley1990 Send a message via MSN to joxley1990
Default Re: Microsoft Access plz help!

I think...go into the Design view, and change the syntax to "auto" - then select time - not 100% so back your file up first.
joxley1990 is offline   Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

All times are GMT -5. The time now is 05:20 PM.

Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0