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

    transferspreadsheet and add a formula ?

    I am using the transferspreadsheet to export my query results to an excel sheet. Is it possible to then add a cell at the bottom of the excel rows that sums up 1 of the colums ? Easy enough to do in excel but I would rather have it automated.
  2. juniormint2009

    tsansferspreedsheet command to do more??

    Hi all, after I run some of mu queries from a command button with the DoCmd.openquery command, I use the Do.cmd transferspreadsheet so it goes right to and excel file. I would like to do more though. Can I have it name the file something unique so the user knows to look for it? Like adding...
  3. juniormint2009

    time difference and/or date difference

    Hi all, I need to calculcate the difference between 2 date fields, but need the time more than just the days. I tried the datdiff function but it gave me a whole number. I have the following code below, and my date fields say: "12/31/2008 9:24:47 AM" and "12/31/2008 12:52:24 PM"...
  4. juniormint2009

    Add date search to my form with the combo boxes

    Hey All, the help I got was awesome! Thanks again! I am realizing that I really don't need my status combo box but will probably leave it on my form anyway incase I want to search by that, now I have a new question. How would I add a search function to search for date ranges ? My field is called...
  5. juniormint2009

    Query gets values from 3 combo boxes but does not give correct results

    Hello all, I am new here, pretty new to access also but have programmed before. I have a form with 3 combo boxes, each combo box has its own table to fill it with values (tblStaff has field staff with about 5 people) (tblSeverity has Severity field with 4 number severities 1 2 3 4) and...

Part and Inventory Search

Back
Top