user initials and auto correction
Can someone please help me with the following...?
People usually type JD in the To: field when they want to send me an email
via Outlook. After a recent addition and deletion of another account with
the initials of JD I'm finding that it is default to this user - and it's
not even trying to qualify the correct recipient with a list of possible
users, like it does with other similar users.
I would like it to ask for qualification and also default to my account. Any
"Joey D" <email@example.com> wrote:
>Can...parsing a date and time field #2
I am having trouble parsing the date and time in a field. I download
data from a data base and the date and time come together in one
field. I want to seperate the two. The date and time comes across as
the following: "2/1/2009 14:37" in the cell. When I parse it, it
seperates into three columns as follows: "2/1/2009", 2:37 AM", and
"PM" I can see what is going on but I would like to get two columns
with one as the date and the other as the correct time. are they any
ideas on how to address this?
Try using the TimeValue and DateValue functions.
First format ...MS Office 2008 home version with Pro for entourage
Hello and thanks for any help you can provide.
I have MS Office 2008 Home & Student edition. I want to install only
word, excel and powerpoint and then separately install Entourage 2008
Pro (as provided by my hosted exchange co.) in order to connect to my
exchange server. I have done this before and remember some convoluted
errors but it eventually worked. My latest attempt did not. Has there
been a change to prevent this from working?
...Day of week time control
Let's say I wanted something to occur at specific times (via DDE) on Sunday,
a different thing on Monday -Tue, Wed, Thurs, Fri Sat and continue over and
I see how I can know the day and time, but to use it in a formula escapes
The use is for a simple area based light control in my house.
"vernon" <there@there> wrote in message
> Let's say I wanted ...moving payables data from open to history
A client says that someone imported data about a year or two ago into Great
Plains from their AS400.
Many payables documents that were imported should have been coded during the
import as open, instead of history. The client knows that she can take care
of this herself within two hours, by simply turning off the posting to the GL
and entering and posting the payables documents to move them to history.
But, she is wondering if there is a quick and easy way to do this on the
I'm familiar with the open and history payables tables within GP. And, I
know through a T...SharePoint (WSS) 2007 / Outlook 2007 - Alert
This is a multi-part message in MIME format.
We have setup a SharePoint Server (WSS) 2007 and are using the alerting =
After we changes stuff on WSS, an alert message is generated and sent to =
an email account.
This e-mail account is hosted on an Exchange 2003 server.
When using Outlook 2007 to open the e-mail, we get:
Cannot open this item.
Wenn using OWA the e-mail can be opene fine.
Does somehow have an explanation for th...disable Review toolbar which came up automatically when opening a.
How can I disable the Review Toolbar which comes up automatically when
opening a file?
In the Workbook VBA actions.
The top left hand corner there is an Excel logo, not the one in th
blue program bar, but in the menu bar.
Right Click and select "View Code"
There will be two drop down boxes one that will probably say General
if this has never been entered previously.
Change the box on the right to Workbook.
Then Change the right hand box to "Activate"
Insert the following code
Application.CommandBars("Reviewing").Visible = False
exit the VBA screen and t...Indiana Time Zone
Indiana, which has always been on Eastern Standard Time, has changed to
observe Daylight Savings Time. As we switch computers over, we have noticed
that all day appointments now appear in two days during daylight savings
time. Is there a patch to fix this issue or do have have to go in and
manually change all the appointments.
Instruct all your users to change their timezone to the normal Eastern time,
and change all your servers likewise.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"d3harvey" <d3harvey@discu..."the wizard is unable to open your query in datasheet mode, possi
"the wizard is unable to open your query in datasheet mode, possibly because
another user has a source table open in exclusive mode. your query will be
opened in design view"
what this message mean ,and how can i solve it
Please provide more details as to what you are doing when you get the error,
what your database setup is (i.e. split Fe/BE?, multiuser?, version? etc).
Without more information, we can only guess.
>"the wizard is unable to open your query in datasheet mode, possibly because
>another user has a ...How do I make a chart with several times during a day
This seems like it may be a simple thing, yet I can not for the life of
me figure out how to do this (or at least semi-easily with VBing it for
I have a simple table filled with the following information (example
12pm 5pm 10pm
11/20 5 4 7
11/21 5 4 7
11/23 5 4 7
11/24 5 4 7
11/25 5 4 7
So basically I am keeping track of a numeric value three times a day. I
would like to make a chart of it with...how to config Server for one user which has 2 mail address.
we have one NT4.0 + Exchange 5.5 Server "A" Email firstname.lastname@example.org ��and
windows2003 + exchange 2003 Server "B" email@example.com user name is same in A
B��Mx record was be set ,question is how to config Exchange 2003 to receive
down the mail to Server A , because of we need to replace A with B.
thanks a lot.
E2K3 setup guides you through common scenarios (like yours) pretty much holding
your hand - on welcome screen tell it that you have existing E55 org and want to
join it, then follow on-screen instructions. Having usable backup of Exchange
databases and AD i...Excel 2000 vs. Excel 2002
I am having troubles with a workbook that I created that is havin
I created it in 2002, and it opens fine in Excel 2002 for other people
However, when I send it to someone who has Excel 2000, it takes over a
hour to open.
Now I also made a very similar report that works just fine whe
trasferred to excel 2000.
Here are a couple of stats on the workbook that is having problems:
500+ externel links
200+ simple calculations (a1+b1; a1/b1;etc..)
1 Worksheet in the book.
2 columns with conditional formatting
Message posted from http://ww...Time update as a limited user not working
I added time update permisssion to my limited user acct. but it does
When I try, the time synchonization is greyed out.
How can I get it to work.
On Apr 4, 12:33=A0pm, Mint <chocolatemint77...@yahoo.com> wrote:
> I added time update permisssion to my limited user acct. but it does
> not work.
> When I try, the time synchonization is greyed out.
> How can I get it to work.
Is this Windows MCE SP2?
What method did you use to add time update permission to your limited
Does your unlimited user accou...Office 2004 issue with documents NOT BEING ABLE TO OPEN APPLICATION, but application can open documents.
Just migrated all my files and apps from a G4-400 to a new Mac Mini
1.87ghz Intel running pre-installed OSX10.4.10.
Used CD to install 'normal' version of Office 2004 Mac on the new Mac
Mini. In fact its the same disk that I used originally to install Office
on the G4-400.
Neither old .xls and .doc documents (made on old Mac, nor new .xls and
..doc documents (made on new Mac)will not open their respective
applications, when clicked upon.
However, when I use either of the the application's "Open" feature,
theres is no pr...Opening .prn files in XL2000
I am using a software that does not save data/reports in .csv or .xls
formats; only in printed versions. Is there a way to save the printed
report in a file and open the file in XL2000? If there is, how is the print
file produced, where is it saved, etc? A friend suggested setting up a
generic printer but didn't know how to go about it.
You may want to give that other software just one more chance--look under File
and see if there is a SaveAs option. You may find something upon further
But if you want to add a generic printer, I think it'll depend on your version
of win...Trying to open the current db in Access 2010 through Access Basic
I haven't programmed in Access Basic in quite a long time. Through Access
Basic coding, I use to be able to open the current database and then open a
table and walk through each record. Now I can't even open the database.
Does anybody have an example of how to do the following:
1) Open Workspace
2) Open Current Database (assume name is unknown during run time
3) Open specific table
4) Step through each record and access the fields
George C. Derkacs <George C.
>I haven't programmed in Access Basic in quite a lon...Reminder Time vs Due By Field
I'm using O2003. For a contact, there is the Due by Field. There is
also a Reminder Time field. If you update the Due By field, it updates
the Reminder Time field. However, if you update the Reminder Time
field, it does not update the Due By field. By default for a contact,
you have access to the Due By field. The Reminder field is avaialble,
but you have to manually add it.
In Tasks, it seems to work the same in that if you update the Due By
field, it updates the Reminder Time field. However, if you update the
Reminder Time field, it does not update the Due By field.
However, you have a...Limiting CRM application ability to aasigning user to approprite CRM security group
IT administrator that I have for client does not like the idea of CRM
application assigning user group automatically. They prefer to do the
security group assignment manually.
Is this possible? What do I need to do to achieve that?
I did it the following way for a customer:
1) You will need to precreate the five groups within your AD. There is no
need of having a own OU (Container, Organizational Unit) for them. Follow the
naming convention of your company or use the default namings from Microsoft
for the five groups. There is no need for your AD Admin to assig...Won't save office applications, appcrash
Help I cant save documents , excel etc in office 2007 on vista laptop. I have
tried open office but this suffers the same problem. Also tried uninstalling
and reinstalling office but no change.
see below for word report, in excel the fault module was given as PROPSYS.dll
Problem Event Name: APPCRASH
Application Name: WINWORD.EXE
Application Version: 12.0.4518.1014
Application Timestamp: 45428028
Fault Module Name: unknown
Fault Module Version: 0.0.0.0
Fault Module Timestamp: 00000000
Exception Code: c0000005
Exception Offset: 00000001
...MS Office Excel97: Removing Page Breaks
How do I remove page breaks? For some unknown reason they started appearing on a
spreadsheet recently. I see dotted lines dividing up the sheet and large "Page
...." in the background. According to an Office 97 book I have, I should go to
Tools->Options->View-tab and set the Page Break option off. There isn't any. If
I right click outside the page area, I see PG menu items but none seem to work.
There's also a PB View in the View menu, but clicking on it doesn't seem to do
Wayne T. Watson (Watson Adventures, Prop., Nevada Cit...Help
I tried to work on Word today for first time on newish Mac and
realized none of my Office applications work.
When I double click on Word I can see something happening as I get the
circle of colours twirling, but half an hour later it still hadn't
opened. I just have to do this as quickly as possible as I have a
deadline for what I have to do Monday at 12.
I've tried reinstalling the software, but that didn't do anything for
me. Mind you I know absolutely nothing about installing anything on
Mac computers so I could be doing it all wrong.
Do any of you have any idea what c...Creating formulas to calculate time on a 24 hr time clock
I have to create a spreadsheet that will calculate total
hrs worked. I've tried several different ways but I guess
I don't know enough about building formulas to actually
make the thing work. For example, I used a basic formula
D3=A3-B3+IF(A3>B3,1)*12. This works to show the time but
not the number of hours worked. If an employee comes in
1/2 hour late, it does not properly calculate this. How
can I correct my formula?
I have tried your formula and it works fine (with start time in B3 and
finish time in A3). Format the reult as h:mm and it's OK.
"MWI...Macro help with saving a spreadsheet with date and time in it
Can someone help me with some code that would save a file name as
Alan, how about something like this
ActiveWorkbook.SaveAs Filename:="Schedule " & Format(Now,
"mm-dd-yyyy-hh-mm") & ".xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Fee...Minus Time Additions
I've been having a problem with an Excel sheet that calculates time. Very
Column A: I have a sprinters lap time (for example 00:02:43 - formatted to
[hh]:mm:ss - so the runner did the lap in 2 minutes 43 seconds)
Column B: I put the sprinters estimated lap time (in the same format)
Column C: I want to calculate the difference between the actual and the
Obviously I have encountered a problem when the runner laps slower than the
I found one way around the problem on the internet using this formula:
=IF(B1>A1,B1-A1,TEXT(ABS(B1-A1),&quo...stop default website of users pointing to the companyweb
I just migrated a W2K3 to SBS2008.
How can I dissable the pointing all default websites of all users to the
http://companyweb? everyone wants to have his own default website.
Group Policy Management
Windows SBS User Policy
Internet Explorer Maintenance
Home Page URL - remove http://companyweb
Customise Home Page URL - remove tick
Russell Grover - SBITS.Biz [SBS-MVP]
MCP, MCPS, MCNPS, SBSC
Small Business Server/Computer Support - www.SBITS.Biz