Search results

Well this is odd... So I've changed my write procedure to replace carriage returns with Chr(182) / "¶" But when I look at the text file having logged an entry with a carriage return, the replacement character is "Â" / Chr(194) So when I then try to identify instances of Chr(182) in the...

Appreciate that namliam but it's still an additional table which will compromise the available space in the BE. I'm trying to keep the BE as lean as I possibly can, for longevity and scalability. The volume of importable data is due to increase ten-fold in the coming weeks. I'm constantly...

A very valid point, namliam, and one which I had considered. I do have some more rudimentary audit trails logged straight to tables as a matter of course. However, this particular activity is quite extensive, and I need to record all attributes as of the time of action (not as they are 'now')...

Nice. Thanks Minty, let me play around with that!

Thanks namliam I kinda need to store this information as text as it's basically an audit log for all the activity that passes through the system. I only use Excel to tidy it up a bit for reporting purposes - I don't particularly want to have lots of Excel spreadsheets building up over time. I...

Okay guys I finally managed to test this and I'm still getting the same (or similar) problem When I write the contents of the recordset to the text file, the line feed is still creating a new line in the text file (rather than just marking it as a line feed character within a text-qualified...

Thanks guys spikepl - cheers for clarifying - I've added a line to replace vbCrLf with vbLf (which I believe is also Chr(10), correct me if I'm wrong?...) when writing the text fields. Still waiting to test it, had some separate issues to deal with yesterday, hence the delay in responding...

Hi guys, I have a function which takes a recordset and writes the contents to a text file. One of the fields in the recordset is a free format text field, the contents of which originate from a text box on a form. Occasionally, a user can hit the 'Enter' key to add a new line (carriage return)...

Wow. Just... just wow :eek: Thanks mate!

It's coming from an Access BE, although I'm hoping, if it is successful in the long term and I can argue the case, to move it to SQL Server at some point in the future I'll test it with Null over ZLS and see if that causes any problems; if not, I'll make the switch. Thanks vbaInet!

Resolved!! Thanks spikepl for the demo db - I got what you were saying but the example made it clearer and made implementing that method so much easier. So basically I do my null check on a non-boolean field within the joined table (I use the primary key which is a basic autonumber...

Thank you all for your valued input and opinion! vbaInet... I tried your methodology of simply multiplying each field by 1. However, I'm still getting 0's for both genuine False records and "expected" Null records. It seems as if the query is evaluating the source field as a boolean first and...

I was under the impression that using IIf's was a bit slow... I may be wrong... Having said that - I tried using the IIf([tbl].[fld] Is Null, Null, CInt([tbl].[fld])) method anyway, but I'm still getting exactly the same output. Everything is either a 0 or a -1 I can't distinguish the...

Hi there, I have a query which returns, among other things, a number of boolean fields. In some cases, there will be a genuine True or False value in each of these fields; in others, it can and should be Null (e.g. as a result of a 'failed' LEFT JOIN of some description, where there is no...

Thank you both for the feedback, much appreciated!

Hi guys, I have a function to write some data to a text file (as an activity log, separate to the live data contained in the DB) It uses the FileSystemObject.OpenTextFile method and works fine However, I'm conscious that, although perhaps unlikely, there is the possibility (which is enough...

Thanks guys, JHB, the code is mountainous - it was an already complex report made even more complicated by a requirement to sub-categorise a load of stuff. So dumping the whole code in here wouldn't really be feasible; plus I would probably struggle to remember all the changes I made. Suffice...

Should have mentioned; top row (headers) is frozen, so selecting a cell in the first row doesn't necessarily scroll up...

Hi guys, I have a function which exports some data to Excel, performs some work, and then attaches the final report to an e-mail. All works fine apart from one small piece which used to work, but doesn't now, and I can't figure out why? As a result of various temporary columns being added /...

Nice suggestion namliam, wouldn't have thought of that I ended up just building a function to loop through each date in the range and perform the calculation for each one. Was worried it might be slow (hence was hoping to find a SQL method) but it's actually strangely quick. So it'll do...