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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access Parameter Query - Public Function Input Help?
Sorry, the parameter query i am actually using does valadation etc... i only used the above code as an example because it creates the same annoying problem... The real module code is below: Option Compare Database Public Function inputPayNo() As String Dim EmpMaster As ADODB.recordset Dim...- Majic
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Access Parameter Query - Public Function Input Help?
I have a query (linked to a single table). I am using a public function to get a value to use as a parameter query... Public Function InputTY() as string Dim ITY as string ITY = inputbox ("enter tax year") InputTY = ITY End Function In the criteria box of the correct field i have...- Majic
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
