Search results

  1. F

    Solved Export Table to txt-File with semicolon spezification in VBA

    I have solve this. Thanks all
  2. F

    Solved Export Table to txt-File with semicolon spezification in VBA

    I saw the Export in this Wizard. (Saved Exports)
  3. F

    Solved Export Table to txt-File with semicolon spezification in VBA

    My whole Code is the line on the top. I have a Form in access with Buttons. The Button have the Click-Callback: Private Sub Btn1_Click() DoCmd.TransferText acExportDelim, "TableExport", "Table", "table.txt", True End Sub If I run this code, i became the error that TableExport not found...
  4. F

    Solved Export Table to txt-File with semicolon spezification in VBA

    Thanks for the fast answer. I test this and create a Export Specification and save this with the name TableExport. If I use this in VBA, I became the Error, that TableExport not found. What I do wrong?
  5. F

    Solved Export Table to txt-File with semicolon spezification in VBA

    Hi, i would like export one table in access to txt-File but with the semicolon spezification. How can I do this? Currently I do the following code: DoCmd.OutputTo acOutputTable, "table1", acFormatTXT, "table1.txt" But the output shows similar as a table with horizontale and vertical lines...
  6. F

    Solved Remove Duplicates in access with Queries

    This works fine with a database within 20 elements. But If I try this with 530000 elements, the query not run. But whyyy
  7. F

    Solved Remove Duplicates in access with Queries

    Hi, in the solution from Eberhard, Access ask me a value for T.Duplicate and X.Duplicate? If I press a and a, i became the message that access would like delete all my entrys in the dataset/Table.
  8. F

    Solved Remove Duplicates in access with Queries

    Yes your right. It doesnt matter which entry I remove. I need in the final table one entry of this duplicate. You know what I mean? For example If I have three entries for car. Then I need one entry of car in my table and not three. But how can I remove this? what do you mean ?
  9. F

    Solved Remove Duplicates in access with Queries

    Hello, i want to remove duplicates from the main table. I found a mini queries sql code in the internet, but they show me the count of the Duplicates. How can I remove the duplicates and keep only the entry on the top(FirstID). SELECT First(Tabelle1.Duplikate) AS [Duplikate Feld]...
Top Bottom