Use Form to prompt for report criteria
I have a form that I am using to prompt for report criteria. When I run the
query outside of the form, it works fine - prompting me for both criteria.
However when I run from the form, I get #Error#. Can you see what I am doing
wrong? Thanks in advance.
I have two combo boxes that I have put in my underlying query. In the
fields of the query are:
[Forms]![frmSelection Criteria Form]![OfficeNumber]
[Forms]![frmSelection Criteria Form]![Manager]
On the OnClick event is the following:
Private Sub Command6_Click()
On Error GoTo Err_command6_Click
Dim stDocName As String
I don't know if you guys have ever try to show the total tax sale on the z
report, but when i make the modified on the z report it came out that the
total tax is 0. It didn't show me anything, i don't know if the script is
wrong or the script is not working for RMS V1.3?? Has anyone ever tried
<ROW> "Taxable Sales|" Report.SalesPlusTax </ROW>
...How can I print just the flip side of a booklet?
How can I print just the flip side of a booklet? I printed the first side
just fine and then my computer went funny and I had to shut down and start
back up again. I have 25 copies of the first side that need to be printed on
the back side.
Pub 2000 user here:
There may be a better way but I think you will have to print a page at a
time i.e., File, Print Page 2 of 2; then 3 of 3 and so on.
"pqc18" <firstname.lastname@example.org> wrote in message
> How can I print just the flip side ...3.0 Customization
Is it possible in 3.0 to have one set of screens appear for one group of
users and another set for another group. For instance, could our
service people only see the service screens while our sales people only
see the sales screens? I know I can restrict access to different areas,
but we want to have a totally different look and feel for each group...
Sorry - I dont believe this can be done
"Matt Harvey" <email@example.com> wrote in message
> Is it possible in 3.0 to have one set of screens appear for one group of
>...Re-print SVC RTV Packing Slips
Please add to the Reports Menu the ability to Reprint a RTV packing slip.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=107decaa-6e0a-4bc...Report CRM 3.0
I would need to find out the detailed procedure (step by step) to customize
Could anybody inform about any links or documents concerning this issue?
I'm not sure if it's detailed enough, but the technical training manual has
a section on creating and customizing reports. You can find it here:
Jeffry van de Vuurst
"Marco Rocca" <Marco Rocca@discussions.microsoft.com> wrote in message
news:CEF80683-EC26-456C-82C...How to sort calendar entries on "size"
I would like to remove large size calendar entries by
being able to sort on "size". I am able to sort Inbox
items on size but not calendar. My company's exchange
server has email account size quota and a 3rd of that
quota is being held up by calendar entries on the server
side, so I would like to get rid of the unwanted past
celndar entries that occupy portion of my account quota.
Any help is appreciated.
On 11/18/03 9:21 PM, in article firstname.lastname@example.org,
"Umesh" <email@example.com> wrote:
> I would...too many "inherited" custome headers and footers
It seems that somehow I have "inherited" custom headers
and footers from someone else's workbook. They have
filled up almost all the allocated spaces in the drop-down
selection list and pre-empt me from adding more than two
custom headers/footers of my own. I need to add at least
four new custom headers to the list.
Is there some way to delete all the "inherited" custom
headers and footers?
...CRM 4.0 Custom Report Filter Problem
I am using the Report Wizard to create a simple report.
Report is using Quotes and Quote Products
I have a custom field in Quote Products which is a bit field Yes-No
When I use that field as a filter for report output, I get all records. The
filter criteria appears to be ignored
Is this an inherent problem with Report Wizard or Am I doing something
depends on your business logic and what you want to see.
If you have three quotes:
Quote-1 has three products, all with the custom field set to Yes
Q2 has three products, two set to Yes, 1 to No
Q3 has three products, all set...Mail Merge Printing collated
When I print a mail merge (I don't use it for mailings and envelopes),
Publisher prints out the first 5 records as an individual document then the
next 5 as a seperate document, and so forth. Since I often need to make
multiple copies of these documents, I end up having to collate them by hand.
How can I get Publisher to print the entire merge as one document before
printing the second, third, copy? I believe when I had P'03 it would print
that way, but when I upgraded to '07 this problem started.
You can't... Maybe later with a service pack these printing bugs will b...stock variance report
Is there any way to edit that stock variance report at HQ? There are no $$
values and this is quite important at HQ.
How do others work with this?
Create a custom report using the Quantity Discrepancy List as a template,
add the SnapShotCost, SnapShotLastCost and/or SnapShotReplacementCost column
from the ItemDynamic table times the qty difference.
"Ivan Brebner" <firstname.lastname@example.org> wrote in message
Is there any way to edit that stock variance report at HQ? There are no ...Customizing Excel's Border Defaults
I'm working with Excel 2000 and use Borders frequently.
The preset default border is a thin line, yet I prefer
and always change it to the thick line. How can I change
the Excel default to the thick line rather than the thin
line? I know it's a small problem, but it's driving me
crazy changing it all the time. In WORD, I know how to
easily "add style default to template", but can't figure
it out in Excel. Any help is greatly appreciated!
...Can you create custom activities? MSCRM 3.0
Is there a way to create a new custom activity instead of customising an
existing one? I have created a custom entity called 'Chat' utilising an
IFRAME. All works well but this entity really should be an activity
considering it's properties.
In fact I've just been introduced to MS-CRM 3.0 and don't really understand
what the difference is between an entity and activity. Would anyone shed the
light for me?
BTW, I think 3.0 looks great. Gotta admit it's improved.
In my experience, you cannot create custom activities. In fact, I have been
dire...MS Excel Print setup
When i save a document by using landscape setting,& by
opening again that document it does'nt show saved setting.
It shows portrait option,not landscpe option.
...How do I print 4 postcards to one page to match my postcard paper
I bought perforated postcard paper that has 4 postcards per sheet. How do I
create that in Publisher? I created it exactly how I want it to look and
then realized it's only printing 2 per page.
Which version of Publisher are you using?
MVP Microsoft [Publisher]
How to ask a question
"Lauren" <Lauren@discussions.microsoft.com> wrote in message
>I bought perforated postcard paper that has 4 postcards per sheet. How do
>...Chart printing issue in Excel 2007
A spreadsheet with charts was created using Excel 2003. I have Excel 2007
and saved it in compatibility mode.
I inserted a couple colored lines on the chart and created my own legend
based on these. A couple of issues:
1. When I close the file or even minimize, 2 of the colored lines on a
couple of my legends disappear upon reopening.
2. When I try to print a chart, it looks good in Print Preview, but then
looks magnified,half off the page, and only one of my drawn lines is printed.
When someone with 2003 prints, the sizing is correct, but all of the
colored drawn lines are missing...Report Filter focus
I am experiencing an issue with the report filters in RMS. It is not a
show stopper, but annoying.
When I launch a report in SO Manager on a win XP machine, RMS version
1.3, the report filter is there, but the correct field is not selected
and the filter under Filters is not selected. When this happens and I
want to change the filter, I first need to click on the Filter itself
in the bottom box and then select the correct field out of the Fields
list, then change the Value. Is there anything I can do to fix this?
To use a real report as an example, When I run the Detailed Sales
rep...How do I print a SINGLE POSTCARD on 5.5x4.25in stock?
I have a preprinted postcard that is 5.5" x 4.25". A standard postcard. I
cannot for the life of me to get Publisher to print on this cardstock!! It
keeps thinking the page is "LETTER 8.5x11".
I have NO problems getting 4 cards (multiple addresses) to print on one
page. But now I have the cards pre-printed and just want to mail-merge an
address list onto them.
How do I set this up? Because apparently, using the post card template of
5.5x4.25 (or even the 6x4) doesn't do it!!!!!
Thanks for any insight.
Here select your stock si...Visio Printing Problem
I am trying to print a flowchart. The print view displays the complet
flowchart. However, when I print the flowchart, the top half of th
flowchart is omitted and the bottom half prints. Any problem solvin
recommendations would be appreciated
jqsandman's Profile: http://www.officehelp.in/member.php?userid=661
View this thread: http://www.officehelp.in/showthread.php?t=136719
Posted from - http://www.officehelp.i
this usually ends up as being "apply available software patches to visio" or
&quo...Outlook reports OLE registration error
I have Office 2000 running in Windows Me on a Dell
Dimension XPS D266 with 64 meg ram. Outlook stopped
working so I ran Repair from Office 2000 CD and then Re-
install Office from same source. Both times Outlook says"
An OLE registration error occured. Program is not
correctly installed. Run Setup again."
Doesn't seem to be much sense in running it again. What
Reinstall Outlook Express.
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
acco...Object error when trying to print custom reports
I am getting an [object error] message when trying to print custom reports
or modified versions of canned reports. They display just fine within CRM,
we just can't print them. I have already tried deleting the ActiveX to
force a reload and manually reinstalling it using
http://crmserver/viewer/activexviewer/en/npviewer.exe with no luck. This is
occuring on systems regardless of whether Crystal Designer is loaded.
Open the reports in Crystal that you are having problems with and make sure
that the "Save data with reports" option is not checked. (In Crystal...I have individual place cards I want to print can anyone advise m
I am helping friends print their wedding place cards, they have been given
the individual cards from the place where they are having the wedding, but we
cannot get them to line up
What are the size of the place cards? Are there more than one card on the page? Are
you merging information? What version Publisher are you using?
Mary Sauer MSFT MVP
"Pauline" <Pauline@discussions.microsoft.com> wrote in message
>I am helping friend...A Strange Printing Problem
Our accounting department maintains an Excel file, updated in an onging
process, converted to a PDF at month close, and distributed to our senior
There are nine worksheets, seven behave normally, but two worksheets default
to printing 2 copies.
No macros, viruses, etc.
Any suggestions on a fix will be appreciated.
I would try a different PDF converter. There are a # of free ones out there.
It would be a simple and quick test to see if that was the problem.
> Our accounting department maintains an Excel file, updated in an onging
> process,...Exchange server reporting tool
Could someone recommend an exchange server reporting tool other than
promodag? I will really appreciate the help.
=?Utf-8?B?c2xhd2Fs?= <email@example.com> wrote in
> Could someone recommend an exchange server reporting tool other than
> promodag? I will really appreciate the help.
Quest messagestats is good stuff.
i second that...
Susan Conkey [MVP]
"Arlo Clizer" <firstname.lastname@example.org...Extra word prints that does not show when viewing the document
When I print my document or view it, this extra word is not there. When the
document prints, this hidden word is in the printed document. How do I find
this hidden word and delete it?
If it prints, you know where it is. Have you turned on your nonprinting
characters, etc? Have you tried copying and pasting it into a new blank
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"S Roberts" <S Roberts@discussions.microsoft.com> wrote in message