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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PotatoTang

    Export a recordset to an Excel

    yes, thanks Andreas, I would try it Yes, I am using ADO to get the recordset from SQL Server. CCLINT, how to do a bulk export to an Excel file? thanks a lot!
  2. PotatoTang

    Export a recordset to an Excel

    Hi, I would like to ask : Other by using a looping to export record one by one to an Excel file, is there any quick method which can export whole recordset to Excel at once? Thanks
  3. PotatoTang

    Textboxes, how do I limit entries

    hey johnwm, u can assign your desired in the value "strValid". For example, if the textbox is just allowed to be entered "ABCDEFG", then set "strValid = "ABCDEFG". Then the text box is just allowing "ABCDEFG" to be inputted.
  4. PotatoTang

    Export a recordset to Access

    Hi, Is there any quick method to export a recordset (in VB) as a MS Access table? I just use a looping to export record one by one to MS Access table. I would like to know whether there is another method which can export all records at once. Thanks.
  5. PotatoTang

    Textboxes, how do I limit entries

    ' Place these code into Keypress event Dim strValid As String Dim i% strValid = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789" KeyAscii = Asc(UCase(Chr(KeyAscii))) If KeyAscii > 26 Then If InStr(strValid, Chr(KeyAscii)) = 0 Then KeyAscii = 0 Beep End If End If
  6. PotatoTang

    Put a Null value into SQL Server

    Hi, Do you know how to put a Null value into SQL DB date field using VB? Since once I issue "NULL" into SQL DB, it has been saved "1900/1/1" into the date field. Thanks

Part and Inventory Search

Back
Top