Recent content by rickes

I made a report in access which gives me a running report of what type of vacation one of my employees took after I have entered them into a form. Whether or not it was a Floating Holiday, Vacation Day ect. At the bottom of the report, I have an unbound text box with the label saying "Total...

I want to set a forms location in the lower righthand corner to pop up and display information like how nortons antivirus 2004 and other applications display info there. I cannot get it to set the location??? here is my code... Private sub form1_load dim alertpop as new frmAlert Dim SWidth as...

Tom, Your the man... I ran it the way you gave it to me and it works great. Thanks so very much for your efforts. Rickes

Tom, Excellent Job. I ran your SQL in a new query. It worked great, except it posts the Hours on Belt in the record below it. For instance, RecordID 6, Belt Press 1, Upper Belt, 11/12/2003 should show it had 4038 Total hours on Belt. But the way the SQL shows it, it is putting the 4038 in...

Sorry I did not explain last post. That is from a table called BeltReplacement. the bold row is the field names. There are 7 records.. If you notice, there are 2 different pieces of equipment, each with an upper belt and lower belt. The next field(ChangeDate), is the field when that belt was...

RecordID Equipment Belt ChangeDate HourMeter Hours on Belt Reason Reason for Other 6 Belt Press 1 Upper Belt 11/12/2003 20765 Torn 7 Belt Press 1 Upper Belt 6/14/2004 24803 Torn 8 Belt Press 1 Upper Belt 3/28/2005...

I dont understand what the A B and C infront of my field names are for? I get errors when i just take your query and change the field and table names to what mine are. a window will pop up saying that it will only display one result and when i click ok it displays #NAMES? in all the feilds...

I am lost. I have an access database that I am keeping track of belt changes. I want it to automatically give me the total hours on a belt from the time it was put on to the time it was changed. I would like to do this in a report or in a query. It looks something like this (top row is column...

I am lost. I have an access database that I am keeping track of belt changes. I want it to automatically give me the total hours on a belt from the time it was put on to the time it was changed. It looks something like this (top row is column header): EQUIPMENT BELT DATE HOURMETER REASON...

I am lost. I have an access database that I am keeping track of belt changes. I want it to automatically give me the total hours on a belt from the time it was put on to the time it was changed. It looks something like this (top row is column header): EQUIPMENT BELT DATE HOURMETER REASON...

If the formula in a cell returns a value of a negative number, how do i make the condition in that cell show no number at all? I want the cell to be blank util the condition shows a positive number from the formula.