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 drewkeller
-
Sort an alpha prefixed field numerically, then concatenate records
Steve, Thanks for the reply. I'm not sure how InStr() would help me. I thought perhaps something along the lines of this logic would work (nested IIf() could do the similar but less flexible): i=0 While IsNumeric(Right(teststr,i+1)) Inc(i) The prefix portion in practical use is up to 4...- drewkeller
- Post #3
- Forum: Microsoft: Access Reports
-
Sort an alpha prefixed field numerically, then concatenate records
I've done a bit of searching and can't find anything that matches what I need to do. One table is a list of parent assemblies, a second table are the BOMs for the assemblies, and a third table shows the reference designators for each component in the BOM. I ask for the parent assembly number and...- drewkeller
- Thread
- Replies: 3
- Forum: Microsoft: Access Reports
-
Access and Outlook integration
Andy i sent you an email earlier but i'm getting some errors back. my email is drew@drewkeller.com thanks.- drewkeller
- Post #4
- Forum: Microsoft: Access Other topics
-
Access and Outlook integration
I think this is possible but it would be nice to have an example to work from... We are going to keep Engineering Change Orders (ECO) in a database on the server to track changes in how a product is manufactured. When an ECO is proposed, it has to be signed off by several people before the...- drewkeller
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
