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: OmandA
  • Order by date
  1. OmandA

    Can I find a FILE path with BrowseForFolder?

    Disregard my last... I found a comprehensive example here: http://tek-tips.com/viewthread.cfm?qid=1103022&page=1 (note: for anyone else who is curious and follows this link... scroll down... there is a useful and quick example at the BOTTOM of the thread - from "mp9")
  2. OmandA

    Can I find a FILE path with BrowseForFolder?

    Thanks... I've now reviewed that thread... but it's quite vague in it's references. Could you please give me an example of how to use the Application.FileDialog function?
  3. OmandA

    Can I find a FILE path with BrowseForFolder?

    Hello! Is there any way to use the Shell.Application function BrowseForFolder (or any other function for that matter) to browse for the path to a FILE as opposed to just a folder? Here is the Syntax I'm presently using to browse for a FOLDER. I want something similar for finding a string that...
  4. OmandA

    Writing a query that will show past due orders

    As 'dhookom' states we likely need more data before we can answer fully however you'll probably be looking to add a column to your query sort of like this: DaysPastDue: IIF(Date() - [ReportDate] > 0,Date() - [ReportDate],0)
  5. OmandA

    Format Of IIF Function in MS Access

    To further "HandsOnAccess"'s response: YES you can combine multiple IIF statements... it's called "nesting" them. Ex: IIF([someField]="Some String","1st IF was TRUE", IIF([someOtherField]="Some Other String","2nd IF was TRUE", "Neither IF was TRUE")) You can put the inner IF condition in...

Part and Inventory Search

Back
Top