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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by TYLRDRDN
-
Open a recordset fro a query
Hello Check this code out and see if it helps. I am not sure why it would come back with a table to test for success, use the code at the bottom. Dim conDB As New ADODB.Connection Dim rstDB As New ADODB.Recordset Dim strSQL As String conDB.Open "DSN=" & sDSN & ";UID=" &...- TYLRDRDN
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Update a table through a form
Date will not return the current date in SQL you are going to need to use sysdate and most likely make sure that you format it accordingly.- TYLRDRDN
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
