Recent content by kwatai

Hello, The subject says it all but I'm looking for some way to escape all special characters for SQL. I'm taking direct input from the user, and composing SQL statements but special characters are screwing up the parsing and craps out. I'm sure its come up before, but I can't find the code for...

Dear great one, I have your answers, so listen carefully. Right click on the control and select Special effects. The last box to the right is what you seek. From the great one

Easy question... hopefully. I need to print out a copy of the form printer friendly so I'm making a report version of the form. Although not necessary, I need to have the fields underlined regardless if the field has something or not. Not only that, they need to be lined up so they look nice...

I'm simply being spoiled by convienience so i'm getting lazy thx anyway

Wishful thinking here. I'm making an error log and I was hoping to populate it with where the error originated. Hoping there is something like a call stack function that I can tap into that allows me to pump it into a record. So in short, is it possible for the code to figure out what...

currentdb.Synchronize strDbName, dbRepImpExpChanges the above code will sync the local db and the remotedb(strDbName being the path) when executed. Its vb so you have to put it in the module. To run it automatically, just plug it in a form that gets loaded automatically at the beginning... if...

The subject says it all, how do I escape quotes in a quote. For example msgbox "You entered "" & Name & "" as your input" and it should come out You entered "Jon" as your input Its so easy in C but can't figure it out in VB. Also, how do you specify a new line? thx Kenta

Thats actually not a bad idea. Thx for the input. And sorry for not mentioning the continuous form part... wanted to make the situation as simple as possible. Kenta

Yeah, i thought so. But from my understanding this thing really doesn't work when you've got a continuous form. It seems that all unbounded objects acts together, so all calculations are actually just the result of the first one. Plus, onCurrent applies to only the current form so unbounded...

First post, so go easy on me I have a field in the table that needs to be filled up with American Dollars. However, the user is going to be seeing and entering canadian dollars. For the seeing part, I can have a calculated expression by muliplying the data. However, for the input part I'm...

Hello MSUKevin, quick question actually on that currency stuff. You might have already filled it. I have a bounded field containing american dollars. However, I have to be able to change it to Canadian with a click... something like a option button or something. Easiest solution is to have an...