Recent content by lovehuman

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

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.

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

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

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

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?

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

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

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

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

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

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

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

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

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.