Search results for query: *

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...

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...

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...

I have a report where page n of m is always wrong. To be more accurate, m is always wrong and always two pages too low. If the report has 12 pages, this will read Page 1 of 10, 2 of 10 etc all the way to 11 of 10 and 12 of 10. Has anybody seen this before? Any ideas on where to start looking...

I have the following problem: I have a report that contains a memo field that must be set to can grow(no maximum). I also need to be able to count the number of lines that have printed. Not detail records that have passed through but the number of lines that have been consumed in the section...

I have a database I've written using Access97. After converting the database to 2000 and making some minor changes that 2000 seemed to need, all works fine on my pc here in my home office. I copied the database to a clients site and all works fine there except one TransferText line in one...

Is it possible to conditionally load an array from multiple detail records, then reference that array at the end of the group? Example: Reading a Cost Code Master File if a record meets certain qualifications, x is incremented and value y is loaded into Array,x. Another record is processed and...