Search results for query: *

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

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

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

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

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

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

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("[" &...

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

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

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

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

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

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

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

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?!?!?!?

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

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