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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Whats quicker - execute query or update a recordset
I have an application that does a lot of executes with queries on a connection variable to a sql server, and I want to know whether it would be quicker to open a recordset and update fields in the recordset, rather than via the conn.execute update query...any help would be appreciated. DavidFC- davidfc
- Thread
- Replies: 2
- Forum: Visual Basic (Classic)
-
Changing report label in VBA - can this be done?
Whats the syntax for changing Caption property of a Report label after the report is open? I have tried: DoCmd.OpenReport "ReportName", acPreview Reports!ReportName.Label28.Caption = "To:" & David" but the report shows just the original default value of "To:" I'd be grateful for any...- davidfc
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
