Comments by Dave the Golfer (Top 46 by date)

Thanks the change works

HCID is defined in the SWITCH loop. In this case it is P1HC.
I have inserted "P1HC" in place of HCID and I get a different error suggesting the data being returned is incorrect.
I have modified the code to
var hc = parseInt(this.responseText);
document.getElementById("P1HC").value = hc;
I now get an error stating ;
away12.php:81 The specified value "NaN" is not a valid number. The value must match to the following regular expression: -?(\d+|\d+\.\d+|\.\d+)([eE][-+]?\d+)?
The form element with ID P1HC is of type="number".
Suggest I have two problems.

Added alert(HCID); to code. Result is the alert states Undefined. So yes the HCID is not being set in the Switch loop.
Corrected SWITCH loop forgot to put CASE values in between "". Now have the Second problem to resolve.
Thanks for your help on problem one.
PROBLEM TWO:
Changed code in PHP file from $handicap = $db_field[handicap]; to $handicap = $db_field["handicap"];
Value being correctly transferred.

I do not only want to display the text but I must be able to read it again later when the checkbox is checked so I can update the data tables. If I simply put text in the cell how do I read it again to update the data tables?

Noticed that the validation is undertaken when the form is submitted.
But can it be done when the data is entered?

Thank you. Worked perfectly.

Looking further at the problem I changed my display resolution to same as my end user (1366x768). With this setting I can only see part of the form , in fact that part that my end user prints on the printer or creates as PDF. Which suggests that the command SCROLLABLE does not seem to work on his laptop.

Do not understand!

Unfortunately the setting of page size did not solve the problem. I thought that the Print to PDF worked but that proved to be incorrect as the PDF Print was the same as printing directly to the HP Deskjet 2540.

As it is a problem with both printers I am assuming that the HP printer is not the problem. It must therefore lie within the laptop! No idea where to start looking!!!

Unfortunately the setting of page size did not solve the problem. I thought that the Print to PDF worked but that proved to be incorrect as the PDF Print was the same as printing directly to the HP Deskjet 2540.
Need to get in touch with HP somehow, as I am not an HP owner.

Richard
Thanks I will look into that. I have now added a line of code to define the paper size. Need to test on my colleague's computer which I hope to do in the next day or so.

Having upgraded to 2017 I have managed to put my old code into a GIT repo. I have created a branch that allows me to progress in a controlled manner. Thanks for all your help I will now close the question.

Thanks for the references.
I am upgrading to Visual Studio 2017 to use GIT control.
Found this reference https://www.visualstudio.com/en-gb/docs/git/tutorial/creatingrepo which I think should help.

Richard

Thanks for the advice. All is working OK.

Maciej Los
I am working with Excel 2000. so as you state ExportAsFixedFormat will not work. I have a Microsoft to PDF virtual printer loaded on the laptop so I will use that.

Thanks for your considerable help.

Maciej Los
I have set all the constants and all seems to be working at this stage.
But and there is always a but.
I want to save the excel sheet as a PDf file.
In early binding my code is
osheet.ExportAsFixedFormat(Excel.xlFixedFormatType.xlTypePDF, Path & "\" & Filename, Excel.XlFixedFormatQuality.xlQualityStandard, True, True, 1, 10, False)
the late binding code I used is
osheet.ExportAsFixedFormat(dbTypePDF, Path & "\" & Filename, dbQualityStandard, True, True, 1, 10, False)
dbTypePDF is a constant as is dbQualityStandard both set to 0 (zero) but it failed.
Error message states Public member 'ExportAsFixedFormat' on type 'Worksheet' not found.
Am I right in thinking 'ExportAsFixedFormat' is a function of the Excel Interop?

Thanks for that . I have been looking for the enumeration values for the excel constants. Now I have them all I shall recode to late binding.

Thanks Maciej Los.
I was going to try late binding but that has produced errors associated with adding pictures to excel sheet and underlining and alignment.
I also have just added Visual Studio to the laptop so I can work on the machine with Excel 2000. I have referenced the project to Excel 9.0 Object Library.
The Class contains the following imports
Imports Microsoft.Office.Core
Imports Microsoft.Office.Interop
Imports Microsoft.Office.Interop.Excel

but I get Excel.Application etc declared as not defined. Do not know what to import for Excel 9.0 Object Library.

I change the code to
oRng = oSheet.Range("A1", "H1")
oRng.MergeCells = True
oRng = oSheet.Range("A3", "H3")
'oRng.Value = "Medford Competition"
oSheet.Range("A3").Value = "Medford Competition"
oRng.MergeCells = True
It failed with same error message on the last line.

ppolymorphe
Tried your suggestion but got the same result.
Certainly looks like Excel 2000 is different to Excel 10.

Thanks very much. Works perfectly. Proper job.

Thanks, I have been scratching my head for sometime now. Works beautifully

Revisited your advice and using Excel seems to be the way forward. Thanks very much. Siddharthrout. Com does very good articles on using Excel in VB .net

Thanks for your suggestion but I do not wish to use Excel.

Richard
Thanks for the advice. I am shying away from a DataGridView as I wanted to display the data in the format I want it printed rather than in a spreadsheet format.

Maciej

Thanks for the advice. I will look into the ReportViewer package.

See my comments to the other solutions. Thanks for your help.

See my comment for solution 3. Thanks for your help.

Thanks for the advice. Bit of a novice here. As I used earlier code to calculate the value and then display it in a label I do not need to convert it back as the value is already available.

I decided on CSV rather than XML because each set of data records are the results of a golf competition. There are going to be a lot of competitions and I was concerned that the loading of the xml into a DOM would start to become a slow activity.
I plan to use a csv file for each competition with the file name related to the date of the competition just incase I need to recall the results at a later date.

Thanks for your help.
Using the debugger I realised the line node.RemoveAll() was not working correctly.
I found a solution on StackOverFlow web site.
I replaced node.RemoveAll() with node.ParentNode.RemoveChild(node).
Code now works.

It is annoying but the same line of code works in VBA and Excel.

Whilst debugging I set a breakpoint and used F11 to step through code.
Having got to the errorhandler I moved the arrow back to the start of the subroutine and carried on stepping.
On reaching the line oLapp = CreateObject("Outlook.application") I got the following error;
An unhandled exception of type 'System.Exception' occurred in Microsoft.VisualBasic.dll

Additional information: Cannot create ActiveX component.

I do not get an error message but when I have run my code I get this output.

'MatchManagement.vshost.exe' (CLR v4.0.30319: MatchManagement.vshost.exe): Loaded 'D:\My Documents on D\Visual Studio Projects\Match Management Application\MatchManagement\bin\Debug\MatchManagement.exe'. Symbols loaded.
'MatchManagement.vshost.exe' (CLR v4.0.30319: MatchManagement.vshost.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Accessibility\v4.0_4.0.0.0__b03f5f7f11d50a3a\Accessibility.dll'. Cannot find or open the PDB file.
'MatchManagement.vshost.exe' (CLR v4.0.30319: MatchManagement.vshost.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Remoting\v4.0_4.0.0.0__b77a5c561934e089\System.Runtime.Remoting.dll'. Cannot find or open the PDB file.
'MatchManagement.vshost.exe' (CLR v4.0.30319: MatchManagement.vshost.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
A first chance exception of type 'System.Exception' occurred in Microsoft.VisualBasic.dll
The program '[4464] MatchManagement.vshost.exe' has exited with code -1 (0xffffffff).

Sorry tried that but it is not there

phil.o

Thanks
I am very new to this. I have added Imports System.Xml above the form class and all works okay.

Again thank you very much

Dave

Gideon

Changed code to
If NewName = 1 Then
MsgBox("Adding Name")
For i = 1 To 16
updateComboName = "Player" & i
updateCombo = CType(Me.Controls(updateComboName), ComboBox)
updateCombo.Items.Add(curComboItem)
Next
End If

It now works, thanks for your support and patience.

Dave

Gideon

Code is now
If NewName = 1 Then
MsgBox("Adding Name")
For i = 1 To 16
updateComboName = "Player" & i
updateCombo = CType(Me.Controls.Find(updateComboName, True), ComboBox)
updateCombo.Items.Add(curComboItem)
Next
End If

But I get this error
Value of type '1-dimensional array of System.Windows.Forms.Control' cannot be converted to 'System.Windows.Forms.ComboBox'.

Dave

Gideon

My code is for a windows form.
I am an absolute beginner so please forgive me if I ask naive questions BUT
where do I put Me.Controls.Find(updateComboName, True)?
Tried various way but kept getting the code error:
Value of type '1-dimensional array of System.Windows.Forms.Control' cannot be converted to 'System.Windows.Forms.ComboBox'.

Dave

Maciej Los

Thank you I will create a CSV file and save the items to that.

Dave

Gideon
Tried the solution but got this error
'FindControl' is not declared. It may be inaccessible due to its protection level.

My code is now
If NewName = 1 Then
MsgBox("Adding Name")
For i = 1 To 16
updateComboName = "Player" & i
updateCombo = CType(FindControl(updateComboName), ComboBox)
updateCombo.Items.Add(curComboItem)
Next
End If
Should FindControl be related to the Form?

Dave