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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
date as number formula
Do any of you remember the formula to convert a date to its corresponding number wherein that number starts at 1/1/1900 (maybe it's 12/31/1899) with 1 and increases by 1 each day until whatever date you use as the maximum? For example 12/31/1901 would be 830? (or there abouts...I still need a...- spiceAlex
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Return contents of a control in an Access form
All I need to do is declare a variable that returns the contents of a field on my Access form. For example's sake, my variable name is myVar, the database is MyDB, the form is MyForm, and the control is MyControl. Thanks- spiceAlex
- Thread
- Replies: 10
- Forum: Microsoft: Access Forms
-
VB/Access Form question
I'm using the where clause in the openForm method to find the phone number associated with my form. It all works fine. If the phone number is not found, a blank form comes up which is fine, but I'd like to also to have a msg box appear saying, "No contact found." I don't know how to search the...- spiceAlex
- Thread
- Replies: 7
- Forum: Microsoft: Access Forms
