Recent content by croydon

One further point, when I take the option to Unprotect Sheet in 97 it asks for the password, which I duly enter. If I then save the spreadsheet, close and re-open it, it still offers 'Unprotect sheet' under Tools|Protection. When I take the option to Unprotect Sheet in 2003 it asks for the...

I'm not sure that this is the case. On both 97 and 2003 the Tools|Protection offers: - Unprotect Sheet - Protect Workbook - Protect and share Workbook This gives the impression that the Sheet is protected not the Workbook. I understand that ranges in the workbook can be protected, but the...

After some more investigation I found that the Excel97 version does not require a password. However, when the sheet is opened in 2003 and then saved, a password is required next time it is opened. This must be due to enhanced security in this version. Unfortunately, if the password is issued to...

The problem is that every time they open the spreadsheet they get the messagebox: '... is protected' Password:

I have been given a Excel 2003 spreadsheet to support. This was originally developed in Excel 97. In Excel 2003 it requires a password when the workbook is opened. Apparently this was not the case in Excel 97 (I assume because of some Excel setting). Could somebody give me some guidance on how...

ca8msm, I think I have the answer. In my row of buttons, instead of using a web form button for this function I have used an HTML button. There is no other functionality required other than re-displaying the previous selections and (unless I'm missing something) this seems to work ok.

Thanks ca8msm. I tried this but I had no OnClientClick event on my asp button. I then found an article that said this event is only available in the 2005 version of VB.NET. Is that correct? I am using VS.NET 2003.

Could someone please tell me how I can simulate using the Back button in IE. I want to give users the option to go to the previous page, either to re-start with a clean selection or modify the existing selection (i.e. the Back button). From what I have read, the answer seems to be to use...

I'm using VB.Net.

Could someone please tell me how I can simulate using the Back button in IE. I want to give users the option to go to the previous page, either to re-start with a clean selection or modify the existing selection (i.e. the Back button). From what I have read, the answer seems to be to use...

earthandfire, thanks for your suggestion. My dollars amount is now correct, but unfortunately my cents appears to be rounding up. The following are the amounts in the table: 1124.38 8549.85 1234.56 1254.98 -------- 12163.77 The dollars correctly shows 12163 but the cents result is 8 (I...

I now have this working using ADODB. For anyone that's interested, my code is: Dim conn As New ADODB.Connection Dim cmd As New ADODB.Command Dim Para As ADODB.Parameter Dim intResult As Integer conn.ConnectionString = "driver=SQL Server;server=SERVUK;Database="Claims;" conn.Open...

This is almost working perfectly. The only problem I have now seems to be Rounding. The line of SQL code is: @cents = SUM(CAST((dbo.tblTreatment.ChequeValue-CAST(dbo.tblTreatment.ChequeValue as int))*100 as int)), An example of the problem is: 235.63 + 5689.23 = 5924.86. But @cents = 84 I...

Thanks for the replies. JerryKlmns, if I were to run this from within SQL Server, the command would be: EXEC sp_SendBatch @Batchid, @Status OUTPUT Using your method, do I need to specify the second parameter as Output, and how to I access the value that is returned? Thanks.

I am working on an Access 2003 database with a SQL Server 2005 back end. I need to run a SQL Server Stored Procedure that requires one input parameter (to run a process) and an output parameter to show whether the process was successful. I have created the SP and pass thru query but I cannot...