Search results

thanks for finding that spelling error, it's corrected, but still the strtrans does not get the value passed in this line : " strtrans = Me.Ingavedatum.Value strtrans = strtrans & "ac" & DCount(strField, strTable)" :(

Becaus they were first strings, that's why. (For me it's stil code that's not finnished, once the shit works i will change it) About the docmd thing, my access does that, i am not a programmer, so how the heck can i now it's then years old. ;) My whole project is made in access 2000 and i am not...

Ok, have to admit, i did not say which variant is not getting the string. Its the strtrans that's not getting the value. The query does run

Hi guys, this worked under access 2000, but not anymore under 2003 "strtrans" is not getting the value. I can't find what's wrong, tried string, defininf them in a module. Nothing. Anybody any idea why that is? Here's the code: Dim strTable As Variant Dim strField As Variant Dim...

Ok, i found out after 1 day of trying that the sequel runs fine until i add tblKlanten.Tel. When the customer has no phonenumber, it's empty when the recordset hits the rs!Tel it returns the error 94. Anybody a clue how i can get rid of that? Please :) thanks

Nobody any clue as to why? Am realy stuck if this don't work. thanks

Yep, the schalke ruiters Nope, now get compile error syntax error

Ok, tried realy allot, anybody can help find what is wrong with this code? [Klantnummer] is a listbox on my form with all the customer numbers in it. in my table it is saved as text. Thanks Private Sub Klantnummer_Change() Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As...

thanks, fixed.

when the database is opened strJaartal gets a value from the database preferences, although this doe not seem to work anymore either.

thanks for finding that error, String has value now, but not everything is passed. Only lngNum is passed and the "CC". The "0" or "00" are not passed. Any idea?

Hi, it worked in acces 2000, and now am using acces 2003. Anybody any clue why the string strVoorstel would not get the value? It just returns nothing. here's the code: Dim strVoorstel As String Dim lngTel As Long Dim strQer As String Dim strDa As String Dim lngNum As Long strDa =...

thanks man!

Tried that before, but nope, still getting all the same result.

Hi, I have a table with training records. Each attendee is listed with date and the related document he was trained on. Now i want to make a listbox where the user can choose between the different dates of the trainings. Now when several people where trained on the same day, i get some dates...

thanks, would never thought of that

Hi, This one is a pain in the but. I tried everything, but why would it just won't work. It always says the query is to complex. Have included the database, anyone a solution? Thanks

Hi guys, maybe this has been asked someowhere before or it's a realu dumb one. But can't find it out. I have a listbox that brings up a record in a form. It contains brand, type, kind and serial number. It gets it from my table. When i look at the table, brand, type, ...etc are all filled with...

still an error Peter Now it's complaining about the querydef. oh, what can life be a bitch when something don't work ;)

Thanks Peter, But still the same error. Can't figure out what is wrong? if have almost the same function running for sending email and that does work perfect. qerkal1.Datum is a field in a query where i want the date in "lbDag1" (text label)to be compared with. Still saying, not enough...