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!

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

    Annoying Outlook 2003 problem

    I have one account but it continues to receive the same emails over and over. It will duplicate the same eamils every day and does not delete them off the server.
  2. HOMMER

    Dates

    thanks works good
  3. HOMMER

    Dates

    I need to sum up volumes by weeks. I wrote the query but the problem is my company weeks do not match access start week. Example 12/26/2004 - 1/1/2005 is week 53 in access but for my company this is week 1 for 2005.
  4. HOMMER

    graph sorting

    My graph has data from 3 different areas. When I run the graph it displays all the data from all areas on one graph. I want to display one graph per area.
  5. HOMMER

    hold last record in a text / combo box

    I want to not change a text and combo box each time I enter data. If I enter a "5" in a text box I want that "5" to keep being entered as I click my add data button. The only time this number will change is when the user changes it. I also need to do this with a combo box.
  6. HOMMER

    Table help

    How do I store the current price? I am using the table as the list...
  7. HOMMER

    Table help

    I have a table that I record products we order. One table has all the products and everything about them. From a form I select a product (from the product table)and record the # of units ordered and current price from my master products table. This works great, the problem is when I have a new...
  8. HOMMER

    report date help.

    Thanks worked great.....
  9. HOMMER

    report date help.

    I write the date on my report with this statement from a form. What I need to do is show this information minus 364 days. I can do it in a query but can not doit on my report... ="Previous " & [Forms]![frm_bm_Report]![txtStartDate] & " to " &...
  10. HOMMER

    between help

    Yes all the data between 1/1/03 7:00 am and 9/1/03 8:00 am only...
  11. HOMMER

    between help

    I want to query between 7:00 am and 8:00 am on my list of time and date stamps. I have a table filled of numbers each number has a date time stamp. I want all the records between 7:00 am and 8:00 am over a date range. When I do the date range it brings all the records between the dates not...
  12. HOMMER

    criteria/case select hep

    In my form (frm_bm_Report) I have this code Select Case optuniloy: Case 0: txtuniloyReportHeader = "All Uniloys" txtuniloynumber = "*" Case 1: txtuniloyReportHeader = "Uniloy 1" txtuniloynumber =...
  13. HOMMER

    date range help

    I can send you a copy
  14. HOMMER

    date range help

    I want the information on my report to look like this list. What I cannot do is I want to have 2001 one the right side and the 2002 on the left side. Then give a percent change between the two numbers. I can do so code just can not get started.... Reason Sum Of time down...
  15. HOMMER

    Date change

    I have a continous form that requires when I change the date txtbox at the top of the form. What I want to do is bring up a date look at the records that add to those records with the date I type in the txtbox at the top of the form. What is happening whan I put a date in the box it requires...
  16. HOMMER

    binary help

    Email address www.rmboltz@bellsouth.net. Thank you every onr for the help...
  17. HOMMER

    binary help

    Sorry but thats not what I need. Thanks for the help...
  18. HOMMER

    binary help

    I hope this can be done NEED THE HELP. Counting in binary I have a excel worsheet. Cells a - p are my cells I want the ones and zeros to show up on. In cell Q I want to type a number and the correct 1 or zero will show up in the cells a - p that make that number up. For example if I type a 3 in...
  19. HOMMER

    Date range comparison

    The query below does just what I want it ot do, but I want to add one more thing. I want to add total minutes for the same date range but one year prior. If the date range is 1/1/01 to 1/1/02 I want the same data for total minutes dates 1/1/00 to 1/1/01. I am doing a minutes comparison for the...
  20. HOMMER

    Sort problem

    This gives me all the info I want but does not sort by weeknumber. It sorts by the average. I need to sort by weeks for the graph. I tryed all the normal ways of sorting I can think of I know I am n\missing somethie easy... TRANSFORM Sum(qry_first_hour_weekly.AvgOfGPH) AS SumOfAvgOfGPH SELECT...

Part and Inventory Search

Back
Top