Recent content by dicesare

Hi all! Does anyone know a method to instruct SHAPE to not return parents recordsets that do not have child recordset? for example, using the following SHAPE {SELECT * FROM publishers} APPEND ({SELECT * FROM titles} AS PubTitles RELATE pub_id TO pub_id) if a...

Hi all! Does anyone know a method to instruct SHAPE to not return parents recordsets that do not have child recordset? for example, using the following SHAPE {SELECT * FROM publishers} APPEND ({SELECT * FROM titles} AS PubTitles RELATE pub_id TO pub_id) if a...

Hi all! Does anyone know a method to instruct SHAPE to not return parents recordsets that do not have child recordset? for example, using the following SHAPE {SELECT * FROM publishers} APPEND ({SELECT * FROM titles} AS PubTitles RELATE pub_id TO pub_id) if a...

Sorry Michael, I simply didn't understand what you suggested me. Now I will try to use the "Chunk" method. Sorry again.

for MichaelRed. thanks for your help. I currently use the method you suggest: I import the file into the mdb and then start the report, but it is a very slow process (due to high number of records). This is the reason why I'm trying to link the TXT file instead or parsing (importing) it. BTW...

thanks, jfischer MSDN says: "If all the records in a fixed-width text file are the same length, there can be an embedded row separator (such as a carriage return and linefeed) in the middle of a record. If the records aren't all the same length, embedded row separators should not be used...

Reading and interpreting the file is not a problem. I can easily do that. But this way I will have 2 separate files. I need to LINK the .TXT file because it is continuously updated by another application. I will use the Access file only for reporting, and I cannot say to the user(s) to import...

Hi all, Access 2000 allows me to link an external text file generated with Basic PDS 7 (DOS, aka Random file), using a fixed format. Unfortunately, all numbers (stored in IEEE format) are unreadable. When Access finds a CHR$(13) or CHR$(10) - they both may be into a number -, it interpretes...