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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ADO Connection to Backend SQL Server
Hi PH, I changed the variable names and tried your suggestion...I am now receiving an error that reads, "The object you entered is not a valid Recordset property." If cmbViewReport.Value = "Average Days for Completed Case - Decision" Then Dim StartDate As Date Dim...- acv111
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
ADO Connection to Backend SQL Server
Hi, I am using MS Access forms as a front end to a backend SQL Server Database. I am trying to use an ADO connection to pass a parameter query to the SQL Server. I have been able to establish the connection to the SQL Server and have verified that the SQL statement is correct. I am...- acv111
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Even Report Columns
I am trying to create a report with two columns that display customer name and address. I have the column layout setup as Down, then Across. Is there a way to even out the number of customer names and addresses in each column without changing the column layout to Across, Then Down. For...- acv111
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
