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!
-
udf params from Expression Builder
I have a select query with a user-defined function field. The function takes required args, some of which are fields in the query, plus some that I don't want in the query. (The query is 1/2 of a union query, and I don't want to have to pad the other select query with fields it doesn't need.) I...- clinresys
- Thread
- Replies: 0
- Forum: Microsoft: Access Queries and JET SQL
-
Unique Identifier - roll yer own
'Check help topic "Quotation Marks in Strings" 'strings in strings are a pain in domain aggr functions Private Function strUnique() As String 'concatenates unique integer with a default string 'to create a unique identifier 'example uses "_default" for default string...- clinresys
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
using form to set defaultvalue property in another form
My plan is to expose only certain fields to the end user of an mde for setting default values (no design views allowed)at the form level. Textboxes in the form to be used to set defaultvalue in the target form have their own defaultvalue set to the defaultvalue of the target form with an...- clinresys
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
