Saving a calculated field
First, yes I have read the threads on storing a calculated field and that it
is bad mojo to do that. However, I have pay data that I calculate and input
to a database and it must be able to be reconciled with our ADP data. So I
need the ability to change and fix the data so it does not change as a result
of recalculations. I have a form with a field that calculates the pay based
on hours and pay rate. I have another field (the "copy" field) next to that
one that has the control source set to the database field. I have set the
default value of that field to be equal to the...How to create a date mask and drop down list?
I am not sure if this is the proper wording, but is their anyway t
create a standard date function/mark, to type dates in without havin
to type DASH, having to type out the entire year etc....
Also how can I create a drop downlist to choose from (that show
results when I type the first letter or second letter) in a column?
Any help with this would be greatly appreciated thanks
Nikos's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=986
View this thread: http://www.excelforum.c...Automatic Calculation #3
In Excel 97, does anybody know why the setting for
Calculation - Automatic or Manual changes on its own?? A
colleague of mine has Excel 97 and every so often, he has
to keep changing the setting back to Automatic because it
reverts to Manual of its own accord.
Can anybody help with this and advise me how to prevent
excel takes its initial calculation setting from the first workbook opened,
so if you open a manual workbook and then open an automatic one, excel will
still be in manual.
Fa...Max sheets in a workbook or max # of calculated cells
I have a excel model that runs company scenarios. It currently has about 90
sheets and I am hitting the difficultly of calculations not updating. For
example, I will make a change in one sheet that is referenced in another..
When I check the sheet that calls the first number, it has not changed. If I
hit F2 and then enter in the cell in question, it will show the updated
number... I have many inputs and this can cause a huge problem as there seems
to be no warning. In using the "info" command it would seem that i am using
a huge percentage of available memory.. It is a mem...Use Date in an excel file to create a calendar appointment
This is what I am trying to achieve
Input a date in excel and have a calendar appointment generated for
Anyone try this?
...Real time function
Hi, I am using the function "=now()" to get the date and time. I have also
set the tool > option > calculation to automatic. However, the time is not
changing second by second.
I wonder what setting I need to changed accordingly to activate this real
Thank you very much
I believe that the intention of the software is not to do what you are
What it will do, however, is if you go out of the spreadsheet that you have
set up and then come back into it, say, 15 minutes later, it is at that point
that the NOW function wi...Display Database Modified Date on form
I would like to display the date that the database was last modified on a form.
I found a message in the newsgroup (I can't seem to find it again) that
suggested this code:
Dim fs As Object
Dim f As Object
Dim strModDate As String
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(CurrentProject.FullName)
strModDate = f.DateLastModified
Set f = Nothing
Set fs = Nothing
However, I need a little more direction. Can someone please provide some
basic assistance? I'm assuming that the code is assigne...Conditional Date Format.
I would like to conditionally format a date. I have read earlier posts on
conditionally formatting numbers but I have been unable to transfer this to
dates. Here is what I want and maybe someone out there has done this.
If the date is before some cutoff point say 1970, I want the format to be
blank, otherwise format the date in RED as m/d/yyyy.
Is this doable?
You can't blank out the value within the cell using format|conditional
But you could use format|conditional formatting to make the cell look
empty--white fill on a white background.
Select the ...Formula that displays a Modified Date
Is there a formula that will display the documents "Modified Date" is a cell?
Function DocProps(prop As String)
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties _
DocProps = CVErr(xlErrValue)
and enter in a cell such as
=DocProps ("last author")
=DocProps ("last save time")
Hi all, I have this issue with calculating dates..
In the Open Form event I want to create a message:
If the value between Today () and the date in the control [Expire] equals or
is less than 90 days?
If datediff("d",date(),[Expire]) <=90 then
Msgbox "Due to expire message . . "
> Hi all, I have this issue with calculating dates..
> In the Open Form event I want to create a message:
> If the value between Today () and the date in the control [Expire] equals or
> is less than 90 days?
issue us? Essentially I need to be able to calculate two values, one
is addition and the second is multiplication. I am getting some
strange numbers. My code is at the bottom under the ------, here are
crmForm.all.estimatedvalue.DataValue = 10
crmForm.all.new_cfp_estrev_nextyr.DataValue = 10
crmForm.all.new_cfp_estrev_yrtwoplus.DataValue = 10
This should make totalestrev = 30,
Then its getting weird, I am taking the following formula (10/100)*30
= 270? Here 10 is the value selected from the drop down value, I
is there any way I can get 00/00/0000 to be used as a default value in a
date field (Table and form).
> is there any way I can get 00/00/0000 to be used as a default value
> in a date field (Table and form).
In a DateTime field, no. What's wrong with Null for the default?
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
On Tue, 18 Dec 2007 08:59:09 -0800, "Dave" <dave@accessdatapros> wrote:
>is there any way I can get 00/00/0000 to be used as a ...Date Formatting #3
I'm trying to condense two columns of data into one clumn that has
In column A is a number between 1 and 365 respresenting the day an
month and in column B is a number (3 digits) that respresents the year
201 is 2001 and 198 is 1998.
How can I get these to show the correct date in 1 cell?
teeb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1317
View this thread: http://www.excelforum.com/showthread.php?threadid=52174
=IF(B1>199,DATE(LEFT(B1,...Excel calculation engine for fast calculations
We have a requirement to manipulate and calculate a workbook behind the
scenes with better performance. Initially we used Microsoft excel to do this
but we ended up with COM related problems (performance and problems while
killing the new instance created by us).
Later we looked at Spreadsheetgear which has most of the excel common
functionality. The problem with this one is, it has limited support for
financial functions and complex funtions. It does not execute/results
complex formulas and resulting wrong values in our calculations.
We are looking for a proper calculation engine...If/then statement between dates
Hello. I am trying to draft an if/then statement that will pull a
rate from a table and use it to multiply by a number from a different
Field: Date of Expense
I am trying to add into my form (ExpensesAll) a string to an unbound
text box that will multiply the mileage by the mileage rate that was
effective on the date of the expense. There are several different
rates corresponding to their respective start dates in the MileageRate
An...What is the formula for getting time difference e.g. ("4 hrs 15 m.
I have 2 rows - one has a start time and other has the end time. In the third
row, i want to display the difference between two times. And it should come
in this manner...
"4 hrs 15 min"..
what would be the exact formula?
A B C
1 Start Time End Time Delta
2 8:00 10:20 =B2-A2
You'll then have to format the C column to have time in the format you want.
"Sandeep Manjrekar" <SandeepManjrekar@discussions.microsoft.com> wrote in
message news:3AA54934-E119-46AE-8822-E...FRx Report with Date Range
When im running a report in FRx 6.7, we want a report for a specified date
It normally takes a defualt date range, where in i want a specified date
range to be given.
Eg: 15 Jan 2005 to 15 March 2005.
Is this possible, i tried creating a T_ATTR in the column format but the
look up window does not have anything.
THanks in advance.
You can specify specific dates in the Column Layout.
> When im running a report in FRx 6.7, we want a report for a specified date
> It normally takes a defualt date range, where...What does this calculation do?!
I am working with a colleague to create a spreadsheet to rank supervisor
performance through several aspects of the average performance of their
employees. We have been given a similar spreadsheet as an example of what is
needed. I am looking at it, and initially cannot understand what in the world
some of the calcuations are meant to do. Here is one that is meant to
calculate the "ranking score." It is a percentage determined by a target
percentage and the person's actual performance percentage:
As far as I ...Calculating the Area of objects in Feet and Inches
I am completing a project in which I need to take data collected on window
sizes and calculate the total area. The data is in Feet and Inches. If
possibe I want to be able to plug the data into excell and have it formated
so it displays 2ft 6in but is still in data form.
I have tried to do this by number formating like this #"ft" ?/12"in" but if
I typed in 2 feet and 6 inches (2.6) I get 2ft7/12in in the cell. I realize
why but I don't know how to format it in a way that excell will interpret it
as 2ft6in. Any help would be great.
After entering the heigh...calculation formulas
Since today I am facing some peculiar change in my excel files. When I
drag a formula from one cell to another cell, result of the first cell
itself are reflected in the subsequent cells. Then I have to press F9
key so that all cells give proper calculation of the formulas.
Product Price Qty Value
A 2 10 20
B 5 15 20
C 10 20 20
D 4 2 20
E 6 5 20
I did the above table in exel. Cell D2 was the result of
multiplication of B2 & C2. Thats is correct. The I dragged the formula
from D2 to D6. However in this res...calculate number of months from baseline date
On the many side of a one-to-many, my many table looks something like
(The " --- " is just to help you see when a new patient begins)
PatientID VisitNo VisitDate MonthsFromVisitZero
1 0 5/1/03 0
1 1 6/1/03 1
1 2 9/1/03 4
1 3 2/1/04 9
2 0 1/1/02 0
2 1 5/1/02 4
3 0 3/1/05 0
3 ...Calculating an average
I have a form that has a list of training tasks with a check box beside each
one. I want to calculate an average score of completed tasks on the form
itself, so that whenever an employee has completed a new task the score will
update. It's a set number of tasks that will never change. Thanks!
On Wed, 02 May 2007 17:54:23 GMT, "bhrosey" <u33878@uwe> wrote:
>I have a form that has a list of training tasks with a check box beside each
>one. I want to calculate an average score of completed tasks on the form
>itself, so that whenever an employee has completed a ...Mailmerge date fault!!!
I have recently notice an annoying fault or feature :-)
When I do a merge from Excel to Word, the date seems to be have been
changed to mmddyy and not the ddmmyy I want.
I'm using Word and Excel 2003
PC is set to Uk with the date format correct
Excel date column is formatted to show ddmmyy
Word language is set to UK
Debra Dalgleish posted this:
There's an article on the Microsoft web site that might help you:
Answer Box: Numbers don't merge right in Word
And if you prefer the ol...Determining Last Access Time for Messages
Our company just bought a third-party archiving software and I've been asked
to come up with some archiving policies. We didn't purchase consulting (my
boss's idea not to) so the vendor isn't being too helpful when it comes to
sorting out how old emails have to be before they get archived, although
they did say we don't want to set the archiving age too "young" or else
there will be too much traffic into the archive servers and delay for the
Is there any way to get the Last Accessed time for an entire mailbox or even
better, a whol...Calculate Sliding Scale Calculation
I need to be able to calculate a commission as follows:
Total Commission (0-$100, 5%)+($101-399, 10%)+(>$400, 15%)
This would calculate a different percentage for each of the ranges
above and then add them together. I hope I'm making myself clear
because I'm confused just writing this.
It seems like there should be a very easy way to do this in Excel.
Any assistance would be most appreciated.
In article <email@example.com>,