Search results

thanks ... but single ' is the single problematic char?

lol I feel stupid :) thanks!!!

so just to see if I understood if I use """ & textbox & """ will it solve me any problems with special chars like ' ^ etc ???? Ben

hi :) I do have combo with two columns the first - it the key value and the second his the title is there any way, when user chose option to save the key value in the database but on the other hand, to show in the combo the title, the second column? thanks!! Ben

hi, if I use double "".. will it accept any parameter? dbs2.Execute " UPDATE production_diary SET [quantity_pro] = " & Forms!output.Controls("mach_" & i).Value & ",[excapp]=""" & Nz(Forms!output.Controls("ex" & i).Value, 0) &"";"

take the word "need" in the first quote and replace with "am forced" sorry about my English I need it comes changes into effect immediately after the condition exists and according your solution i'm still forced to click on any enabled textbox.. and just after it the event occurs...

if u say " ' " it's the only special char which can make a troubles with sql, so I can use replace, but I don't know if it's the only one thanks :)

I want avoid use of any special chars

hi :) I understood char like " ' " makes troubles with text box and sql I would like to make a validation function which checks if the textbox contains special chars and asks the user change his input thanks :)

thanks Is it supposed to work in Access?

thanks my darling :) it's same affect like when it was as update event :( I need to click on any enabled textbox.. and just after it the event occurs

hi :) there is any way in access make "predominant" pop up form ? I mean when the form pop up, it will came front of all windows which open in the computer (not just access windows)? thanks! Ben

hi :) I created BeforeUpdate event for "coiltxt" in unbound form (so until user click for saving it, I cant do reqeury): it checks If Not Me.tempcoil.Value = Me.coiltxt.Value Then and if it exists, it runs all over the other textbox and makes them enabled but I found the changes do not...

thanks! I changed it to Variant for all optional but i'm afraid... if it's a Variant , can it deal with dates well??? Ben

hi, I made this function: Public Function blokingmain(Optional indexm As Integer) If IsMissing(indexm) Then.... .... and I call this function: call blokingmain but it doesn't make indexm missing it assigns 0 to indexm why? how can I avoid it? thanks Ben

I indeed tried DateAdd ( "y", -DatePart ( "y", date), date ) start of year DateAdd ( "w", -DatePart ( "w", date), date ) start of week

I understood how I take apart dates but how I combine them to new one date?

0. based on the current date 1. Midnight 2. Sun thanks!

hi :) please, what are the most elegant ways to do those? *from now to accept the date for start of the day *from now to accept the date for start of the week *from now to accept the date for start of the month *from now to accept the date for start of the year thanks u Ben

thanks my friends! hugs!