Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DeltaTech

  1. DeltaTech

    Creating an Access table programatically

    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...
  2. DeltaTech

    Creating an Access table programatically

    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!
  3. DeltaTech

    SQLServer transactions?

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

    SQLServer transactions?

    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...
  5. DeltaTech

    SQLServer transactions?

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

    SQLServer transactions?

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

    SQLServer transactions?

    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...
  8. DeltaTech

    Button click event fires twice

    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...
  9. DeltaTech

    Button click event fires twice

    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.
  10. DeltaTech

    Database connections

    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...
  11. DeltaTech

    Form (On Return) -Run A SUB

    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]
  12. DeltaTech

    Printing a picture using the Printer object

    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]
  13. DeltaTech

    Where have all the good people gone?

    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...
  14. DeltaTech

    -2147221231 Automation error (XML + VB)

    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...
  15. DeltaTech

    Where have all the good people gone?

    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]
See more

Part and Inventory Search

Back
Top