Recent content by Thijs

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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