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 Westi 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: *

  • Users: JMB70
  • Order by date
  1. JMB70

    SELECT SUBQUERY - using % wildcard with IN CLAUSE

    Thanks Carp, second option is ideal and works exactly as I'd hoped. You're a Star! Ta for speedy response, you've resolved a headache for me.
  2. JMB70

    SELECT SUBQUERY - using % wildcard with IN CLAUSE

    Hi, I'm trying to write the following DELETE FROM TABLEA WHERE TABLEA.ID IN (SELECT DISTINCT(ID)||'%' FROM INVALID_IDS) The idea is that table INVALID_IDS could have an entry of '12' and so all entries starting 12xxx would be deleted. INVALID_IDS could also contain ABC so all entries...
  3. JMB70

    Add in a dialog confirmation box to Save button in Office

    It's o.k. I've worked it out. thisdocument.save
  4. JMB70

    Add in a dialog confirmation box to Save button in Office

    Thanks Tony, you're a star, that has worked a treat for the SaveAs option. I want to do the same for the standard Save option, is there a page you know of where I can find the names of all the functions to call... You have written: Application.Dialogs(wdDialogFileSaveAs).Show to call the...
  5. JMB70

    Add in a dialog confirmation box to Save button in Office

    Thanks Tony, Do I need to create a new button and put this code behind it? Or can I edit the standard MS buttons code? I do need to do it for the whole of office, but if it is a case of having to do each app seperately then I'll do that. I'm trying to make sure people don't just...
  6. JMB70

    Add in a dialog confirmation box to Save button in Office

    Sorry didn't mean to come across as impatient, just didn't want my request for help to dissapear because I'd misunderstood some form of protocol. I certainly wasn't demanding an answer, and do realise that this is free advice I'm seeking. Thanks for the FAQs.
  7. JMB70

    Add in a dialog confirmation box to Save button in Office

    I would really appreciate any help on this issue, is there any obvious FAQs that I should be reading? Or a protocol to asking questions?
  8. JMB70

    Add in a dialog confirmation box to Save button in Office

    Hi, I have a document management system that is the desired location for saving documents. The intention is that I will move the Save button to a less prominent location than the new applications save button. I would like a dialogue box to appear whenever the standard Save button is used that...
  9. JMB70

    Clearing Request.ServerVariables("LOGON_USER")

    This can be done in IE, but as yet I haven't worked out a way of doing it in Netscape. To clear the user session variables, if you point a link to a page outside the restricted area and put: http://none:none@www.yoururl.co.uk/logout/logout.htm for example, then the browser will overwrite...
  10. JMB70

    Cursor Error Trapping.

    Hi, I'm new to this place (and to sql server), I'm having trouble and a friend reccomended I ask here... hope someone can help? I have an insert statement that is trawling through thousands of records from the source table. When the cursor finds a bad record from the source(e.g. a null...

Part and Inventory Search

Back
Top