Search results for query: *

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...

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...

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...

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...

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...

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...

In order that users do not have to see some of the less pleasant emails that arrive we have rules set on our Public Folders to move all mail that comes in marked as spam to a separate folder. Unfortunately something is triggered on a fairly regular basis that turns this rule off. This happens...

Even though I turned the quick launch toolbar on and configure it after the computer is rebooted it turns its self back off again. For some reason the tick box for Quick launch bar is unticked. Does anybody have a reg patch for this problem. Note it use to work.

We have Exchange 2000 and run a batch file at night to stop all the Exchange and McAfee GroupSheild services for an offline backup of the edb files. However at least twice a week the Information Store takes hours to stop instead of normally a minute or so. What would cause the Information...

Sometimes when I first load my php page the links on the page contain session variables - something like sugar/showpage.php?pagename=contactustext?PHPSESSID=e58973a35a24c7607fc699d88881dc31 - this makes the link invalid. a) How can I fix this ? b) What puts it there in the first place ?

The following code: <?php // Include the MySQL class ini_set("include_path",'\www\common\'); include "MySQL.php"; ?> works on a unix based server but on our windows based server gives the error message: Parse error: parse error, unexpected $end in...

I have knowledge of Javascript and Visual Basic but I would appreciate some pointers in the best way to create a user freindly interface for my PDF archive. I would like to hide the Adobe menus and options from the user as much as possible. Does anyone know of any good tutorials available to...

I am trying to have all my common files in one location called Common. The code is: <?php // Include the MySQL class include '/Common/MySQL.php'; $host='localhost'; // Hostname of MySQL server $dbUser='kamac'; // Username for MySQL $dbPass='websmurf'; // Password for user...

Our priv.edb keeps reaching the limit of 16gb and we have to run the purge routine to clean this out. My concern is that items that are purged in the same month that they are created are nver archived in the long term - we keep daily backups for a fortnight and then a monthly backup is retained...

I am using Access 97 and my form settings are set so that the auto centre window value is set to Yes. Despite this setting the form still insists in opening up in the position I have it in design mode. Am I misunderstanding this option is there other settings I need to check in order to get the...

I have written what should be a straight forward uploading script which doesn't work and I don't know why. The script is: <?php $uploaddir = 'public_ftp/incoming'; $uploadfile = $uploaddir. $_FILES['userfile']['name']; print &quot;<pre>&quot;; print &quot;Attempting to copy to...

I have a VBA script running in Access 97 which saves records into a nicely formatted Word document. This script works fine on small amounts but if there are a large number of records I get the error 'The formatting in this document is too complex. Please full save now' Does anyone know how to...

In a module I have the code : DoCmd.TransferText acExportDelim, , cTablename, cOutFilename, True The table cTablename has text fields that contains the £ sign. Using the above code the £ sign is converted to a œ symbol. If I use the Export option within Accesss the £ signs are converted...