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!

  • Congratulations strongm 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. Anna22

    Network printer default to black and white

    Hi Im not sure whether this is possible but... We have several networked photocopiers which act as printers for the larger departments. The printers are deployed to around 100 users already. My question is this... i need the printers to default to black and white for every print and the user...
  2. Anna22

    Display subform as comma seperated string

    Hello I have a database which holds client information. Each client is categorised into the type of work they do. So my form displays the following: MainForm ClientName ClientAddress ClientTelNo ClientFaxNo .. etc .. SubForm Category1 Category2 ... etc ... Each client can have one or more...
  3. Anna22

    Excel 2003 Unable to copy last work sheet

    Dear all Please could someone help me ... i have several excel spreadsheets that are worked on by various people on a weekly basis. Each week a copy of the previous worksheet is taken and copied as a blank to the end. This works fine for a few weeks and then i am unable to copy the last...
  4. Anna22

    Insert filename or filepath into Excel cell

    Hi Im not sure if this is possible but i would like to be able to put a reference to the filename and/or filepath in random cells on an excel template. I know you can put the filename into the header or footer using page setup but was wondering if there is a way of putting it into a cell...
  5. Anna22

    CDRW in Nero only has image option cannot write cds

    Thank you for all your posts, i will try all of these and let you know the outcome Anna
  6. Anna22

    CDRW in Nero only has image option cannot write cds

    Help.... Nero ahs stopped recognising the CDRW (Artec WRR 52z) as a CDRW. If i check device manager, everything is still installed and has no errors or warnings against it. I am able to write CDs using the XP wizard so the CDRW is definately working. However when i use nero 5.5 or 6 it only...
  7. Anna22

    Excel 2003 - Remove autofill options

    Dear All Is there a way of removing the autofill option tag when you copy cells in Microsoft Office Excel 2003 Thanks Anna
  8. Anna22

    Group Policies

    Dear all i have started to look into the group policy side of active directory as i want to lock down workstations connected to the network, i have organised my users into specific areas so i can apply different policies to different groups of users. However when i looked into the group policy...
  9. Anna22

    Tick a check box to run a macro

    I am trying to use VBA to run the macro i had the following code in my head but cant seem to get it to work if checkbox1 = true then run macro else do nothing end if would it be as simple as this or more in depth Thanks Anna
  10. Anna22

    Tick a check box to run a macro

    Dear All I have been puzzling about this one for some hours now and im struggling, I have an excel spreadsheet with check boxes on it. The checkboxes run fine but what i want it to do is when i click a check box i want it to run a macro.... is this possible? All help is greatly appreciated...
  11. Anna22

    Importing data from Excel

    Dear all I am trying to import a csv file which i get exported from an audit program which we use. the data contained in the csv file is network information. I have imported csv files into access many times before and never had a problem except with this file. The format of the csv is in...
  12. Anna22

    Autoformat borders when new entries entered

    Hi i am using Excel 97 and have been asked if there is a way of automatically putting a border round new entries which are added to a spreadsheet and if there is how would we go about it Thank you Anna
  13. Anna22

    Margin Problem

    Hi I hope someone can help me. It not really a critical problem and does nt stop any user from working but it is strange and i would like to get it fixed if i could. I have several Windows XP machines running Microsoft Word (97), we are looking to rollout office 2003 soon but would liek this...
  14. Anna22

    Email sending incorrect text

    Hi I have a user running Windows 98 on a Fujitsu laptop who when he sends an email with a £ sign in it. After the email is sent changes to ? and when you view the email at the recipients end they too display a ? instead of a £. I have tried swapping locales and regional settings but i am still...
  15. Anna22

    Excel - Search all worksheets

    Hi xlbo We are running 97 at the moment, we are looking to upgrade soon Thanks anyway Anna
  16. Anna22

    Excel - Search all worksheets

    Hi "Sub Find() ' ' Find Macro ' Macro recorded 20/07/2004 by admin ' ' Keyboard Shortcut: Ctrl+Shift+F ' Cells.Find(What:="crown", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False...
  17. Anna22

    Excel - Search all worksheets

    Thanks for the reply. If the search word changes will i have to keep amending the macro?
  18. Anna22

    Excel - Search all worksheets

    Hi Can any of you help me please. I have a workbook with severall worksheets in. I want to do a search on every worksheet within that workbook for a particular word (i.e. a street name) when i select all worksheets and then go to find it only seems to search the worksheet that i am on . Am...
  19. Anna22

    Inserting Text

    Hi I have some more information which may shine more light on the subject. After i have typed the text in the main screen when i press ok, it insers the text as a floating selection i.e i can move it around the screen. However all of the three options do not allow me to modify the text as i...
  20. Anna22

    Inserting Text

    Hi i was owndering if anyone can hel me I have paint shop pro 7 nad have been using it successfully for quite a while now. My problem is when i insert text i am getting prompted with different way than i am used to. I now get prompted with what looks like a insert text dialogue box where i...

Part and Inventory Search

Back
Top