How do I get column headings to stay visible at all times in Exce.
I need the column headings to stay visible at all times on teh screen, and
not just when you print the document?
Select the ENTIRE row immediately under your column headers then goto
"nemmettiv" <firstname.lastname@example.org> wrote in message
>I need the column headings to stay visible at all times on teh screen, and
> not just when you print the document?
Select Cell A2. Windows->Freeze Panes to hold row 1 inplace
or select B2. windows->Freeze Panes to ...Extracting only time in CRM Reports
I created Case-activities detail report using SRS. I need to get only the
activity modified time(local time). I used the following expression on the
iif (Fields!modifiedonutc.Value is nothing, "",
and got the following error:
Object variable or With block variable not set
I should not get the above error because if the modifiedonutc is null, it
should not change to localtime, right?? However, it is changing to localtime
even the condition is not satified.
Any idea would be greatly appreciate...Record time peroid to run code
Is there a msgbox method that will record the length of time it take for
code to complete its execution.
Dim StartTime As Single
StartTime = Timer
'do code here
MsgBox "Code took " & Timer - StartTime & " seconds"
*Remember to click "yes" if this post helped you!*
> Is there a msgbox method that will record the length of time it take for
> code to complete its execution.
> Thank you.
The topic i...date / time difference
in A1 previous date
in A2 todays date
in A3 i have formula.... =DATEDIF(A1,A2,"d")
Not working, how do I get it to show the length of time between the 2
dates. Years and months
I have cells formulated to dates
Can anyone sort for me
What is "not working"?
Error or ???
Works fine for me with real dates. Are the values valid dates?
=DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, "&
DATEDIF(A1,A2,"md") & " days"
Gord Dibben MS Excel...Emails sent to a distribution list are delivered multiple times
A user has sent an email (marketing info) to a distribution list (50+
addresses), the email is delivered to every address 50+ times.
We have here Exchange 1003 with all the latest patches, emails are sent
through a smart-host of our ISP.
What can we do to prevent such things from happening?
If I understand your question correctly then here it is .....
Under Exchange General Tab of your DL select the option "From Authenticated
> A user has sent an email (marketing info) to a distribution list (50+
> addresses), the email is ...Business Portal Time & Expense Approval
It would be nice to be able to customize the 'Details' screens that a Time
or Expense Approver sees? I have a customer that wants to be able to see
Expense notes but there appears no way to do it as these pages are compiled.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I...Min Max buttons of Excel Worksheet
I recently recieved an Excel file from someone where the Min, Max & Close
buttons of the Excel Worksheet are disabled.
Also you cant move the Worksheet window around.
How is that done ? How can they be enabled ?
I know VBA coding & there are no Modules or code in the worksheet. Is this
just a setting ?
Any help would be greatly appreciated.
The workbook is protected I think
Tools>Protection.....Protect workbook (Select Windows)
Regards Ron de Bruin
"Jeff" <Jeff@discussions.microsoft.com> wro...Time Calculation
Can somebody help please.
I am trying to enter this formula but something does not seem to work.
Cell C2 containes a time data in the format HH:MM:SS
i am trying to enter in cell D2 the following formula:
This does not seem to work with time, though it does work with general
Thanks in advance
If C2 is the result of a calculation, be aware that if...Minutes to hrs calcultion
I have a form where you enter minutes but the calculation needs to give the
result in Hr:min. I've tried
The result being 3.3 but I need it to show 3hrs 20 min
Sounds daft I know!
You could try the following:
=INT(A2/60)&" Hrs "& (MOD(A2,60))&" mins"
this will look at A2 - if it has 200 the formula will translate that to
3 Hrs 20 mins
Mark Lewis wrote:
>I have a form where you enter minutes but the calculation needs to give the
>result in Hr:min. I've tried
> A2=180 A3=20=SUM(A2,A3)/60
...Max and min
I would like a formula to anticipate the expected maximum and minimum of
votes for each political group in the elections and that the variables are
necessary to know
Thanks in advance.
...PLEASE HELP: Display current Date & Time in Query Output
How can I display current date and time in query output?
Is there a way to do this?
Thanks in advance
You can use the built-in functions of Date() and Time() in the query.
Microsoft Access MVP
> Hi All,
> How can I display current date and time in query output?
> Is there a way to do this?
> Thanks in advance
On Sun, 25 Apr 2010 20:39:01 -0700, sam <email@example.com> wrote:
>How can I display current date and time in...Time Format Auto Entry AM and PM
The default time format is AM. I would like to create a format for cells that
will only have PM entries. When someone writes 2:00, it will automatically
upon exiting cell create 2:00 PM. I've looked in help and tried alterations
of the General Time Format - No Luck. Is this a can do? BULAMAN
I think you'll need VBA. See:
> The default time format is AM. I would like to create a format for
> cells that will only have PM entries. When someone writes 2:00, it
> will ...Abililty to Display Time portion of Date Time field
I'd like to be able to display Date and Time of certain timestamps on the web
client screen. At the moment I can only show the date even though the
database holds the Time aswell. This is very limiting as my users need to be
able to see response times in hourly terms on Cases.
This issue comes up again and again. We currently have cases that need a
response within 24 hours or a penalty charge of $25 is made. Not being able
to see the time is an absurd oversight.
> I'd like to be able to display Date and Time of certain timestamps on the web
>...Turning One Time Gain Into Compound Annual Return
If you will receive 100 + X% of an investment in Y months, what is the best
way to calculate the annual compound return represented by that?
On Jun 10, 9:22 pm, "Will" <westes-...@noemail.nospam> wrote:
> If you will receive 100 + X% of an investment in Y months, what is the best
> way to calculate the annual compound return represented by that?
Two equivalent ways are:
=(1+x%)^(12/y) - 1
=(1 + rate(5,0,-1,1+x%))^12 - 1
PS: I assume you mean that you invested 100 and you will receive
100*(1+x%) in Y months. That is, your investment will grow by x% in Y
...Run Time error When Outlook XP starts in WXP
I just upgraded my Dell PII 400 from W2000 SP4 to WXP SP1.
I was having a lot of problems with Outlook XP (all updates applied)
crashing multiple times while in use, which was 1 reason for the upgrade.
Now when I start Outlook, most times I get a message box entitled:
'Microsoft Visual C++ Runtime Library'
with the text:
abnormal program termination.'
When I click OK, Outlook closes. The next time, it starts OK, but has to scan
the Personal folder for errors.
"In an era o...Excel 2003
This is a bit like my last question. I want to fill a cell with
either the minimum of two values, or, if that minimum is either zero
or negative, then 0. I'm using
However, if cell f26 is empty, this formula will show the value of
f28, rather than showing 0 as I had intended. Is there a version of
this formula I can use that will automatically assume that blank cells
MS Excel MVP
"Guest3731" <firstname.lastname@example.org> wrote in...When searching this type of folder, you can't search other folders at the same time
I have a user that is trying to use Advanced Find to search another users
mail box for and e-mail in Outlook 2000 Sp3.
When the user selects the browse button to select more than one directory to
search, the following error message appears "When searching this type of
folder, you can't search other folders at the same time".
Also, if a top directory is selected, Advanced Find does not do a recursive
search, but only searches the selected directory.
The user has the owner role assigned to the folders in question, so I don't
think that's it to do with permissions....program loading time
The money 05 loads very slow, I have archived everthing past 90 days but it
still loads slow. Any suggestions?
In microsoft.public.money, oltexasboy wrote:
>The money 05 loads very slow, I have archived everthing past 90 days but it
>still loads slow. Any suggestions?
Restore the archive as your main file, if you have not gone too far
with it since the archive. Archiving did not help your speed
appreciably, and you might want to refer to that older data.
Consider reducing scheduled bills. Remove accounts from the budget
if you think that would be appropriate.
Set your start page t...when recieving email the time is off how do i reset time
How do i reset my time on my microsoft outlook email the time is right on my
computer but my email time is off
On Mon, 5 Nov 2007 09:56:03 -0800, Lori Bucknell wrote:
> How do i reset my time on my microsoft outlook email the time is right on my
> computer but my email time is off
You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
Please repost to the correct newsgroup for whatever program you are
using. I would suggest you include your Windows and Office version
number in the message.
Please r...installing WLM second time
I had uninstalled my WLM because there were some issues with it (not all the
e-mails were coming through) and then tried to install again - but got
message that I have the copy of it already. I cannot find that copy anywhere
on my computer and cannot download it either. Fortunately, I managed to
install it on toolbar and that's how I can access it now - but how can I find
it on my computer (advanced search turned the WML folder only) or add to my
Anyone knows what's going on?
In Control Pane for Programs to uninstall it will be listed under
Windows Live Essen...Search for documents by time modified
I need to narrow a search for documents by author, a range of time (say from
5 p.m. to 8 p.m.), and a range of years (say from 1998 to 2004). They would
need to include Word Perfect and Word documents. Thanks for any help.
Version of Windows?
Use Advanced Search.
But if you're using Word2007 in Windows XP, you might not have much of
a search function (it pretty much got moved from Office to Windows
with the new versions).
On Feb 19, 9:01=A0pm, D. Ring <D. Ring @discussions.microsoft.com>
> I need to narrow a search for documents by author, a range ...How Can I Know last time was activity on a database
I'm doing a process that uses databases from sys.databases.
I would like to know when is the last time happened some activity there.
I've tryed to look at sys.tables but only shows me last structural change on
it. Not last time data has changed.
How this can be done?
SQL Server doesn't store this information (imagine the overhead for all
those who doesn't need it). You can for instance use a trigger to keep track
of that information.
Tibor Karaszi, SQL Server MVP
http://sq...calculate time and date
I want to find out how many houer iy is between one date/time and
another date/time. date and time one cell A1= 04.03.2005 08:30
date/time two cell A2= 05.03.2005 23:59
custom format [hh:mm] or for Norway [tt:mm]
"make" <email@example.com> wrote in message
> I want to find out how many houer iy is between one date/time and
> another date/time. date and time one cell A1= 04.03.2005 08:30
> date/time two cell A2= 05.03.2005 23...Time segments in OWA
I need to change the time segments in OWA when creating new
appointments. The default is 30 minutes but I need 20 minutes. I can't
seem to find the right code in the exchsrvr exchweb controls. I'm close
but can't find the time array expression tha generates the 30 minute
Can anybody help me with this?
Techhead <firstname.lastname@example.org> wrote:
> I need to change the time segments in OWA when creating new
> appointments. The default is 30 minutes but I need 20 minutes. I can't
> seem to find the right code in the exchsrvr exchweb c...How to Calulculate Hrs and Mins between time frames
This is a multi-part message in MIME format.
If i have 2 cells with time values say: A1=3D7:30AM and B1=3D3:30PM.
7:30AM - 3:30PM set to NORMAL Hours
3:30PM - 6:30PM set to TIME & HALF Hours
Any time after 6:30PM - 7:29AM to be DOUBLE TIME hours
Then if i set 4 other cells for data input:
A2=3D( DATE 1) 29/5/2009 Start date. B2=3D(Date 2) 29/5/2006 =
A3=3D(Time) 7:30AM Start Time. B2=3D (Time) 7:00PM =...