Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by coco86

  1. coco86

    Problem with AfterUpdate - Field shows code, not answer

    Well, the message box should be showing the SQL not the result...that's what you've told it to do. If you want to see the result move the line down to after you open the recordset and change it to msgbox rst![Acro] Since you're only looking for a single record, though, I'd use dlookup rather...
  2. coco86

    Max size of varchar variable in stored procedure

    Ok thanks it's showing up correctly in the results pane now. I guess I have two different problems going on here because it still gets truncated when I pass it to the Persits Mailsender object (ASPemail) I guess there IS a limit for method calls. Thanks for your help though. -Coco [auto]
  3. coco86

    Next Record in Report

    Add a footer for your unique ID and then in the properties for the footer section set "force new page" to "after section" -Coco [auto]
  4. coco86

    Max size of varchar variable in stored procedure

    I have a stored procedure that contains a variable that is supposed to be varchar(1000). However, it insists on truncating the data I put into it at 255 chars...no error message, it just chops the end of the string off. Is this a limitation of SQl Server and if it is is there any way to get...
  5. coco86

    Access 1/0 conversion to yes/no

    Well, I don't know if this will work or not but try SELECT *, IIf([FieldName],"Yes","No") as DisplayName FROM DynamisPoints ORDER BY Job ASC -Coco [auto]
  6. coco86

    Access 1/0 conversion to yes/no

    You can have a query inside an MDB file but I don't know how coldfusion works so I don't know how to specify to use a query instead of a table. Do you include a table name inside your connection string? If so, you can probably use the query name instead. -Coco [auto]
  7. coco86

    document formatted for a printer

    If you want to use the default printer, why don't you just set the report to use the default printer (file=>page setup=>page)and not worry about setting it in code? As for your problem Is Ne01 the printer you want to use? NO: is the report set to use that printer? Can you remove the printer...
  8. coco86

    IIf statement in query design grid

    IIf(DepartDiff > 330,"Late",IIf(DepartDiff < -30, "Early", "On-Time")) -Coco [auto]
  9. coco86

    Query Help

    Try select temp1.partnum, count(temp1.PONum) as PoNumbCount from [select distinct partnum, ponum from tablename] as temp1 group by temp1.partnum Or, use two queries Query1 select distinct partnum, ponum from tablename Query2 select partnum, count(PONum) as PoNumbCount from query1 group by...
  10. coco86

    Access 1/0 conversion to yes/no

    sxschech brought up a good point. If you use a query as the datasource for your page, you can have it return yes/no instead of -1/0 (using the technique he described) and you won't have to do any special formatting on your page. "DisplayName" (or whatever you change it to) would be the new...
  11. coco86

    Access 1/0 conversion to yes/no

    Sorry, didn't notice you were using coldfusion...thought this was an access report. Still, the coding will probably be different (I don't use Coldfusion) but the approach would probably work. I've used similar techniques in ASP. -Coco [auto]
  12. coco86

    Access 1/0 conversion to yes/no

    Try putting a textbox control on the form and setting the control source to: =IIf([FieldName],"Yes","No") -Coco [auto]
  13. coco86

    Keep together issues

    OK, I tried that too, still isn't working -Coco [auto]
  14. coco86

    Keep together issues

    Thank you for your response but I've already made sure "Keep group together" is not checked for all the groups. That's why this is so confusing. I'm not using sub reports. Any other suggestions? -Coco [auto]
  15. coco86

    Keep together issues

    I hope someone can help me here. I've developed a report as part of a VB.net application. (This is the first time I've used crystal reports and I'm learning as I go.) I've got "keep together" set to false for all sections on the report but it seems to be keeping the sections together anyway...
See more

Part and Inventory Search

Back
Top