<span> and filters
I have a lot of junk mail coming in and my filters take care of most of it.
The problem I have is with people using the <span> function to disguise junk
I had hoped that an outlook rule would recognise <span and send it to my
junk e-mail box but it doesn't.
Any advise would be greatly appreciated.
"CGR" wrote in message
> I have a lot of junk mail coming in and my filters take care of most
> of it.
> The proble...Displaying Time on the Calendar
In 2003, you could schedule an appt. for 11:15-11:45 and those times would
appear on the calendar. In 2007, the times don’t appear. Is there a way to
make them appear?
What time scale do you use? Which view?
They should show if they are out of the scale - if the appointment length
is not a multiple of the time scale you are viewing, the times will show.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
mailto:dai...first time connection after booting
I would be grateful for any help with this. I embedded WMP in MSAccess 2003.
The first time I open WMP set to a url avi file on my local drive it is super
slow. BUT THIS IS ONLY AFTER I BOOT THE COMPUTER. If I close and reopen the
db when the system is on it is fine until I restart the computer and again
have the same issue. I am using vista 64. Your help is greatly appreciated.
set to autostart
strURL = "c:\mylocation"
Me.WindowsMediaPlayer0.URL = strURL
Never heard of WMP in Access 2003,only in visual basic & visual studio..
Youre best bet ...Run time error 2465
I'm trying to open an access db and upon loading or opening I get Run
Time Error 2465 Can not find field 'cmdLock' referred to in your
expression. When I go to Debug I see it highlight the line in
frm!cmdLock.Caption = IIf(bLock, "Un&lock", "&Lock")
It seems OK, what am I missing?
One other strange thing, (well strange to me) is that this db is
located on a network drive. No one else has this problem, but me?
When an application works on other PCs, but fails on one PC, this is usually
a sign of a MISSING reference...Missing printers causing long boot times?
A Vista Business 64-bit was booting fine until an Epson printer decided
that the ink was low, put a two page document into the queue, and never
operated properly since. We first deleted the printer object,
connected to another printer on another workstation, and were able to
print. But that failed on the second attempt to print, so we waited
for the refurb Lexmark to arrive. The Lexmark works fine, prints like
a champ, but the boot still takes forever.
Is there a log that I can look at to determine if time is being lost
while the boot process looks for the old Epson printer...Calculating sum of two given times.
Is there a way to calculte the sum of two given times? For example, A1 says
08:00 and B1 says 17:00 then C1 will auto calculate "9". Also, if it can be
done, because my time is always based on quarter hour, will the end result
show a fraction? Example, A1is 07:45, B1 is 17:00, then C1 is 9 1/4.
<< Is there a way to calculte the sum of two given times? For example
08:00 and B1 says 17:00 then C1 will auto calculate "9".>>
=(B1-A1)*24 and format Cell C1 as *_general_*
<< Also, if it can be done, because my time is always based on quarte
I have Time values in column A i.e 2:30, :45. I want to add a column showing
these times as values. I want column B to show 2:30 as 2.5 hours and :45 as
Is there a formula I can use?
....and format as 'General'.
Hope this helps!
In article <AEF5E34F-CD93-4E49-AD37-7B1785876D8E@microsoft.com>,
"tojo107" <email@example.com> wrote:
> I have Time values in column A i.e 2:30, :45. I want to add a column showing
> these times as values. I want column B to show 2:30 as 2.5 hours and :45 as
> .75 ...Convert Text Time to Time
I have text in the following format:
How can I convert these text to 8:00 AM, 8:30 AM etc...
mdalby's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=705
View this thread: http://www.excelforum.com/showthread.php?threadid=26248
=INT(A1/100)/24 + MOD(A1,100)/(24*60)
>I have text in the following format:
>How can I convert these text to 8:00 AM, 8:30 AM etc...
>...SQL Time on Worksheet 250/260
We are creating a rather large worksheet 250/260(> 33,000 items). It works
fine on one of our stores (running SQL 2000 SP4 same location as HQ) without
any issues. When we run the worksheets for the other store (SQL 2005
Express), it runs for an indetminiate time (about an hour) and fails. The
worksheets run if we break the number down to less than 5000 items.
Ref. No.: 52610
4/15/2007 10:58:56 AM Updated 3 record(s) in table 'QuantityDiscount'.
4/15/2007 10:58:57 AM Updated 3 record(s) in table 'ItemClass'.
4/15/2007 11:47:01 AM <<ExecuteCommand>...overlapping textboxes
Is there a way to save textboxes that are in a layout overlapping one another
as a pic, the way text can be saved as a pic?
What prevents you from overlapping?
Don - Publisher 2000�
"firstname.lastname@example.org" <email@example.com@discussions.microsoft.com> wrote in
> Is there a way to save textboxes that are in a layout overlapping one
> as a pic, the way text can be saved as a pic?
Which version of Pub are you using?
Microsoft MVP Express...Superscripts & Overlapping Text
I wish to place a trademark symbol "TM" close to my text and change its
font size to make it smaller. When I make it a smaller font size and
make it a superscript its vertical position changes to be too low. So
I've tried to put the TM in it's own frame box, but when I move it close
to the other text, that text disappears. I've tried sending the objects
forward and back and making them transparent to no avail so far.
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Lefty Smith <firstname.lastname@example.org>...
> I...Workflow Time out
I am trying to write a workflow with a timeout so an email can be sent 2
months prior to a specific date field. The workflow fire but just keeps
waiting even past the 2 month time frame. I am not sure what I am doing wrong
The workflow states:
workflow -> Timeout -> Equals months:2 Before Client License Information:
Maintenance Exp. Date.
I believe this is correct. Can some please let me know what I am doing
I've seen issues sometimes with workflow timeouts or wait states which
fail to trigger if the condition is already met when the workflow runs.
...Oulook logging the wrong time
When I send a message from Outlook, the recipient within the same office
gets it as being sent an hour later. The client sending the mail has the
clock set for the right time and the time zone is also correct. No other
computers in the office are having this issue.
Sorry - forgot to check the savings time
"boe" <email@example.com> wrote in message
> When I send a message from Outlook, the recipient within the same office
> gets it as being sent an hour later. The client sending the mail has the
> clock set...entering time into a cell
i have a friend who says that she used to have a workbook where she would
type 8.3 into a cell and it would automatically change to 8:30 etc .. .after
her system was upgraded (don't know the specifics) this no longer works ...
maybe she had applied a custom format such as
"JulieD" <JulieD@hctsReMoVeThIs.net.au> schrieb im Newsbeitrag
> Hi All
> i have a friend who says that she used to have a workbook where she
> type 8...Overlapping time intervals
I have three jobs that a piece of equipment can perform: one to put
away, and two to pull out.
Each job has one start time and one end time and the three jobs may
overlap either or both of the other two.
What I would like to determine are discrete answers for:
How many hours is only one job active;
How many hours are two jobs active;
How many hours are three jobs active?
The first answer is the total hours minus the sum of the other two
calculations and I can get the hours for two jobs with:
I am having some problem comparing 2 time values. When I compare 28:0
(mm:ss)(H9) to 28:12 (H10) (formula: if(H10>H9, "Pass", 'Fail"), I ge
"Fail". But when I do the same thing using lookup, I get "Pass"
Sheet3!A2 is age of the person
Minimums!D2:D35 is time based on age, A2:A35
I also have a formula that displays"Fail" if any one event display
if(or(c2="Fail",F2="Fail,I2="Fail"),"Fail","...the PowerShell ?? regular expression quantifier
The ?? PowerShell regular expression quantifier is defined
"Zero or one matches, matching as little as possible."
Wouldn't that always be zero matches?
Can someone provide an example of how to fruitfully use ?? as a regular
expression in PowerShell?
On Apr 3, 3:08=A0pm, Larry__Weiss <l...@airmail.net> wrote:
> The ?? PowerShell regular expression quantifier is defined
> =A0 "Zero or one matches, matching as little as possible."
> Wouldn't that always be zero matches?
> Can someone provide an example...Times New Roman Bold in Word for Windows not showing up correctly in Word for Mac
Operating System: Mac OS X 10.6 (Snow Leopard)
I created a Word document in Word 2007 on Windows XP. The document has certain text formatted as "Times New Roman" with bold (I'll refer to this text as the "Test Text"). The font dialog box shows the font type for the Test Text as "Times New Roman" and the "bold" option is selected. <br><br>I emailed that document to my Mac OS X and opened it with Word 2008 on my Mac. The document formatting for the document as a whole look...Question on Time zone settings on mailboxes
We have a 2-node Exchange cluster that houses mailboxes for everyone
in the company. The servers are in Eastern time zone, but our users
are all over the country. We applied all the DST patches to the OS and
Exchange 2003 itself, and ran the Exchange Calendar Update tool. When
we ran the tool, it came up with about a dozen "conflicts" and a slew
of "nonexistents" (users whose timezone couldn't be determined).
This leads me to a couple of questions:
1) should I be setting the time zone for my users to the location they
are in? Or should they be set to what time zone th...Calculating Clock start time in Excel
I am trying to calculate when an inquiry comes in to our helpdesk
outside working hours and when it was answered based on the follwing
Working hours are 08:00 - 17:00 Monday to Friday.
If inquiry comes after 17:00, then the inquiry is attended the next
working day and an answer is guaranteed by the close of following
working day. If the inquiry comes during working hours, again the
garantee is for the answer by close of next working day.
I need to be able to measure how long an inquiry has missed the
promised deadline by.
Can anyone help please?
I am trying to figure time worked on a daily basis. I have done thi
formula before, but have forgotten how to complete it.
My times look like (2nd shift hours)
The formula needs to calculate hours worked greater than 5.5 to tak
out 1/2 hour lunch, and hours worked less than 5.5 to calculate tota
hours with no lunch. We do not clock in and out for lunch breaks, i
is an automatic deduction, but somebody has earased my formula.
LGrobe's Profile: http://www.excelforum.com/memb...overlapping elements in tabs
how can i manage to avoid overlapping elements in tabs.
for example: if i have a group box and want to use a check box in the
group box header sometimes it works, but most of the times the check
box is hidden under the group box.
is there an option to 'order' the elements like we know it from
thanks for the help - happy easter
"baeman" <firstname.lastname@example.org> wrote in message
> how can i manage to avoid overlapping elements in tabs.
> for examp...Access 2007 Run-time Error 2467 when accessing a listbox value on a sub form
I have a database that has been in production on Access 2003 for quite
some time and has run without errors.
A user's machine was recently upgraded to Access 2007 and now the
database throughs a Run-time Error 2467 "The Expression you entered
referes to an object that is closed or does not exist" on the
following line that references a listbox value on a sub form.
If Nz(Me.sfrm_Consultant_Contract_Request.Form.Cmb_Consultant.Value) =
I changed the code to
""...How can I Sum time duration?
I have a spreadsheet that is output from an in house system.
One of the columns is "Duration", and is of the form "+0 hh:mm:ss.xxx", e.g.
"+0 00:09:11.983" where I'm guessing +0 is the number of days and is always
0 in my examples, and hh:mm:ss is hours:minutes:seconds and xxx is
milliseconds. I want to be able to add all of the Durations to arrive at
total time, preferably as a largish number of minutes, typical totals being
up to millions of minutes.
I've tried using Sum, but this returns 00:00:00
I'm sure there must be an easy way to do thi...Opening a word file opens "New" every time
Every time I open a file from a folder by double-clicking it opens as
"New" and I'm unable to save it over the same file. In order to open it
I have to right-click and click "open". The "New" opention from the drop
down menu is also bolded. How do I change the default to "open" not
"open new" ?
First try the simple fix: Click the Windows Start menu and choose Run, type
(note the space before the slash), and click OK. That will rewrite Word's
registry entries and may fix the pr...