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!

  • Congratulations TouchToneTommy 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. 007700

    Looping trough array looking for matching words

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

    Looping trough array looking for matching words

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

    Arranging IP numbers

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

    Arranging IP numbers

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

    Problem with IIF

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

    Problem with Iff

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

    Problem with Iff

    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")
  8. 007700

    Preceding record

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

    Preceding record

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

    Preceding record

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

    Previous record

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

    Previous record

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

    Auto update fields

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

    Complex formula

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

    Complex formula

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

    Searching trough more than 1 column

    Thanks PH, That did the trick for me...... The solution I was looking into was far to difficult, and this gave me the same results.. Thanks
  17. 007700

    Searching trough more than 1 column

    Hi there, Maybe my problem is very simple, maybe not bur I can't seem to solve it. I have created a query that will look trough a column for a value that I give in. I do this with the statement Like '*' & [What is the IP?] & "*" in the criteria field. I would like the search to look...
  18. 007700

    Search trough IP table

    I mean I only could get the search to go trough one column. Iff it could be done via query much the better...... What I did was I put the following rule in the criteria field. Like '*' & [What's the IP ?] & "*" This enabled me to look trough one column for a peace of an ip number. What you...
  19. 007700

    Search trough IP table

    Hi guys, I am looking for some good help. What a would like to do is create a search function that will look through one entire tabel filled with IP adresses. This table exisit out of multiple columns. I would like the search to go trough the entire table and in the end list me all the values...
  20. 007700

    Searching on date

    Hi Guys (girls), I am pretty new to this, but I have a problem wich I can't seem tot tackle. I need some advanced help. What I would like to do is create a search that will go trough one table called tblIP_Sheet. This table is filled with loads of IP adresses. I am looking for a module that...

Part and Inventory Search

Back
Top