New "Manufactured Item" Type
I need an additional new item tyype that behaves like a mix between an
assembly and a kit.
My shop sells items that are produced when the client buys then, and certain
components can be substituted at time of sale and qty of others may have to
increase, so creating kits is not really an option. I also need my stock, for
each individual component to deplete when this item is sold. I would use
assemblies as this gives me this flexibility, but I do not want every single
component listed just the title of the component item and it's cost.
I figure I need a new Item type, somet...Customizing Activities / History List saving changes
I have made some changes to CRM forms using formeditor. I do not know how will these changes show in my system. I have uploaded customization but its not working.
Any suggestions, advice please
did you publish the changes via Deployment Manager on the CRM server?
"Sarah" <email@example.com> wrote in message
> I have made some changes to CRM forms using formeditor. I do not know how
will these changes show in my system. I have uploaded customization but its
>...Drag and drop of eMail to own application
i like to drag and drop an eMail of Outlook ( Express & Xp ) and
Thunderbird into my own application ( MFC ).
There'in the dropped eMail should be readed and the subject, body text,
Recepiant, ... should be displayed into textboxes.
I can check the different formats of the Drag-Event or Clipboard data.
An Outlook Express mail is stored in plaintext into the clipboard, so
it's seriously possible to extract it. But with Outlook XP Mails i see
only the name of a .eml file ( the of file which would be saved on the
Destop for example ) But how to extract the data?
Do...Distribution list cannot receive external mail
Windows 2000 Server SP4
I have set up a distribution list and it works fine internally. It cannot,
however, receive mail sent from an external address. An NDR is generated and
I have included a copy below:
This message was created automatically by mail delivery software.
A message that you sent could not be delivered to one or more of its
recipients. The following addresses failed:
SMTP error from remote server after RCPT command:
550-Invalid recipient <XXXX@XXX.com> 550 (#5.1.1)
I have configu...Drop Down List #9
I am trying to create a drop down list using two worksheets. How would I
One sheet would where the final product is and the other would be where the
data is being kept.
Watch this 5 min video:
How to setup a data validation drop down list:
Microsoft Excel MVP
"Vincent Kerzman" <Vincent Kerzman@discussions.microsoft.com> wrote in
>I am trying to create a drop down list using two worksheets. How would I
> create this.
> One s...Users not appearing in Global Address List
I've created three new users all with mailboxes and they aren't appearing in
the Global Address List.
Can anyone tell me why?
On Tue, 14 Sep 2004 16:39:52 +1000, "Joe Spenceley"
>I've created three new users all with mailboxes and they aren't appearing in
>the Global Address List.
>Can anyone tell me why?
Check in ADU&C to see if an email address has been applied.
http://s...drag and drop
Using office XP I cannot drag and drop items from one
folder to another in outlook 2002.
...Filter list not correctly refreshed
I created a pivot table in Excel, linked to a database.
So I added some filters to this table, displaying lists.
The fact is that when I try to find a value in this list (my filter list), I
don't find this value.
I explain with more details.
I add a new value to a list A in TFS (value x). I wait for the OLAP cube to
I open my excel file, I check in the A list (used in my file as a filter)
and try to select the value x, but I don't find it.
My OLAP cube has correcty refreshed the data (I can see it with the
displayed data in my tables).
What should I d...drop down calendar #4
In a cell I want to have a drop down calendar of the current month. I
downloaded a template of a calendar and tried data valadation but it only
displayed the source range. Any ideas?
"Ray A" wrote:
> In a cell I want to have a drop down calendar of the current month. I
> downloaded a template of a calendar and tried data valadation but it only
> displayed the source range. Any ideas?
See Ron de Bruin's site for this.
Gord D...drop down data want to choose more than one item for cell
I have a drop down box that i want folks to be able to choose more than one
item from the box to go into the cell.
Multiselect from a DV dropdown is possible using VBA.
See Debra Dalgleish's site for a downloadable sample workbook with event
Note that you can have the selections in an adjacent cell or in the same
Gord Dibben MS Excel MVP
On Fri, 26 Feb 2010 12:40:08 -0800, FranW <FranW@discussions.microsoft.com>
>I have a drop down box that i want folks to be able to choose more than...Drop Down List #2
Can this be done, as I am struggling.
I have data in sheet B and want to create a drop down list in sheet A from
this data, and I can't make it happen, I can create a drop down list in
sheet A from data in sheet A but not from sheet B
Could anyone help please
Name the range on the other sheet, and you can refer to it in the data
validation dialog box. There are instructions here:
> I have data in sheet B and want to create a drop down list in sheet A from
> this data, and I can't make it h...Missing Contact List in Outllook 2002
User is trying to create a a distribution list in her
Contact List, but found the contact list to be missing.
How did this happen, and can it be replaced?
...Question of drop-down listbox
Is it possible to have listbox or combobox with Auto HScroll
I don't get it. ES_AUTOHSCROLL is an Edit control style, how would it apply
to a listbox or combobox?
What are you trying to do?
"Ririko Horvath" <firstname.lastname@example.org> wrote in message
> Is it possible to have listbox or combobox with Auto HScroll
> (ES_AUTOHSCROLL) capabilities.
> Thank You!
I'm soory for not expressing my question properly...Listing Dates
Hi! I have a spreadsheet with the following info:
Date Time Profit
03/10/2003 0132 65
03/11/2003 0358 -22
03/12/2003 2135 120
10/29/2004 1826 -18
So there are hundreds of rows of data.
1-How can I generate a list of all the MONDAYS to the side of this list?
2-How can I get the average value of PROFIT when Time is <= 14:00)
...Where is my contact list
After a minor systems crash, something seems to have gone wrong in Outlook
I can see my contact list in Contacts. However, when I send an email, there
is no contact list and no alternatives on which to select.
If I then add a new contact, it is saved and appears on its own in the email
contact list. Further investigation shows that is is stored in a file called
outlook1.pst whereas all my other contacts are stored in outlook.pst
I've prodded around and everything else seems fine.
Does any know how I can get to access my original contact list when sending
So how ma...I want a list of everything defined on a form
I have a fairly complicated form. I want a list of the names of everything
on the form. How to do this?
Have you looked into the documenter that comes with Access?
Tools | Analyze | Documenter (actual selections vary by version).
Microsoft Office/Access MVP
"tom" <Spamblocker@ameritech.net> wrote in message
>I have a fairly complicated form. I want a list of the names of everything
>on the form. How to do this?
On Mon, 23 Jul 2007 16:45:26 GMT, "tom" <Spa...Global Adrress List
I need help guys, i have two DOMAINScontrollers,the first
" Exchange server 2000 " with name of : FOX.COM.
The second " Exchange server 2000 " with name of : TEST.COM
I need access "Global Address List" of FOX.COM in TEST.COM.
How make this?
Are these just two domain controllers, both members of the .com domain? Or
are these two seperate domains?
"Fabio Viana" <email@example.com> wrote in message
news:firstname.lastname@example.org...create a csv file type format for a centrally access address book
We have Outlook 2003 clients on a LAN with a Small Business Server 2003
Standard editon box. We require a single fax document sent to new or
existing clients with using our shared fax service from the SBS. Is there a
way to create a .CSV file type format in Microsoft Excel for our new client
database and import this information into Exchange as a seperate address
book for fax use? Thank you in advance for your assistance.
See my response to your post in the contacts newsgroup.=20
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart...reporting on drop-down values
We created drop-downs and wish to add the values to a report, but of course
the extentionbase tables only show the numbers. Is there a specific table
where all the actual text values are stored?
Hi use the stringmaps table to get the description of picklist values.
I hope it helps.
> We created drop-downs and wish to add the values to a report, but of course
> the extentionbase tables only show the numbers. Is there a specific table
> where all the actual text values a...List Box to show your Order
At the Moment I have a query that lists my Horses on my form I have a Text
box next to each horse so depending what number I put in my text Box gives
me a Printing Order, This is for Printing Worksheets, What I am trying to
Achieve is say to list Boxes and you highlight a Horse a click the arrow to
send it to another Listbox on the same form then print the Order in list
Box2, Once you select a record and click it to List Box 2 it disappears from
list box 1, Any Ideas how to start this?
Thanks in advance for any help with this......Bob
MS Access 2007 accdb
Windows XP Home...finding largest value from list of strings
I have a range that is populated from a db using MS-QUERY. All fields
are formatted from the source as strings. Some columns contain numeric
How do I find that largest value in a column? If the fields where
values, I could use MAX() or LARGE(), but with the fields being
strings, these don't work.
Try this array-entered** formula (change the ranges to suit your needs)...
**Commit formula using Ctrl+Shift+Enter, not just Enter by itself
Rick (MVP - Excel)
"Daron" <Daron.Lowell@gmail.com> ...Drop user or alias before dropping login
I am trying to delete a user, and I get this error:
Login is aliased or mapped to a user in one or more databases. Drop the
user or alias before dropping the login.
GO to SQL server --> logins and select the user and open check the
properties of the login and see what database access the users has. If any
uncheck all the database access and drop the user.
Also make sure from the GP front end you have unchecked the company access
If still you get errors go to each database on the server and make sure they
are not in the users list in the databases.
...Drop down list 04-23-10
How do you display drop down list button even if the cell is not selected?
You can't. Perhaps you've seen the button created from a AutoFilter ot
"DLB" <DLB@discussions.microsoft.com> wrote in message
> How do you display drop down list button even if the cell is not selected?
Use a combo box from the Forms toolbar. The drop down arrow is always
Microsoft Excel MVP
"DLB" <DLB@discussions.microsoft.com> wro...Outlook 2003 Drap and Drop Issue
If you take an email from Outlook and perform a drag and drop to the tasks,
the task is created but the message body text is empty.
Any reason why this should happen.
...How do I remove a "List" once I've created it in 2003
I just used the new feature "List" in 2003 to try to organize all my source
data into one "unit" (to make pivot tables easier). It's not working as I
planned and it slows down the resources so I'd like to undo the list.
DOes anyone know how to do that?
I believe you are looking for...
Data | List | "Convert to Range"
Win XP & Office 2003
"Joyce" <Joyce@discussions.microsoft.com> wrote in message
>I just used the new feature "Lis...