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 Chriss Miller 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: *

  • Users: Thijs
  • Order by date
  1. Thijs

    Network routing problem...

    Hello! I have a problem with configuring my "network". I have the following setup: adslmodem/draytek 2200e router/w2kserver+dhcp/network The modem is just a pass through object. Is connects to the draytek router. Which is a relay agent. The modem has a fixed IP on the...
  2. Thijs

    Network, DHCP, Server, Router problem...

    Hello! I have a problem with configuring my "network". I have the following setup: adslmodem/draytek 2200e router/w2kserver+dhcp/network The modem is just a pass through object. Is connects to the draytek router. Which is a relay agent. The modem has a fixed IP on the...
  3. Thijs

    Combobox Lookup doesn't work.

    Thanks for your advice. But I made a stupid error :-( I simply needed to type the following: Me.soe_nummer.Value = Me.Combo30.Value And the combo selects id+lastname... Thanks againt though. Grtz, Thijs Kromhout
  4. Thijs

    Combobox Lookup doesn't work.

    Hi all, I've got the following problem: I have a form which selects data from table "bewoner". The only problem is that you can only search on bewoner_id. But I also want to be able to search on bewoner_achternaam (=lastname in dutch). What I did is the following. I made a combobox...
  5. Thijs

    Password update doesn't work - Module error

    Well what I tried is the following. I made some changes in the tables. In the old db employee ID was AutoNumber --> Long Integer. I reset that to Text. And Access then gave the same error. txtEmpID is no longer number but text. So is that where it is going wrong in the module? Somewhere...
  6. Thijs

    Password update doesn't work - Module error

    What the strangest thing is. This module I got from another DB. Exported the module to my new db. Even the from I copy/pasted. In the old DB it worked just fine. Do you have to do something 'special' when you import a module/class???
  7. Thijs

    Password update doesn't work - Module error

    It still wont work :-( He now keeps hanging on this peace of code: ************ ElseIf txtPassword <> txtConfirm Then MsgBox &quot;Password and Confirm Password do not &quot; & _ &quot;match. Re-enter one or both.&quot;, vbInformation, _ &quot;Warning&quot...
  8. Thijs

    Password update doesn't work - Module error

    I've tried but no luck :-( The debugger still points to: Call UpdatePW.NewPW(str1, str2) And the error message still remains... And I can't see what I am doing wrong...
  9. Thijs

    Password update doesn't work - Module error

    I put it in the code. But the error still remains. The exact error is: Run-time error '-2147217904 (80040e10)' No value given for one or more required parameters. Any other idea???
  10. Thijs

    Password update doesn't work - Module error

    Hi! I've got the following problem. I have a form on which users can change their password. On this form there a submit button with the following code: ********************* Private Sub cmdSubmit_Click() Dim UpdatePW As New MyTestClass3 If Me.filledCheck = False Then MsgBox...
  11. Thijs

    Query result as validation??

    Katho (Vincent), I made a mistake in writing my question. The query makes a SUM of a row with money figures. The query does this per user. e.g: User01: SumTotal = 95euros User02: SumTotal = 110euros etc. Query results are: User_ID | Sum of vergoeding User01 | 95 If the total sum exceeds 100...
  12. Thijs

    Query result as validation??

    Hi all, I've got the following question: I have a query which calculates the sum of a field per user. In the form where the query is used there is a button &quot;new&quot;. When this button is pressed the query runs. When the result is >= 100 a msgbox has to come up with a message (of...
  13. Thijs

    Click on subform gives record in mainform

    Thanks a lot. I've searched for the right code. And it seems to work for now! Muchos gracias :-) Grtz, Thijs Kromhout The Netherlands ps: it is the following code: Private Sub Form_Click() Dim rsClone As Recordset Set rst = Me.RecordsetClone Forms!terugkeer!afspraak_id.SetFocus...
  14. Thijs

    Click on subform gives record in mainform

    I've got the following problem. I created a mainform with some fields on it. In those fields people can fill date, time and location. The primary key consists of date/time/user_id To make selection in the future more easy etc I created a field afspraak_id. Just in case. Now I have this subform...
  15. Thijs

    Refresh/New Button doesn't work entirely

    Hello, I've got the following problem: I have a form which is place on a tabpage. In this form there are several textfields. These fields are divided into two groups. Furthermore there are two buttons. If button one is pressed then 3 fields get a lock and a different backgroundcolor. If...
  16. Thijs

    Have combox look-up record?

    DAG, I will certainly try this solution! Thnx to you and &quot;petrosky&quot;. :-) Grts, Thijs Kromhout
  17. Thijs

    Have combox look-up record?

    LS, To begin bluntly, here is my problem: I have a form with a subform on it. On this subform is a set of fields belonging to one table. Furthermore there is this combobox which looks-up the last name&quot; in the table (it is a table with a doctor name, address, etc) How do I, when I select...
  18. Thijs

    How do I calculate time average?

    Brian, One word: YEEHAA!!!! Thijs :-)
  19. Thijs

    How do I calculate time average?

    LS, I have a mdb with several fields. One of the fields contains the duration of a telephone-call. What I want to do is to calculate the duration of all calls per day. But the average function is working voor a time format. I've tried to convert time --> number but that didn't work either...
  20. Thijs

    How to delete Crystal Report reference?

    Dear J.Jones, Yeehaa!!! Finally got on a pc where I actually access the register ;-) They dont know so keep it quiet :-) But it worked! The error doesn't appear anymore... :-D Thnx for your help anyway... Grts, Thijs Kromhout The Netherlands.

Part and Inventory Search

Back
Top