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...extern BYTE error when executing
// GAS.cpp : Defines the class behaviors for the application.
// CGASApp construction
// The one and only CGASApp object
// CGASApp initialization
extern BYTE dR0h,dR0l;
extern BYTE dR1h,dR1l;
extern BYTE dR2h,dR2l;
extern BYTE dHl,dHh;
extern BYTE dXl,dXh;
/////////GAS is a SDI application programe,and extern BYTE defined as
// STATICFORM.cpp : implementation file
extern BYTE dR0l,dR...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
...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....WriteFile, insert data in the middle of the file.
What I want to do is to insert data (not overwrite existing data) in the
middle of a big file. Does WriteFile( ) have this option?
If there's no way to insert data in the middle, I guess I have to read out
all the data from the insertion point, and append my new data, and write them
back to the file? Isn't this too inefficient? Anybody knows how OS handles
this kind of "insert in the middle" scenario?
Thank you, I appreciate your opinion.
Well you answered your own question. There is no way to write to the middle
of the file without overwriting what's ...Function to multiple ranges
Which function may be used with multiple ranges?
Commonly used "lookups", "index" and "match" don't seem to work. Is there a
trick in multiple ranges?
Some functions work, others don't. INDEX has a 4th argument that allows you to specify the area
(which of the multiple ranges). The lookup and match functions require a single contiguous block
On Wed, 29 Oct 2003 14:19:08 +0100, "Tomek" <firstname.lastname@example.org> wrote:
>Which function may be used with multiple ranges?
>Commonly used "lookups",...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...Outlook Error Message #6
Since I've installed Office 2003, I am experiencing error
messages. I've uninstalled Office 2003 and re-installed
and I am still getting the following error
message. "Managed MAPI Service Catastrophic Failure", this
error message which prevents me from opening and reading
Can anyone offer a resolution?
I have created a custom Entity - "Inventory"
This has a relationship with Accounts which is used to show the location of
a piece of hardware - a lookup field is used to choose an account. All good.
However I'd also like to have a couple of other lookups for Supplier and
Manufacturer. These are both stored in Accounts so they'd need to reference
an entry in Accounts again.
Is this possible? I know you cannot create multiple relationships between
entities but can you create multiple attributes using the one relationship?
Can anyone help with this - still got no further.....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.
...NTFS file meta data
This is a multi-part message in MIME format.
How can I set the From, Subject, To properties of Outlook MSG files to
display in a manner as EML files?
I have folders of thousands of these files and would love to create a batch
processors to do this.
Conte..."Disk is full" error when opening Excel 2000.
I am getting a "disk is full" error when opening MS Excel on my laptop (not
connected to any servers/LAN). I am running Windows 2000 and my Excel
version is 2000 as well. Additionally I can not open MS Word or Adobe
Acrobat either as these applications are giving errors that it can not find
the file. Have others experienced this and if so, do you know of a solution
for fixing it?
...MAPI Spooler error #2
i am having a problem with sending e-mails with my outlook
2000. for some reason the outbox does not seem to send a
few e-mails since yesterday.
when i click on the selected e-mail it says
"can't open this item. the mapi spooler has already begun
transmitting this message"
all my email settings and internet connection are fine. i
also tried to repair the office using the installation cd,
but the problem did not go away.
the e-mails are being received by people, but the they
still appear in my outbox as never being sent? it looks
like the spooler grabed the...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...Installation error with SBS
We are installing CRM server 3.0 under SBS 2003. The setup terminates with
the following "the Microsoft search service cannot be administered under the
present account" changing the services logon account from the "local system'
account to the administrators account made no difference.
All replies are valued very much.
MSSEARCH is a component of Microsoft SQL Server 2000. You must change
the MSSEARCH and probably all other MSSQL service to run as "local
System" and then change the CRM services to run as NetworkService. This
can be done via:
Start > R...Add users to a Distribution Group using csv file
Is it possible? I have a list of approx 3200 users that I want to add to a
common duistribution group w/o having to do it manually. At present I have a
csv file with all the users that I want to be in the group. Is there a way
to import them into the group using this file w/o recreating their accounts
using csvde or ldife?
"kage13" <email@example.com> wrote in message
&...Error: Object could not be found
Using Outlook 2003 on XP Home with the MS Mail 'hack
(http://www.outlook-tips.net/howto/msmail.htm) installed, and I'
having a problem.
When composing a message, all goes well until I click Send. It the
pops up an error saying that "Operation could not be completed: Objec
could not be found". Initially, the titlebar of the messagebox sai
Microsoft Word 2003, so I assumed it was because of the editor, bu
after changing the editor (to Outlook), the error persists, only wit
the titlebar value being Microsoft Office Outlook 2003.
Any idea how I can fix thi...Data from multiple sheets and workbooks
Each week I receive a workbook from one of my customers. It contains mutliple
sheets with salesnumbers from all the branch of my customer. Each sheet
contains from 1 000 to 15 000 lines of salesdata. Every article sold gets one
line in the sheets.
Each workbook are named "weeknr.xls" and are stored in the same folder.
Now my question/problem. I need to gather all sales info for one branch on
one article from all the weeks.
I know how to get the data from one workbook to another, but how do I get it
to scan all the workbooks in the folder.
Sub LoopFolder...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...outlook files taken over by www.jraun search
Anyone have this problem. My outlook personal files
systems open to a search through www.jraun.com. I cannot
seem to get rid of this problem is it a new trojan or
"ncw" <firstname.lastname@example.org> wrote in message news:<email@example.com>...
> Anyone have this problem. My outlook personal files
> systems open to a search through www.jraun.com. I cannot
> seem to get rid of this problem is it a new trojan or
I've got it too. No luck in getting rid of it yet.
ncw <anonymous@discus...I need a templet or file for creating a personal checkbook.
I would like a templet or file that I can covert to Lotus 123 that will track
There is a few templets out there but I can not convert them to Lotus?
Any help would be appericated in advance.
I have a worksheet that has multiple rows that have the same name. For example.
I have a worksheet that looks like this
Name 401k FICA
Julie 100 200
Patrick 200 400
Sam 50 100
Julie 100 200
Julie 100 200
Patrick 200 400
I am trying to figure out how I can have excel look at the worksheet and
find all entries labed Patrick and return the columns already summed. Similar
to a vlookup but able to know that if I want the 401k column it should return
...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 ...Error during sending and no new messages, Outlook 97
I use a Internet E-mail with an adress with yahoo. When I
try to send an email I have the next message :
The TCP/IP connection was unexpectedly terminated by your
mail server. If the problem persists, contact your LAN
Administrator or Internet Provider.
I don't what to do because right now I used without
trouble Outlook Express, whithout such problem.
Besides I can not receive any email.