Stop print more than one copy of a report
I am trying to print only the current record with the following code and I
get 2 copy of the same report everytime I print and I also get an error
Private Sub Command59_Click()
On Error GoTo Err_Command59_Click
Dim stDocName As String
stDocName = "rptDocSub"
DoCmd.OpenReport stDocName, acNormal
DoCmd.OpenReport "rptDocSub", acNormal
Reports![rptDocSub].Filter = "Primary ID = " & Me![Primary ID]
Reports![rptDocSub].FilterOn = True
M..."Sending messages x of x" in Outlook 2007 status bar
When I send a message in Outlook 2007, appears "sending message x of x"
where x is greater than 1.
I read that it seems automatic responses, but automatic responses are
Thanks for your time,
It's a bug in outlook- x-1 should = the number of email accts in your
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Ex...Split report into pages?
I have a CRM v4 report that groups data by account.
I want to display each account on a separate page. Or ideally a separate
Excel Worksheet within the same workbook!
Any pointers? Thanks in advance,
MR ICT Ltd - http://www.mrict.co.uk
When you create groups in a single Table opr Matrix in SRS, you can open the
Table Properties dialog, go to the Groups tab, and click the "Group Detail"
button (for Tables) or the "Edit..." button (for Matrices) and specify that a
Page Break occurs at the end of each group. This way, if you gorup by
Acc...Macro to show only rows with X
How would I write a script or macro to display rows that have and x in "A"
and hide all other rows?
With data starting in ColA; try
Cells.AutoFilter Field:=1, Criteria1:="=x"
Jacob (MVP - Excel)
> How would I write a script or macro to display rows that have and x in "A"
> and hide all other rows?
> Thank you
Dim rng As Range
Dim cell, RowArray As Range
Set rng = ActiveSheet.Range(Cells(1, "A"), Cells(Rows.Count, &qu...On Account tender type doesn't show on z.
Our On Account tender type doesn't show on z.
JR Data Inc.
The On Account tenders don't show on the Z report near the other tender
types. Look in the section with:
Paid on Account
> Our On Account tender type doesn't show on z.
> JR Data Inc.
Yes, Paid on Account and Paid to Account are in a different section from the
other tenders on the Z report.
In theory, the tender section should be what you are depositing fo...Upgrade from Mac Office 2004 to Office X?
I've been running Mac Office 2004 and I want to upgrade it to Office X.
Do I really have to buy the complete version of Office X to do this, or
can I just buy the Office X upgrade?
The reason I ask is that from what I've been able to research, the
Office X upgrade only allows you to upgrade from Office 2001 but not
from Office 2004. Am I correct about this? And if I am correct, does
anyone know why Microsoft would have implemented such a policy?
Thanks in advance to anyone who can help!
Wait! don't answer that. just realized 2004 is the upgrad...modifying field in report?
For days of the week (not including Sunday) the field had numeric 1 or 2 or
3, etc. or combinations such as 13 for Monday and Wednesday. The database
had only 6 places for possible days a class could be held during the week.
For the report is there a way to:
1) Place a text line stating that 1=Monday, 2=Tuesday, etc.? I tried to
place * by the caption for the field and place the text in the Page Footer
but the = sign caused fits when I tried.
2) Test the field so that if there is a 1, Mon. would be written, etc.?
3) Do a query and generate the Mon, Tue, based on the numbers in the field...Aging Report
1) DateRecvd: E2 (ex 7/19/07)
2) DateClosed: F2 (ex 10/16/07)
3) Days (should close with in # of days, Example: 60) H2
4) DueDate: I2 (ex 9/19/07)
5) TurnAroundTime: DateClosed - DateRecvd (example:60) H2
6) # of days out of compliance (example 29) L2
A) If date closed is null then calculate now() - date recvd otherwise give
me dateclosed - daterecvd, is this possible? What formula would I use?
B) Take 6 & do buckets in a pivottable of 30, 60, 90 and 120 or greater? Is
this possible and are there any examples that can be downloaded?
Any help is greatly appreciated.
...active X control
I have a calandar (active x control) on my form.
Does anyone know how to link/sync it to a bound control; i.e., when a
user chooses a date control, the calandar appears, and when a date is
selected it populates into the requisite field.
Arvin Meyer, MCP, MVP
"alex" <firstname.lastname@example.org> wrote in message
>I have a calandar (active x control) on my form.
> Does anyo...Report Printing 12-07-07
I have a database name Transfer Deed & I have a form in which I’ve to give
data for fields.
Shares Distinctive No. From
Shares Distinctive No. To
No. of Shares (Difference of above)
I’ve a report also on before open the report a popup form occurs & ask for
Deed No & Lot which represent data above what I want know that before open
the report it open with lot of nos. provided for example.
Distinctive No from is = 500
Distinctive No to is = 1000
No. of shares is = 500
And lot provided on popup form is 100 then 5 pages report of 100 each...Getting query data for a report
If I have the query "UniqueCounts" and following query results:
2 Food Basket
99 Men's Dorm
84 Personal Needs
5 PN Family Pack
14 Program Dorm
7 Temporary ID
What would I put in a text field in a report to get the query results
from Count for the ServicesType "Men's Dorm". (Which should be the
you would want to put in 'Men's Dorm' as the criteria in the query....on in
a new query that is applied to this query
...Macro to change X-axis scale has errors
I've read and studied code from a number of posts on this subject but my
"newbie" macro code has errors. I have the minimumscale value and
maximumscale value (entered by the user) stored in Sheet1 at $E$2 and $F$2.
My chart is in Sheet2. This is my complete macro:
' ChangeXAxisScale Macro
With ActiveChart.Axes(1, 1)
.MinimumScale = Range("$E$2").Value
.MaximumScale = Range("$F$2").Value
I know I am missing s...unable to use ip literals user@[x.x.x.x]
my exchange server 5.5 had an open relay which has now
been fixed. but the IP address of my mail server got
listed in www.dsbl.org. and now i am not able to send
mails to our branch office which uses the list of
www.dsbl.org to get rid of spam mails.now i need an
address postmaster@[x.x.x.x] to receive a confirmation
email from dsbl.org. i did everything that the following
miscrosoft site says.
but still i am not able to receive mails at postmaster@
[x.x.x.x]. i tested this by sending a mail to this ID ...Sub Report Repeating Details
With On My Report I Have a Sub-Report,
The Main Report Shows The The Project Number, Project Title and
Enquiry Type: IE SUPPLY DUCTWORK ONLY
The Sub-Report Shows The Drawings That Are Needed To Be Sent For that
The Sub Report Is A Contineuous Type,
What The Problem Is That Some Times I May Decide to go out 3 Ductwork
When I Print The Report, it Repeats The Drawings Depending How Many
Companys Ive Gone To for that Enquiry,
Ive Tried Going Into The SubReport Properties and Selecting The Fields
Hide Duplicates No Difference.
Is there a simple way of Stopping it, or ...Office v.x Word
When creating mailing labels I am unable to print. I can
preview page layout under data merge manager and print
the page. But when I complete the merge to new document
and then print it seems to be sending somewhere other
than my printer.
This merge file was created in word 98. I recreated in
v.x and it still does not print the labels. Could it have
something to do with entrouge. Help please!!!!
I am new to OSx I just upgraded from 0S 8, I know behind
When you use File > Print you can select which printer (if you have more
than one) from the dialo...Active X Pop-up???
Blank How does one delete MS Internet Explorer "Active X" pop-up
By asking in an IE newsgroup, perhaps?
"Rudy" <email@example.com> wrote in message
: Blank How does one delete MS Internet Explorer "Active X" pop-up
: message?? Thnxxxx........Rudy
> Blank How does one delete MS Internet Explorer "Active X" pop-up
> message?? Thnxxxx........Rudy
What did you find when reviewing the ...Thermal printer cuts twice on Access report
I have an Access report that supplies data to a thermal receipt printer. I
noticed the previous developer placed a label at the bottom of the report
with the letter "P" in it. Next to this label, he placed another label
pointing to the first label saying "Used to cut the receipt at this point".
I'm assuming the P label sends a command to the receipt printer to cut the
paper? I ask because the users have been complaining that now (after they
installed a new printer driver), the Access report now cuts the paper twice!
It prints the receipt, cuts, then adva...Using a dll to generate report data
I am assessing whether we should move to reporting services to make
available various company reports via the web.
While most reports have a stored procedure origin for their data, there are
a few of our reports that require some programatic massaging.
These reports typically involve some specialised data pivoting and/or
My question is, can reporting services utilise a custom dll as the source of
data for a report? As an example, reporting services can generate a report
from a stored procedure via a select statement. Can reporting services build
a rep...Framework X error
I am getting this message when I open Office X programs:
"An unexpected error occured while trying to load the Microsoft
Framework X library"
There are users on the ibook. This happens under student where much is
I checked permissions for the user data folders in the users Document
folder and these are ok.
Thanks in Advance
On 8/6/03 1:08 PM, in article
> I am getting this message when I open Office X programs:
> "An unexpecte...Sales reports #2
Can anyone tell me how to run a sales report that includes sales per customer
for a given dept.
Go here and download the Detailed Sales with Customer Detail;
Put in you dates, drag the Department column so that its first, change the
grouping to the first 2 columns, then collapse grouped rows.
Must have access to CustomerSource
Get Secure! - www.microsoft.com/security
You must be using Outlook Express or some other type of newsgroup reader to
see and download the file attachment. If you are not using a reader, follow
the link below to setup O...SRS Reports
We were certainly hoping that executives could access the reports on the SRS
server without having to have a license to CRM.
What we are discovering is that a user has to have a license just to view
the reports. Is that the case?
I can't justify spending $1000 a user just so they can view the reports of
the data within the system.
You have a couple of options here.
Since the reports in CRM uses the impersonated user they will need to be
users in CRM.
1. Develop custom reports using a proxy CRM user.
2. You can create the same report in SRS but using a different data source....Putting a label on the x-axis of a column graph
For a column graph with 2 columns for each month, how do I get a label
to appear for each of the 2 column groups (ie show Mar Apr May
repeatedly for 4 different groups)?
I'd like to see an x-axis like below:
2 columns each month
Mar Apr May Mar Apr May Mar Apr May
If you can figure out a little 8th grade algebra (where's an 8th grader
when you need one?), you can use an example like this to apply custom
labels wherever you want:
Basically, you hide the ...Oulook has small red "x" in left hand corner, can't get new emails
I messed around with the Windows firewall a couple of nights ago
(trying to get rid of alg.exe) and ever since I haven't been able to
get new emails and every time I open outlook I get that small red x in
the system tray. I did a system restore but that didn't seem to help.
It's a Dell Latitude D600 if that makes any difference and I'm running
Go back to your Windows Firewall settings and make sure you have an
exception set for Outlook.
Ben M. Schorr, OneNote-MVP
Roland Schorr & Tower
Microsoft OneNote FAQ: http://www.f...How to have value scales on x and y axes?
I cannot find how to do a simple graph of y versus x
where I can set the scale of both the x axis and the y
axis. In my attempts, it appears that only one axis eg
the y axis can have actual "values" shown on the axis.
Although the data is graphed as the y values versus the x
values, the scale cannot be set on the x axis as it is
a "category" axis - so that the labels along the x axis
are for example "1", "2", "3"....where this means "Point
1", "Point 2", "Point 3".....though the actual values of
those poin...how to generate individual reports?
Hello. I'm a teacher, and I've got a few spreadsheets
that list grades for my students. I'd like to generate
individual reports for each student -- that is, instead
of handing out ten spreadsheets, I'd like to hand out one
report to each of ten students with only the appropriate
information on each.
If possible, I'd like to take my grades (listed
horizontally in rows) and put them in a single (or maybe
two) column(s) that read down the individual report.
It'd be nice if the report had the student's name at the
top, and it'd also be nice if I could s...