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!
-
Problem converting date stored as text to data/time format
I have a problem converting text to a real date value so I can do some calculations. I have a query that brings in data from an external data source. It appears the data is stored in the external table in text format and looks like this: 20050902 15:40:41 I have tried CDate to convert the text...- gddrew
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
Protecting/unprotecting form...going the next step
I have read other messages here and have learned how to create a button and use it to protect and unprotect a form. Use the following code for the form's On Load event: With Me .AllowAdditions = False .AllowDeletions = False .AllowEdits = False End With Create a...- gddrew
- Thread
- Replies: 13
- Forum: Microsoft: Access Forms
-
Combining records for mailing labels
I am new to Access and programming in general. I hope someone can answer my question regarding combining two or m ore records into a single mailing label. I maintain a membership database. In this database there can be a separate record for two individuals who live at the same home address...- gddrew
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
