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...Excel Query #3
I want to use an Hanging Indent for the text within a
cell. I can do it by spliting that into two different
cells but I feel that would be wrong.
Financial Data for
the year ended 2K
Please note that the text data should be in the same
cell.If any one can help me.
can't be done with Excel. You may insert a manual linebreak with
ALT+ENTER and insert some spaces but an automatic ident for the second
line is not possible with Excel
> I want to use an Hanging Indent for the text within a
> cell. I can do i...Anti-virus software disabling Money's internet access
I tried to open my Money file today (Plus Premium) but it immediately balked
about not being connected to the Internet. After doing some checking, it
turns out that ZoneAlarm had quarantined some part of the Money programs.
If you suddenly find that you can't get online, you might want to look at
"Digid" <Digid@discussions.microsoft.com> wrote in message
>I tried to open my Money file today (Plus Premium) b...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...Can't access pst file
I had a problem with my computer which the computer guru
resolved. Now I can't access Outlook. The program opens
but it cannot access my files. I would think there should
be some place where you can find out how to log into these
lparticular "pst" files but I can't find it. I only use
two or three names and passwords so I could get in if only
it gave me the opportunity. Anybody know the cure??????
If you know where your .PST files are, you should be able to open them from
within Outlook using File | Open. What version of Outlook are you using?
MV...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...inability to assign anonymous client access to the free/busy public folder
I have 3 MS Exchange 2003 servers, 2 of which the
free/busy public folder access is fine, the third one I
can not change to assign anonymous client access to the
free/busy public folder.
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
Shell "C:\Program Files\Internet Explorer\iexplore.exe", vbNormalFocus
SendKeys "www.google.com", True
This procedure can open IE, but the URL isn't entered into address bar.
If you hard coding the URL why bother with sendkeys, why not like this
MyPage = Shell("C:\Program Files\Internet Explorer\IEXPLORE.EXE
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
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 ...Using Access 2007 to open ADP files from Access 2003
I have a few ADP files created in Access 2003 that connect to a SQL Server
2000 database. They have a lot of complex forms, reports, and extensive VBA
I just upgraded to Windows Vista and Office 2007 through MSDN, and when I
open the ADP files in Access 2007, they are excruciatingly slow and sometimes
seem to choke entirely when loading some forms.
Does anyone else have this problem or know what to do about it?
I posted a comment a few days ago noting slowness of Access 2003 and 2007
with Vista in just running queries. So far there have been no responses.
Hopefull...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...Total a column (or row0 by highlighting cells
Isn't there a way to total a column of numbers without using the AutoSum
function. I seem to remember that I could just highlight a series of cells
and the total would be shown in the fx box. I can count the number of rows by
just highlighting them. Can't I do the same thing to total by simply
highlighting a group of cells?
Right click on the box in lower right of XL (not sure what its exact name
is, its in the status bar to the left of where "EXT" appears when you strike
the F8 key...)
Change this to display the operation your prefer.
Best Re...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...Access in guest acct XP Pro
i need to allow a guest account to use the PC, but deny access to
Control Panel, Network Places.
Lots of pretty complicated regedits, gpedits, etc.
any easy, less scary way?
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 ...ldap query #8
I have to find users in a particular domain: is it possible make ldap query
That wasn't a lot of inormation...could you be a bit more specific?
"Damb0" <Damb0@discussions.microsoft.com> wrote in message
> I have to find users in a particular domain: is it possible make ldap
> like this
> (distinguishedName query=*domainname*)
> any help
I'll assume Win...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 ...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 <firstname.lastname@example.org>,
"Andy" <...MS Query not finding network Access db
I tried using MS Query to query a secured Access database
that resides on a network, but Query won't let me select
the database as a data source. Can someone tell me why,
and what I need to do? Thanks in advance to anyone who
...calculate swim times
How can I track swim event times - mm:ss.ms format? I need to go two digits
deep in the MS format. This is to be used to track swimmer's times and
Thank you all for your time and help.
Format the cells with
In article <46dGc.9460$Bv.email@example.com>,
"saladbar" <firstname.lastname@example.org> wrote:
> How can I track swim event times - mm:ss.ms format? I need to go two digits
> deep in the MS format. This is to be used to track swimmer's times and
> chart progre...