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 Chris Miller 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: *

  1. Shiloh917

    Making a report Fit on one Page

    I've already done that and it still won't change. These are canned reports that I am re-doing for my needs. Do you think that might be the problem?
  2. Shiloh917

    Making a report Fit on one Page

    How to get all on One Page I have a report that I have grouped by OrderCode and totals for each order code. My information is correct but my report is putting 1 group on 1 page the next group on another page etc... How can I get it to print all on 1 page? I have tried taking out blank sections...
  3. Shiloh917

    Getting inaccurate data from my report.

    I have a report that I have the params set up to show me information from Start Date to End Date by Order Code. Which an Order Code is just really the name of a certain product. I have 3 diff products that I am interested in I set it up in the Edit Selection Record as well like this...
  4. Shiloh917

    Groups within a Group

    Well that works but like I had it. I need to have all the floors that start with a 4 group together and show as one floor, and show one product and show one qty for the product. This way shows each product and all locations and diff qtys for each location in other words it is showing Bottled...
  5. Shiloh917

    Groups within a Group

    I tried this and it is giving me and error that says: The ) is missing I tried adding the paren where the cursor flashes and it still won't work. Suggestions?
  6. Shiloh917

    Groups within a Group

    Okay, This is what I have. I have a report that has 3 Groups. The 1st group is the location, the 2nd group is the product and the 3rd group is the qty of each product. However I have 10 locations with a variety of the same products on each floor. For Example: 10N has 11 products and a certain...
  7. Shiloh917

    Questions Re: SQL Server 7.0

    It is a one system with different functionalities. We just would like to see only the Peds side of the functions so I am thinking maybe a joint master table with different attribute tables may be what I am looking to do. This would allow us on the Peds side to just see the templates that apply...
  8. Shiloh917

    Questions Re: SQL Server 7.0

    We use Sql Server as a backend to the Medical Sw that we use. We have two depts that use this Peds and Adults. When we the Peds Dept do our charts we still see all the Adult stuff as well. Is there a way to set it up on SQl that will allow us to separate our stuff from the adults? Sometimes we...
  9. Shiloh917

    How can I stop my Subform from changing!

    I figured it out. All I needed to do was on the Personal Form which is the Subform was set data entry to No. Thanks anyway!
  10. Shiloh917

    Form Question-Viewing Report from Command

    I fixed this so no need to reply to this
  11. Shiloh917

    How can I stop my Subform from changing!

    I have a form based off of two forms The EmpData form and the Personal Information Form. I am adding information into these forms on a regular basis they are connected by the EmpID and ID keys. The problem is after I have edited the form and then I need to go back in and add more information I...
  12. Shiloh917

    Form Question-Viewing Report from Command

    I am building a database that lets me pull up when the licensing is due for our therapists. I have a form set up that has a command button that pulls up my report with one clk. However, I was asked to set it up where when I open the db it opens to a full form mode the form with the command...

Part and Inventory Search

Back
Top