Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pcsmurf

    Getting second result in the set

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

    How to use a sub query

    Thanks :-)
  3. pcsmurf

    How to use a sub query

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

    Parsing XML with JQuery

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

    Parsing XML with JQuery

    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>...
    • pcsmurf
    • Thread
    • Replies: 2
    • Forum: XML
  6. pcsmurf

    Problems with XmlTextReader

    ...' Set the formatting to something nice writer.Formatting = Formatting.Indented TextBox1.Text = TextBox1.Text & vbCrLf & _ "*** Writing Article " & artcount.ToString + ".xml" TextBox1.Refresh() End If If (reader.Name = "publication") Then...
  7. pcsmurf

    Replacing Bold Text

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

    CommandBar Item for Chart Menu

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

    CommandBar Item for Chart Menu

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

    CommandBar Item for Chart Menu

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

    Login stops at applying internet explorer branding policy

    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??
  12. pcsmurf

    Login stops at applying internet explorer branding policy

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

    Login stops at applying internet explorer branding policy

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

    Converting from Word 97 to Word 2002

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

    Converting from Word 97 to Word 2002

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

    Outlook rules are disabled

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

    QuickLaunch Bar will not work

    It is a personal machine. No logon scripts are run.
  18. pcsmurf

    QuickLaunch Bar will not work

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

    Why would an Exchange 2000 information store take hours to stop

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

    session variables

    session.use_trans_sid is on and session.use_only_cookies is off. I should point out at this stage that my php server is run by a webhosting company so we do not have direct control over server settings.

Part and Inventory Search

Back
Top