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 Rhinorhino 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 demosoc

  1. demosoc

    Error 2013 on Insert on a junction table

    Hello All, I'm new to Mysql and am having some trouble. I'm trying to insert into a junction table, "action_x_recipient", and I'm getting a 2013 error code. When I run the query w/o the insert, it runs fine. Basically we get a big data dump (over 8 million rows) which I need to move into...
  2. demosoc

    Crystal Label report - need footer on each label in same position

    Mike-you got me thinking more about the details and the suppression option and I came up with a solution after looking at the data- since the dynamic fields do not exceed 2 lines, and since each detail has a different size font, I added a details section (d and e) with suppression formulas for...
  3. demosoc

    Crystal Label report - need footer on each label in same position

    Thanks for trying!
  4. demosoc

    Crystal Label report - need footer on each label in same position

    Thank you for the suggestion Mike- it seems I'd forgotten to add the most important part- unfortunately, the lines (line 1, line 2, etc.) can grow. I actually have the label set up as you suggested, but can't seem to find a way to make the final detail line print at the bottom of the label due...
  5. demosoc

    Crystal Label report - need footer on each label in same position

    Greetings, Feeling a bit dim-witted here...I'm working on a label report in Crystal 9 which needs to print a barcode on the bottom of each label regardless of how long the name and accompanying info is (which needs to be positioned at the top of the label and grow downward). Like this...
  6. demosoc

    Deleted field rises from the grave

    That was it!!! There was one little query in the Access DB that was still calling the removed 'Bounced?' field. And when I deleted the field in the Access query, the reports stopped asking for it! That's so strange as the query was never a part of the report. Crazy. Thank you so much!
  7. demosoc

    Deleted field rises from the grave

    Unfortunately, that doesn't work. I tried making the 'Bounced?' field a text and even a date/time field and the report doesn't care or highlight the field. This is the case even on the ReportCopy. So I get the prompt regardless of field type, and I still am unable to locate where the field is...
  8. demosoc

    Deleted field rises from the grave

    Thanks to all for the efforts so far... Well, I've tried to export the report definition, but can't get it to work. It requires the disk (which took us awhile to find) and the one we found doesn't help even when I point it to the file it's looking for. So I'm currently unable to export the...
  9. demosoc

    Deleted field rises from the grave

    NiteClerk- thank you, but unfortunately, this didn't do the trick. Additionally when I look at the report explorer, the field does not appear. -------- lbass- I am prompted in the 'Enter Parameter Values' box, under 'Parameter Fields:' it appears as 'Contacts.[Bounced?]' -------- I created...
  10. demosoc

    Deleted field rises from the grave

    Yes, I verify the database, it recognizes that the table has changed, says it is up to date, and then I get the prompt for Contact.Bounced? as a Parameter Value when I try to run the report.
  11. demosoc

    Deleted field rises from the grave

    1. No- the only Selection Criteria is based on cst_add_date being >= a Parameter Date field 2. No- there are no subreports
  12. demosoc

    Deleted field rises from the grave

    I am running Crystal 9.2.0.448 against an 2003 Access DB and am pulling fields from two tables. The problem is that one of the fields (contacts.bounced?), which was removed from the report and also from the DB is now appearing as a parameter. When I open the Field Explorer to see if the field...
  13. demosoc

    Multi-User Access 2003 errors for (XP pro, office 2007, ie8) user

    Hello, I have a multi-user Access 2003 database with front and back end security that has been working just fine for everyone. One power user was recently upgraded to Office 2007, and there have been issues ever since. I believe everyone else is still running 2003. This latest one happens...
  14. demosoc

    Query pullinig info in Access, but not passing it to outside report

    Thanks so much dhookom!
  15. demosoc

    Query pullinig info in Access, but not passing it to outside report

    Do you have them compact automatically, or do you do so manually? And how often?
See more

Part and Inventory Search

Back
Top