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!

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

Search results for query: *

  • Users: tennisguy
  • Content: Threads
  • Order by date
  1. tennisguy

    Find child records where status is complete

    Hello... I have a parent table called Tickets (tech-support tickets) and a related child table named Tasks, related via TicketID. One ticket can be made up of one or more tasks. Each ticket has a status of open or closed. Each task has a status of completed, waiting, etc. I'm trying to...
  2. tennisguy

    Preventing Record Creation when Balance Check Fails

    Hi. I have a form called RFP Entry. On it is a subform (RFP Expenses subform). In the continuous subform for a new expense record, I choose a doctor from a combo box (Doctor_ID), select an account from a combo box(Account), and fill in an amount of the expense in a text box (Amount). Each...
  3. tennisguy

    Scroll Bars Missing

    Hi. I have a form that does not display either the horizontal or vertical scroll bar. The Scrollbars property in the form's property sheet is set to both, so I was curious if there was something else I'm missing that would cause this. Not sure what other information to provide. The form is...
  4. tennisguy

    Subform/DLookup Multiple Value Concatenation Issue

    I have a combo box named Account on a subform named RFP Expenses subform. That subform is on a main form named RFP Entry. There is a text box on RFP Entry named Account_To_Be_Charged. The main form and subform are linked via a field named RFP_Number. For each record created in the subform, I...
  5. tennisguy

    Populate Table w/ Range of Numbers from Parameter Query

    Hi... I have a field named RFP_Number in a table named RFP_General_Info. I would like to have something like a parameter query that can prompt a user to enter a range of new RFP numbers (e.g., from 5001 to 5500). I would then like those numbers used to create as many new records in the...
  6. tennisguy

    Delete Parent Records with no Matching Child Records

    Hello! I have a Projects table with 11 project records. I have an Employees table with 25 records. Each project has an ID (Project ID) and each employee is assigned to work on one project (Project_ID Number). The tables are related from Project ID in Projects to Project_ID Number in...
  7. tennisguy

    Print Parameter Field Criteria on Report

    I have 2 parameter fields that ask for dates and customer name when the report is refreshed. The dates will accept multiple values (discrete & range values). The customer name accepts multiple values as well using a drop down list on the parameter box. So, we're wanting to print in the header...
  8. tennisguy

    Showing Drill Down Magnifying Glass Symbol in Group Tree

    It seems that unless I hide or suppress all group sections in my report, the turquoise magnifying glass symbols do not appear in the group tree. I'd like to have the symbol display next to all groups in the group tree when doing a summary report so that the symbol gives some visual cue that...
  9. tennisguy

    Reorder Parameters in "Enter Parameter Values" Box

    Once several parameter fields have already been created in Crystal, they appear to show in the list at the top of the "Enter Parameter Values" box in the order that they were created. Is there any way to change the order without removing and then recreating the paramter fields in the...
  10. tennisguy

    Printing to 2 Different Printer Trays

    A student would like to print the report so that the first page prints to one tray in the printer (with company letterhead) and the remaining pages print to a different tray in the printer (with regular paper). The student mentioned the old DOS printing codes or something like that as an option...
  11. tennisguy

    Open Report in Notepad to Reveal Connection Info

    In Crystal 8.5 Pro (and perhaps earlier versions), you can open a *.rpt file in Windows Notepad, and in all of the jibberish that displays, you can find the field names used in the report, the directory path used to locate your database file or database server, login information (username &...
  12. tennisguy

    Protecting Report Connection Information

    In Crystal 8.5 Pro (and perhaps earlier versions), you can open a *.rpt file in Windows Notepad, and in all of the jibberish that displays, you can find the field names used in the report, the directory path used to locate your database file or database server, login information (username &...

Part and Inventory Search

Back
Top