Search results for query: *

Thanks for all youre help people :) I have solved the problem. The date fields and the numeric fields didn't need " or ' or & characters and that's what I did wrong. Thanks again :)

Hi Randy thanks for your help. But on both lines I get an error. On the first line I get a Syntax error in date, in query expresion #"# but when i change the order of the characters I still get a syntax error. On the second line I only get a syntax error with no discription why.

I'm using the following code to insert a record into my table. It's dutch code so I hope you understand :) And it's about the field dat_bouwdatum. On my form the field is not linked to the table because then the insert won't work properly. I tried the following but it won't work: In my SQL...

Hi PH, It's not working I get a compilation error that after the Null) Access needs a "=". Could you explain to me what this line does? Thanks so far.

Thanks for your quick help :). I have done it a bit different. I have used a check boolean to see if it was true or false and then i used it like you discribed above. But I still have the problem with the date field. I have tried to make it Null but I still get an error that Access could not...

Hi all, I have two questions: 1. I have a public procedure that i call in another procedure but in the second procedure I use a Exit sub but then it goes back to the first procedure but I would like to get out of both procedures. So that I return to my form. I hope that i'm clear. 2. I have...

Thanks for your help that solved the problem.

The problem is that it's not working. I will get an error on using that line. I get an error something like value doesn't match or something like that. And I wouldn't like to specify a field but I would like to use a variable for it. Hope somebody could help me out because I have tried it but...

Hi, I would like to do a search in a table with findfirst but I get an error for my criteria. What I would like is something like this: rs.fields(customer).value = search_value Where search_value is a value from a combobox. Hopefully somebody can help because I have tried a lot of different...

I found some good working code at: http://www.di-mgt.com.au/src/basCRC16.txt So this solved my problem. But thanks for your help.

I have found this code but I cann't get it work in VB6 I hope somebody could help me out :) 'This Function is used to format output from hex calculation 'Into a format of iwidth string. This is sometimes neccesary to return also the 'Hight order byte zero. Public Function FmtHex(ByVal i As...

Hi, I'm searching for a normal CRC16 code does somebody have a working version?

Thanks earthandfire and PHV, I have tried to put after the end if the line txtproject.Requery but then i get an error message that i can do this when i leave the field. But i cann't because then i get the error showed in my first post. And PVH I know that I made that Inner join because i...

Hi, I know there is a lot of posting here about this topic but I couldn't find a good solution. I will try to clear the situation. I have one form with 3 comboboxes that are all connected to each other with queries But now i would like to enter a new value in the second combobox project with...