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!

  • Congratulations Mike Lewis 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. lovehuman

    XML and ADO

    Hi, I have a file which contains data in XML format. I want to create ADO recordset out of it and then display the data in the datagrid. How is this possible? Any help will be appreciated. Thanx
  2. lovehuman

    alternative to form scrolling?

    Ed, You are not creating the label or text box on the sstab control. Place the controls directly on the sstab control. If you place the controls on the form and then drag them on the sstab control, the control will be visible on all tabs.
  3. lovehuman

    LOOKING FOR DATABASE SAVVY

    If you are planning to insert more data into this table, then in the long run you might jump into problems. The only problem is crashing of database. Access database easily gets corrupted. But you can always repair the database :) If your database grows very fast then it could be a problem in...
  4. lovehuman

    alternative to form scrolling?

    You can change the height of the form at runtime by using following code in the form load event Private Sub Form_Load() VScroll1.Max = 32767 Form1.Height = 30000 End Sub
  5. lovehuman

    Distributing Folders how can I do it

    You can set the locations of your file to be installed. If the directory you specify does not exist, setup wizard will create it. This option can be set in 7th or 8th screen in PDW. It shows "Install Locations" in the forms title bar and you can type the locations in the list view...
  6. lovehuman

    alternative to form scrolling?

    The maximum value you can set for Scroll bar is 32767. Try using this piece of code Private Sub Form_Load() VScroll1.Max = 32767 End Sub I hope I understand your question right? R u talking about form'e height or scroll bar's maximum value?
  7. lovehuman

    alternative to form scrolling?

    Use this piece of code to scroll the form and change the value of MAX property to whatever u need Let me know if it works :-) ------------------------------------------------------------ Dim VPos As Integer Private Sub VScroll1_Change() Call ScrollForm(0) End Sub Private Sub...
  8. lovehuman

    .NET - Hailstorm : Where Microsoft is taking us???

    Read this guys: http://www.microsoft.com/net/hailstorm.asp
  9. lovehuman

    VB MCP Exam Questions?

    Hi, Where can I find some sample questions for VB certification exam? thanks
  10. lovehuman

    Cool C# Examples

    For those who want some examples for C# Follow the link: http://msdn.microsoft.com/theshow/Episode008/Richter.html
  11. lovehuman

    Visual Basic.NET

    For those who want to have a first look at Visual Basic.NET Follow the link: http://msdn.microsoft.com/msdnmag/issues/01/02/vbnet/vbnet.asp
  12. lovehuman

    Problem assigning SQL statement to ADODB.RecordSource property

    Yes Boss, you are right the quotes are muddled up b'cuz i tried to make it simple for u. The string should be: mYear = "199" "Select * From employees R Where R.hiredate LIKE '%" & mYear & "%'" And for your information if you write SQL for MS-SQL server you cannot...
  13. lovehuman

    Modify Registry

    Try the sample code at this link: http://www.planetsourcecode.com/xq/ASP/txtCodeId.10479/lngWId.1/qx/vb/scripts/ShowCode.htm let me know if it helps...
  14. lovehuman

    Problem assigning SQL statement to ADODB.RecordSource property

    I tried this with Northwind database and it worked perfectly fine. Select * From employees R Where R.hiredate LIKE '%' + '199' + '%' See if it works for u
  15. lovehuman

    glipuma

    Update your data access objects (MDAC). Install Visual Studio Service pack 4 or Service Pack 5. Or you can download DAO directly from the internet.
  16. lovehuman

    Problem assigning SQL statement to ADODB.RecordSource property

    Try using single quotes instead of double quotes
  17. lovehuman

    defining coloumn size in a datagrid

    Use this code: Dim mColumnWidth As Integer For i = 0 To (DataGrid1.Columns.Count - 1) Select Case i Case 0, 2, 4 mColumnWidth = 2000 Case Else mColumnWidth = 500 End Select DataGrid1.Columns(i).Width = mColumnWidth Next Hope this will help u? :)
  18. lovehuman

    How to give the shinning effect ?

    This is mind blowing guys ! Really these effects are great. Thank you so much for the links
  19. lovehuman

    How to give the shinning effect ?

    WOW thats really cool. What else can be done with text???
  20. lovehuman

    How to give the shinning effect ?

    Thanks Virt2001 and oldnewbie. Yes, thats exactly what I wanted. But i'll try to make the dot bigger Thanks

Part and Inventory Search

Back
Top