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

  • Users: iainm
  • Order by date
  1. iainm

    export to file with auto geneerated filename

    My boss is trying to write a macro to export a query to a word document. He can cope with that just fine, but he wants to automatically generate the filename, based on today's date and a few other data items - I'm not entirely clear where those other data items are coming from, I think what he...
  2. iainm

    Outlook 2000 date functions

    I'm trying to create a field for my tasks list which show the number of weekdays between two dates. This is what I have atm: DateDiff("d",[Start Date],[Due Date])+ 1 According to help, the appropiate interval to use is "w", but this is just counting the number of whole weeks...
  3. iainm

    counting weekdays in outlook 2k

    I'm trying to create a very basic uder-defined field in outlook tasks to calculate the number of working days assigned to a task, given the start date and end date. I've set it up as type=formula and put in the following function: DateDiff("w",[Start Date],[Due Date]) According to VB...
  4. iainm

    using error values as parameters

    I'm trying to write a formula to determine if text in one cell is contained in another cell. The romula I've built so far is =IF(SEARCH(G2,F2,1)>0,"Pass","Fail")If the text is found, Pass is returned in the box. If it's not found, #Value is returned. I've had this problem...
  5. iainm

    very basic query - auto-update 1 field based on another table

    It's been a long time since I did any access work, and I can't remember how to do this, even though I know it should be easy. I've got two tables in concern here - one is a set of equipment records, and the other contains the history of those units. The equipment table has an EQ# (primary key)...
  6. iainm

    Excel accounting number formats

    I just found it. it was obvious really. General;(General) -Iainm
  7. iainm

    Excel accounting number formats

    I'm doing an accounting and finance course in which the lecturer requires us to format numbers by putting negative numbers in parentheses - I'm told this is a firaly standard acconuting practice. I've found number formats which put negative numbers in red, but not in parentheses. I tried writing...
  8. iainm

    SQL null

    I need to know how to say [Field]=Null or [Field]="" in a query. My problem is, I'm creating dynamic Filter strings using string concatenation of different fields to filter on (User enters Field, Operator, Data in a form and another form is filtered on this data), so if it is simply...
  9. iainm

    locked out

    Guys, I've rather cleverly managed to lock myself out of my own database. I was messing wround with the startup options - trying to set it up so that when the user started the dtatabase they'd only get the main form, not the database window, the toolbars and menus etc that are available to the...
  10. iainm

    search in string

    thanks
  11. iainm

    search in string

    Couple of quick ones. I need a method to determine if one string is contained in another. Also, I can probably find this myself, but for the record, how do I get a simple Message/OK/Cancel-type dialog box? cheers, -IainM
  12. iainm

    How to tell if a form is open?

    thanks guys
  13. iainm

    How to tell if a form is open?

    Can anyone tell me how to tell if a given form is open in code? Was thinking there may be something like an IsOpen property, but that would give you an error if the form was closed. Is there a method that will accept a form name and return true if the form is open, like IsOpen(formname)? What I...
  14. iainm

    Access 2000

    erm...could you give us some more detail? I've not got a good picture of what you're trying to do here
  15. iainm

    language

    :) thanks mate. knew there had to be something like that.
  16. iainm

    language

    Organise, recognise, realise and similar terms annoy the heck out of me. I've changed my regional setting so the language is "English - Australia" and used the office language tool so that Australian English is the only language enabled. But office still insists on checking spelling in...
  17. iainm

    ctrl + alt + del wont' bring up taskman. Alt + F4 won't quit tsr

    erm...ctrl+alt+esc minimises the current window, always has. Haven't installed sp2, probably should. may be prog, I dunno. any ideas on the altf4 thing?
  18. iainm

    ctrl + alt + del wont' bring up taskman. Alt + F4 won't quit tsr

    I've got a dual boot of w2k and w98 using the standard w2k boot menu. In w2k, when I press ctrl + alt + del instead of bringing up the task manager, the active desktop disappears for a second (displays the underlying wallpaper) then flashes back again. I've tried turning off active desktop but...
  19. iainm

    duplicating unbound combo boxes

    anyone?
  20. iainm

    Comparison with null

    Yes, I'm sure it's always going to be the case. But my problem comes from a situation like a=1 b=Null If b<>a Then..... OR If Not b = a Then... b is clearly not equal to a, however, neither of these expressions will return true. My point is that null has no place as a result in boolean...

Part and Inventory Search

Back
Top