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??

    This is great! Really saves me time from cutting and pasting, another question, is there a way to name the sheets something else besides "sheet 1", "sheet 2" etc ??? I want to be able name the sheets a certain name, can this be done?? Also, one of my queries has a field that I calculate and is...
  3. juniormint2009

    tsansferspreedsheet command to do more??

    WOW, that is awesome! Thank you Harley!!! I have it working great now! Thanks again!
  4. 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...
  5. juniormint2009

    time difference and/or date difference

    thanks Ray! I am using my above datediff argument with the 'n' option instead of h and then dividing by 60 which gives me my number like 19.27 (so I know it is 19.27 hours to resolve a problem) unless there is an easier way. But thanks for the reply! You guys are great and have helped me out tons!!
  6. juniormint2009

    time difference and/or date difference

    ok, I may have spoken too soon, I actually did this Expr1: DateDiff("n",resolved_time,open_time)/60 now that gives me the amount of time it took in hours too resolved an issue, but the number is negative. I plan to take the total of all these valuse and then averaget them, I am pretty sure I can...
  7. 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"...
  8. juniormint2009

    Add date search to my form with the combo boxes

    So is this possible or am I doomed ??
  9. juniormint2009

    Add date search to my form with the combo boxes

    In my form, I enter a date like 02/01/09. I entered the criteria into my query, I inserted a new colum so its the 1st set of parameters, when I close and save it and then view it again, the criteria for the opened time field is >=[Forms]![comp_search]![txtstartdate] and then it adds a columm for...
  10. juniormint2009

    Add date search to my form with the combo boxes

    sorry, typo, I added the field "Opened Time" to the query with the criteria set to, the table is the same as the others, dbo_probsummarym1 Criteria is below. If I use it in another query with just that as the parameter it works but if I try and add it to this query with the other 3 options it...
  11. juniormint2009

    Add date search to my form with the combo boxes

    what I tried was adding a text box to my form in short date format called txtstartdate, then in my query, I tried to add the criteria in a new cell with the "opened by" field as the field and the same database dbo_probsummarym1 and the criteria below, but it doesn't work. If I do just a seperate...
  12. juniormint2009

    Add date search to my form with the combo boxes

    Thanks dhookom, I understand your logic and totally appreciate the help. But what I really need to do is have a between date function on that same page as my combo boxes so they can pick records in a date range like after 1/1/2009 and before 1/10/2009 and also with the criteria from the combo...
  13. juniormint2009

    Add date search to my form with the combo boxes

    hmm, all that just for the date ? I was actually hopeing to ad like a calender in there to select it. Didn't realize it was so hard. Oh well, guess I will try it that way. Thanks for the help!
  14. juniormint2009

    Add date search to my form with the combo boxes

    ok, below is my SQL, I made a table tblOpentime with date() as the default value for the field Opened Time, I named the text box txtOpentime the form fills in the defualt date but the search does not pull it based on the date, all else works fine if I take out that date part, I figured I would...
  15. juniormint2009

    Add date search to my form with the combo boxes

    Thank you again dhookom! I am in the process of adding it, I have been working on outputing the query to excel and having decent luck. I am burnt out now though, gotta work on this tommorow. Thanks again for all the help! Now I have a great query and my my forms are looking good. This is going...
  16. 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...
  17. juniormint2009

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

    YOU ARE PROGRAMMING GODS!!! IT WORKSS!! Finally! Thank you all!, took those spaces out and bamm! You guys are great, I got a nice looking app going and that part was killing me! I can't thank you guys enough! You are the best!
  18. juniormint2009

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

    WOW, now the query works perfect, only problem is when I run the form, after I select the values from my drop down list, I have a "Search" button that does this on the "OnClick" part DoCmd.OpenQuery "comp_search", acViewNormal, acEdit Now, when I click the button, the query asks me for the...
  19. juniormint2009

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

    Thanks dhookom, here it is when I clicked on design view SELECT master.* FROM master WHERE (((master.[Opened By])=[Forms]![comp_search ]![cboAgents]) AND ((master.[Ticket Status])=[Forms]![comp_search ]![cboStatus]) AND ((master.Severity)=[Forms]![comp_search ]![cboSeverity])) OR...
  20. 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