Run report on multi selected records.
I try to make a report for a custom entity that works like the Account
Summary: let's say that it's Customer's Inquiry Summary for entity Customer's
I made the report so that I'm able to run the report on Customer's Inquiry
But when I select multi records in the list of Customer's Inquiry and run
report, only one record is show in one page of the the report.
I would like to have the selected records appear in the report with each
record on each page.
How can I do this?
...Combo box list selection based on earlier selection by user
I have a form that has a combo box 1 (Product) that reads a the Product
table and has a unique id attached to each product (RO#). There is a second
combo box 2 that is RO#. Now what I would like to do is when a user selects a
Product in combo box 1, the system should lookup the Product selected from
combo box 1 and upload the corresponding RO# in the combo box 2 list. Now I
am using both combo boxes as Unbound and in the combo box 2 I have the two
columns Product and RO# - in the Criteria row of RO# I have the following:
Like IIf([Forms]![xa_f_lookup]![RO#]=" ",[Forms]![x...Searaching for Contacts with multiple categories
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
Using the search function, it seems I am not able to search for a contact that belongs to more than one category. It seems to only recognize the contacts primary category. Can this be true? <br>
It makes searching for contacts by multiple characteristics (categories, used like keywords), not possible. Please tell me there is another way.
To clarify, I am trying to find an item whose category is both A and B. I can of course search for A or B, even though they have other categories assigned to them
...Outlook With Business Contact Manager #4
I am trying to set up Outlook to use the BCM using an E-
mail Exchange Account, I can not find the Accounts option
mention in the following link:
The Workstation is a W2k SP4,
Any comments on how to configure the BCM on a Exchange E-
mail account is appreciated.
Thanks in advance
If you're using the classic view of Control Panel, run the Mail applet.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.a...Can't select objects in Excel 2007
I'm trying to create a form in Excel 2007, and although I can manipulate,
copy & paste controls (check boxes, etc)
I can't select multiple objects to align them, etc.
I've checked on-line help (and have followed the instructions), and other
websites, but no one seems to have indicated a problem.
It is extremely cumbersome and I need a solution. Any ideas?
Thanks in advance,
I know this is about a year too late, but it may help others who have stumbled across this page looking for similar help.
On the Home tab, in the Editing group, click Find & Select....OL2003: No Categories on Recurring Events generated from Contacts (e.g., birthdays)
OL 2003 SP2
Windows XP Professional (Dell OEM factory installed)
I categorize my Contacts using my own custom Categories, which are
included in the Master Category List.
Having migrated to OL 2003 (on a retail Office 2003 Professional CD) on
my desktop for about a month, I just noticed Recurring Events in
Calendar generated from Contacts info such as Birthdays, Anniversaries
have been regenerated without any Categories being assigned. I deleted
all of these Recurring Events (including the original ones with
Categories) and resave the Contacts entry, but the new Event still has
...Lot Selection not Showing when I select PO on Receiving Entry
Usually, the Lot selection screen would pop up when I select a PO at the Line
Detail of the Receivings Entry, now it does not! And GP will let items post
without a lot number! It seems as if a setting has changed. Any ideas
Any help is appreciated.
Are you sure the item is marked to track lots? This wiould be set item by
item on the Item Maintenance Options window.
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
&q...Please help with contacts and address book
I am using Outlook 2000 and have two sets of folders:
1. Outlook Today - [Mailbox - My Name]
2. Personal Folders
The first folder is my link to Exchange Server.
When I click on New Mail Message and click on Address Book, the list
of addresses I see is from Contacts located under Personal Folders.
I have two questions:
1. How do I get the Address Book to list my Outlook Today (Exchange
2. How do I back up or synchronize my Outlook Today contacts so both
contact lists (Outlook Today and Personal Folders) are the same?
...Select contact then hangs
Hi, please help. I have a user that when she selects a
contact using To: in a new email, after selecting 2, it
closes outlook??. Spec is W2kSP4\office2k with all
windows updates and office updates installed. Profile has
been deleted and re-created, plus i have set up personal
folders and moved contacts into there, and set that
folder as a default, but makes no difference.
...Other User's Contacts in Address Book
I and other users on my SBS2003 Exchange network have enabled "Show this folder as and Address Book". The problem is, I can't see their contacts in my address book and they can't see my contacts. How can I see contacts from another user so I can send e-mail to that contact?
Create a public folder to hold Contact Items and give the appropriate
permissions to the users on that folder. They can drag and drop contact to
that folder and set it to show as an Outlook Address Book.
PATRICK REED [Outlook - MVP]~~~~~~
-Microsoft Certified Professional (MCP)
-Have you checked ...Additional Contacts
Can you have multiple contacts for a customer?
You can have multiple address IDs for a customer and each address ID gives
you one contact. That would be one option. I would bet that there are others,
as well, such as using user-defined fields.
I hope this helps.
> Can you have multiple contacts for a customer?
...Selecting rows from various sheets
I have several sheets with a few columns in each. One colum
in each sheet has a unique value. Most of these unique values are th
same in each sheet but not all. Is there any way that I can set up
new sheet that will have the unique value in column 1 and th
corresponding column values frommeach sheet beside it. For example
aa 1 1 1
bb 2 2 2
cc 3 3 3
aa 4 4
cc 5 5
aa 1 1 1 4 4
bb 2 2 2
cc 3 3 3 5 5
shav's Profile: http...select text in Calendar
I'm working on a calendar in Publisher. I'm adding text into a cell by
spacing down 1 point, then typing in 8 points. Doing fine until April. At
that time, I can only select cells (whole days). It will not let me select
the text. Help is no help. Any hints out there. Did I accidentally select
something to do this?
Have you added a picture to the cell or a shape? If you have send it to the
back, make the cell no fill and try again.
Mary Sauer MSFT MVP
"GoBonnieGo" <GoB...macro to filter data based on selected data
Hi, I am looking for a macro that requests input of a reference code and then
a date and then filters the data in my spreadsheet based on this criteria. I
am using excel 2007. Any help with this will be greatly appreciated.
You can probably record a macro while doing it manually and then clean it up
and add input boxes to ask the question or input your variable in a cell and
use that. If all else fails,
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the ...show tab in contacts only if there is a "yes" in another field
I would like to customize that there is only a certain tab shown if there is
a certain value in another field. e.g. if on the first tab the field
"payment" gets the value "yes", contacts should show the tab "payment data"
any hints are really appreciated. thanks.
There is a pretty good article about hiding tabs at the following
On May 11, 3:00 pm, Hermine <Herm...@discussions.microsoft.com> wrote:
> I would like to custom...Disable Contacts
Is there anyway to prevent users from being able to use Contacts, but still allow them to use a Global Address list. Basically I want to prevent them from adding their own information and details of clients
I don't think you can do anything to control what they do in their personal
Fat Lad wrote:
> Is there anyway to prevent users from being able to use Contacts, but
> still allow them to use a Global Address list. Basically I want to
> prevent them from adding their own information and details of clients
...Link select with a blast
I have Win 7 Home Premium, x64. Quite often, when I select a link, a mouse
pointer changes to a palm with a blast. I understand, the palm is the
standard mouse pointer for link select, but what is the blast? What it
Fort Myers, Florida
I suspect that this is being caused by a tracking program.
Run something like Ad-Aware and see if it indicates a tracking company.
If so, you can delete it, however, it might prevent you from accessing that
"Ilya Zeldes" wrote in message
news:7A6FF9B1-5512-44...Select Case in a Change Event
I am trying to use a worksheet Change Event to trap changes to specific
columns. depending on which column is chnaged by the user, the value in
another ciolumn will be altered; so, changes in either column O or P will
update column Q, changes in either column T or U will update column V and
changes in column Z or AA will update column AB.
What I can't figure out is the Select Case bit (where I've got the shouted
question below). Here's what I've put together, any comments would be much
Private Sub Worksheet_Change(ByVal Target As Range)
...Select Records based another table...
This may be very elementary, but i can't wrap my brain around it. I have
tried to dummy it down as much as i can for myself, with plans of adapting it
into something working. I have three tables that look like the following:
ProdID A B C
1 $1 $2 $3
2 $4 $5 $6
3 $7 $8 $9
[tbl1 ProdID] ------ [tbl2 ProdID]
[tbl2 RmNum] ...Outlook 2003 email and contacts
Is there a way to have Outlook 2003 Email window and the Contacts window open
at the same time>
Sure, right-click Contacts and choose "Open in New Window".
Ben M. Schorr, MVP
Roland Schorr & Tower
Author: The Lawyer's Guide to Microsoft Outlook 2007:
"Jetson" <Jetson@discussions.microsoft.com> wrote in message
> Is there a way to have Outlook 2003 Email window a...Multi-Select List Box Does Not Retain Selected Items
I created an Outlook Form in 2003. But when I select
items in the list box they do not remain select when I
select another control on the form.
Did you bind the list box to a keywords field?
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"kaykay" <email@example.com> wrote in message
> I created an Outlook Form in 2003. But when I select
> items i...Contact note max length
I have modified the note of a contact so it's length can be as long as
5000 char instead of 2000.
My problem is that in Sales For Outlook, the error message still appear
when the size exeed 2000 char :( I've tried to "Go Offline" so my
outlook could be updated but is did not change anything.
I have almost the same problem. People keep putting too many characters in
the contact description. Clicking on the description in the CRM application
tells you "there are more than 2000 characters, text will be truncated". All
I am very new to VBA and access and have a question regarding a SELECT
statement. I am going to run a select (recordset - so I can loop through and
process each record) but on my SELECT I want to make sure I return at least
20 rows, otherwise I am going to change my WHERE clause to include more rows.
Is there an easy way to do this or do I need to just do an inital SELECT
COUNT(*) and then decide which WHERE clause to use??
Do you have an example I can look at?
Thank you in advance!
On Fri, 14 Dec 2007 17:14:00 -0800, AJ <AJ@discussions.microsoft.com>
I would not first ...Drop down list quicker selection
We are using Excel 2003
We created a drop down list using the Data\Validation process, which works
When the arrow within a cell is clicked on to show the drop down list, how
can you quickly select one of the many names in the list just by typing the
first character of a name within the list.
At the moment, we have to scroll up and down the list to select a particular
name, which in itself isn't a problem, but slows down the process of finding
the right name.
Can the names within the list be alphabetically grouped when inputting the
first character from the keyboard, and spee...outlook business contact manager and existing outlook data
I have a new computer where I just installed office pro 2003 and outlook
business contact manager. How should I import my outlook data from my old
computer which has outlook with out business contact manager. Can I just
copy over the pst file to the new computer or is it a different process?
Yes, just copy the pst over and use it as the default message store. You
should only use import if you had an older version of outlook and want to
use the new pst format.
On 4/28/06 4:24 PM, in article u6FSxGwaGHA.3408@TK2MSFTNGP04.phx.gbl,