Recent content by HOMMER

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.

thanks works good

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.

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.

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.

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

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

Thanks worked great.....

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 " &...

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

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

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

I can send you a copy

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

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