Recent content by DeltaTech

Hi RiverGuy Null doesn't seem to affect zero length, which after the table is created and you view it through Access is still set at No. Or is my SQL statement wrong? "CREATE TABLE tbl ([Column1] TEXT(255) NULL, [Column2] TEXT(255) NULL, [Column3] TEXT(255)) NULL;" The NULL at the end seems...

Hi While I know how to create the database and tables through VB.Net, I have not been able to find examples that show how to set the field properties. For instance, if we want to allow for zero length in a particular field. Any help would be appreciated. Happy New Year to all!

Hi Ryan The example you gave is what I was looking for. Thanks very much

Hi Ryan Appreciate the feedback. Yes it is an ASP.Net/VB.Net question, and you are right, I establishing a SqlConnection. I have searched online, but could not find anything that explained the SqlTransaction process in simple enough terms. (Sorry mate, I am a beginner and sometimes find it...

Hi markros Thank you for your prompt reply. Quote: "See BOL for details" Sorry, could you clarify/elaborate please? Thanks

Sorry, forgot to mention that I am doing this in ASP.Net. Thanks

Hi Can anyone help with SQL server transactions please? I have a number of updates to perform and want to commit the transactions only if all are successful. With ADO, all that was needed were ADO BeginTrans, CommitTrans and RollbackTrans Methods. Have searched the web, but nothing really...

Duh! Finally figured out why the button click event fires twice. It's a mistake that a beginner like me with no formal training will make. So, for the benefit of others who might encounter this problem, here is the solution: If we specify the OnClick event when creating the control, we do...

Hi When I step through my code, I find that it steps through the Button click event twice. It's a login form and once the user enters the user name and password, clicking on the submit button causes the code to execute twice. Can't seem to figure out why. Anyone can help. Thanks in advance.

A newbie's dilemma If opening a connection is resource intensive, and with ASP.Net we have to explicitly close a connection, when is it best to open and close? Of course, if you have just one procedure that retrieves data for display, then this is a non-issue, as you would open, retrieve and...

You could call the routine to TotalAll from within command button click as well like this: Private Sub Command1_Click() Load Form2 Form2.Show vbModal, me TotalAll End Sub TotalAll will only be called after Form2 unloads. [bigcheeks]

For those of you who use the printer object like I do, and need to print a logo or picture on the report, Microsoft's KB 175084 may be of help. http://support.microsoft.com/kb/175084/en-us [bigcheeks]

I do beg your pardon Mr BobRodes. There was no malice intended to anyone who responded to the posts, and in particular Tsuji. The gift horse, as you call it did not work, as if it did, I would not have reposted. I do regret, however, that despite reading both my posts, you chose not to respond...

Hi BobRodes Yes, I did try Tsuji's suggestion, but there was no joy. Tsuji was right in that I was being version specific, but even after I changed it, the same error came up. "the object you're trying to instantiate isn't supported in Windows ME" Tsuji is using WinME and it works, so I am...

I've been changing channels But I don't see them on the TV show Where have all the good people gone? Friends If any of you are familiar with VB/XML please, please give me a hand with the problem that I am facing. See -2147221231 Automation error (XML + VB) Thanks. [bigcheeks]