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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Updating Name on Subform
........................................................... assumptions : When at the participant form the Contact form is still open and that is where you want to get the father-mother info from! If no Father surname is present the field will be null as opossed to " " I have not...- GROG600
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
IIF in Query Criteria
thanks so much for your help.- GROG600
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
IIF in Query Criteria
based upon selection from a form, I would like to vary the selection criteria in a query. for example query field expr1, crieria : IIF([forms]![frm1]![option1]= true, "<45", "=45") This doesn't work, any suggestions? PS I know how to do it building an SQL statement in...- GROG600
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Renaming table Tip
Yes thats how I do it, however, you can also use an addin like Find and replace (www.Rickworld.com) shareware. absoloutly brilliant little add-in- GROG600
- Post #2
- Forum: Microsoft: Access Other topics
