Recent content by pcsmurf

I have a table called prices which stores prices for different contracts. Sample shown below. id AsAt contract price 1 01/01/2012 1 6.5 2 02/01/2012 1 7 3 04/01/2012 1 5.2 4 04/01/2012 2 6 5 03/01/2012 2 9.1 6 01/02/2012 3 7 7 02/02/2012 3 6 8 03/02/2012 3 5.1 9 01/01/2012 4 6.5 I need to...

Thanks :-)

I have a table of contracts and a table of prices. For the purpose of this test the contracts are just contractid and name. The prices table contain records in the format: contractid, AsAt, Price. prices.contract and prices.AsAT make up the primary key so each contract will have multiple...

Thank you so much for saving my sanity. I knew it shouldn't be too difficult but I just could not get it right.

Not sure if this is an XML question or a JQuery question but I have an XML file which is given to me by another company (so I cannot make any changes to its structure). The general format is: <products> <product> <name>Title</name> <description>Description ...</description> <field>...

I have a script which reads through an XML file and writes out each article element to a separate file. Generally, this all works well but when the reader hits an HTML entity such as &euro; it just skips this completly and carries on with the rest of the article. Is there a switch or something...

I have a VBA script to convert any text that it finds in bold in a document to be tagged as follows: <P>This paragraph contains some <b>bold text</b> and some plain text.</p> This works when only part of a paragraph contains bold text but if the whole paragraph is in bold the output I get...

Thanks for all the help. The "Chart Menu Bar" solution works. The only real problem is that it appears to be guesswork trying to find out the name of the command bar. Originally I was using "Chart". Incidentally, the macro record tip returned the name "Chart" so that threw me a bit. Thanks...

The code I use is Sub MakeMenu() Dim cControl As CommandBarControl RemoveMenu 'Prevents duplicate entry of the menu item Set cControl = Application.CommandBars(1).FindControl(ID:=30007).Controls.Add _ (Type:=msoControlButton, temporary:=True) With cControl...

I have written a small piece of VBA code which adds a new command bar option to the main Excel menu bar. This works well and appears on the menu as expected. Unfortunately one of the options is related to copying charts and as soon as I click on a chart in the Excel file this new menu bar gets...

Thanks for the help, but i have no error event iD 1202 on event id 1704 for the period the server went wrong to present day. Any more ideas on how to proceed??

Ok im using a group policy, but don't have the same problem with the other win2k servers and my user account or the admin account. I have tried creating a new user for the server and get stuck at applying internet explore branding policy when login on. Can you elaborate on your suggestions.

I have windows 2000 sever and have just installed MDAC2.8 from Microsoft. After rebooting i login and can't any further than applying internet explorer branding policy. If I try via terminal services connect I get the same. If I crash the login and try again via terminal service or from the...

Thanks for both your replies. I am hoping to convert all our macros in due course but I need to get them all working as quickly as possible. Most of the ones we use run as is. I'll try out your suggestions and hopefully I'll end up with a working macro. Thanks again.

The following code is a snippet of code used in a macro that we successfully run under Word 97. The purpose of this part of the macro is to take the text from each cell and write it into a text file (which becomes an HTML file eventually). However running this through Word 2002 I get the...