Search results

  1. W

    Loop through fields

    Yes!! The array worked. I cant believe I didn't think of that. Thank you so much!! Code: Option Compare Database Public Function makeTable() As Long Dim looper As Integer Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim rs1 As New ADODB.Recordset Dim rs2 As New ADODB.Recordset...
  2. W

    Remember when...

    The first computer I ever used was in the mid 90's. The earliest form of media i used were the large 5" floppys. I cant wait till people are like "Remember when we use to use physical media, that stuff was lame and broke all the time"
  3. W

    Loop through fields

    I attempted the decelerations that you suggested and added the length to the create field statement with no luck, same error,
  4. W

    Loop through fields

    I will paste all of the code. My declarations are not like that. Option Compare Database Public Function makeTable() As Long Dim looper As Integer Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim rs1 As New ADODB.Recordset Dim rs2 As New ADODB.Recordset Dim rst As New...
  5. W

    Intro

    Hi, My name is William and I am from Lancaster, PA. I am currently working for a company that makes home decor as helpdesk\ jack of all trades guy. I work with SQL and Access a lot. I have had classes on VB and Access but never VBA. Most help I need will be in the VBA\coding area. Ive been...
  6. W

    Loop through fields

    Hi everyone, Im new to the forum and I have a question I cannot find an answer to. I need to loop through fields to add header names. Every time I run the code I get an invalid operation error. So, is there a way I can loop through the fields. I do not want to have to copy and paste the code a...
Back
Top Bottom