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

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

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

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

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

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

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

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