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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: reubenpatterson
- Order by date
-
Updating Zero Rows
Ah, sorry 'bout that. No, it doesn't exist in the table, I'm trying to pull it from the form when it's been entered in the AcctNumb field, and store that value and the appropriate city (which is derived from the fldSysprin value.) That's why I thought INSERT was better than UPDATE. It works in...- reubenpatterson
- Post #10
- Forum: Microsoft: Access Modules (VBA Coding)
-
Updating Zero Rows
Hi AceMan, it's actually a variable drawn from a form. Here's the complete code: Dim AcctSysprin As String AcctSysprin = Forms![FrmEsc4Disp]![AcctNumb] AcctSysprin = Left$(AcctSysprin, 8) Dim AcctCitySQL As String AcctCitySQL = "INSERT INTO TblDateContact" AcctCitySQL =...- reubenpatterson
- Post #8
- Forum: Microsoft: Access Modules (VBA Coding)
-
Updating Zero Rows
Sorry, "Updating 0 rows" nothing populates in the table.- reubenpatterson
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Updating Zero Rows
Same error...thanks for trying though.- reubenpatterson
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Updating Zero Rows
Hi, I'm really new to this, so here it goes...when I run this it runs without errors, but says "Updating 0 rows" and nothing is written to the table. What am I missing here? Dim AcctSysprin As String AcctSysprin = (Forms![FrmEsc4Disp]![AcctNumb]) AcctSysprin = Left$(AcctSysprin, 8) Dim...- reubenpatterson
- Thread
- Replies: 9
- Forum: Microsoft: Access Modules (VBA Coding)
