sales line item workflow and process holds and requested ship date
It would be nice if we could set up workflow tracking per line item as well
as assign process holds per line item in Sales Trx Entry. It would also be
nice to have the abilility to fulfill all items on an order through a
specified requested ship date and leave items with future requested ship
dates unfulfilled. Then to be able to transfer and ship items that have been
fulfilled without having to fulfill those with future requested ship dates.
Right now I have to backorder those items that have future requested ship
dates just so I can transfer and fulfill the other items on the order...unwanted Lines and characters showing up in publisher documents
When I open a document made in Publisher 2000, unwanted
characters and lines appear next to the text. When I go
to print the document the characters do not show up in
the print but they are not all erasable as they appear in
Is this a new occurance? Have you tried updating your video drivers?
Publisher can do some really strange things because of video driver issues.
MVP Microsoft [Publisher]
"cc" <email@example.com> wrote in message
> When I open a document made in Publisher ...How to insert a page break every 10 lines
I have been stumped on this one. I have been trying to write a macr
for days on inserting a page break every 10 lines and haven't been abl
to figure it out. I will have have to write a macro to insert a blan
row every two lines.
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
The following code will insert a page break every 10 rows. Change the
values of StartRow and EndRow to meet your needs.
Dim RowNdx As Long
Dim StartRow As Long
...email subject line
Is there a safe way to remove that ugly guid from the the subject line of
I'm using crm 1.2. I'm getting ~30% mail bouncing back. I'm sure it's
because of the guid...
Read the following article on turning off the guid.
Be aware of the ramifications of doing so; mainly you lose the functionality
of the CRM to automtically process retrun e-mails in your thread. Yes
they're ugly, but they are there for a reason.
When I set up a meeting and list the attendees, these
individuals do not get a option to accept or decline. I
have requested a response. Whats wrong
Are you sending using Outlook Rich Text Format?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Deb asked:
| When I set up a meeting and list the attendees, these
| individuals do not get a option to accept or decline...Allow Multiple Values check box not showing up
I am trying to create a Multivalued Lookup Field. I am using the Lookup
Wizard, but when I get to the place where is should let me choose to store
multiple values for the lookup that section does not come up. I went online
and printed the instructions off the help page so I know I am doing it right.
IMO, multivalued and lookup fields are not a good idea. You didn't mention
what version of Access you are using.
Microsoft Access MVP
> I am trying to create a Multivalued Lookup Field. I am using the Lookup
> ...Compound Lookup Field Only Showing First Field
I am using a lookup field for name and the name is broken into two
fields - FirstName and LastName. When selecting the name from the
drop down, I see both first and last names, but after selecting, I
only see the first name. For visual reasons, I would like to see the
first and last names in the form. I am using Access 2007, but believe
this issue is in previous versions as well.
I am open to suggestions and appreciate your help,
> I am using a lookup field for name and the name is broken into two
> fields - FirstName and LastNa...Rotating a line chart?
Is it possible to rotate a line chart so it looks like a vertical chart
rather than a horizontal chart? And if so, once it is rotated, can one
still interact with the chart and it's data?
Visit Excel Tips and Cases
and scroll down to 'Invert and rotate charts'
The direct link
is almost certain to change in the near future.
The above applies to a XY Scatter chart. Hopefully, you can use that
instead of a line chart.
Tusha...Combining Stack bar and Line Charts
I'm trying to display 2 sets of data within the same chart; I want to
display yr 1 data in a stacked bar format and yr 2 data in a line
format. Both data sets would use the same axis; month and volume. I
need to distinctively display each mo/yr together to show any increases
or decreases in volume. Any suggestions you have are appreciated!
tibor's Profile: http://www.exceltip.com/forum/member.php?action=getinfo&userid=156
View this thread: http://www.exceltip.com/forum/showthread.php?threadid=1...RA's showing on Invoices
Does anyone know if there is a way to apply a return to an invoice, and
have that reflected on the invoice balance?
If I remember basic accounting from many years ago, an invoice is the
record of a specific transaction for an account and a statement is the
record of the activity, over a period of time, for an account. You are
trying to mix the two. I don't know of any way to do this - perhpas
someone else will chime in with a brilliant workaround.
> Does anyone know if there is a way to apply a return to an invoice,
> and have that reflected on the i...Contact not showing up in Global Address List
I have created some contacts for people out outside the
company that everyone in the company should see. The
contacts are not show up in the GAL. But they are showing
up in the All Contacts list. The client is Outlook 2003.
It is the client or the setup in AD ..
Any help would be great
Make sure that your GAL filter includes contacts. If it does, there will be
the following filter (objectClass=contact)
"Mat" <firstname.lastname@example.org> wrote in message
> I have created some contacts for people out outside the
...Access 2003 Command-line /WRKGRP Not Working
Even though I have created a workgroup for each of my databases, trying
to use the command-line /WRKGRP option does not seem to work. Whichever
workgroup I use the "Join..." button for is not replaced when I call up
another database using the following command structure:
"[path_to]\MSACCESS.EXE" "[path_to]\mydb.mdb" /WRKGRP "[path_to]mydb.mdw"
The only way I can change the workgroup is through the menu. That is NOT
the solution I need as users ARE NOT going to do this each time they
change to another database. The reason I need seperate workgroups ...Discrepancy with report and x/z tape for weighted items
We sell chocolates by weight at one of our stores and we have found that
there is a rounding issue with this item, it processes correctly but at the
time of closing the sales amounts on the x/z report do not match, it is
usually a penny different but because of this the batch won't integrate to
our accounting software (Great Plains). Does anyone know how to fix this
...Updating Values and X Axis Labels
Thanks for your help. This response by XP wasn't expected. When ever I
update the chart value range and X axis labels the chart (line graph) doesn't
update. I click and drag to update the Value and Categoty X axis labels.
Do I have the axsis formated incorrectly? Under the format labels, Right now
I have "base unit" checked. And the Max and Min dates are entered. In
previous versions of excel I know you could just update the cell range and
the chart would update. This should be so elementary. Thanks - Tom
If the min and max are not set to au...How to show day of week
I have a form, one of the fields is called ShipDate. On this form, I
would like to have right beside the field a single letter (or 2 - Th for
Thursday) indicating the day of the week that the ShipDate is. For
example, if the ShipDate contained 3/22/10, right beside that I would
like a M (for Monday). I don't have a lot of room on the form to put the
whole thing (Monday)
Never mind, I found it. Sorry, I got a little lazy and forgot to search
I'm using =Format(ShipDate, "ddd")
I think I can live with 3 characters
On 3/25/10 11:59 AM, ...print lines and arrows
I am using lines and arrows to show relationships between two columens of
data. Visually they connect but when printing the lines do not connect or
alien to the columen data cells.
Do you know of a method in excel to condense the y-axis such that you still
use zero as the origin when your data is centered on, say, 5,000,000?
You mean this?
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"John" <John@discussions.microsoft.com> wrote in message
> Do you know of a method in excel to condense the y-axis such that you
> use zero a...Subform causes Main Form to show the same record multiple times
I have a form named Patients Info with a subform on it for Household Members.
The Patients Info form is created from the table: Patients and the Household
Members subform is created from the table:FedPovertyLevel. The table
Patients is related to the table FedPovertyLevel in a one to many
The problem I have is that when a second, third, etc Household Member is
added, the button for the record selector on the main form now has to be
clicked forward by the number of household members. For Example, if only one
name is entered as a Household member, there is only ...clistctrl drag image not showing text
I am using a class derived from clistctrl. I am using the
CreateDragImage function to create the image shown when dragging. My
understanding is that this should create an image of both the icon
displayed as well as the text for the particular item I am dragging,
however all I am getting is the icon with no text. I am sure this has
something to do with the fact that this is a derived class, but does
anyone know any other workarounds for getting the text to display in
the drag image?
could i create a bitmap from the rect of the selected item on screen
and use that bitmap for t...X-Y axis
Is there a way I could get the x and y axis coordinates to display in
cell as I drag the shape around with a mouse?
ActiveSheet.Shapes.AddLine(14.25, 7.5, 143.25, 8.25).Select
With ActiveSheet.Shapes.BuildFreeform(msoEditingAuto, 10.5
.AddNodes msoSegmentLine, msoEditingAuto, 10.5, 297#
.AddNodes msoSegmentLine, msoEditingAuto, 109.5, 297#
.AddNodes msoSegmentLine, msoEditingAuto, 109.5, 381#
.AddNodes msoSegmentLine, msoEditingAuto, 10.5, 378.75
I want to be able to cross compare other shapes relative to the ne
position of this shape after it has b...Printouts of emails not showing the attachment icons etc.,
Recently upgraded to Outlook 2003 due to Exchange etc., and one of our
bosses was taken off Outlook Express and put on Outlook 2003. His
latest gripe is that when he used to print emails out in OE, it would
show the attachments that came with that email (just the icons
indicating there were attachements), and that Outlook does not do
this. The Outlook 2K3 shows me how to print the attachments themselves
out (which is not what I want), and there is one article on Google
about this some time ago where no one gave an answer, but there a few
"me too" type responses from other peo...Outlook showing appointments as all day events when they are not
I am a (relatively) new user to outlook (XP home running under win98). Having
set up a whole series of appointments (most of which are weekly reoccuring)
outlook today is reporting some of them as all day events when they are not.
Help suggests unchecking the all day event box - the check box is not showing
on the problematic items - the items do not span more than (say) two hours
and do not cross days. Have checked knowledge base cannot find anything - any
What do you show as the start and end times for any example appointment that
exhibits this behavior?
Milly Sta...Search formula showing results plus 100 characters
I use a formula to find text in a particular text and ask the results plus
the next 100 characters to display in another cell. I was wondering if there
was a way to show the proceeding characters. The formula i am using is:
"Deb" <Deb@discussions.microsoft.com> wrote in message
> I use a formula to find text in a particular text and ask the results plus
> the next 100 characters to display in another cell. I was w...Rolling chart to show 13 months back from current month
I am using names andd offset to create a 13 month chart which rolls forward
automatically. however it only updates when a new month is added, i want it
to display the 13 months up to a particular month - held in a separate cell.
x-axis labels uses the name chtCts
table looks like this:
So at the moment it ...Hyperlinks not showing up after mail merge launched from Word
I have a Word document with a URL in it. When I do a
mail merge and send thru Outlook my URL is not coming up
as a hyperlink to the recipient. It is showing in my
document however. Any suggestions?