Recent content by ebs17

  1. E

    Data Change in CSV file after TransferText data export.

    If the CSV file extension is such a huge problem, which is incomprehensible because this issue has existed for at least 30 years and generations of developers and users have been able to deal with it - if the problem is the file extension, then TXT should be used. Importing and exporting in...
  2. E

    Data Change in CSV file after TransferText data export.

    First question: If a CSV is required for an import into the SAP system and a CSV is created for the export from the Access application - where and why does Excel come into play? Second question: If the CSV is opened in Excel out of curiosity or playfulness, the CSV itself does not change unless...
  3. E

    make query updatable

    What does watching calculations have to do with query updateability? Does the topic title make sense?
  4. E

    Data Change in CSV file after TransferText data export.

    A CSV is plain text. This file or its contents will never change independently. As written, you can check this by simply checking. Changes only occur through access from third parties or simply through a clumsy import because no suitable import specification is then used. The CSV is innocent...
  5. E

    Data Change in CSV file after TransferText data export.

    A CSV is a text file, i.e. a simple file that only contains plain text, but never own code. So if you open the text file with a simple text editor as written above, you will see the content exactly as it was written. There is nothing that can independently change anything. If you open the file...
  6. E

    make query updatable

    What exactly do you want to update? The calculated values? Stupid solution: Write the query contents to a new table using a make table query. Then you can change, but you no longer have any reference to the actual data. If you don't like the calculated values, go back to the base (=>...
  7. E

    Data Change in CSV file after TransferText data export.

    The specification for export and import with the same structure of the text file is the same. So you can also import a text file, create the specification and remember the name of this specification so that you can then use it when exporting.
  8. E

    Data Change in CSV file after TransferText data export.

    Docmd.TransferText acExportDelim, ___ , "008_EQUI_Temp", myfilename, True Text should remain text and should not be reformatted. You could create and use an export specification where this column is defined as text.
  9. E

    Solved Indexing a foreign key in the child table

    In queries with multiple tables, relationships are often modeled as joins, but other than that, relationships can be linked in completely different ways depending on the goal of the query. So it's all about the sum of relationships and connections. I was talking about lookup tables. If you have...
  10. E

    stream data to excel

    Dealing with hardware is not a core task of VBA. I once had a task with a certain similarity. To use a scanner, you first had to make sure that the scanner was connected and available. Available (new) hardware appears in the Device Manager of the Control Panel. That would be a visual clue. In...
  11. E

    Solved Indexing a foreign key in the child table

    No, a relationship without an RI set is practically useless and should only be started if necessary or out of ignorance. The only benefit: In the database schema there is a visual indication that two tables logically belong together. Possible need: According to Access specifications, indexes and...
  12. E

    hide a record while it's being edited in a form

    @shura30: You want suggestions, you discuss some of them, but you don't understand them (at least not visibly), and you probably don't really want to try them out either. You persist in your idea. In my example in #33, I had determined times of around 5 milliseconds for a local and small table...
  13. E

    Solved Data from form not showing on Statement of Account report

    It is correct that a subreport is loaded before the main report. Therefore, passing filter parameters to the subreport or its RecordSource becomes a little more difficult, since you only open the main report specifically. There are different ways to solve these problems. I describe one way of...
  14. E

    Difference in selection and ordering on RecordSource compared to using Filter and Order property

    I would disagree with the previous statement. Whether I set a filter in Access or reset the SQL statement, the relevant records are reloaded in both cases. However, Jet can use indexes. So if I set filters or entire SQL statements with a WHERE clause that are formulated to use the index, then...
  15. E

    Solved Indexing a foreign key in the child table

    The index for the foreign key is only set automatically in an Access file if referential integrity is set in the relationship. But again, this should be standard.
Top Bottom