Search results for query: *

Skip, That was exactly what I was looking for. Thanks much to both of you. H.

man, you are pretty good at this. yes, the only problems with your latest code is that 1. what you mentioned above (doesn't ignore blank cells) 2. it applies "pasteSpecial" to the answer (hard codes it) I think I will continue looking into this so I can manupilate what you gave me. thanks...

yeah, there might be. I was hoping that I have numbers in the following ways: Row 1 Column Title Row 2 5.0% Row 3 1.0% Row 4 (completely blank) Row 5 .01% Row 6 .02% Row 7 1.0% Row 8 (Product Formula) What I wanted was, when I run the macro after clicking in row 8, for it to grab the rows...

thanks for the reply skip. Your formula also covers just the specified amount of cells. I was hoping to find a way for it to not just do "-6" always but to grab all cells above active cell which have values in them (non-blank). thanks for your help. H.

I've created a macro and assigned it a hotKey for the Product formula (=product(1+C5:C10)-1). The macro works fine but the short coming is that, the range that it selects is the range I selected when I recorded the macro. So in the above example, it would only select rows C5-C10. The way...

I just got it, thanks anyways.

Thank you so much MajP. not to sound stupid but I was wondering, where should the password be? thanks again.

Sorry but I can't use the search feature since it is out of service right now. Is there a way I can password protect a specific tab on a Form? thanks in advance

Thank you so much PHV, you really deserved TipMaster of the Week award. Thanks again

Thanks for the quick reply PHV. I'm not exactly sure in what way you recommended using the default value property control. I can't just specify one name to show up as a default because there are many employees. Each employee will be entering data for many days at a time and I just want their...

I really need your help. I have a form that is used as a time tracker. 1.Employees select their name from a drop down combo box (cboName) 2.Click on a drop down to select date (cboDate) AND 3.Enter the hours for the day (txtDate) Employees would enter their hours for a month or so at a...

Thanks PHV, that's that's the name I was looking for!

Hi, I am new to this and wondering how I can accomplish the following. I have Initials for employees, I also have categories of work they have done I want to display it like this: Category Total hrs HGB AKA JFK Dish 50 20 10 20 burger 20...

Hi, I am kind of new to this game. I created a site bases on php. I have a "Top.php", "Bottom.php", "Left.php", "right.php" and a "middle.php" put in a "index.php". The problem I am having is that, the website does not show up right on diffrent computers. I played with the table sizes so...

I know this is simple but I don't know how to implement it. I have a form where employees select their names from a drop down before they add their hours in perspective text boxes. I want their mug shot picture to show up on the form as they select their names. Can someone please by providing...

You can use the count function but if you are trying to display the total count in the footer, you will not be able to calculate it directly into the footer. You must use the count function in a new textbox(txtCount) that you can create in the detail section and make that text box's visible to...

I need to find out how I can have a report with a criteria emailed to me everyday before the day ends. I need the system to run a report with a date criteria (starting date=current date & end date =current date). The report I have is rptEmpHours. The report will have the Emp_Name, Date...

Sorry for not being clear. here is what I have: I have transactions tables called tblBusinesWork, tblIndividualWork help. They each have fields such as tblBusinessWork BEmp_Name BDate BStart_Time BEnd_Time tblIndividualWork IEmp_Name IDate IStart_Time IEnd-Time I have two...

I know you how you can get the hrs and mins calculated but I am not sure about the seconds. to calculate the hours, =sum(value)\60 To calculate the minutes: = sum(value) mod 60 hope this helps hobman

EnemyGateIsDown, the way I got over that kind of bump is as follows. I created a text box in the detail area of the page and did the calculation in that text box. I them put the text box's visibility to "No" and linked its name to a text box in the footer. hope this helps hobman Explaining...