Search results

  1. 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...
  2. 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...
  3. C

    INSERT TO syntax error

    Importing into staging table using a form button and it's successful but inserting that into the actual table that I want the data to reside in is not working. I'm getting syntax error for my INSERT TO statement. Private Sub cmdImport_Click() Dim FSO As New FileSystemObject Dim strSQL As String...
  4. C

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

    I am searched long and hard trying to find an answer to this and I have not. - Importing .csv file via form button - I do not want to edit the source file prior to importing - Source file does not have headers I have tried changing the code to include and not include headers and neither works...
  5. C

    New to Access from Oklahoma, USA!

    Hi, I am a relatively new user to Access! Within the past month I have been teaching myself during my downtime at work, in relation to a project that I am wanting to get off the ground for us to be able to use. I am not foreign to technology at all but have just scratched the service as far as...
Top Bottom