General :: Scrolling Form Order

Jul 11, 2013

I have a table with about 290 record. When I'm in the "Form View" and click the "Next Record" arrow it scrolls by order of Employee instead of the primary key "Record Number".

View Replies


ADVERTISEMENT

General :: Comment History Field To Appear On A Form - Change Sort Order Of Results

Aug 28, 2013

I have after much stress gotten my comments history field to appear on a form.

The following code gives me what I needed

Code:
=ColumnHistory([RecordSource],"LastUpdateBy","[ID]=" & Nz([ID],0))

I have only one simple thing left, that is perplexing to say the least.

Some comment fields will be many short notes, spread over time.

My desire is to change the sort order of the results so the most recent (rather than the initial) comment is at the top.

View 5 Replies View Related

Scrolling Down A Form

Jan 12, 2006

I'm using access 2000, and have built a long form. My users would like to be able to use their mouse wheel to scroll down the length of the form rather than having to click the scrollbar. is there a way to do this? (I'm sorry if I missed this being answered in another thread, I looked but did not find.)

Thanks

Jamesmor

View 2 Replies View Related

Scrolling In Form View?

Mar 15, 2006

Hey, just a quick question that I hope someone out there maybe able to help with :-) In form view I don't want the mousewheel to scroll through my records when I use it, Can someone tell me what is the easiest way of turning this option off? I tried editing the [event procedure] in the form properties but it bought up a page in VB which I have no idea how to use. Sorry if that is confusing, basically i only want mousewheel to scroll down the form page that I'm on and NOT iterate through all my records. Any help would be much apprecitated :-) Thanks

View 1 Replies View Related

Continuous Form Scrolling Problem

Sep 7, 2006

Hope somebody can help with this. I checked the archives but not luck.
My continuous form allows entry of 12 records. On the thirteenth record the new row scrolls to the top and all the previous rows disappear. Every new record after that scrolls up out of view and a new blank row is at the top. I can scroll up to see the previous records but they do not scroll one at a time as data entry is performed.
Data Entry is set to No, Allow Additions is set to Yes.

Am I missing something?

Thanks for any help.
Kerry

View 1 Replies View Related

General :: First In First Out Order Shortage

Mar 25, 2013

I need to design a query in which order shortage is calculated with respect to fifo method for orders .

Attached is the logic

How to create it. and if i need to incorporate more than 10 orders , what is the best method for this ?

View 3 Replies View Related

General :: Using Autonumber As Order Number

Aug 13, 2015

i am going to use the autonumber as an order number but I want " SC2015 in front of it so i end up with " sc20151 , sc20152 but next year i want it to change the year SC201650 .how to put the sc2015 in my report without any input from the user

View 2 Replies View Related

General :: Order Of Tabbed Documents

Oct 17, 2012

Because of certain design considerations and the amount of data I'm maintaining, I have chosen to use tabbed documents rather than floating windows or subforms.

The hierarchy is supposed to be a person who is categorized as either a client, family member, donor, etc. Further, a client may use one or more services. In the example, our client uses Specialized Home Care. However, the tabs are intuitively out of order: the people tab is left-most, followed by the Specilaized Home Care tab, and lastly the Client tab. It should be People, People:Client, People:Client:Service. If a person uses a lot of our services, there will be separate People:Client:Service tabs and the People:Client tab will scroll off to the right. I'd like Access to order them properly but see no way to do it.when the forms are opened, it's people first followed by the high-level classification (i.e. Client), and the lastly the specific Client:Service tabs. I would expect Access to open and display them left to right, but, as you can see, it doesn't.

View 7 Replies View Related

Allow More Than Order In ORDER Form

Apr 4, 2013

I have a problem when I want to create an "ORDER" form, that will allow user to enter more than one order.

I have no clue how to do it.

View 14 Replies View Related

General :: Updating Sort Order Of Records

Nov 10, 2014

I have a table with entries describing a sequence of Tasks (tblTask)

tskID TaskDescription
10 Clean Room
12 Wash Dishes
etc

I have second table called Steps (tblSteps) that is related to tblTask via the field "StepNumber" which is a concatenation of [tskID] & "." & [StepOrder]
So if we look at washing dishes as a task then the steps are as follows:

StepID, StepDescription, StepOrder, StepNumber
202 Put plug in the sink , 1, 12.1
512 Turn on tap, 2, 12.2
205 Put in detergent, 3, 12.3
210 Place dishes in sink, 4, 12.4
435 Turn off tap, 5, 12.5
etc

If I decide delete the third step I get the following:-

StepID, StepDescription, StepOrder, StepNumber
202 Put plug in the sink, 1, 12.1
512 Turn on tap, 2, 12.2
210 Place dishes in sink, 4, 12.4
435 Turn off tap, 5, 12.5

Is there a simple way renumbering the StepOrder entries when one step is totally removed to give me the following?

StepID, StepDescription, StepOrder, StepNumber
202 Put plug in the sink, 1, 12.1
512 Turn on tap, 2, 12.2
210 Place dishes in sink, 3, 12.3
435 Turn off tap, 4, 12.4

View 6 Replies View Related

General :: Order Payment Database - Balance Due

Nov 22, 2012

I am new to Access. I am creating a simple order/payment database.

I have tables for the orders and payments and have a relationship setup.

I created an order form with a subform for the payments.

[URL] .....

View 2 Replies View Related

General :: Get Some Information To Show Up In Chronological Order?

Jul 17, 2015

how to get some information to show up in chronological order.

For example,
It is showing up like this..

Week 1
Week 10
Week 2
Week 20
Week 3
Week 4
and so on

I want it like week 1
week 2
week 3
week 4
week 10
week 20

View 8 Replies View Related

General :: Sort Order For Topmost One-to-many Relationship

Dec 6, 2013

I am currently studying Robert Jennings book entitled Using Microsoft Access 2007 Special Edition. In reading about specifying of the sort order and top value limits established by inner joins (pg 455), the author makes this statement.Access displays query result sets in the order of the index on the primary key field of the table that represents the one side of the top most one-to-many relationship of query tables.An example of a query with Orders, Order Details, and Products tables displays rows in productID (the primary key field in the Products table) sequence. He says that it does so because the Products table has a one-to-many relationship with the Order Details table and indirectly with the Orders table. I do not understand why the Products one-to-many relationship with the Order Details table is ranked as the top most relationship in that the Orders table also has a one-to-many relationship (OrderID is the primary key field) with the Order Details table and an indirect relationship with the Products table. The Order Details table has two primary keys (ProductID and OrderID). My attempts to change the sequence in which the table relationships were formed as well as the location of the tables in the database had no effect on the result.

View 2 Replies View Related

General :: Automated Order Status Field

Feb 25, 2014

Basically working on a Customer Order Database for my carpet shop.

I have a Customer, Job and Order table. The order table contains the line items for each job and each customer can have many jobs.

I have a field in the Order table showing the item order status being either "Instock", "To be Ordered" or "Ordered"

I also have a Job Status field in the Job Table

I would like that Field to be automated depending on the item order status for each item on the job.

At the moment the Job status is a manually selected drop down box of either; 'Ready To Fit', 'Awaiting Stock', 'Items To Order' or 'Job Complete'

For example if all of the items had a item order status of 'Instock' then the Job Status would display as 'Ready To Fit'

If any of the items were 'To Be Ordered' it would display as 'Awaiting Stock'

I dont know how i would solve the situation of some marked as say 'In Stock' some 'Ordered' and some 'To Be Ordered' ????

Also the 'Job Complete' would come from another field in the Job Table marked with a check box...

View 5 Replies View Related

General :: How To Order Values In Multi-Select List Box

Jun 4, 2013

Is there a way to order the values in a multi-select list box:

1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20 appears in the listbox as:

1,10,11,12,13,14,15,16,17,18,19,20,2,3,4,5,6,7,8,9 . Is there a way to have it appear as it does originally?

View 1 Replies View Related

General :: Creating Auto-Sequential Order Number

May 6, 2013

I am trying to create an auto-sequential order number

Example : AB000112 - AB is standard prefix, ''0001'' is the first invoice number, ''12'' is the year 2012.

so the next order number should read AB000212 and the next AB000312

Out of this, I have to issue several debit notes relating to the same order number when the payments are due from customers over a period of time, this will be

001AB000112
002AB000112
003AB000112

Can such numbers be the primary key?

View 4 Replies View Related

General :: Order Database - Discount Table With Percentage For Each Item

Aug 23, 2013

I have been asked to create a database that creates orders, debits stock etc for my company. Now I have been asked to put in some kind of discount table with percentages for each individual item for each individual customer. What would the best way of doing this?

I figured in the Customer Table I would have a code such as 'CustomerADiscount' and 'CustomerBDiscount' etc. and then in my table maybe

Product A - CustomerADiscount - 10%
Product A - CustomerBDiscount - 20%

Product B - CustomerADiscount - 5%
Product B - CustomerBDiscount - 7%

This link these values up within a query? Would this be the best way of doing it?

Is Access able to determine a percentage in "10%" or "5%" or do I need some type of formula for it instead?

View 3 Replies View Related

General :: Use Drop Down Control In Service Order To Select Customer

Mar 1, 2014

I have a client table.
I have a client product table for ski's
Each Client has 1 or more products (skis)

I have a Service Order table and form that I use a drop down control in the Service order to select the customer.In the Service Order Form a I have a continuous Subform for detailed service.

This is where I'm having the problem.In the detail subform I want to select from a drop down box the customers particular ski that I want to service. how to have only that one customers ski's to show up.

View 14 Replies View Related

General :: Concatenate - Combine Dates Into One Cell To Have One Row Of Order Data

Feb 25, 2013

I have 2 gig of order data which has duplicates due to different invoice dates. How can I combine the dates into one cell so I only had one row of Order data.

i.e. order number, price, order date, invoice date

same order number, same price, same order date, different invoice date.

How do I combine the second line with the first so that I only have the data once.

View 10 Replies View Related

General :: Priority Based Multiple Order Shortage List

Jan 21, 2013

I have created an access application for production system .

I have a final stock query and 2 to 3 orders based on priority and i want to create a shortage list based on priority ... here is detail :

ItemName....|Stock qty....|ORDER1....|ORDER2....|ORDER3....|
A.................|200............|40............. |90............|100...........|
B.................|500............|0.............. .|400..........|200...........|
C.................|30..............|40............ .|0..............|20............|
D.................|0...............|0............. ..|10............|0...............|
E.................|900............|400...........| 300..........|280...........|
F.................|130............|200...........| 50............|0...............|

Now I want shortage as:

ITEM NAME |O1 SHORTAGE | O2 SHORTAGE | O3 SHORTAGE|
A................|00..................|00......... ..........|30..................|
B................|00..................|00......... ..........|100.................|
C................|10..................|00......... ..........|20...................|
D................|00..................|10......... ..........|00...................|
E................|00..................|00......... ..........|80...................|
F................|70..................|50......... ...........|00...................|

What method Do I use to write a query as I have hundreds of Products and 40-50 orders????????

View 6 Replies View Related

General :: Pull Data From SQL Server Based Off Of Order Number?

May 27, 2015

I am looking into re-creating something I have created in Microsoft Excel into Microsoft Access.What I do in the Excel spreadsheet, is when I type in an order number, various fields in the spreadsheet are populated using vlookups and ODBC's.

I wish to re-create this in Access but not sure how. I have a basic form, with various fields such as, order number, part number, description, quantity.What I have in my mind is that I would like to be able to type in an order number, then the rest of the fields would be populated by a query to a SQL Server database.i can see a way to do this using VBA but would rather look for a more direct way if possible.

View 2 Replies View Related

General :: Work Order System - Empty Records Showing In Table

Apr 3, 2014

I have a work order system that people use but it somewhat randomly puts blank records into my table. I've added a lot of validation checks when submitting, closing and resetting the form and limited the way people can exit out of the form to fight this issue but it still happens.

View 3 Replies View Related

Forms :: Use Buttons On A Form To Change Sort Order On A Continuous Form

Jul 23, 2013

I want to use buttons on a form to change the sort order on a continuous form. In the buttons click event I am using a public function (named Sort_1) to change the sort order. The first element of the event call is the name of a generic query (named Sort_1_Query1) and the query field to sort (LAST_NAME OR FRIST_NAME, depending on the button.)This is the Click Statement.

=Sort_1("Sort_1_Query1","LAST_NAME")

This is the Public Function
Public Function Sort_1(SortName As String, FieldName1 As String)
DoCmd.ApplyFilter SortName, FieldName1 & "between 'A' and 'Z'"
End Function

I think the problem is in the use of quotation marks or trying to pass the query field name to the Do Command or the use of an ampersand.

View 4 Replies View Related

Scrolling

Dec 10, 2004

Does anyone know why with some combo boxes, when I grab the scroll bar and haul it to the bottom of the records, after I let go of the mouse button, the scroll jumps back up to around the middle of the combo box? Then, I have to keep pulling it to the bottom several times before it finally gets to the last record.
Thanks

View 1 Replies View Related

Duplicate A Form And Sort A Form In Ascending Or Descending Order?

Oct 2, 2005

Hello,

Is their a a way I can have a button or something in which duplicates all the data in the text boxes instead of re-entering data?

Also how can I sort data (DATES) that is in a form in descending order.

Thank you,

Onofrio

View 5 Replies View Related

A Different Scrolling Issue

May 18, 2006

This is not an other post about disabling the mouse wheel in access application but an other issue that is starting to really bug me...
Some of my forms have a continuous subform, I can normally use the scroll wheel to go up and down the different record in the subform BUT i have noticed that if there is just a small amount of record in the subform (let's say three for example) when I scroll down the different records, they disapear in the detail header frame of the subform and only the last record is visible which I guess I don't mind to much. What annoys me is that if I scroll back up nothing happens the 2 records stay hidden behind the frame and the only way to put it back to normal is to use the scrolling bar on the right of the subform!???
I was wondering if anybody had a similar problem and if there is any solution to it?

View 4 Replies View Related







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