Recent content by canary

Just simple SUMIF functions. Worked ok in XP but not 2003. Just funny that if we save the sheets in Excel 2003 and change the Calculation option to Manual the #VALUE become the correct numbers.

Ken, Thanks for the reply. All the link files are valid files and plus we do need to update them upon opening. Just don't get it that the files worked fine in OfficeXP and now in Office 2003 just don't seem to work. Thanks!!!

Hi macropod, Simple ones just SUMIF. But if these are run on OfficeXP just the same they work, just after in 2003 just return #VALUE. Oh, as mentioned if I open those link source spreadsheets and just hit save they master file works. But surely this cannot be the final solution...

Hi, Macropod! Thanks for the reply. I wish it were that simple. I have been sratching my head about this one and just cannot understand why it is doing this. Any more thoughts or ideas? Cheers!!

Hi, I recently migrated from OfficeXP to Office2003 and upon openening my spreadsheets in Excel2003 those files with linked references to other spreadsheets only display in the cells #VALUE. However, if I goto those linked spreadsheets and open and save them then the #VALUE vanishes and the...

Hi, We run a macrotised spreadsheet that ran perfect in OfficeXP-Excel. We are performing some testing on Office2003-Excel and after the macros have run, when we try to paste in Excel we keep getting the message "Cannot Empty the Clipboard" Anyone have any ideas/solutions? Thanks!!

Hi, I just downloaded the Free SQL Server 2005 Express Beta 2.0 from microsoft. I have been trying to connect the SQL Server default "SQLExpress" endless times through the Server Explorer but with no luck. My .NET version is from 2001 will this make any difference? If I use the VB.NET 2005...

I've been trying to figure out how to use SQLConnection in .NET to connect to a Sybase server. Have been trying to read up on bits and pieces but nothing really explains how you can connect to them. Does anyone know what syntax I should use if I'm connecting to a sybase server i.e...

I was doing some testing using the ASP Application under VB.NET and created some Web Form Controls. However, when I went to view the page both in IE and the .NET browse mode. The web controls did not appear. Could someone tell me what is happening here and what I need to do to remedy this. I...

DotNetDoc, Many thanks for the tip and link. Thats a new one for me. I'll give that one a shot too. Thanks Canary

DocNetDoc, Thanks for the reply. However, I forgot to post the solution! I had originally declared the array as "Friend Product() as Object" and to set the size of the array I used the ReDim statement. Using this way always brought me the memory exception error...

In VB.NET I have a form that stores data into an array while it is loading. The form is a child form. When I click on the toolbar button to open it I keep getting the following error: An unhandled exception of type 'System.OutOfMemoryException' occurred in system.windows.forms.dll Additional...

I wrote a piece of testing code using an oleDB connection to connect to a sybase database (code as follows): Imports System.Data.OleDb sub connect() Dim PipeCon As OleDbConnection = New OleDbConnection("provider=sqloledb,data source=ABC_TEST," & _ "user...

We have been running some access applications, that call stored procedures on Sybase, under WinNT for a very long time now. Just recently we moved over to WinXP and all of a sudden those processes (calls to the stored procs) now prompt the user to login around 5-10 times instead of the once as...

Hi, I have created an automated print job that generates X amount of Microsoft Access XP Reports and creates them as PDFs and posts them to a web site for viewing. However, I recently upgraded to WinXP and found that everytime the PDF posts it prompts for the "Save As File Name&quot...