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 bkrike 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 David27
-
Filter records to be printed
Thank you so much! I changed your suggestion a little and it worked within a couple of minutes. Here is what I did: StrWhere = "[CustomerNum] = " & Me![CustomerNum] DoCmd.OpenReport StrDocName,,, StrWhere Extra commas in DoCmd line are placeholds so StrWhere is recognized. It printed...- David27
- Post #3
- Forum: Microsoft: Access Forms
-
Update Query
I am updating our master client database with new client address information from our UPS shipments on a regular basis. Rather than enter the updates manually I want to merge the info. Duplicating the field structure in both databases is no problem. I want the query to only add a UPS entry to...- David27
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Create unique record id
I am trying to find a way to have Access 2000 create a unique record ID when record is updated based on customer name. ID would consist of first five characters of last name plus first three characters of first name plus middle initial of customer. Example: SMITHBILA. If ID length is less than...- David27
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
