Recent content by carterlw12

  1. C

    Query Builder: Only show first value of duplicates

    Nvm I figured it out. Column Count = 1 Column Widths = 3"
  2. C

    Query Builder: Only show first value of duplicates

    Neither of those worked. I have over 46 fields in my table.. so to keep it simple this is what I have. FileName, DatabaseID (primary key) rcokrons_20180719@1603, 12 rcokrons_20180719@1603, 13 rcokrons_20180719@1603, 14 rcokrons_20180720@2000, 15 rcokrons_20180721@0600, 16...
  3. C

    Query Builder: Only show first value of duplicates

    I am operating in the SQL View of the Query builder. I have a list box on a form that is pulling values based off my query. The problem is I have several duplicate values. For instance, when I import files using a form, I have a column in the table update with the file name for every record that...
  4. C

    Importing file only if it has "example" in the file name

    I understand what you are saying. The very first time I tried it I omitted the 1st character and the compare options. Did not work. Then I added the 1 option without the compare options. Still didn't work. Then i used the 1 option with the TextCompare, still didn't work. Then I used the 1 option...
  5. C

    Importing file only if it has "example" in the file name

    Whenever I tried it with the Compare option it would not work correctly. As soon as a put in the Compare option it is only importing files with the file name "rcokrons" in it, Which is what I'm looking for.
  6. C

    Importing file only if it has "example" in the file name

    Thanks I got it. If InStr(1, Me.txtFilepath, "rcokrons", vbBinaryCompare) = 0 Then
  7. C

    Importing file only if it has "example" in the file name

    It's not working. Whether I do it how you referenced above or "<> 0" or "> 0" or "< 0" it still can't tell the difference. Btw I did read the URL that you posted. That's where I came up with the initial code. lol
  8. C

    Importing file only if it has "example" in the file name

    C:\Users\carterlw12\Documents\Audits\Rcokrons\rcokrons_20180718@1535.csv This is what is in my txtFilepath.
  9. C

    Importing file only if it has "example" in the file name

    So I've tried to get this working a couple different ways but I think my beginner status is showing through.. lol I'm getting the MsgBox to show up even though my txtFilePath does have the word "rcokrons" in it. Private Sub cmdImport_Click() Dim FSO As New FileSystemObject Dim strSQL As String...
  10. C

    DoCmd.TransferText (Run-time error '2391')

    Yes. I have actually changed the field names and characters instead of leaving them as reserved names and characters! Thank you!
  11. C

    DoCmd.TransferText (Run-time error '2391')

    I did. I looked up reserved words, because I didn't know all of them, and changed all my field names in the tables and VBA code. All is good! Thanks.
  12. C

    Importing file only if it has "example" in the file name

    Is there a way during my import that I can specify that it only imports if it matches a certain word in the file name? I'm using: Private Sub cmdImport_Click() Dim FSO As New FileSystemObject Dim strSQL As String strSQL = "INSERT INTO PeopleSoft_Import_tbl (GlobalID, RecordEffDate, BirthDate...
  13. C

    DoCmd.TransferText (Run-time error '2391')

    It was ft/pt, reg/temp and union need brackets around them
  14. C

    INSERT TO syntax error

    Ahhhhhhh it was the "union". I didn't realize that was "illegal". That worked!!! Thank you!
  15. C

    INSERT TO syntax error

    I tried that. Same error "3134 Syntax error in INSERT INTO statement".
See more
Top Bottom