Simple Sales Order Entry Application

Jun 3, 2006

Hi, I am using a wet and cold holiday weekend to learn about Access. I want to create a simple sales order entry function.

I have set up 2 tables Orders and Order Details. The Orders table holds order number, customer, due date, etc and the Order Details table is to hold the line items (product, quantity, price, etc). So far, so good.

I have created 2 forms and made the Order Details form a subform of the Order Header form. So far, so good.

I have 2 questions arising from this.
1. How do I get the cursor to tab from the last field of the header form to the first field of the details subform? When I get to the last field of the header form it just goes to create another order.

2. Is it possible, and if so where do I get info on how, to enter (and show) many detail lines for the one header. This is a normal sales order situation, customer stuff followed by 5 or 6 lines of products on the order.

I have two old (Windows 95) MS Access tutorial manuals, beginners and advanced but can't find the answwers there. I am using MS Access 2000.

Any help or pointers to where I can get the help would be appreciated.

BD:confused:

View Replies


ADVERTISEMENT

Sales Order Line Pricebreaks

Jul 11, 2007

I'm not sure if I have a table structure, query or Form/subform problem, so I'll post here and see what happens

Objective - From a Sales Order form (and linked Sales order Lines subform) once the Item to be sold has been selected and quantity entered, I wish to check against a Pricebook table, where each item has 3 price/quantity breaks stored and have the correct price drop into the sales order line

Any suggestions on what is the best technique to achieve this?

ps not too bad using standard query builders etc, but pretty hopeless at code (which is one of the reasons for joining, to improve in this area)

So far found this a great place to be, lots of good advice from lots of helpful people

Thanks

View 9 Replies View Related

First 10 Months Of Sales, Seems Simple, But Proven To Be A Horrorcase.

Jan 8, 2008

I have a table with historic sales values, so an Item has 36 months starting (Field names are ranging from "Oct 04", "Nov 04", "Dec 04" ... to "Sep 07")
I also have a column name First month of Sale. which is filled with for example "Dec 04", for the next Item is might be "Jun 05" or "Aug 06").

I would like to get a Query where I just show sales values of the first 10 months after that first month of sale.

I have tried, and tried, and tried till my head exploded:mad:
It seems a simple task, but I am obviously overlooking something.
can anyone help me with some hints?

View 5 Replies View Related

Modules & VBA :: Data Entry Application

Oct 1, 2013

I am making a database, where 10 to 20 users will be entering data. I have queries

1. I am planning to create a form with which user will be directly entering in the table, will that b right?
2. If 2 or more users will open form its own side does they all will be entering in same row number?
3. What will be the best of these, by insert query or directly to form?

View 1 Replies View Related

Access Application With Handwritten Data Entry

Feb 16, 2012

I am using MS Access 2007. Can an Access application be designed so that data entry can be handwritten, not typed nor dictated?

Is there third party software to interface with the manuscript recognition and convert and insert this handwritten data into the appropriate forms in a conventional "font" display? Or, is Access able to do this without additional software/hardware?

View 3 Replies View Related

How Can I Create A Sales Form That Can Update Both The Product And Sales Tables

Oct 11, 2007

Am creating a Product-Sales Database, and I would like the corresponding Sales made in the Sale Table to be automatically deducted or to be reflected in the Product Table. The product table contains all my stock and has a relationship with the Sales Table. The Sale Table does not necessarily include the Stock. How can I create possibly a Sales Form that will be used as an entry point for all the products (stock) sold and automatically register the sold products in the Sales Table and at the same time make the required adjustments in the Products Table.

View 1 Replies View Related

Simple Event Order Problem

Aug 23, 2005

I have a form with a test list. Each test is a record with a yes/no checkbox, and controls for testdate and examiner. I don't want the user to be able to exit a record if the yes box is checked and either the testdate or examiner fields are blank. The code I am using is:

If IsNull(Me.Examiner) And Me.SelectTest = Yes Or IsNull(Me.TestDate) And Me.SelectTest = Yes Then
MsgBox "You must enter an examiner and a test date for each test you select.", vbCritical + vbOKOnly + vbDefaultButton1, "Missing Data"
Me.Examiner.SetFocus
Cancel = True
Else
Cancel = False
End If

I am having trouble with which event should be used with the code, however. In both before and after update I have had the following problem. If a user accidentally checks the wrong test and then unchecks it, they still get the message as if the box were still checked yes. Can anyone tell me why and how to avoid that?

Thanks in advance,
Carly

View 7 Replies View Related

Order Entry Template

Mar 24, 2008

How do I find the order entry template that came with the 2003 version?

I have the new vista and it is not there. I cannot find it anywhere.

David

View 2 Replies View Related

Simple Order By Stmt Need Expert Answer

Mar 14, 2005

I have a very simple SQL stmt

Select * from MyTbl order by MyID

The error: "Syntax error in ORDER BY clause"

If I remove the order by clause, it works. Now, I have been programming for 30 years and for the life of me, I cannot figure this one out. It is my first use of 'order by' on this ISP so I am assuming there is a server thing? Can anyone suggest to me what this might be? Thank you very much.

-Extremely Frustrated (Ken)

View 10 Replies View Related

Order Entry / Stock Control Template Db

Jan 5, 2006

I have to provide a Quote/Order/Invoice and stock control system very quickly for one of our satellite offices, and wondered if anyone knew of any "boilerplate" databases that have done all the grunt work, so that I can just edit reports and forms etc to get them up and running. We are happy to pay a (modest) fee for this service, but would expect to get full access to the design/code for later development and customisation if required.

I've tried Googling but get page after page of rubbish !! Any pointers would be gratefully recieved.

Thanks and Regards

Richard Keith

View 3 Replies View Related

Required Fields And Subform Entry Order

Jun 23, 2005

Hi,

I have created a form with 3 subforms. This form is split in to 3 parts on a 3-page tab control.

I want the user to enter data in the order below. All fields are required. My problem is that Access97 wants all fields of the main form to be completed in the order set by the table. ie. before I fill in a sub form. I have tried setting the form tab order property but it is being overridden.

First page:
a) Complete first 6 fields of main form
b) Complete subform 1
c) Complete subform 2
Second page:
d) Complete 5th field of main form
e) Complete subform 3
f) Complete 6th field of main form
Third page
g) Complete three fields of main form

Any help appreciated,
Seth

View 1 Replies View Related

Order Entry Database Problem With Pop-Up Subform

Sep 6, 2005

I have taken the Order Entry database sample from Microsoft and have added a "Wizard" type interface.

Question) I'm having trouble understanding how to get more than one Feature applied to a single new service.

- For example, If I add a new SERVICE to an ORDER, and I need to add all available FEATURES to that SERVICE, how do I do that? *see my attached database & relationships. The form of FEATURES is also attached. I just want to be able to check off the ones that apply.
(is this many to many? I tried a junction table but can't make it work)

I would really appreciate some advice on my Forms, and definitely advice on my Table / Relationship structure.

ps: My tblServices use to be called tblProducts. I then added the tblCategories, tblPaid, tblTeleServ, tblLongDistRate, tbl800Serv & tblFeatures.

Thanks in advance for your help,
jlig

View 1 Replies View Related

Access 97 Can Not Display Records By Entry Order

Nov 29, 2004


Access 97 does not display records in their original order of entry in a report or its query whether they are indexed or not. Results
are always in ascending or descending order even when sorting and groupings are not set. Any suggestions?

View 2 Replies View Related

Error With Simple Date Entry!?!?

Jul 5, 2006

I got this to work easily on another form but on this particular form it doesnt work. I enter a command button and name it d1, then I enter this code for it to populate the current date in the field next to the box:

Private Sub d1_Click()
Date_Entered.Value = Date
End Sub

Can anyone see why it doesnt work :eek:

ERROR IS:
Run-time error '2465':

Database cant find the field 'Date' referred to in your expression.

When I enter a date field it enders whats in that field (blank) into the field I told it (Date_Entered) on my form.

View 3 Replies View Related

Limit For To Single Entry? Tabbing Order Question...

Aug 25, 2004

Newbie Access user here, with what I hope is a fairly easy task--
I have a form which contains fields for info about clients and a subform which has only one field for a corresponding video tape number. Is there any way to limit the record for this subform to one single entry, so that when I hit Tab after entering the single number, the second record in the subform will not appear, but rather I can jump to the next record in the main form?
If not, then can I just tab through the main form, into the sub form and then onto the next record? Is there a shortcut to create the next record other than having to manually mouse click the next record arrow at the bottom of the form?

View 1 Replies View Related

Forms :: Create A Data Entry Form To Order Table Using 2 Cascading Combo Boxes

Jan 31, 2014

What I am trying to do is create a data entry form to an "order table" using 2 cascading combo boxes. I have created a data entry form based on a query. I can't get the cascading combo boxes to work properly.Here is the code:

Private Sub Combo0_AfterUpdate()
Combo2.RowSource = "SELECT L2_ID,L4_Element_name,L5_Category FROM qry_ord WHERE L3_ID = Combo0.Value;"
Combo2.DefaultValue = [Combo2].[ItemData](0)
Command4.SetFocus
End Sub

[code]....

View 2 Replies View Related

Opening Access Application Like Desk Application Done With Java Or Vb

Jan 5, 2014

it is possible to Open access application like desk application done with java or vb, or install access application as exe or similar methods. My requirements is to giving a access application to customer with data base for printing an invoice. when he running the aplication he can see access open and tables, queries forms left hand. how to hide these thing ?

View 4 Replies View Related

Is It Possible To Integrate MS Access Application To A Web Application??!!

Jun 11, 2007

We have an extensive reporting application in Access and would like it to be available through a web application. I've went down the road of migrating this application to SQL to use SQL Reporting Services; this is a good tool but I am wondering if MS Access has an easier solution for me other than migration to SQL.

I'm looking for a solution that will make these reports available over the web for many users. Price tag is a consideration...need to know if there is any.

Please help...thanks in advance for any thoughts!!!!

View 2 Replies View Related

Queries :: How To Trigger By Date To Create A New Entry In Database Based On Old Entry

Aug 6, 2014

I have a database that makes use of standing orders. That means that if a client has a standing order to receive products during for example 4 time as year (quartely at the end of the month). to automate the new entry by copying an old entry in the database.

Let's say I have a client where we will have to send a product at the end of June, it will look at a field where the next send date is, and when it reaches 2 weeks for that date, to create a new entry in the database based on that entry. This way, it will pop-up in our open cases and we are aware of it and also will be visible in our report.

View 1 Replies View Related

Forms :: Combo Box To Verify With Last Entry And Display Other Options Than Last Entry

Sep 8, 2013

I am working on creating an access database for tracking physical assets linked to locations. I need to make a combo box list to show items other than the current location of the asset. Basically I need it to refer to last enery of the user and define the new possible entries. so we have a unique relationship between location and asset. The assets and location will always remain fixed and there is never going to be any addition. I am creating a web form so that it can be uploaded into sharepoint.

View 3 Replies View Related

Cash Sales Vs Invoices

Mar 25, 2007

I'm creating a database where I have a customers and invoices table, obviously there is a relationship between the two tables using a customerID field where I have referential integrity enabled. However not all invoices require a customer account as some are cash sales where no customer details are required.

I'm unsure of the correct procedure, all I can think of is to create a separate table for cash sales??

View 3 Replies View Related

Querry About Sales Commisions

Oct 1, 2005

Hi There
I Need A Querry For Commission Sales.
I Have 10 Items 7 Items At 2% Of Commission 3 At 4%. Each Salesman Have To reach A Min Of 5000 USD Of Sales Per Month Then All Sales Above That Amount Commission Will Be Calculated.
I Need A Querry To Calculate Sales And If Salesman reached The Min Sales Commission Is Calculated .

Any Help ???????
Thanks

View 1 Replies View Related

Calculating MTD And YTD Sales For Report

Dec 1, 2005

I have been stuck on this one for a while. I have an Access 2003 Database that I need to calculate the MTD sales and the YTD sales of parts ordered

Here are the relevant tables and thier attributes
Part -
PartNum
Description
UnitPrice
OnHand
ReorderPoint

Orders -
OrderNum
OrderDate
CustomerNum
CustomerPONum

OrderDetail -
PartNum
NumOrdered (Quantity)
QuotedPrice
NumShipped

If I have left anything off that may be vital please ask and I will supply the info. I need this info ASAP though.
I think the answer has something to do with the Date() and CurrentDate() but I have no clue. Please let me first know the queries I need to run and that should be it. I just need to put MTD and YTD Sales in a report.

I REALIZED THIS SHOULD BE A QUERY THIS WILL BE POSTED IN QUERY INSTEAD

View 10 Replies View Related

Query Sales Anlaysis

Jan 16, 2006

Good afternoon

I have two tables - sales 2004 and 2005 - both showing account number, product, quantity, sales and margin. When I link account number and try to show both years the results are incorrect.....I know I am doing something wrong!! I have tried creating new table with blank fields for 2005 basing the table on 2004 and then updating 2005 - but no go.....

Help please

Many thanks

Catherine

View 4 Replies View Related

Sales Transaction Query

Mar 17, 2006

hi there...

I have been looking around the forums for a little while now... and cannot seem to find anything which will help me.... heres my query..

I have a stock control database.. which allows for sales transactions via a barcode reader...

my first query is.... when the user scans a product.. how can this be 'looked up' in the (UPC data table)... returning the correct information.. ie.. description.. but then taking the price from the product table.. the query doesnt seem to let me be able to join the two tables.. no idea why!?

secondly.. I want to create a form.. for the 'sales transaction'.. when the user clicks 'pay' i want the form to clear and store all these items in the sales table.. (deducting the units in stock at the same time..)

I hope anyone has any suggestions.. or pointers! Many Thanks
:)

View 7 Replies View Related

Negative Sales Goals

Nov 30, 2006

Sounds weird huh?

I have a salesman that has a negative "Net Flow" goal (sales goal). Others have positive goals.

His YTD Net Flows (Sales) is say...$1062 (million) and his goal is "-266 million"
Of course he is doing quite well, when I use the following code to get a % to goal I get "0" whenever there is a negative goal involved.

% to Goal: IIf([NetFlowsGoal]>0,([Total Net Flows]/[NetFlowsGoal]),0)

But it works fine if all numbers are positive as you might guess.

Any pointers would be great...Thank you

View 4 Replies View Related







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