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 Rhinorhino 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. darrenhubbard

    Strange eigrp authentication behaviour

    I am testing some eigrp authentication and am getting some very strange behaviour. Three routers, each with an ethernet connection sitting on the same subnet. 1st router also has a serial connection connected elsewhere in the network. 3rd router has a loopback pretending to be a...
  2. darrenhubbard

    Check Box Unusual Behaviour

    Heh found a solution/workaround -- the checkboxes would respond as required to MouseDown events. So that's all-right then! Cheers for everyone's help...
  3. darrenhubbard

    Check Box Unusual Behaviour

    Hi All, I've added a few check boxes to a form to allow the user to turn off various bits of the database. However, the checkboxes are all enabled and unlocked and they don't even seem to be responding to their click events (I put in a simple msgbox to test this and it didn't appear!) Anyone...
  4. darrenhubbard

    Query Column Width (Newbie)

    Cheers, Tony that did it! I couldn't do it originally as I was missing out the ".Fields" bit.... so now I know! Cheers, Darren
  5. darrenhubbard

    Query Column Width (Newbie)

    OK, "stupid question time" as I'm sure this must be really simple: I've created a query through vba and I just want to specify the width of some of the columns within vba -- and I can't find a method to do it.... Thanks for any help! TIA, Darren
  6. darrenhubbard

    RunSQL Problem

    Quick update -- if I add an INTO [temptable] into the SQL it then runs fine. So, I can only assume that RunSQL won't launch a datasheet type view of query it's running (ie it has to "do" something). Does anybody have an alternative that will work? TIA, Darren
  7. darrenhubbard

    RunSQL Problem

    Hi All, I have the following VBA function: Private Sub TrafficButton_Click() Param = [Forms]![VAD]![TableSelect] If IsNull(Param) Then MsgBox "Please select a table from the drop-down list" Exit Sub End If Param = Trim("[" &...
  8. darrenhubbard

    Query / base case

    I think I muddled it up a bit with my first post. Basically, if you consider the applications table as I defined it above (with four entries for http, app1, app2 and webapp3) and the aux_total contains the following (relevant fields only shown here): 10.0.0.1 TCP 1100 10.0.0.4 UDP 7 1.1.1.1...
  9. darrenhubbard

    Query / base case

    Hi All, I have the following SQL query: SELECT aux_total.[Last Occurence], Applications.Application, aux_total.[Server IP], aux_total.[Server Port], aux_total.Protocol, aux_total.[Client IP], aux_total.[Server Total], aux_total.[Client Total], aux_total.[Total Number] FROM aux_total LEFT JOIN...
  10. darrenhubbard

    SUM Query

    Cheers guys! That did the trick! Takes bloody ages to run, though (about 10,000 records and some of those numbers and REALLY BIG). Thanks for all your help, Darren
  11. darrenhubbard

    SUM Query

    Hi All, A quick SUM question. This is a result of a query: Date From To Type Speed Quantity1 Quantity2 3/1 LDN NY A V 10 1000 4/5 LDN FR C Q 5 10 1/1 LDN NY A V 2000 300 I need to...
  12. darrenhubbard

    Left Join Query - URGENT

    It's OK people. not to worry -- I solved it about two minutes after I posted (and it was more simple than I thought...)
  13. darrenhubbard

    Left Join Query - URGENT

    I have a table with four fields (call them a b c z) and a very simple query that uses some custom vba functions. The results of this simple query is 8 fields (call them a b c d e f g h). I've written a Left Join query so field z gets matched into the other query AND so anything that doesn't...
  14. darrenhubbard

    OLE Problems

    Hi All, I've got a table with two fields: text and an OLE Object. I've designed a form that's meant to display these two fields. The text one (of course!) works fine but the Bound OLE refuses to display as an icon -- I've set it to icon but when the form actually opens it changes to...
  15. darrenhubbard

    Record Finding (Novice)

    I managed to fix the "type mismatch" error by removing the Dim rs as Recordset line (I rarely use Explicit anyway). And then it all works perfectly?!?!?!?
  16. darrenhubbard

    Record Finding (Novice)

    Cheer for that but I'm getting a "type mismatch" error on the OpenRecordset line... all I've done is made the line look like this: Set rs = db.OpenRecordset("MemberAdded") Where MemberAdded is a query. BTW, MemberAdded is a query on another query -- is that relevant...
  17. darrenhubbard

    Record Finding (Novice)

    Hi All, A real beginners question, and I'm sure it's really simple to solve, but it's driving me up the wall: Basically, I have a query and I need to be able to through it, record by record, and store various pieces of the data in a varable AS TEXT. ie. in verypseudocode: For i= 1 to...

Part and Inventory Search

Back
Top