14 results in 0.0032 seconds.
-
How to sort date column in ms access?
I need to sort a field that displays date on a form.This field is a textbox that simply displays a column 'date' from sql database i.e. it is not of type datetime when displayed.I had two ideas in mind; either I can convert the format to yyyy/mm/dd which helps sorting text or I should convert text into date format and then sort it.The problem in the first one is that even if I convert to yyyy/mm/dd I need to display as mm/dd/yyyy and the problem... -
Converting vba(excel macro) to vbscript
Hi All,
Copying code from vba to vbscript did not quite work. I was hoping if anyone could give me a hand. The purpose of the code is to sort the selection so that the smallest value is on the top. I was wondering if there is a way to make this work. Thanks!
This is the original vba code.
...Code:Range("F1").Select Application.CutCopyMode = False ActiveWorkbook.Worksheets("Sheet3").Sort.SortFields.Clear -
Reorder dictionary in pyrhon according to a list of values!!!
Let us consider a dictionary:
I want to re-order this dictionary in an order specified by a list containing the order of the dictionary keys that I desire. Let us say the desired order list is:Code:sample_dict={1:'r099',2:'g444',3:'t555',4:'f444',5:'h666'}
So, I want my dictionary to appear like this:Code:desired_order_list=[5,2,4,3,1]
How do...Code:{5:'h666',2:'g444',4:'f444',3:'t555',1:'r099'} -
Need some help with Grid view
I'm trying to do the following.
I want to use a gridview to load a set of associated
records dynamically based upon the input of the user.
I want the gridview to have a checkbox to the left of
the records and allow the user to use this to select
records to remove. The gridview will have pages and will
be sortable using the columns.
I had this working using a delete button, but when I went... -
Would someone help me with Searching and Sorting Arrays?
This is basically what I have to do. I think I have the methods correct in terms of sorting, but how do I switch it from largest to smallest?
The selectionSort method should take an array of integers as a
parameter and will sort the numbers into order from largest to smallest.
Place a println statement in the sort so every time a new maximum is
found, it is printed to the screen. Once all are sorted, the method... -
Prevent Filtering and Sorting with Subform Controls?
Hello,
I have some specification sheets with subforms I have created. I'm having a problem where if you right click and filter/sort any field in the subform (which is tied to the main form in a 1:1 relationship), then the subform only displays the first record. This ends up permanently altering the spec sheet. I notice that when this happens, text typically shows up in the "Order By" or "Filter" fields of the subform.... -
MS ACCESS FORMS using ORDERBY with [fieldname] in descending order
In MS ACCESS version 2003 I have a form that is based on a table. I have indicated that I want the form to display the table content in the order of the tracking id number (InvoiceNumber) which is an autonumber field.
In detail view of my form, I select the upper left corner black box properties to get to:
Form - Properties
Record Source - Table1
Order By - Table1.InvoiceN umber
As the field... -
Creating a reporting chart
I am trying to create a data reporting chart that will sort all my data by one of my columns and then list them.
For example: In my sales table I have a status column. My status are closes, proposals, concepts, etc. I want my end result to look something like the .pdf I have attached.
Is there a way to do this or do I have to export it to excel before I can create the information?
Any help is greatly... -
Dates - initial and modification
I am creating a sales tracker for work and I am trying to have it so for each sales form I can have an initial entry date and a modification date. Is there a way to lock the initial entry date so that it won't change after the initial entry and have the modification date change every time information is updated? -
Sorting a xml file
HI,
I'm trying to sort this list of xml data alphabetically (supplier name) but for some reason this code is not working. Coud you help? Thanks!
My xml
CONTRACTS
-CONTRACT
---SUPPLIER
----SUPPLIERID
----SUPPLIERNAME
My .net.vb page
...Code:Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
-
problems with datagridview rowheader value
I have an application where a datagridview is used to display some data, a datatable is bounded to it, and i want to put some text in the front of some rows to indicate that they are different from others.
my code checks the rows and used the following
mydatagridview. Rows.Item(iCnt) .HeaderCell.Val ue = "A"
to set the row header values, it was fine when the data was first loaded. however, when... -
Quadratic Sorting Algorithm Program
Hello! I need help with a program that I believe I am nearly done with. However, there seems to be a few details that preclude me from success. Here is my assignment:
Here is my class file (Sorts.java):
...Code:import java.util.*; /** * Description of Class * * @author Blake Walsh * @created October 20, 2009 */ public class Sorts{ -
wxGrid
Hi,
I'm using Python 2.6, and I'm trying to write a gui program that uses wxGrid. I have made it so that the columns can be dragged around to different locations, but I need to bind to an event that tells me when they are moved, and which one moved where. Can anybody help me with this? I don't see any events that jump out at me as being relevant.
Thanks. -
Report Grouping without Sorting?
I'm running Access 2003 on XP.
I have a report that needs to be grouped by a field that contains values such as:
Cherry
Apple
Grape
I need to group my report by this field, but I am required to conform to the above order. If I group this field, it is forcing me to sort ascending or descending, both of which destroy the required order.
Is it possible to group in a report without...
