Search results

  1. A

    Use first line of Query as Column Headers

    Hi Guys, Here's the background. I get a CSV mailed to me, it's monstrous. I have a DB that i import this CSV into, (after alot of manipulation), and then run my queries to get what i need. I've got some code that will autoimport this CSV into a table and then i can use nested queries to...
  2. A

    Changing DSN linked tables to DSNLESS tables

    Hi Guys, I have linked tables in my db at the moment that rely on user dsn connections to an SQL server. I've been reading about DSNLess connections and want to try convert what i have to have permanent DSNless connections, but the code i've found doesnt appear to be working. Could you give...
  3. A

    Not In List Name Checker

    Hiya, I've got a combo box that has the following code in the Not In List option Private Sub Operative_NotInList() Dim count As Integer Dim I As Long Dim First As String Dim Last As String Dim Tmp As String Dim Name As String Name = InputBox("Operative is not on file, Please enter...
  4. A

    Copy entire contents of a recordset to a table

    Hi Guys, I've got the below code Private Sub WorkOrder_AfterUpdate() Dim strsql As String Dim rst As ADODB.Recordset Dim taskid As String Dim JobDesc As String Dim sql As String Set rst = New ADODB.Recordset rst.ActiveConnection = CurrentProject.Connection strsql = "SELECT...
  5. A

    openrecordset script

    Hi Guys, I'm trying to adapt some code an ex-employee has written to perform a different function, not really too crash hot with the finer points of VBA unfortunatly. Anyone have any ideas? Private Sub PropertyRef_AfterUpdate() Dim rstTemp As Recordset Dim qrydefTemp As QueryDef Dim strSQL...
Top Bottom