Recent content by 007700

Function Collect_DIAGTable(MyAltCommand) Dim X Dim S Dim E Dim LOD Dim Serialnumber Dim Partnumber on error resume next Collect_DIAGTable = "" If Len(MyAltCommand) > 0 Then Cmd = MyAltCommand Else Cmd = "show diag" End If If EnterCmdSingle(Cmd, 1, 0) = False Then Exit Function...

Hi there, I am currently writing a script that will analyse the output of a cisco device. From the device I get the output of the Show Diag command. It produces something like show below. VHN_1101_1#sh diag Slot 0: Combo 2E, 2W Port adapter, 4 ports Port adapter is analyzed...

Brilliant !!!!!! There are no other words to describe this ...!!!! Thanks

Hi there, I am looking for a way to arrange ip numbers on a form. I have got a form containing txt boxes with IP numbers. Each text box contains 1 ip number. When I try to arrange them now, this is the result I get: 10.208.148.129 10.208.149.129 10.208.15.129 10.208.150.129 10.208.151.129...

Hi there, I am trying to get this to work in a textbox on the form. I knwo it looks messy, and it might nog be according to standards but it's the only way I can think of to get it to work. The only thing is that I think (at least Access things it) that I am missing a "[" or a "("... Any ideas...

Well it keeps op giving me #Name? as result..... and I can't seem to find out how to fix it..

Hi there, Could anyone tell me what is wrong with the following statement ? I don't seem to be able to find it.... iff((([Eind maand]-[Instalatie_datum]-[aantal_dagen_deze _maand])+1)<=0,"true", "false")

Some more info. For exmple: First I select from A combo: February Then on my form it will display me alle the info for February. What I want is that it will also display all the info for January....

M_ID M_nr Name Begin_date End_date Nr_days 1 1 Jan 1-1-2005 30-1-2005 30 2 2 Feb 1-2-2005 28-2-2005 28 3 3 Mrt 1-3-2005 30-3-2005 30 This is how the table looks. I was hoping to do something via subform's....but I can't seem to tackle it...... any help is greatly appreciated....

Hi there, This is what I would like to do: I have got a form displaying me information from a table. Bassed uppon that information I would also like to display the preceding record on the form. For Example: I a table with months when I select February, it must automatically look into the...

This should do the trick and is all the functionality I need. If you could provide me with some code, that would be great !!! You don't have to worry about the start en end of the record.....I have got that one covered.. Thanks in advance

Question, maybe anyone knows a nice and easy solution. I have got a form bassed uppon a table wich is filled the months of the year. Now I have a form with a combo via wich the user can select a month. That all works fine. The thing I would like to do now is show on the form in text boxes...

Hi there, A strange thing. What I would like to do is this: I have got a table with the number of the month, name of the month, number of days in a month. With this I want to create a form creating a combobox of the name of the month. When changing the name of the month via the combobox I...

The $B9 is a date value that the user has to select from a drop down list.

Hi there, I have created a complex formula in Excel and need to apply it in a query/report in Access. Now have I never applied such a formula into access and am therefore unsure on where to apply it. Could anyone help me on where / how to apply the formula ? It's about calculating days of...