Sort not working correctly
I created a report for a query. When I sort the desired field most of the
records sort correctly, but some records do not. This phenomenon happened
both in the query and the report. I was able to solve the query sort problem
by highlighting the column in the data set view and right click ascending.
The mixed sort continues in the report weather I use Order By On or the
Sorting and Grouping dialog box. Any idea what I'm doing wrong?
Frank <firstname.lastname@example.org.(donotspam)> wrote:
>I created a report for a query. When I sort the desired field most of the ...close gp automatically after running a macro
Can anyone suggest the best way to close gp after running a macro. We are
using macros to open GP to run an integration and need to close it
afterwards. We are currently getting dexterity error messages.
You can exit Dynamics during recording your macro so it will automatically
exit during playback.
Then add the following line as the second line of your macro.
Logging file 'macro.log'
This will prevent message from appearing within the macro and will log them
to this file.
Consulting Technology Lead
The views or opinions expres...hyperlink to macro
Click on a hyperlink to execute a VBA macro. How to setup the Macro
address and/or subadress fields for this? I remember seeing something
for this a while back.
You could use the Worksheet_FollowHyperlink() event as below. This runs the
Sun RunCode in a standard module. Obviously you can test the values provided
by the Hyperlink object (Target) if you only want to react to certain
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Microsoft MVP - Excel
<alo...sorting activities for each lead/contact by actual end dates
When I view the activities associated with each lead and
contacts, the actual end date are not shown. Does anyone
know how I can dispaly this field?
The activities list in workplace does show the actual end
dates but we'd like to see that when we access the list
through indivial contact/lead record.
There is no good out of the box way to do this in MSCRM today. We're working hard to fix this for v2.0. Many of our customers have worked around this issue by registering for a post call out on the activity creation, and then having a custom object wh...WSS 3.0 Search only works for administrator
I just moved WSS 3.0 contents to new SQL 2008 server. I did this by
backing up the contents, wiping out the WSS on the server, re-
installing it, setting up the new install on the new SQL server and
restoring the content.
Now search is working only for administrator. All other users that do
a search doesn't return any results but doesn't get error either. It
just says "No results matching your search were found."
I am not sure what other information to provide for this problem.
Please let me know if you need more information on this.
Did ...Sorting in Excel 2003
When I sort columns that contain blank cells, Excel throws them down to
the bottom. Is there any way to get them to appear at the top of the
You could try replacing the blanks with a space by clicking Crtl + H
then leave go straight to replace with. Click in cell and press the
space bar once.
Then sort Ascending order
VBA Noob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33833
View this thread: http://www.excelforum.com/showthread.php?threadid=561267...sort dates
My dates use the system dd/mm/year
if i press the sort button.. it will sort by day->month->year
I want to sort by year->month->day
how do i do this??
Message posted from http://www.ExcelForum.com
The best thing to do is to store your data as real Excel dates. Then they
will always sort properly, regardless of which format you display the date
As you have numbers, rather than dates, sorting isn't so easy. The choices
1. Create a Date field (=Date(year,month,day)) and sort on that.
2. Split out the day, month and year, then sort on the three separa...How to change sort-by and sort order?
I am trying to figure out how to change the sort sort-by to "Product ID"
instead of "Name" for the Product Record Lookup in Opportunities, Quotes and
When you click the magnifying glass to "select a value for product", a web
page dialog pops up. The "available records" view is soted alphabetically by
the "Name". I would like to have the view alphabetically sorted by the
"Product ID", and have the order of those columns swapped...i.e. Product ID
column on the left, and Name column on the right.
All advice greatly a...Sorting out Duplicates
I have a price list with part numbers sorted on the left and price so
the right... The genius who wrote the price list doubled up on a whol
bunch of numbers. Is there a way to identify the duplicates ?
Actually I know there is ... I have been using the following function
after sorting by part number...
A2 part number
What that does is say true in the c column for dup part numbers....
What I am actually trying to d...Max length of description on Appointement en CRM 3 ?
We adjusted the Max Length for the Description field in the
Appointment record from the default of 2,000 to 5,000. When we use
the web client we are able to save appointments that have 5,000
However, when i go offline with my Laptop Client and then try the same
thing the appointment form closes but there is a hidden error message
behind it stating "The length exceeds the max
length of it will be truncated". When you open the record back up
instead of having 5,000 chars, you only have 2,000, i lost most of my
How setup Outlook to respect the 5,000 limit (as desi...Create a Chart using a Macro
I would like automatically generate a Gantt style graph though use of a
Macro and a little button. I have the following data
Does anyone have some code that I can just use?
Scott, I don't have a Macro but there is a GANTT chart available at:-
Item Number 78.
You might like to download this.
If my comments have helped please hit Yes.
> Hi all,
> I would like automatical...GP Macro Question
Does anyone know of a way to run a GP macro from the command prompt? it can
be done for the login macro but i am trying to run it for a macro that i
would like to occur while GP is already running and i cannot schedule it
because it needs to be run at different times. any ideas? thanks for your
...HELP! How do I get a total for columns sorted by account number on a spread sheet
Ok, I am not sure how else to explain this. On a spread sheet I will be entering account numbers and a balance due on different spots in the sheet. On a 2nd spread sheet I need it to find the specific account number and add up the total that customer owes. Can I do a total by account number by formula or will I have to do seperate spreadsheets for each person? If you can't tell I am lost.
Try something like
where Sheet1!A1:A100 is the account number range, "123456768" is the account
number to check, Sheet1...Macro for Graph #2
For the following table, I have written the macro to obtain the graph
But the problem is the no. of column and rows can change... So I don
want to hard code particularly the first part of macro... Please help.
Keyword Date Total Of Value XYZ TUV RST
ABC 27/10/2003 7 7 11 100
ABC 27/11/2003 7 3 5 15
ABC 27/12/2003 7 10 200 25
ActiveC...sorting a list
I have a column of faculty and need to sort it by rank in a particula
order. There are four ranks. How is this done? thanks for your hel
dee student's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3480
View this thread: http://www.excelforum.com/showthread.php?threadid=55160
You could set up a custom sort list under Tools>Options>Custom Lists...
import or type your four derivatives in the order you want to sort them.
Once you have this set up, go to data...MSXML 3.0 patch 955069 breaks our application
If I apply MS08-069 KB 955069 our application will not fully function.This
Server has MSXML 4.0 on it as well. How to I get our application to point to
another version of MSXML. I am not a developer. However I contated some of
ours and they were of no help. Any help would be greatly appreciated.
> If I apply MS08-069 KB 955069 our application will not fully function.This
> Server has MSXML 4.0 on it as well. How to I get our application to point to
> another version of MSXML.
What kind of application is that? For instance in classic ASP with
VBScript you would ...grouping/sorting limits
I have a need to have the maximum number of groups possible on a report (10),
but I want each grouping to be sorted by a field that is different than the
grouping field. Is there any way to add a sorting field to each of the 10
groups without deleting any groups? Not surprisingly, I was unsuccessful in
trying to apply the sorting in the query.
Post sample data and what you want in results.
Build a little - Test a little
> I have a need to have the maximum number of groups possible on a report (10),
> but I want each grouping...Instant messaging #3
Sorry I'm a newbi to ek2003, what componets should I have loaded to allow
for instant messaging? I don't even have a virtual server for it? Thanks
"Are you still wasting your time with spam?...
There is a solution!"
Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
I believe IM capabilities are only available through Communications Server.
If you are upgrading from Exchange 2000 and IM is already installed, you ca...Sort command does not sort some columns?
When attempting to sort data, newly entered data seems to stay the same while
the old data sorts itself. I have one whole column that is now mismatched.
I am a newbie to this program so I am sure I am doing not doing something
If you want to sort a multi-column range of cells:
Select the entire range of cells
Set your sort parameters
Click the [OK] button.
If all of the relevant columns are not pre-selected, they will not sort with
the column you want sorted and you'll have out-of-sync mess.
Does that help?
XL...Sort a Subtotalled List?
Does anyone know if you can sort a list after it has been subtotalled?
The reason I ask is because I am basically sorting a list based on a criteria
and then deleted all transactions that offset to each other to equal zero. So
if I could sort the list after it was subtotalled all the subtotalled amounts
that equaled zero would be in order and I could delete them all at once,
instead of scanning through the list. Any help would save me a huge amount of
Would it be better to remove the subtotals (Data/Subtotals/Remove All) then
sort/delete data, then re-apply t...Adding #3
Does anyone have any suggestions for the following:
I would like to add the last cell in column B (The row varies daily) o
sheet 1 to the existing amount on Sheet 2 Cell A2.
For example the last cell on Sheet 1 column B is $100. The amount o
Sheet 2 Cell A2 is $5. I would like a Macro that would find the las
cell on Sheet 1 Column B and add it to the existing value of Cell A
Sheet 2 to create a new cell value of $105.
Any help would be greatly appreciated
STEVEB's Profile: http://www.excelforum.com...matching a sorting the exact value in the data list
In Excel 2000 I wish to match and sort the following data using some type of
function in Excel.
....so the above mentioned data should look like this(see below) after the
function has been applied.
CRXU1972999 CRXU1972999 (wish to join but in seperate columns)
CRXU19739...2nd search box not sort properly after using 1st search box
I have 2 combo boxes on a continuse form. One to search name and Other to
Private Sub cboFind_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Me.OrderBy = ""
Set rs = Me.Recordset.Clone
rs.FindFirst "[Last Name] = '" & Me![cboFind] & "' AND [First Name] = '"
& Me![cboFind].Column(1) & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Me.cboFind.BackColor = -2147483633
Private Sub cboDepartment_AfterUpdate()
When I create a new email message, hit the "To" button and select my contact
list, I get the Full Name. I would like to get the list Last Name, First
Name which is how my "File As" column is setup. Is there a way to do this?
...Sort highest by name
I have 55 teams in A1 to A55.
I have their scores in B1 to B55.
Is there a way to list the scores (highest to lowest) but giving their team
names instead of all the numbers in order of the highest to the lowest?
Help Obe 1
Why don't you just sort this data by column B in descending order?
Select the range starting from cell B1 then just click the sort descending
button on the toolbar.
If you don't want to sort the data then you could use a formula. Are there
any tie scores? What type of values are the scores? Are they whole numbers?
Microsoft Excel MVP