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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Error msg NEXT WITHOUT FOR
Ok, I am probably blind (comes with age, I guess) but I can't figure out this error. When the following code is run I get the error msg "Next without For" Set db = CurrentDb() Set rs = db.OpenRecordset(sql, dbOpenSnapshot) If rs.RecordCount > 0 Then For i = 1 To 37 If...- jambet
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Multiple lines of input in calender text box
Thanks, Paul When I inserted your code directly, still only received one job# for each date. Tried inserting a 'do..loop until rs.nomatch' before and after the "if not rs.nomatch" segment and received a reply of "False" for those dates that had multiple jobs scheduled. Any more ideas...- jambet
- Post #3
- Forum: Microsoft: Access Forms
-
Multiple lines of input in calender text box
Hello, I have a calender composed of 37 text boxes (one for each day of a month) which when run, uses the following code to extract job#s from a table for the appropriate date. Set f = Forms!frmCalender For i = 1 To 37 f("text" & i) = Null Next i sql = "SELECT...- jambet
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
-
Updating Calculated controls on Subforms
Thanks, AceMan. Tried the recalc with no positive result. I'll keep looking- jambet
- Post #3
- Forum: Microsoft: Access Forms
-
Updating Calculated controls on Subforms
I have a tabbed subform (frmProd) (the secondary tab) that contains a calclulated control (weight) using data from a subform (frmWeights)on the frmProd subform. I am able to calculate these controls by using the ctlJob_GotFocus event with the following code, this being the first control to get...- jambet
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
