Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by fishfartus
-
List Box Criteria
Use a query for your list box rather than the actual table. Have the query limit the options by Current (True) or Not Current (False), Use this for all of the options you want to limit by. This should limit the amount of fields the user needs to sort through in their selection. I hope this...- fishfartus
- Post #2
- Forum: Microsoft: Access Forms
-
Convert 6 digit numerical field to short date
Thanks for the help PHV. I was able to use the DateSerial function in an update query, then go to the updated table and change the data properties to "Date" without loosing my data. I have spent 6 hours trying to figure this out, and you helped take care of it in 3 minutes. Way-to-go!!- fishfartus
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Convert 6 digit numerical field to short date
I am importing a text file with a fixed width field 6 characters long. I want to convert this six digit numerical or text field into a date field, but everything I try displays an odd date. The six digits are imported something like "010905", and I want them converted to 01/09/2005, with date...- fishfartus
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
