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 derfloh 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. tonygr

    Is This Possible? using Formula in parameter

    Excellent, Thanks again LB Works a treat! TG
  2. tonygr

    Is This Possible? using Formula in parameter

    Hi LB, Thanks again for your input, would the above work if I had other parameters included in the record selection? please see below original record selection based on your first solution: ==================================================== {viewDaysLastVisit.EXPIRY} >= currentdate() and...
  3. tonygr

    Is This Possible? using Formula in parameter

    Yes! Tonyg
  4. tonygr

    Is This Possible? using Formula in parameter

    Sorry LB, I did correct as per your previous post and noticed my newbieness (Silly me!!!) Thanks for spotting it. I also added the "[1]" to make the below work, in case anyone else finds this thread of some use. select {?Age}[1] case "0 to 4" : {@age} < 5 case "5 to 10" : {@age} < 11 case "11...
  5. tonygr

    Is This Possible? using Formula in parameter

    Hi LB, Thanks for your response, who are we to question customers requirements :) I said the same thing about the groupings strange I know. Many Thanks Problem Solved
  6. tonygr

    Is This Possible? using Formula in parameter

    Hi All, I am using crxi2 R3 to SQL2000 DB I have a report that uses a dynamic prompt for selecting first a place then dynamic brings up list of values to select from that. I would like to add an additional parameter based (not dynamic) but referencing a formular which in turn references...
  7. tonygr

    help pulling data for 1st or 15th every month ???

    Thanks Madawc, Works a treat:) Regards Tonygr
  8. tonygr

    help pulling data for 1st or 15th every month ???

    Hi All, I am using crxi11 developer, sql2000 server. I am having trouble pulling all data for the 1st of every month or 15th of every month, ignoring month and year. The date field is held in datetime type, any help greatly appreciated. tonygr
  9. tonygr

    help with datagridview row to new detail form

    Thanks for the pointers. I have found some code see below, that does something along the lines of what I am after. 'DataGridView Form Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim frm As New DetailForm 'This assumes...
  10. tonygr

    Dynamic Data not visible???

    Hi All, I am running crxi dev, vs2005 vb.net, sqlserver2000 A strange thing has happend for no apparent reason, When I run a report with dynamic parameters non of the data is present that used to be there when I browse at the data tables in data explorer window I can see the data fine. These...
  11. tonygr

    help with datagridview row to new detail form

    Hi all, Sorry for asking such a newbie question, I am using vs2005 and sql 2005 server I have a form with a datagridview, and I want to double click a row and open a detail form. Can anyone point me in the right direction for this. Thanks in advance Tony
  12. tonygr

    Creating a search button on a form

    Hi TipGiver Thanks for the reply. Unfortnatley as stated above complete novice! is there any sample code available that you could point me to? all I have done is to place the textbox, and button along side the datagridview on the form. any help or tips on where to search for a tutorial would...
  13. tonygr

    Creating a search button on a form

    Hi all, I am using vs 2005, sql server 2000. Firstly sorry for the newbie question I have created a form with a datagridview from a table called tblMembers. when the form opens it displays the data from the table. I would like to search for a record using a textbox & button. If possible also...
  14. tonygr

    unmatched records from two tables help

    Thanks Ver Much! synapsevampire I took your advise and spoke to a friend who then helped me create a view on the SQL server for the first part. It looks at the customer visits and datediff to the last visit.I have then used crystal to group into months, using a simple formular. This shows...
  15. tonygr

    unmatched records from two tables help

    Hi all, I am Using Crystal Developer xi, SQL server 2000 I am trying to show unmatched records from two tables, but the selection criteria is based on both tables. I have a left outer join from table2(Visits) to table1(Members) linked via the member number fields the following works...
  16. tonygr

    problem crystal 11 dynamic parameters/prompts not working vb.net 2005

    Hi Can Any body help, I have a few crystal 11 reports which use dynamic prompts to get the required select. I have started building a small app in visual studio 2005 / vb.net. the data is stored in a couple of tables in sql2000. When the reports are run wihin crystal developer the paramatised...
  17. tonygr

    importing csv datetime problems! Please Help

    Hi All, Sorry to reserect this thread. I am still having problem with the date(s) (above mentioned) has anybody got any further, in there knowlege of ssis that can help with this one. proving to be a real pain. Thanks Again Tony
  18. tonygr

    problem populating a field in another table from a dropdown list

    can anybody help me with a insert command? Thanks in advance Tony
  19. tonygr

    inserting selection into another table from a dropdownlist

    p.s. I should have added this related info + code. on the form in design view the when the combo is highlighted it produces a arrow top right, click into this then tick databinding mode Data Source = centredescriptionbindingsource Display Member = centre_description Value member =...
  20. tonygr

    inserting selection into another table from a dropdownlist

    Hi All, I originally posted the below in the vb.net forum, but it may be more relevent in this forum, please help. Hi All, Can Anybody help, I have a sql_2000 db which has two tables, I am using vs.net2005 (VB.net) as a front end. I have a form with a drop down box on it, populated from...

Part and Inventory Search

Back
Top