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 AlienHost

  1. AlienHost

    Conditional Select and Sort statement--can't do it

    Hello there, I'm developing a stored procedure for a Crystal report and starting out with some code that has already been developed. I'm fairly new to this and this is just over my head. Can you help? I have 8 types of fields that need to be sorted, according to the values contained in each...
  2. AlienHost

    Verify Random Sample code?

    I did it right after you pointed it out. Thank you!
  3. AlienHost

    Verify Random Sample code?

    Oh, don't I wish! We're using SQL 2000. In your mind, would it return random samples?
  4. AlienHost

    Verify Random Sample code?

    Yes, I had just changed that from the TempID late last night. When the other developer saw it, it had the TempID as the final sort. I musta been bleary. Thanks for waking me up! What do you think about the code with it sorted by TempID?
  5. AlienHost

    Verify Random Sample code?

    Hello, I wrote some code that is supposed to select a random sample of clients from three views. I needed to allow the user to ask for a certain number of records to be returned. What I did was run the parameters of the selection and union the results of the return into a temp table, while...
  6. AlienHost

    How to code choosing wildcard or variable in WHERE clause?

    Thanks to all of you! I got some great ideas, but used GMastros code first and it did the trick perfectly. I had to think about why the first part [(@ServiceCodeGroup = 'All Service Codes'] would return all records, but then I translated this to the equivalent of "where 0=0" which would be...
  7. AlienHost

    How to code choosing wildcard or variable in WHERE clause?

    Hello, I'm trying to set up a where clause with (among other things) a selection of a variable if it has a value other than "all" or a wildcard if it is "all." I'm pulling the data from a temp table. I'm not sure how to code this and have botched it in several different ways. Can you help me...
  8. AlienHost

    Create Proc won't recognize declared variables

    George, Thank you for the more streamlined code! Also, I removed *all* the "go"s and removed the two extra "insert into"s that I had in the union query and I'm down to an error near "not" which I can handle. Thanks so much for your help!
  9. AlienHost

    Create Proc won't recognize declared variables

    Thanks JBenson and George. I'll get rid of the "GO" and try it. I never get to call the procedure because it isn't built yet. Just running the code checker through Query Analyzer nets me errors. Here is the error list: CREATE PROCEDURE dbo.usp_ProgressNotes @TherapistName...
  10. AlienHost

    Create Proc won't recognize declared variables

    Hello, I hope you can help me as I'm new to using SQL. I'm trying to create a procedure, but when I test it in Query Analyzer, it doesn't recognize the variables that will be passed in as having been declared. Is there something wrong with my syntax? I've looked at several things and have added...
  11. AlienHost

    Hyperlink Crystal Report to Crystal Report with separate params?

    Hello, I'm using version 8.5 and trying to link a Crystal Report main report to another report that uses the same stored procedure on a network. I want them to remain separate, as I want the parameters of the second report to fire only when the hyperlink on the first report has been clicked--not...
  12. AlienHost

    Incorrect report result

    I'm having this same problem and don't get it. I have a very simple query: one table that the report is based on. When I go into the record source and run the query, it returns all the data, which is sorted by sequential item ids. However, when I run the report, it leaps from record 1 to record...
  13. AlienHost

    MS Access VBA: docmd.printout fails. how to fix?

    Thanks Bob, but I don't want to use another form. These reports are to be printed out on the fly and the time to pull up two forms just would get in the way. It should work from code at a button push like anything else. All they're inputting is the year.
  14. AlienHost

    MS Access VBA: docmd.printout fails. how to fix?

    Hi Bob, I probably wasn't clear enough in my original explanation. Some of the reports run input boxes from the "on open" event, which I don't want the user to have to fill out multiple times. I'm trying to print out multiple copies with one print command, which DoCmd.OpenReport rpt...
  15. AlienHost

    MS Access VBA: docmd.printout fails. how to fix?

    Hi, I've set up a form that accesses the reports container and lists out specified reports. The User selects one of these reports and can either view it by clicking one button, or print it by clicking another. Since these reports might be run in multiples, I wanted the ability to print the...
See more

Part and Inventory Search

Back
Top