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 Chriss Miller 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 skrappySenior
-
Dates Manipulating in Access
The post by Adalger works. This is the kind of help this old lady needs! I added the rounding function as follows: =Round(DateDiff("m",[dob],Now())/12,0) My formula is correct only if you have passed the month of birth in the current year.- skrappySenior
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Dates Manipulating in Access
I am new to Access and VBA. I am learning the old-fashioned way of books with a candle in front of a fireplace....I have read many of the solutions regarding date formating and calculating. For me as a first time user they were too ambigous. I have documented below precise steps that I have...- skrappySenior
- Thread
- Replies: 6
- Forum: Microsoft: Access Modules (VBA Coding)
-
VBA code auto assign value to related fields from several tables
I have one existing table of client and census data,with 119 fields. I am separating into 10 tables tblClient; tblCensusOne....Nine They will all have a one-to-many relationship on the tblClient.clientId & tblCenus(One..Nine).clientId (primary & foreign)field. One to many relationship is...- skrappySenior
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
