Need User Friendly Sorting Of A Report Using A Sort By List...

Jun 29, 2006

Ok, I am a noob at reports and did a search on this. My searching DID NOT HELP ME! I thought I would make that clear :D Maybe someone can tell me what to look at for this issue.

I need to take one report, allow the users to easily use a dropdown or listbox on a form to Sort and Group many fields of data. To recap: The user will click on name in the list and it will sort report by name. Also I need them to be able to select up to three sort criterias.

EX: Sort by Name then LastName then Company

Please guide me to the answer. Thanks.

View Replies


ADVERTISEMENT

User Friendly Linked Forms

Jun 2, 2006

ok can someone please explain this to me..

i linked the booking to the driver using the ids through the bookingdrivertable.

the italic fields are the ones i have included in my Query called "bookingdriverquery"

bookingtable
booking id (autonumber)
date (date/time)
time (date/time)

drivertable
driver id (autonumber)
name (text)

bookingdrivertable
booking id (number)
driver id (number)

after doing this i created a form using the wizard, choosing all the fields from the "bookingdriverquery"

when i opened my form, i hid the booking id and driver id (as they are autonumbers anyway)

i then added a date.. a time.. and a driver name.. pressed save..

the booking table had 1 record, the driver table had one record.. and the bookingdrivertable had 1 record (both the ids)

this is the outcome i wanted..

i would however like to use the booking id and link it to another table in the same way.. a customer table for example (using booking id and customer id)

i had trouble however doing this.. because to duplicate this above method means that my user will have to re-enter the same booking details on another form.. and then the customer details..

how can i link all this together.. if someone wishes ask me a question and i will try to explain.. someone help me please.

View 1 Replies View Related

User Friendly Data Entry

Jun 29, 2006

Please Exuse the question I am about to ask. I am a bit rusty with Access and cant remember how to do the following. I have tried and tried to work it out and tried various help searches but cant get the answer I'm looking for.

What I need to do is create a data entry form, very simple! However I want the user to be prompted to enter a project name and number in order to find the project that i want the new data to be entered under. Then it will need to create a new record in that project ready for new data to be entered from the data entry form.

I hope it is clear what I need to do

View 1 Replies View Related

Make Forms More 'User Friendly'

Dec 11, 2006

Hi,

Im coming to the final stages of designing my database - its a Uni project. For extra marks it needs to be pretty user friendly.

One of the things I would like to do to my forms - I will use the following screenshot as an example - is remove the 'X' (Close) tab from the top right but I am unsure of how to do this exactly.

I would also like to remove the grey area around the form including the record navigation at the bottom.

Could someone point me in the right direction?

Screenshot - http://img237.imageshack.us/img237/7909/screenydg1.jpg

View 2 Replies View Related

Null Not Allowed, User Friendly Msgbox

Jul 27, 2005

I have a table field where Null is not allowed, how do I use a user freindly message to tell the user to add data to this field. When a user tries to leave the field Null (ie by tabbing out), they get a message, "tried to assign NUl value to vaiarble which is not variant datatype.

What I want to appear is more like "Please enter a name" or some other custom message.

Any ideas - I have tried before anfd aftyer update events and vaidation rule on the form field of Not Null, but the underlying message always appears first.

Paul

View 3 Replies View Related

Stylish Forms That Actually Look Good And Are User Friendly

May 9, 2006

I searched google for sample databases and most forms are rather primitive... Currently there are some features to make more user-friendly forms that I have yet to find in excess:

1. Stop updating record automatically :
For some strange reason access auto-update the records the user change in a form. What I want is to only update records when the user press the "SAVE" button. This could allows better validation without forcing the user to remain trapped in an entry.

2. Better error messages
Instead of annoying pop-up telling the user that he made an error, I want something like an ErrorProvider Component that tells what error the user made with a small symbol (!) which provides the explanation of the error when you over the mouse on it.

3. Using different formats for different columns in a datasheet form
For some reason it is not possible to assign a special backcolor for some field that are locked to indicate they are locked if you use a datasheet form. This needlessly confuses users who hammer their keyboard trying to enter info in locked fields and have no feedback ( except maybe an incredibly annoying pop-up window ) to tell them not to enter data there.

4. Better excel-style features for datasheet forms :
Good way to annoy users : prevent a way to cut and paste multiple rows/columns of information in datasheet. If you try to paste more than one column at the same time it just doesn't work.

Also why is it impossible to make the title of field to take more than 1 row ? I mean it sure looks dumb to have

Number of tax report
1
2
3
4

Instead of

Number of
tax report
1
2
3
4

View 8 Replies View Related

A User-friendly Way To Link Tables In A Split Database

Feb 25, 2008

Hi, all.

I have a "client/server" split Access 2003 database with an Interface file containing all the code/forms/queries and some system tables and also a Data Backend file, with all the data tables and table structure.

This is being deployed to multiple sites, each getting their own version of the backend, so sites will not be using the same backend between them all, rather multiple users in each site will all share that site's backend file.

Since users will deploy in different network locations, etc. they will have to re-link all tables. Is there a meaningful/user-friendly way of doing that without relying on user's knowledge of "Linked Table manager", etc.?

Thanks!

View 9 Replies View Related

Reports :: Sorting And Formatting A Report Based Off Of Values And User Input?

Jul 1, 2013

I'm trying to make a report that a untrained user can use to review the relevant data from the database I'm creating. All of the work I've done so far has been directly in the tables . Here's a quick outline of my general data organization:

Department:
DepartmentID(PK)
DepartmentName

Employee:
EmployeeID(PK)
EmployeeName
DepartmentID(FK)
Needs_Work (check box)

[code]....

Basically, I want the user to select a department to view using a combo box or option group (which I'm not sure of how to do in a report). Then, I want to view the employees within that department sorted first by whether or not the Needs_Work check box is selected, and then by how many of their competencies are unchecked.

View 2 Replies View Related

Queries :: Sort By Year Is Sorting By Month

Sep 16, 2013

I've created a query based on 2 other queries.

I then filter the results of the third query based on 2 dates.

This worked great for 2013.

As a test I started making some records for 2014 and I've now found that my third query is not filtering the dates properly.

The filtering is happening based on date fields that contain only month and year eg: "09-2013".

My problem is that when I try to filter for records in 2014 it brings up results for 2013 as well.

If for example I had a record in August 2013, September 2013 and August 2014.

The sort would be:

08-2013
08-2014
09-2013

NOT:

08-2013
09-2013
08-2014

How do I make the sort apply to month then year to get the correct results returned?

View 6 Replies View Related

Report Sort Different From Query Sort

Mar 3, 2006

i made a report based on a query. when i run the query, my results are sorted by Job Time Ascending, like i want...
when i made my report i chose job id as the main group priority in the wizard..

now in my report it displays the jobs in ID ascending, rather than Job time ascending as my query says..

i dont want to re-do the report it took ages.. how can i fix this?

View 3 Replies View Related

Report Sort Is Not The Same As Query Sort...

Jan 9, 2005

I have a query that sorts players batting averages from highest to lowest. When I run the query just by itself it sorts it right however when I open the report based on that query it does not sort in descending order like I asked. What am I missing??

View 3 Replies View Related

Sorting List Box

Nov 2, 2006

Currently I am creating a form in Access 2003. I have a table that I has 7 column headings, events, location, date, time notes, classs, and region. I need to know how to sort these columns by clicking on a button that will be assigned to that column or by clicking the column header? This needs to be able to sort it in ascending order based on any one of the columns? An example of this would be similar to an e-mail account, where you can either click on the subject header to reorder based on the subject, or click on the date header to reorder based on the date.

View 1 Replies View Related

Allow User To Sort Data

May 10, 2006

Hello everyone

One of my forms has a load of data displayed in it from a query and I would like to allow the user to sort this data by means of some buttons next to each column heading. For instance clicking 'up' next to first name / last name etc will sort ascending on first name, 'down' will sort descending etc. I tried setting up different queries for each sort and changing the record source of the form in the on click event but then the controls don't seem to know where to populate from!!

Can anyone help with what I should be doing?

Thanks

View 2 Replies View Related

Reports:Grouping, Then Sorting, Then List?

Feb 23, 2006

Ok Second issue: I have a list of companies that each offer 5 different programs. Eash Listing in the query (My report is built on this) has both a column for the definition and a colum with a number idenitfying the amount of people in the program.

What I need is to HIRE someone, but maybe I can do this:

I want to list each company and all 5 programs associated with that company; easy and its done.

Then I want to have a summary at the bottom of the report that goes to each company, takes the 5 programs for maybe 1, maybe 3 or maybe 92 companies, and lists them in order. Order = the top 5 programs for all the different companies. See and it gets complicated because sometimes, a program can be the largest for every company in the report, and then the second program for each company is different for each each company. So I need to arrange the programs in an order. then sort them by size, and them only show the top 5.

PLEASE, if you got through this far of my irrational and illogical brain then maybe you can help

Thanks Sean

View 2 Replies View Related

General :: Sorting Data In A List Box

Sep 21, 2012

I have a database with a form. Form has a list Box. I write a code for sorting data in list Box and it is worked but sorting in one of the column in list box does not work.I think the reason of it that this column is a combo box with multiple values.

The file of database is in attachment.

View 2 Replies View Related

Queries :: Sort By User Input Order

Apr 30, 2013

I have a simple form with a text box, I enter a series of part numbers separated by newlines, and then I use the following code to query for each of the separate part numbers:

Code:
Dim strSql As String
Dim part_nums() As String
Dim num As Variant
Dim multivar As Boolean
multivar = False

[Code] ,......

This all works perfectly, but what I need to do is have the query return the records in the same order I entered the part numbers. They are automatically returned in alphabetical order by item_no, and when I enter 15+ part numbers it becomes slightly difficult to search through them all on the form to find the one I am looking for. It would be a lot easier if they were output in the same order that I type them in. Is there any way to make this happen?

View 1 Replies View Related

Button To Sort A List

Jun 30, 2006

Hello there!

This is my very first post on this forum. I started to work with Acces and SQL only two weeks ago, so my questions probably are newbie-stuff, but please bare with me and please help me anyway :-)

In my form I've inserted a list that shows data from one of my tables. The posts are ordered by 'ID' (and I know how to change this). But I want to make a button just right of it, that, when it's clicked, sorts the list by 'first name' instead.

How do I make such one???

// John

View 3 Replies View Related

How To Sort The Field List

Aug 8, 2013

When I "Add Existing Fields" I'd like the list to be sorted alphabetically...how to do this?

View 4 Replies View Related

Forms :: Unbound Combobox - Sorting List Of Files

May 19, 2014

I have a BackUp and Restrore from BackUp procedure in my my database.

I can backup to a spreadsheet and the spreadsheets are renamed to include the date of the backup.

When I restore from the backup an unbound combo is populated

Code : Set SourceFolder = FSO.GetFolder("c:GPandDetectionDogTrainingLogBackUp")

This all works, the only issue being, is that I want the most recent backup to be at the top of the list, at the the moment its at the bottom.

is there a way of implementing a sort order, bearing in mind that its an unbound combobox.

View 5 Replies View Related

Combo Box To Sort Already Sorted List Box

Jun 30, 2005

Ok what I have is a List box with four rows. (Name, Assignment, Location, Description) These are all labeled with a frame at the top that when that frame is selected that row is put into alphabetical order.
The next thing I have is a combo box which also sorts the List box by "major location". The combo box has the following (All, Fort Mills, Corporate, Pequot Lakes, Savage, Retail) When one of those is selected the location row then shows only one of the following locations and the others are removed.
Here is where the problem comes into place. I want to be able to select a major location, then be able to sort with the frame. When I select a major location, and then click on the frame, lets say "Name" the list resets back to everything from that table and not just that certain "Major Location" that I have selected. I need to sort whatever is selected in that "Major Location" by whatever is selected in that frame. thanks for any help, I know its a hard one.

View 2 Replies View Related

Sort Order Of Unbound List

Sep 15, 2006

I need to manage a list of, in this case "medications", with this list the most common "meds" are on the top of the list. there will be at times new "meds" added that should be at the top of the list. I want to create a unbound box that will let me drag the "meds" up or down in the list. The best emample i know of is the way you can set the "Tab" fields on a form to move the tabs stops.

View 4 Replies View Related

Forms :: Sort Form From List Box

Apr 14, 2015

I have a form named "frmItems" with a list box in it called "lstItems"

I would like to create a find (or search) button for it, but how? I also have a search box called "txtSearchI" ...

View 14 Replies View Related

User Input Data In Table Using Form - Sort By Month

Mar 28, 2013

I have a table with product numbers and their cost. That table has 3 fields : SKU, Cost, Month. (The cost can change every month, therefore the list is built to have a cost / month)

I want the user to be able to input the data in the table using the form but I would like the form to be sorted Alphanumerically for the SKU numbers and then per month (in their normal order not alphanumerically).

I have a combobox (named month for testing purposes) to force the user to select one of the 12 months and the field type is Text.

Also I am unsure how to "autosort" (or apply a permanent sort) the form whenever it's opened. Will it be applied if I just set the sort and then restrict the user from seeing let's see design mode?

View 4 Replies View Related

List Records By Desired Groups Instead Of Sort

Aug 3, 2007

Data in table “tblEmployees”:

EmpName GroupNum
Jon Group1
Sam Group2
Tom Group1
Bob Group1
Hal Group2
Dan Group3
Cal Group2

With sample table above, can I write a query in Access that lists the data by GroupNum based on my criteria, say Group2 1st, then Group3, then Group1? Basically, how do I make the result show:

Sam Group2
Hal Group2
Cal Group2
Dan Group3
Jon Group1
Tom Group1
Bob Group1

View 3 Replies View Related

Multiple Combo / List Boxes - Sort Based On Entries

Sep 23, 2013

I am trying to put together a form where employees will be entering maintenance information into my database. One of the requirements for this data is that when they perform repair work on an asset, they have to list a problem, cause and remedy. These are codes that are specific to each asset.

The closest thing I can think of to what I am trying to acheive is the selectors on car search websites. You select a MAKE, and then the MODEL list is narrowed down based on that, then you pick the TRIM, which is narrowed down based on the model selection. I have an Excel spreadsheet of the Assets(Failure Class), Problems, Causes, and Remedies...I'm just not sure how to put this into Access to get the desired output. I have attached a sample of the Excel spreadsheet for illustration.

I believe I'm going to have to put each of the columns in a seperate table and use relationships..but I'm not sure about that.

View 2 Replies View Related

Report Sorting Order?

Feb 9, 2005

I have created a report from the information submitted on a form. When I pull up the report, I would like it to sort differently than it is. I am not sure what it is using to sort from but I want it to sort by a designated # I have assigned it.

Is there a way to make it so the access's record # will always match our companies record #?

Today I entered information in a form that should have gone in as record 96 but when I went back to look at the record in the report, it was record # 72. ??????? Now what do I do?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved