Hi Lynn, After I posted last thread, I looked at that code statement very closely and I found the mistake in that code staement (i. e. Changed "Item" to...

Hi Lynn, Thanks for your nice response.

I know the problem is in that code statement as you pointed out. But I don't know what I should do to correct...

Hi pthrope, Thank you for your response.

I am the owner of SQL Server Express/SQL Server Management Studio Express (SSMSE) and MS ACCESS 2003. What do you mean by...

Hello Matt,

VB 2005 Express does not have the wizards as VS 2005 has. And all the databases (including my ChemDatabase) in SSMSE are not instance-specific. These 2 things make me...

Hi Matt,

Calling the stored procedure (Pivot Table or CTE) from the ADO.NET 2.0-VB 2005 Express is the first step. Getting the Connection Class, the Command Class, the Parameter Class, and...

Hi Matt, Thanks for your response.

I am confused now about doing SQLCLR on SQL Server 2005 Express via Visual Basic 2005 Express. Today, I saw a statement "...

Hi Joe,  Thanks for your response.

I used myComputerSQLServerName without "SQLEXPRESS" to run the old project that was copied from the website. It ran and it passes through the code statement "connection.Open()". But...

Hi Joe, Thanks for your response.

I tried all the options you asked me to do/change the connection string and nothing worked for me.  Let me show you what errors I got:

1) If...

Hi Cory, Thanks for your response.

1) I tried to type your VBA code and I got a Compile error: syntax error  on the code statement  .Parameters ("@year") = '1995' - the two single...

Hi Cory, Thanks for your kind response and valuable code for doing the "Rotate a Table" in Access 2003.

I tried to do it as you instructed. First I did write the VBA...

Gentlemen, Thank you for your responses and help.

I mimicked the programming code statements in Pages 605-607 of the Book "Programming Microsoft Office Access 2003" by Rick Dobson to do this Access 2003...

Hi mkeast, Thanks for your response and wonderful source code.

Your source code worked nicely in my Microsoft SQL Server 2000 (Developer Edition) Query Analyst. I am a new comer in...

Hi R. Brush,  Thanks for your response.

I found an error in the script of my stored procedure in Access 2003 Queries:

ALTER PROCEDURE dbo.[Year_In_@year_In_out-return]

AS SELECT Year, Quarter, Amount

FROM dbo.QTRSALES

WHERE (Year...

Hi Marc, Thanks for your help.

I did add that statement as you suggusted. And that problem was solved.

I proceeded to execute the project and modified the code statement " Set prm3 = cmd1.CreateParameter("year",...

Hi Richard,

Thank you very much for your valuable information and technical insight.

I am very new in doing Access 2003, SQL Server 2000/MSDE and VBA programming. But I have to have...