Recent content by fvd_1

Re Hi Bat17, Thanks for replying. Yes, i always use notepad to open and view the textfiles. The exported format is .txt. I do not have the problem when i export it as a .rtf-file, then it is a clean file without empty lines etc. but unfortunately it has to be a .txt-file to use it afterwards...

re Hi Ziggy, No, i tried that, when i use a table or query as the source this does not result in a proper 'clean' textfile because there are line inbetween the rules of text, looks like this then: --------- | zefghf | --------- |zerzerz | --------- So it has to go via a report... The...

Hi, I have a report that i send with a e-mail (via a macro), the exported values of the report are send as a .txt-file. Now something strange happens, between every 4 or 5 lines of text there is a blanc rule, this i want to get rit of! So the textfile looks like: qsdf sdfg dsfg xcvb xcvb rty...

Hi, I have a report that i send with a e-mail (via a macro), the exported values of the report are send as a .txt-file. Now something strange happens, between every 4 or 5 lines of text there is a blanc rule, this i want to get rit of! So the textfile looks like: qsdf sdfg dsfg xcvb xcvb rty...

eternal gratefull ;-) Thank you very much ReAn! Brilliant, it works! (offcourse it works you are thinking) A huge relief, now i can continue making my database... Many greetings! fvd_1

Hi, i'm not sure that this is the kind of solution your looking for but i think this is the formula you'll have to use: (100/[allrecords])*[yesrecords] So you'll have to make a query that counts all the possible records (this field will then be [allrecords]) and another query that counts all the...

Hi, I'm having difficulties finding the corerct SQL-code for an updatequery. This query needs to define the record which has the highest numeral-value and update the new record with this number+1 For example; there are 3 records in a table, numbered 1,2 and 3 3 is the highest number, so the...