PDK Approval Window Sort by Date
Does anyone know how to change the sort order of the records in the PDK
Approval window in PDK Version 10? I need the records by date not employee
...I need to add and subtract time cells. ie. 13:45 minus 13:58
I am having trouble manipulating cells formated to time. I need to be able
to add, sum, subtract the entered cells, and then work with the results of
the addition etc.
To add times and prevent them being converted into days, Cusstom Format as
"Mschertz" <Mschertz@discussions.microsoft.com> wrote in message
>I am having trouble manipulating cells formated to time. I need to be able
> to add, sum, subtract the entered cells, and then work with the results of
> the addition etc.
...[ANN] Updaters for Office 2004 and Office 2008 08-12-08
Microsoft Office 2004 for Mac 11.5.1 Update
Contains very little for Entourage, but there is a Word fix that you should
consider and update.
Microsoft Office 2008 for Mac 12.1.2 Update
Several considerable fixes involving Sync Services and stability.
Read the complete description and details of the updates on the Entourage
Help Blog <http://blog.entourage.mvps.org/>
Currently, the updates are only available via Mactopia downloads, but should
be showing up via AutoUpdate shortly.
Diane Ross, Microsoft Mac MVP
Entourage Help Page <http://www.entourage.mvps.org/>
Entourage H...business portal
business portal requisition company setup close unexpectedly, When I
re-opened the requsition company setup shows error "this is being modified by
Has anyone encountered this? Thanks...
Assuming this is Business Portal 3.0 and GP 9..
There's a table in the Dynamics database named MultiUserManager that
contains the "locks". The lock should time out but in case it doesn't open
the table with Enterprise Manager and delete the record that relates to the
> business portal requisition company setup c...Item Quantities purchased by date
Is there a report that shows item quantities purchased by vendor for a date
You could use the Receivings Lines SmartList, filtered by Vendor and
MCP-GP, MCT, MVP
East Coast Dynamics
...JOINING OF TEXT & DATE
Text = "Receipts from:"
Date = 10/5/06. (This date will in a different cell and will change every
The decription I desire will be: "Receipts from: "1st to 5th October" or any
variation thereof as long as it shows the period
If the date is in cell A1 then:
="Receipts from:" & TEXT(A1,"mm-dd-yyyy")
> Text = "Receipts from:"
> Date = 10/5/06. (This date will in a different cell and will change every
> The decript...Microsoft Windows XP Professional Media Centre update issue.
I have created two accounts on my own desktop PC (not networked) one with
administrator rights and the other one with limited rights. I wish to
download windows auto updates with my account with limited rights. Is it
possible and if so, how to proceed with?
Thanking you and expecting your replies,
No you can't use Microsoft's update programs (Windows Update OR Microsoft
Update) unless you have administrator rights. You could set your system to
automatically download updates for you (but need to be an administrator to
do t...select case from combobox and option group
I have an series of actions that need to be executed from differnt types of
controls on 2 different forms
one control is an option group, the second is a combobox (limit to list =
the commands had already been moved to a sub, SetPresetOptions(frm as
Access.form) <call SetPresetOptions(me) > , which is located in the same
module as the option group (and can be moved to a differnet module if
the code reads something like this:
Select Case optSetPresetOptions
case = 1
case = 2
case = ....
Can anyone please help my small problem.
when taking the difference between two time cells I get a time forma
output in minutes, formatting the cell with ( [h]:mm )
However when multiplying this cell, Excel recognises it as the origina
excel real time format not as text.
The output I get is incorrect due to the cell in date format, when
need it in a text format (ie: 120 (minutes) not as 1/1/1900 2:00) i
the cells calculation.
Your help is gratefully appreciated
Message posted from http://www.ExcelForum.com
to get this value as minute in decimals use
R...Are attribute values case sensitive?
I know that elements and attribute names are case sensitive, but are the
actual attribute values case sensitive when referred to from within an
xsl stylesheet for example?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
"Kathy Burke" <firstname.lastname@example.org> wrote in message
> I know that elements and attribute names are case sensitive, but are the
> actual attribute values case sensitive when referred to from within an
> xsl styleshee...How to update a document
I have a large document in which I'd like to have the user enter some values
for several static names, press a button to have Word automatically update
all references to those static names throughout the document.
The table looks like this and there are more name/value pairs. The user will
update the value for each name as required.
Current release 188.8.131.52
Upgrade release 184.108.40.206
UI Server name Sterling
DB server name Sterling
Further down in the document are references to these Names such as the
following. For us the Names are Bold ...Case Lookup 04-21-06
Is there a way to prevent resolved cases from appearing in the case lookup?
Create an email in Outlook. Click the 'Track in CRM' button.
Click the 'Regarding' button. Change the 'Look For' to Cases.
Currently this lookup displays all cases with no restrictions. I would like
to restrict this to only show active cases.
Thanks for the post. I will have to take a look at this to see if there
is a way to filter the view. A quick glance at the issu...Letter case problem
I try to use a lowercase letter i in a cell, just as a bale for a list
of items, all by itself, and Excel insists on changing it to an
uppercase I. It does not make any difference if I specify that the
cell is text. In fact, nothing I have found solves this problem.
Does anyone know how to make Excel behave in this case?
"docbnj" <email@example.com> wrote in message
>I try to use a lowercase letter i in a cell, just as a bale for a list
> of items, all by itself, and Excel insists on changing it to an...Formula: Date plus 3 months
Hiya, I have a date in cell A1 and I want to know a formula which will
calculate this date minus 3 months, in cell A2.
I've tried a simple "=A1-3month" but this doesn't work.
Followup to newsgroup only please.
"Carly" <Carly@discussions.microsoft.com> skrev i en meddelelse
> Hiya, I have a date in cell A1 and I want to know a formula which will
> calculate this date minus 3 months, in...How can I use fill hand to copy the fomula in this case?
Here is my fomula:
Is it possible to use fill handle to copy the fomula automatically in my
case?, If so, how? Thanks.
I assume that B4 should read = sheet2!A10
with a help column in sheet1
enter the first function in B1 and fill that down the column
enter in C column a series of 1<><>2<><>3<><>and extend that down th
do a sort on C column
delete the surplus rows
> Here is my fomula:
> B1: =sheet2!A1
> B2: =sheet2!A4
> B3: =sheet2!A...Modifying a cell
I'm stuck with a problem.. I hope you will be able to help me.
I have an odbc connection to an sql database which stores data on call
logged per a day. I want to run some sql queries which will identif
how many calls were logged on a certain day.
When I import the data in to my excel spreadsheet, the date appear
with the time next to it. The following is an example of what the cel
8/01/2004 03:32:57 PM
Now, my problem is i'm trying to count how many times the date appear
in the page i can't match it up against anything. I am using thi
=SUM(IF($E$4:$E...changes to receipt format not having any effect!
I've been looing at chaning some bits of my receipt - nothing too
complicated, i just want to re-size the text of the main items scanned, as
currently our item number is so long it runs into the description and it
just looks messy. I have changed the text size in SO, but when i test it
nothing seems to have changed. Is this something to do with my OPOS driver
or something like that? Any advice?
Make sure you re-select the template in the receipt properties. No changes
will take effect until you do.
"Philip Gass" <firstname.lastname@example.org> wrote in messa...Combo Box Showing Date Selections
I have a spreadsheet with a combo box setup. I want it to display in the
pull down dates in the format dd/mm/yy from todays date - 5 days to todays
date + 30 days. I have searched the help and discussion post and found code
to get it to pull down in the format mm/dd/yy from a specific date but I am
not clever enough to alter this to what I want. If you want me to post the
code I have so far let me know.
thanking you in advance for this help.
> I have a spreadsheet with a combo box setup. I want it to display in the
> pull down dates in t...Recieved to date..
I am looking for a report that would tell me how many of each item i
recieved to date...
IE: All items of one supplier with columns to include
Recieved to date
Sold to date
Inventory on hand
Retail Analytics from Professional Advantage will give you that report and
more. Basically, anything that is captured in RMS can be reported on using
We have the Up Close and Personal (UCAP) program available for RMS clients.
UCAP...Recipient Update Service unable to see DC?
This morning I created an account and it never formed a mailbox. It seems as
though we are now unable to create any new Mailboxes in Exchange. This
happens with both new accounts and older ones when I try to create the
Mailbox. It says that it was created successfully however at no point it the
account able to logon to the mailbox and it does not show up in the mailbox
store. I have been looking at how to fix most of the day; everything seems
to revolve around the RUS and updating or rebuilding it. I have tried this
with no success at this point. I have noticed one thing and it is...save a doument that has not been modified
I am asked to save a document that has not been modified. Even a new unedited
new book1 file asks if I want to save?
This often happens if there are any functions in the worksheet that would
force a recalculation, such as =TODAY().
"Alan" <Alan@discussions.microsoft.com> wrote in message
> I am asked to save a document that has not been modified. Even a new
> new book1 file asks if I want to save?
Cheers bob, but I can open a new document with no entries and I still get
aske...Text Box & Date Updating
I'm creating a mail merge postcard and would like to put an expiration date
in a text box. I see how I can insert a data field with the current date,
but how can I make the date show 90 days out?
See fellow MVP, Macropod's Date Calc 'tutorial', at:
Hope this helps,
Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.
"osbornauto" <email@example.com> wrote in message
news:492F...How to change font size of MSChart control?
I have embedded a MSChart control on a CDialog and am using a generated
wrapper to access the MSChart. I have created a very large bitmap that
corresponds to a 300dpi printout. The MSChart renders correctly to the large
bitmap except for the text being much too small. I would like to find a way
to scale the text up appropriately. Thank you.
Ok I realize after looking at the folowing example that there are some other
objects defined like the CVcAxis and CVcFont. The problem is that these did
not come across when I generated a wrapper class for the MSChart object
(Microsoft Chart Control...Updating Contact book
Is there a way to send a form to each contact in my address book to update
(their physical address, phone numbers, alternate email addresses, birthdays,
etc) and when returning to me, automatically tranfer the information
(updating) the contact's information without manually entering all the
I appreciate your help. I'm really new to this. (I still can't get my
contacts from my yahoo account transferred over to my 2007 outlook!!)
Google is your friend. Plaxo comes to mind but I have only used it once and
almost ran screaming from the room when I saw wha...Convert date
How can I convert a date in this format (mm-dd-yyyy) to a
Julian-date (i.e., YYYYDDD)?
For example: 09-13-2003 to 2003256
> How can I convert a date in this format (mm-dd-yyyy) to a
> Julian-date (i.e., YYYYDDD)?
> For example: 09-13-2003 to 2003256
On Wed, 8 Sep 2004 10:24:57 -0700, "gary" <firstname.lastname@example.org>
>How can I convert a date in this format (mm-dd-yyyy) to a
>Julian-date (i.e., YYYYDDD)?