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

    File, Send, E-mail not available in Office 2007

    Yes, Thunderbird is registered as default mail program, and it works from other programs which interface to mail. It even worked with the Office 2007 Beta.... But proper Office 2007 just acts as though I don't have a mail program.
  2. beniez

    File, Send, E-mail not available in Office 2007

    Any ideas how to get Office 2007 to play with my email client?In Word 2007, the option to Send email from the File menu is greyed out: in Excel 2007 it's simply missing; in PowerPoint 2007 the Send option on the File menu itself is greyed out. Is this punishment because I use Thunderbird as my...
  3. beniez

    Numbering documents automatically

    Ken Perfectly doable, and yes you can have a data file that records the last used number; reads it, converts it to a number, adds one, and uses it to set a document property. Then you include that document property as a field in your document. I used to have some code to do pretty much this...
  4. beniez

    select entire row of current cell

    ... and mine was the least elegant solution :-)
  5. beniez

    select entire row of current cell

    Matt Rows(ActiveCell.Row & ":" & ActiveCell.Row).Select HTH Ben
  6. beniez

    identify weekend in VBA

    Geoff Yeah well.... I kind of thought my little bit of hacking didn't qualify as VB coding.... No I didn't: I just didn't read the post properly. So you were right and I was wrong, but hey, who's counting? ;-)
  7. beniez

    identify weekend in VBA

    hj When I had to do something similar, I created a user-defined function: Function CellColor(r As Range) As Integer '-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* ' Returns Color index of first cell of a range ' If return is >1, then cell is coloured '-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* Dim...
  8. beniez

    Word XP turns on "WarnBeforeSavingPrintingSendingMarkup" option

    Our users keep turning *off* the warning that pops up whenever you save or print a document which has Tracked Changes in it (Tools, Options, Security: turn off the checkbox "Warn before printing, saving or sending a file that contains tracked changes or comments"). But when they next...
  9. beniez

    Excel: Formating cells for negative numbers

    Searae You can input a set of numbers as positive; highlight the range of cells and choose Edit, Copy; Paste Special Subtract to a blank area of the spreadsheet (this turns them negative by subtracting them from zero); and then Cut and Paste them back to the original place. This is one of those...
  10. beniez

    How to access excel files with ODBC?

    xlbo That's really useful - solves a problem that's been nagging at me.... Thanks Ben
  11. beniez

    How to access excel files with ODBC?

    Xantix You're right (so, of course is xlbo!) - use range names. Just be careful about the end of your range. I've come unstuck by defining the range to end where my data does; then wondered why records added at the end aren't picked up by the query! Either include some empty rows at the end, or...
  12. beniez

    number

    If you don't want to put your numbers in as text, then use =B1&TEXT(A1,"0000#") This works for all numbers - eg A1=45, C1='C00045', etc: TEXT() just works like setting the format of a number. HTH Ben
  13. beniez

    Reference a sheet that might not exist

    Hi Use ISERROR, as in: =IF(ISERROR('Missing'!B12),"Sheet missing", 'Missing'!B12) (Where 'Missing' is the name of the sheet that might be missing) If you put this in while the sheet is missing, Excel will open a files dialog box to allow you to find it; press cancel unless you want...
  14. beniez

    Find and replace problem

    Hi assafjak I think you need to use the &quot;Use Wildcards&quot; option in the Word Find/Replace dialog box. Then use <A> as your find string. This means &quot;look for cases where A is both the beginning and end of a word&quot;. This works whether or not the As are in table cells. There used...
  15. beniez

    Linking Access to Excel

    Hi Stephen Best way is to create an external query in the spreadsheet referencing your Access database. Choose Data, Get External Data, Create New Query, and create a query to get your data. If you want it to refresh automatically when you open the spreadsheet, choose Data Range Properties from...
  16. beniez

    I need to do a find and replace

    Unless I'm missing something, these are basically find and replace activities (highlight the relevant column and find &quot;1&quot;, replace with &quot;Closed&quot; etc). If you need to do this repeatedly, then record your actions as a macro. Ben
  17. beniez

    MS Word - Duplicate Page Numbers when Sections used

    Hi Tony Normally Word defaults to continuous numbering between sections, but if it isn't, go into View Header/Footer, press the Format Page Number button, and choose &quot;Continue from previous section&quot; there. HTH Ben
  18. beniez

    Updating existing records

    David Creates a new query - or rather, you create the join in a query (which you can if you want use to create a new table). Go into query and add two tables with a common field; drag the common fieldname from one to the other; you've created a join. HTH Ben
  19. beniez

    Updating existing records

    David Joining the data is pretty much the only way to do what you want in Access - how else will Access know which record to put each bit of NewStuff into? (Remember that Access, being a relational database, doesn't regard a table as having an &quot;order&quot;). I'd be tempted to paste your...
  20. beniez

    Regular expressions in VB/VBA

    Am I right that there is a Microsoft library that supports PERL-type regular expressions? One that's available to VB6 or VBA programs (ie, before VB.NET)? If so.... which library is it? Ta in advance Ben [rofl]

Part and Inventory Search

Back
Top