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!
-
Type Mis Match
It is difficult to tell from here but how are rstObj and curKey defined..... for example dim rstObj as recordset dim curKey as string- wjmsm
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Ruturning a Value from a Function in a Module
normally to get a function to return a value you specify the function signature as follows Function myFunction(passedParm as string) as String ' The as String after the closing parens denotes the type of data returned by the function and the fact that the function returns something End Function- wjmsm
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
"Too few parameters. Expected 1" :(
Remove the semi-colon ";" from the end of your assignment statement so that SqlStr = "SELECT Main.Name, Main.Date, Main.Action FROM Main WHERE (((Main.Name)=[forms]![Switchboard]![cobName]) AND ((Main.Date)=Date()))"- wjmsm
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
