OK, let me simplify this:
I have an access table that has a memo field in it.
If I write "AAAAAAAAAAA" & chr(10) & "BBBBBBBBBB" & chr(10) & "CCCCCCCCC" the resulting output would be AAAAAAAAAAA*BBBBBBBBBB*CCCCCCCCC, where the * represents the little square box for chr(10)
If I write...
For purposes of this discussion the only pertinent thing about the external database is that for this field in this file they have chosen to use the null chr(0) as the character to determine, for display purposes, that any subsequent characters will display on a new line.
I am using Access /...
I'm using Access 2003 to output records to an existing database.
For whatever reason, the existing database uses the null value as one would normally use carriage Return and Line Feed.
As I try to create this particular table entry, as soon as I add the chr(0) all subsequent characters are being...
I was just thinking of other formulas I've done that load shared array variables, I always put some bogus value at the end as the result of a formula cannot be an array.
In this case I certainly wouldn't want to that, this was more for future reference...
LBass,
Thanks for your quick response and answer!
Your solution was much simpler than mine and works great.
It's not for record selection but to determine if a certain value belonged in the WTD column of a report.
Obviously, your code is cleaner but would there be a way to build that range(like...
Using CRXI with an ODBC database, I'm trying to build a date range which depends on the day of the week of a date type parameter. The Date range will always be a Saturday to Friday Range. Once I know the day of the week, I can build my date range by adding to or subtracting from the date...
I'm using XP along with Timberline Accounting software and CR. Clients are migrating from CR10 to CR11, with text exports that previously worked fine(CR10) becoming problematic(CR11).
It seems that using CR11 along with the typical "stealth" subreports will preview properly.
Any/all subsequent...
I'm having trouble using form values within the DoCmd.RunSQL SQL3 statement shown below. I'm guessing I need some specific combination of quotes in order for the form value in variable RequisitionID to be evaluated properly. It looks ok in debug mode but when the SQL3 runs it gives:
RunTime...
I have a report I've written for a client that contains a linked OLE object(ms Word doc). When the client runs the report, it does not reflect any changes to the word doc since the last Crystal modification.
The client stores the word doc on a mapped drive, such that the path is G:\xxx.rtf...
I have a few Crystal Reports(cr8 developer)that I have written and/or modified and emailed to a client.
They have been returned to me with requests for further changes.
I'm able to open them here, make changes and save them. Any subsequent re-open attempt generates the message"xxx.rpt...
Ken,
Thanks for the reply, at the very least I feel better knowing that you couldn't find it either. Although, finding out there was an operator that I couldn't find would have been good as well.
Mike,
Thanks for the code, I'll be giving that a try.
IDO,
I'm not so sure I understand your...
I need to keep track of several numeric values for a variety of different related string values. Under normal conditions, a cross tab would probably work. For a variety of reasons, cross tab isn't the answer.
Essentially, I'm keeping track of things like Original Estimate, JTD cost etc. for a...
Ken,
Thanks for your help. The questions you have asked sort of got me started, hopefully in the right direction.
I'm going to dig around for a while before I consider passing the problem along to someone else. I'll let you know if I can determine the cause.
Thanks,
Jeff
Ken,
The conditions used are pretty complicated, there are formulas involved and one value used in the conditions comes from a subreport. The client requesting this report has a pretty convoluted set of criteria that determine whether a particular job is included or not.
Do you need to see the...
Ken / Ngolem,
The problem occurs regardless of printer.
There are conditionally suppressed sections.
The problem occurs on other pc's.
I'm beginning to think that it is related to conditional suppression, that two pages worth of information may be printing that perhaps should not.
Is it possible...
Ken,
1. Using CR8 Developer Edition.
2. Standalone CR
3. Happens in both preview and print
4. So far, I've only seen it in this one report
5. Yes, I saved the data with, then reopened and the problem still occured.
Thanks,
Jeff
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.