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...
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
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...
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...
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...
I have a database with Business Clients and Individual Clients. I also have transaction records for each type of clients. Employees work on both types of clients. I would like to have a report that shows all the work done by each employee. The report needs to include the work done for...
I have a report that I am running based on a querry. The querry has parameter values that the user must enter in order to run the report. The parameteres are: date (which the user enteres) and the second parameter is the Name of anaysts (which I want the user to select from a drop down combo...
I am trying to create a form that a user can enter car information. instead of typing the car info such as make and model, I wanted a drop down that they can select from. I have a car make/model table that is like:
Make Model1 Model2 Model3 Model4 Model5
Audi 82...
I have been asking this question couple of times but I don't think I am making myself clear. Here it goes again. I am tracking meetings that happend. With other fields, the meeting also has a "Duration "field. in that field how long the meeting lasted is entered. for example if it took 1hour...
This is my first database and I was wondering how I can make a start up page so that when users open it, it won't whow the access window. Instead, all they can see and access will be the main form that contains a menue with everythig on it. can someone please help?
I have a form from which a user enters meeting details. along othe things, the duration (how long the meeting lasted needs to be enterd) for example if it took 1 hour and 14 minutes, the user will enter 1.15 and if it is 1 hr and 45 min the user will enter 1.75. The problem I am having is I...
--------------------------------------------------------------------------------
I had a bigger question earlier and it was answered but I am still having problems with a small part of it. I am trying to track the details of a meeting. who requested it, for what project, date, duration, who...
Hi, I have a big problem. Here is the business rule, I am trying to track meeging request(MR) made. A meeting request is made by a manager,MR can include many analysts, and MR involves 1 project. I am trying to creat an input form for the MR table (tblMR) The input form is going to contain all...
I have contact person information that is exported into excel. The Experience field has multiple experiences in one cell and they are separated by a period. I would like a macro that will split the experiences and cut and paste each one in difference cells. Possibly by inserting a new cell...
Hi, I'm new to this forum and had couple of questions. I have an excel workbook with two sheets ("first", "second"). Both of the sheets have a list of names. What I want to do is take each name from the first list and see if that name exists in the second list. when there is a match to cut...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.