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 TouchToneTommy 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 shelibels
-
Input mask not working with lookup
Duane, Thanks for the response. I hope this makes sense... I originally started there, but then got confused trying to create the lookup for the other table. I don't have much experience. I thought I needed an autonumber primary key since I need both the calendar year and pay period to...- shelibels
- Post #6
- Forum: Microsoft: Access Tables and Relationships
-
Input mask not working with lookup
I appreciate both of you responding. I now know not to use input masks. Does anyone have a suggestion on what TO do? The user is going to need to add more calendar years (4 digits) and pay periods (2 digits) as time goes. I was concerned that 200820 would be harder to read than 2008-20...- shelibels
- Post #4
- Forum: Microsoft: Access Tables and Relationships
-
Input mask not working with lookup
Hi. I used an input mask (0000\-00;;_ to separate the year and pay period, i.e. 2008-20) in a field of one table that I'm using as a lookup field in a second table. I included an input mask on the same field in the second table, but when the list drops down in the second table, the input mask...- shelibels
- Thread
- Replies: 6
- Forum: Microsoft: Access Tables and Relationships
