Search results for query: *

There is an Add-In called Smart Indent that works in Access and Excel. I'm sure it will work in VB6 too. http://www.oaltd.co.uk/

I am having the same problem so if you find a solution please let me in on it too. Thanks,

If you have two text boxes with one being txtFind and the other txtReplace you could update the database with the text in txtReplace after you have done a search for txtFind. Then if you wanted to undo it you could now update the database with the contents in txtFind where the database field...

You could put three option buttons on a frame and the other three on another frame.

Thanks for the other products chiph. My manager does see the need for some kind of control so when I said I was trying to push them that way it was really just a suggestion that we use SourceSafe. Thanks again and I will check the other ones out. Joe46

I started a new job a couple of months ago and have been dismayed with the lack of any type of safe handling they have for their code. I tried to push them toward SourceSafe in order to have something to fall back on in case something goes wrong with the file they are working on, but they do...

Have you tried running them with the execute method of the command object? Joe

My guess is it would take a performance hit since you would be maintaining more than one connection.

Sorry, I haven't used it. I was looking through my book "Visual Basic Oracle 8", when I came across this statement: "Next Recordset: Clears the current Recordset object and returns the next Recordset by advancing to the next in a series of commands." Like I said, I was just...

Yes, you can have multiple recordsets with Oracle, although I don't know what is causing your error. Just wanted to let you know that it is possible to have more than one recordset.

If I understand what you mean then just hold down the SHIFT key before you open it.

Okay, even though no one else has had this problem I will post the solution in case it happens to you. All I had to do before I executed the SQL statement was to put a begin.trans, execute the statement, and then commit.trans Thanks to anyone that looked at the message and gave it some thought.

I remember having this problem about 4 years ago and it was something simple. I thought then that I would never always remember what I was doing wrong, but "NO!" I take it no one else has ever came across this situation before?

If I put a break point at the end of a SUB that is populating a database in Access and then viewing the printout in CR all the data shows up. When I run it without any break points it misses one record in CR although the data is in my database.

I'm not sure, but maybe the machines where the error is does not have the same MDAC installed.

MyFunction(Optional myString as String) AS String

Thanks for your quick reply. I tried DoEvents like you suggested but that didn't work. Thanks again for your help.

I have a web page created with VB that uses stored procedures in SQL Server 7. The web page has been running fine so the user wanted me to add a DateApproved field on the form. The problem is while running it will not update the field, but if I step through it runs fine. I do not receive any...

I think you need to use val like this: txtTax.Text = val(txtMatTot.Text) + val(txtPadPriceTotal.Text

I forgot to change the name of my labels. They should be: Label1.Caption = X Label2.Caption = Y Joe