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 SkipVought 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: welshone
  • Order by date
  1. welshone

    inserting field name from a query

    thanks les, I understand !
  2. welshone

    inserting field name from a query

    unfortunatley I cannot change the structure. I have more fields I wish to display, so unioning the data will not work will it ? the data looks like : name access jan feb mar apr may ws 12 y u y n rt 11 u u ek 11 u y y y
  3. welshone

    inserting field name from a query

    hello all, how can I do this : I have a table with fields jan, feb, mar, apr, jun, and so on , in each of these fields is either a null or some value. I want to beable to run a query so I can input a month and bring back data for that month that is not null. something like : select [chosen...
  4. welshone

    update one table with data from another

    no there is no primary key. however, I think I've asked the wrong question, this is only one part of it, what I want toachieve is : if data in table1 can be found in table2 then update the information, if the data in table1 cannot be found in table2 then insert the data. the tables look like...
  5. welshone

    update one table with data from another

    hello, how can I update table1 with data from table2 where table2.field1 = table1.field1 AND table2.field2 =table1.field2 this is with ms access 2000 thank you
  6. welshone

    Excel Line graphs

    thanks, I will keep trying this, I think you are right about the formatting, my daa starts off in a database with the space as a varchar, I'll convert it to a number. thNanks for the help
  7. welshone

    Excel Line graphs

    my data looks fine, the drive space can be like this though : 22.50 18.88 36.00 but this shouldn't have any affect should it ?
  8. welshone

    Excel Line graphs

    I would need the data in a format like : server drive 12/7/04 13/7/04 svr2 C 10 10 svr2 D 80 82 testsvr1 C 40 44 testsvr1 D 50 50 like that.
  9. welshone

    Excel Line graphs

    the data I am hoping to see what be the true value for each drive on each date, then I could create a line graph mapping this info.
  10. welshone

    Excel Line graphs

    no mate, that hasn't worked. when I llok at my dat , I choose differnt field settings for the space only count displays data, every other function shows 0.
  11. welshone

    Excel Line graphs

    hi, I have tried that but it puts the space as count of space, I need to actual number.... how cna I do that ?
  12. welshone

    Excel Line graphs

    hello, hope someone can help me with a line graph. I am attached to a datasource that is a table setup like this : servername drive drive_space date testsvr1 C 40 12/07/2004 testsvr1 D 50 12/07/2004 svr2 C 10 12/07/2004 svr2...
  13. welshone

    accessing stored procedures

    hello, how can I use a SQL server 7 stored procedure instead of a table for my crystal report ? version 8. I am trying to connect via ODBC but can only see my tables, ( no SP's can be seen) thank you for any info.
  14. welshone

    running a Call from onclick

    doh. its been a lonnng day ! thanks.
  15. welshone

    running a Call from onclick

    I've tried this ,but its not working. I am submitting the form to the next page, I try to do a response.write request.querystring("servername") but nothing is there ?
  16. welshone

    running a Call from onclick

    server. my sub is : Sub GetServerDetails(servername, username, password) Dim oWMI Dim sURL Dim objLocator Dim strServer Dim strusername Dim strpassword strServer = servername strusername = username strpassword = password Set objLocator =...
  17. welshone

    running a Call from onclick

    so all my b and this is on next.asp ?
  18. welshone

    running a Call from onclick

    hello, I am trying to pass parameters from input boxes to some vb that I then want to run via a button onclick methos ,how can I do this ? so far: <BODY> <p><INPUT type=Textbox name=servername></P> <p><INPUT type=TextBox name=username></p> <p><INPUT type=textbox name=password></p> <INPUT...
  19. welshone

    access 97 calendar control

    fixed it ! looking on microsfot site there a problem with files registered if access has been upgraded from 95 to 97. specifically the calender control is not registered correctly. I have reregisted the correct verions (8) and now it works ! thanks for the help in pointing me in the right direction.
  20. welshone

    access 97 calendar control

    the users that are crashing have an older version ofthe calender control. how can I install the version 10 ? I have tried registering the version 10 ocx, the correct calender then appears in the activx list, but when I click on it and try to add the calendar to a form it crashes...

Part and Inventory Search

Back
Top