I have a cross-tab query that works as desired. I can get it to post to a
report. My problem is the report (legal - landscape mode) is limited to 12
items. How can I get the report to go beyond the 12 items? The data in the
cross-tab query will take multiple pages to print all the data. Is there a
way to get the report to pick up with the next "12" items if the cross-tab
has more than 12 items?
I can post a stripped-down version of the database if needed.
Creating a dynamic cross-tab report is by no means easy, but it can be done.
Here's Microsoft's take on it:
...Changing the name of the CRM server
I have been asked to change the name of our CRM server. The ip address will
not be changing, just the server name. Has anyone tried this? Is it as
simple as just changing the name. I plan on reinstalling the outlook plugin
for everyone so that won't be an issue. Are there other issues?
You may run into problems with the Exchange router or the Crystal configuration
as well. You can always rename it back if you run into problems.
If you do have problems, you might also try uninstalling CRM from the server, do
the rename, then install using the exinsting DB & AD info. ...Linking Queries
Can anyone help?
I have a system where employees register property with us. They then report
back to us when they sell the property.
Registered properties are held in one table and sold properties are in
another, where the common field is the employee.
I want to create a query where it will show the employee and the details of
the registerly and the sale.
I cant seem to get the details of the registry and the sale to assign to the
If you were limited to working with a spreadsheet, you might come up with a
design that puts properties in one status on one s...How to create DSN Less connection on pass through query?
I have DSN Less connection code as follows for linked tables which the code
is on the switchboard form:
Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.
' Move to the switchboard page that is marked as the default.
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
Me.FilterOn = True
Dim ServerName As String
Dim UserName As String
Dim Password As String
ServerName = "CPSHOUDB15"
UserName = "********"
Password = "********"
'Attach the linked database table...OWA change password button does not display
I am testing the OWA change password feature in the lab following Q297121.
However I still cannot see the change password button after following the
article line by line.
In my test environment I have 2 front-end servers and a cluster back-end.
User connects to OWA using a common namespace that is load-balanced by NLB.
The certificates with that common namespace is installed on both front-end
Steps I have performed
1) make sure that SSL certificates is installed on default web site on both
2) run adsutil.vbs to set the paswswordchangeflags to 1
3) created IISADMPWD manua...changing the semicolon as separator in csv
when i save a worksheet to a .CSV Excel uses the semicolon ";" character
as the default separator
Where do I chnage the setting so that it uses a comma "," character?
In Windows XP, it's under the control panel|Regional options tab
then click customize and look for List separator on the Numbers tab.
Or you could rename your .csv file to .txt
And the specify the delimiter when you get the text import wizard.
> hi all
> when i save a worksheet to a .CSV Excel uses the semicolon ";" character
> as the def...Problem: Publishing changes with Deployment MAnager
I have a problem publishing changes with Deployment Manager (CRM 3.0)
My Deployment Manager has only 3 nodes ( Server Manager, License Manager &
User Manager). If I get it right, any time I make changes (for ex.
Customizing Leads adding new Industries) I need to publish changes in
Deployment Manager, and I simply can't because I don't have such an action.
You publish changes in the web client under Settings, Customizations,
Customize Entities, highlight the Entity and click the Publish button.
"George Athanasopoulos" wrote:...Almost got it. Change order on subform After new record added
I have a customer sub form
Every thing works great.
I have ordered the records in descending order.
The only thing is when I hit the new call record and save it
the record appears at the bottom of the list.
When I change to another customer then go back every thing is how it
should be. New record at top of the list.
I have put a me.requery command in the subform but does not seem to work
Use OrderBy to set the name of the field to sort on and which direction,
Desc for descending, and leave blank for the default of ascending.
Then set OrderByOn to True.
...Global Margin Change
MS Publisher 2002
I've been given a 70 page document with two columns per page and want to
change the margin for every page. Can I make a change in one place that will
change the margin on all pages? Changing the layout on the Master Page seems
to change only the pink margin guides and has no effect on the text on the
Can margins or text box widths be set in styles so I can change a style and
get a global change in text box width?
While waiting for decisions from his 6 university choices, Ed sees a
message from John Smith <firstname.lastname@example.org>. On it is written:
&g...changing thickness of Excel row and column headers
By this I mean the gray A through IV and 1 through 65535 on the edge of
all worksheets. I haven't discovered a way to reproduce this on demand
but it very definitely happens: some workbooks show thicker headings
(BOTH) than others. If you haven't experienced this yourself there's no
need to read further. You might see it if you open a half dozen
workbooks created over a long span of time.
seems to describe the problem exactly, if that helps...
I recognize that the row number heading expands as you cross row 100...update a table based on a sum query
I have seen the zillions of answers to this that state "never add a total
into the table.." But there are cases, such as mine when it is prefered.
I want to update a project table with the final invoice cost. I want it
entered as a hard figure so that I can then export the table for accounting
purposes. Additionally, once an invoice has been generated, there isn't any
need for the total to ever, ever change! In fact it shouldn't.
So the question is.... is there a way to do this?
To update a table with a value from a sum query?
Thanks for any help.
...Change radio button when sheet is protected
I have two radio (option) buttons (from the forms menu, not controls),
one to protect the sheet and one to unprotect the sheet. These are
linked to cell $D$1 I also have code that protects/unprotects the
sheet in order to sort the data.
How can I get the radio buttons to change to reflect the current status
of the worksheet (protected/unprotected) when the code runs to sort the
Selection.Sort Key1:=Range("B4"), Order1:=xlAscending,
, Order...How to use different type Query for Excel PivotTable? (ODBC)
How to use two different type of Database Query for Excel PivotTable? (ODBC)
My PivotTable gets data from Microsoft Query by ODBC. But I can not get two
different type database for ONE PivotTable. For example, one table is *.dbf,
the other is *.btr, Can i use these different table for ONE PivotTable?
I know Crystal Report can do it. How about Excel PivotTable?
try Vb, ADO programs or SQL.Request function (Excel ODBC Add-In) with "SELECT....IN... UNION SELECT....IN... " statement. I do such a queries into another file and make PivotTs basing on it
...UNION query and Data type mismatch in criteria expression
I did some searches on this problem before trying to post here to the
newsgroup, but what little information I found did not seem to help.
Here is the problem. I have a UNION query that joins 2 queries into 1
dataset. Each sub-query works fine individually, but when I place them into
a UNION query it gives the error message "Data Type mismatch in criteria
I first double-checked to make sure any JOIN fields were of the same data
type - which they are (everything is in TEXT format). Also, the information I
found suggested there might be problems when an empty field...Change contour plot
This is (hopefully!) a simple this to answer... I've got a contour plot, and
the contour lines are too are apart. How do I change the scale on the Z-axis
to fix this? (Also, I presume there's a way to change the number formatting
on the legend. I can change the formatting on the X- and Y-axies, but not on
the legend display.)
On Thu, 30 Oct 2003 16:19:17 -0000, Invisible <email@example.com> wrot=
> This is (hopefully!) a simple this to answer... I've got a contour plo=
> the contour lines are too are apart. How do I change the ...Change "Account" to "Company" in Navigation pane
Ok, what am I missing here. We don't want to call companies "Accounts".
So I went and changed the "Account" Entity "Name" field to "Company"
(and the corresponding plural name to "Companies". However, in the
navigation pane, it still shows up as "Accounts". What am I doing wrong?
Do I need to edit the site map for this?
After you changed the name of the entity to Company/Companies, did you
publish the changes? After you publish, you might have to refresh the page
to see the changes. I have been able...List Box to create a Report based on crosstab query
I have a form with a list box to select a value, and a button that is pressed
to create a report based on the value selected in the list box. The problem
is the query used to create the report and populate the values in the list
box is a crosstab query, which is not updateable of course.
Here is the SQL for my query:
TRANSFORM Avg(Val([tblCourseGrades].[Grade])) AS AvgOfGrade
SELECT TblStudents.[ClassNumber], TblStudents.Rank, TblStudents.[Last Name],
TblStudents.[First Name], Avg(tblCourseGrades.Grade) AS AvgOfGrade1
FROM TblStudents INNER JOIN (tblCourses INNER JOIN tblCours...Charts that don't change size
I have 2 charts on a sheet, each representing different data, one on top of
the other. I would like the plot areas to line up with each other. I can do
this easily with no data, but when data is added, one will be bigger or
smaller than the other. There is new data added every month and no matter
how hard I try to keep them aligned, they just keep changing sizes!! The
chart is not the problem, it's just the plot area.
Is there a way to lock the plot area size, whether there is data in it or
I think -- but I am not sure -- you could write a macro that aligns the
plot areas. ...tableadapter Query linked to Access 2003 table
I'm trying to write a query for my Dataset's table adapter. It is
linked to an access 2003 database. Basically, I'm trying to duplicate
the following query.
SELECT Parts_Inventory.Aisle, Parts_Inventory.Rack,
Parts_Inventory.Shelf, Parts_Inventory.QNTY, Parts_Inventory.MFG_PN,
WHERE (((Parts_Inventory.Manufacturer) Like "*" & [?] & "*"));
I'm using a text box as my control to the manufacturer field. If it
is blank, it will show all my parts.
I'm able...Mutliple Complex Queries
Thank you in advance for your assistance.
I have data that I must access on a weekly basis that involves a number of
criteria. To date, I have performed each query and then coalesced my findings
(by hand) into a table. Something tells me that this would be far easier with
better knowledge of the program.
I have three major data categories (Poor Performance rating, Location, and
Seniority) that are dependent upon sorting the Employees into three different
sections (Dismissed, Retained, and Reallocated). For each of the sections, I
must calculate the percentage based upon the main data...date track based on svc cond.
I'm looking to track material out for repair by the type
of service requested.
In cell (G:2) will be the type of service:
BCK = bench check = this will have a projected return
date (I:2)within three days of the repair order date (H:2)
REP = repaired = This will have a projected return date
(I:2) within 7 days of the repair order date (H:2)
OVH = overhaule = this will have a projected return date
(I:2) within 14 days of the repair order date.
With all this I would also like to include the warranty
schedule from the date of the service reurn date(J2)
BCK= no warranty
REP= 90...workflow fires twice
I have a workflow associated with quotes that is set to fire when the status
changes. The first line of the workflow checks the status. If the status is
not won, the workflow cancels, if the status equals won, then the steps
The workflow fires twice most of the time. Both of the workflows that fire
say they fired because a record attribute changed.
I even created a very simple test workflow to rule out an issue with any of
the steps in my real workflow as being part of the issue.
What people are doing is taking a draft quote and activating it, then
turning the draft quote in...Tracking inventory that is sent back and credits due
I have a liquor store client who needs to track the return of a keg shell (to
Budweiser for example) and that they are expecting a credit. How would this
be done? Offlien Inventory? Transfer Out?
The only way we have been able to come up with for tracking our returns for
credit is to standardize the "Remarks" and "Title" fields on the transfers.
If you standardized these fields ie "Return to suplier for credit" you can
filter them out on reports.
> I have a liquor store client who needs to track the r...Change client permission on multiple Public folders
We have an Exchange 2003 Server with many public folders with subfolders
(migrated from Lotus Notes). These are MAPI folders an have to be given
access rights by using Exchange System Manager and give client permission
manually on every single folder. Is there no "apply to all subfolders" add-in
that exist? Or maybe a script? It takes some time to change permission on
some 1200+ folders.
Right-click on the parent public folder and pick "All Tasks". There is a
"Propagate Settings" option there.
"Bjorn Standal" wrote:
> We have an Exchange 200...How do I change the group heading COLOR of incoming e-mail?
Is it possible to change the COLOR of the HEADING of a group for an incoming
e-mail? It's pretty annoying having to search and search for incoming e-mail.
Thanks so much.
yes, its automatic formatting-and is part of the view settings. you can use
Tools, Organize. to access it.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slips...