Manual Ordering.

Jun 9, 2005

I think this may be impossible but I am hoping it isn't :)

Have any of come across a way to Manually order a continuous form.

The way I would see it working is to have a column in the table called sort_order and two buttons on the form called move up and move down. Once clicked the sort_order value would change thus changing the order on the form.

I should imagine it would be alot more complicated than my brief description, in fact it may like I said be impossible.

If any of you have an idea how to achieve this I will be very grateful

Cheers

Paul

View Replies

Manual Input Table

Aug 2, 2006

I want ot design a monthly table which shows each day 1-31 but I want to be able to enter a data value manually for each day.
I'm looking at building a query from the table which asks me for the date ie; 2Aug06 and then asks me for a value ie; 6 so the query (from which I can build my report) shows 02Aug 06 6

Regards

Richard

View 1 Replies View Related

Manual Primary Key Entry?

Mar 3, 2014

My table depends on the primary key ID to generate an entry.

I had 1399 entries done upto last night.

Somebody entered 1400th and deleted it . and next they continued from record #1401 to 1410. Now 1400 # is missing.

How I can manually enter 1400th record in my table.

View 1 Replies View Related

Code For Manual Data Entry

Sep 7, 2005

Can anyone tell me what code I can use to manually enter data from a textbox. I don't want a bound box, but want to write some code that will take the text from that text box and enter it into a field in a table when i wish it to.

How is this code written please?

Thanks

View 2 Replies View Related

Choose From Combo-box, Or Manual Entry. Help!

Apr 6, 2005

Can't seem to figure this out.

I built a db for tracking and entering sales info but I'm having a problem with one of my combo boxes. To make entering data easier, I created a combo box that you can select a sales persons name from, then based on who is selected, their Title and Office location also populated.

The problem I have is when I want to manually type in the Name and other info for a temporary sales person. How can I allow users to choose from the drop down or just type it in if that person is not in the list?

Thanks in advance for your assistance.

View 1 Replies View Related

General :: Possible To Have Manual Primary Keys?

Jul 11, 2013

why Access requires primary keys to be automatically generated so that there are no redundancies.We have a specific agreement with another organization that involves different billing system in which they send us purchase orders, each with a unique invoice number, that includes orders for one or more events.In my events table I have included a field to manually enter the PO number for this organization when it's needed.

I would like to have another table for the PO's with a one-to-many relationship with the events table (since each PO may cover multiple events). Is it possible to use this manually entered PO number field as a primary key to establish the relationship?

View 6 Replies View Related

Update Query For Manual Entry

Nov 21, 2014

Is there a way to have an update query update values in a table based on the user's input?For example, I have categories of tests and educational assignments indigenous to a course I manage."How many students failed the Science Exam?" The user would then put the manual calculation in since it varies from semester to semester.

View 6 Replies View Related

Manual Settings Of Allow Zero Length In Fields Of Table

Sep 25, 2013

I'm using Access 2010 and cannot find where I can set my fields in a table to allow for allowzerolength.

Is there still a location, under table properties etc, where this can be set?

View 3 Replies View Related

Ordering Help

Dec 8, 2005

i have a database with 3 main tabels: customers, items being sold and orders. i am having problems with having more than one item assigned to a order. can anyone help me please? i am new to access so if anyone can help can you explain in symple steps?
thanks
mooink

View 2 Replies View Related

Ordering Sheet Help Please!!!

Feb 22, 2006

hello i have created an ordering sheet for my company. i want to know if it is possible to automatically record the time of each order made?
If possible could someone tell me how it is done?

Also is it possible to put a clock in an Access database?

Thanks

Sean

View 2 Replies View Related

Ordering Sheet Help Please!!!

Feb 22, 2006

View 2 Replies View Related

Ordering Records

Nov 25, 2005

Is there a way of , when a database administrator enters a new rocord to a database, making the new record appear at th e top of the table it is enter ed into, i.e can he prefix the entry to tell access to put the record at the top of the table

View 1 Replies View Related

Ordering Dates

Jul 25, 2007

Hello

I have a question on date order please see attachment. I have changed the numerical value into a date abbreviation with an iif statement in design view via another crosstab query.

I am now trying find out a way to start the data with April and ending with March for my financial year. Any help would be appreciated.

Thanks

View 2 Replies View Related

Ordering Records

May 12, 2005

I have a database containing music library data, with fields <Composer> and <Title>. I have a form that shows a these fields as lists, but I want to add a button at the top of each list to order the data by that field. How do I do it?

View 4 Replies View Related

Ordering Form

Nov 4, 2006

I have actually 2 questions. They are probably very easy to solve, but I have no idea where to start looking.

1) I have a form (Form1) which has a combo box. When pressing "F2", I start a second form (Form2).

On Form2 I want my records order by Name, but I always have them ordered by ID. I tried the "Order By" property on the form, but that doesn't seem to work.

2) When closing the form, I want the selected (or the newly created record) to be the current record in the Combo box on Form1. How do I do that?

Thanks.

View 2 Replies View Related

Populating A Field Automatically OR Allowing Manual Entering Of Data

Sep 26, 2005

I have a simple table with two fields in that table called:

1. BankName
2. BankNumber

Each bank has a bank number. For example Bank XYZ and all of its branches have the same Bank Number 123. There are 5 banks I have listed in a combo list under the BankName field. I can also type in a different bank in that same field if it is not listed in the combobox list.

Now, I want the BankNumber to automatically populate based on what I choose under BankName. If the BankName is manually entered (for banks that are not in the combobox), or if the BankName field is blank, I want the BankNumber field to be able to enter a number manually.

For example, if I go to the BankName field and under the combobox I select Bank XYZ, i want the BankNumber field to automatically populate as 123. If the BankName has a bank name that was manually entered, i want BankNumber field to allow me to manually enter a number.

Thanks for ur help. I couldn't figure this simple request out.

View 5 Replies View Related

Manual Auto Numbering Subject To Change In Date Field

May 18, 2006

Greetings everubody,

I've a problem and hope to get answers for,

The situation is that I have a table named patient and a form named [patient1] where it holds a textboxs named "MFC_Seq_no" and another to hold [date], now, I manged to do a manual auto numbering for "MFC_Seq_no" using the following VB :

Private Sub Form_Current()

If Me.NewRecord Then
On Error Resume Next
Me!MFC_Seq_no.DefaultValue = Nz(DMax("[MFC_Seq_no]", "Patient"), 0) + 1
End If

Whenever user create new record, the system will automatically store the next number in the new record.

Now, I've be requested to code that system to start again from 1 as value for "MFC_Seq_no" whenever there are changes in date field (i.e. next day in the date field)

Is this doable and how?

Q2. how to duplicate an entire record with a subform, from another table, in it?

Thanks,

View 2 Replies View Related

Reports :: Graph Y-axis Scaling Manual Scale In Report

Sep 8, 2014

I have set up a form on which there is a graph which draws data from a query. I have set up a text boxes to take in the Y axis min, max and interval values so the user can customize the graph according tot he range coming out of the query. This all works fine and is perfect, however, i also need a report and set up a report with the same graph which can be printed to pdf, however, i cant get the y-axis to adjust like i do with the one on the form,

View 11 Replies View Related

Modules & VBA :: Current Record Does Not Show On Report - Manual Refresh?

Aug 31, 2014

I have a form that when a user fills out the information and select a submit button. It brings up that record in reports in print preview for them to print. The issue i am having when the user enter the information, the report does not show any data until i refresh it. I tried include me.refresh,etc. No luck. I attached the code to make things simpler.

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.Dirty Then
If MsgBox("Do you want to Submit this Contract Form? Clicking No will DELETE ALL ENTERIES,and Log You Off", vbYesNo, "CONTRACT FORM") = vbNo Then
Me.Undo
Cancel = True
Else
If MsgBox("PRINT FORM", vbOKOnly, "CONTRACT PRINT") = vbOK Then
DoCmd.OpenReport "rpt_Contracts_Main", acViewReport, , "[CONTRACT_ID]=" & Me!CONTRACT_ID
End If
End If
End If
End Sub

The reports comes up, but i have to manually refresh it to show the data that was enter.

View 7 Replies View Related

Report Grouping And Ordering

Jan 5, 2006

Hi everyone,

I have a field in a table on Access 2000 database with takes the following information in any order and can be repeated. e.g. can have 10, etc people with contact signed, 10, etc people with PDD issued, etc.

contract signed
PIN issued
PDD issued
validation finished
Host country approval
EB approved
CER's issued.

I am designing a report in which I want to Group and order the info. in the field in the order shown above, e.g 1. contract signed, then 2. PIN issued followed by PDD issued, etc in Ascending order say and the other way round say CER's issued, EB approved, etc.

Can anyone help here? I have not much experience with designing reports but I have tried using the report Sorting and Grouping and it does it in aphabetical order, not in that order I require.

Thank you

dfuas

View 10 Replies View Related

Ordering In A Report Column

Jan 23, 2007

I have used the following Query statement to produce a variable that appears in a Report column:

ValueInReportColumn: IIf([Number1]=0,"NA",Val(Format([AnotherQueryName].
[Number2],"Fixed")))

Although the The Val function reconverts the text, produced by the Format function, back into a number the IIf function seems to convert back to text again. This means that in the Report, when I order the values in descending order I get:

NA 50 50 50 40 28.57 14.29 100 10 0 ...

Is there anyway round this, to order the numbers and leave the text value NA at either end?! Hope this makes sense! Any help very welcome. mcchu

View 2 Replies View Related

Ordering By Date In A Form

Dec 10, 2014

I have created a form with many companies. each companies have 4 events in one year,but the first event in the form is the last one. How can order this events in this form chronologically?

View 5 Replies View Related

Ordering A DISTINCT Query Of Dates?

Jul 20, 2005

Is this possible, if using the following:

SELECT DISTINCT (Format([Month],"mmm yyyy")) FROM Table;

Adding a ORDER BY [Month]; gives a "distinct and order by" conflict...

Is there any way to alleviate this?

I want to display a "mmm yyyy" formatted combobox in order (i.e. Jan 2005, Feb 2005, Mar 2005, etc...)

TIA!

View 7 Replies View Related

Ordering/Sorting Data In Form

Feb 24, 2005

Hi all,
I have a simple 2-table database. the 'parent' table is tblProducts, and the 'child' table is tblDocuments. (one [products] to many [docouments] relationship)

My data entry is done using a 'documents' subform inside a 'products' parent form. The data entry works fine, except i would really like it if my products and documents would be listed in alphabetical order in their respective form/subform {makes it easier on the user, and saves me needing a find record button}. At the moment they seem to be ordered by the time in which they were added to the table. I guess Access is using the primary Key as the 'order by' parameter.

The thing that is infuriating me is that i have gone into my two tables and told access to sort the data by Product Name, and Document name in the respective tables. I can verify that this has worked by going to data view; lo and behold the data are listed in the order i specified.

Further I have gone into my form and sub form properties, into the Data...Order By property and have keyed in the name of the field i want to sort by (product name in the parent form, and document name in the sub form).

I have tried all combinations and permutations of the above processes but nothing seems to work.

It seems i am missing one crucial piece to the puzzle, as i haven't had much luck finding a solution on groups.google or anything else (maybe im using the wrong search terms). I am having this problem with all of my databases, so any help would be appreciated.

Thanks in advance.

View 2 Replies View Related

Ordering A Drop Down List In A Page

Aug 22, 2004

hey,

i have a page, with several drop down boxes, each containing quite a few options, but they dont show in alphabetical order so its a pain trying to find the one i want. how can i order them by alphabetical order,?

thanks

Baz

View 1 Replies View Related

Forms :: Ordering 10 Line Items At A Time

May 22, 2014

How to generate prescription order form, so that I can order 10 line items at a time. I have the following tables,

Suppliers
---------
SupplierID
SupplierName
SupplierContact
SupplierAccount No
SupplierPhone No

Order Form Header
-----------------
SupplierID
SupplierName
SupplierContact
SupplierAccount No
SupplierPhone No
Date

Order Items
-----------
OrderID
ItemID
Item Name
Item Description
Item Size
Item Code
Item Qty

Items
-----
ItemID
Item Name
Item Description
Item Size
Item Code
Item Qty

View 2 Replies View Related