Order Entry Database Problem With Pop-Up Subform
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 Complete Forum Thread with Replies
Related Forum Messages:
Required Fields And Subform Entry Order
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 Replies !
Order Entry Template
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 Replies !
Order Entry / Stock Control Template Db
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 Replies !
Simple Sales Order Entry Application
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 !
Limit For To Single Entry? Tabbing Order Question...
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 Replies !
Subform Blues - Data Entry Setting Itself To 'No' & Requerying 1 Subform From Another
2 Subform problems I have a data entry subform that is only supposed to show an empty record ready to be populated, and a display records subform that is supposed to show all the records. The subforms are both on the same tab of a tab control on my main form. Problem 1: The data entry subform shows all the records rather than a blank record. Something on my main form is causing it to show the records when it should not. Any ideas? The Data Entry is set to Yes. To try to isolate the problem, I created a new form and added the subform to it where it behaves properly:confused: I then added Me.DataEntry = True to the form open to see if that would solve my problem but it still sets the data entry to no. If I have the properties box open when in form view of my main form, I can set the data entry to Yes and it works fine until I move to the next record of the main form when it resets to no. Teraing my hair out here.:mad: My final attempt was to search the entire project to see if there is a "DataEntry = False" somewhere but there isn't. What is setting this property? Any ideas where I should look? Problem 2: After entering data in the first subform (data entry form), I want to re-query the second subform but I just can't get the syntax right. I have wrestled with the "Syntax for subs" document downloaded from http://www.mvps.org/access/forms/frm0031.htm (Microsoft MVP site) but to no avail. My main form is called fdlgPrjDetails, the data entry is via fsubPrjCommentsUsersDataEntry and the subform I wish to requery is fsubPrjCommentsUsers. None of the attempts below worked giving a cannot find control error. Private Sub Form_AfterUpdate() On Error GoTo ErrHandler Me.Requery 'Me!fsubPrjCommentsUsers.Requery 'Me!fsubPrjCommentsUsers.Form.RecordSource.Requery 'DoCmd.Requery ([fsubPrjCommentsUsers]) 'DoCmd.Requery [fsubPrjCommentsUsers] ExitHere: Exit Sub ErrHandler: MsgBox Err.Number & " - " & Err.Description & Chr(13) _ & Chr(13) & "Error in fsubPrjCommentsUsersDataEntry: Err 003" Resume ExitHere End Sub Any Ideas? Both problems have me stumped so I'll be grateful to anybody with a scoobie on this.:)
View Replies !
Order By In Subform
hi, I have a subform to track details. In the "order by" property I do put the field (which is a date field -short) as the field to sort on ascending, but it doesn't work. The subform is based on a table - so If I want to be able to add new items as well as display them, what's the best way to do this? thanks!
View Replies !
SubForm In Middle Of Tab Order
Is it possible to set the Tab Order to move to a subform before all the controls in the Main form have been passed through, and then come back to the Main form where one left off? I have a form with a client name and a chargable service, a subform with products and, on the main form again, amount tendered. Logic dictates that one select all items for which one is paying before showing how much is paid. Right now, I go through the client info, then chargable service, amount tendered, and then anything purchased on the subform. That's kinda bass ackwards. I'd somehow like to insert the subform's controls into the Tab Order, after chargable service and before amount tendered. Anyone know if I can do that, if so, how?
View Replies !
Order Of Records In Subform
I have a form with a subform. I want the records on the subform to be in alphabetical order of first name. At the moment, they appear in the order the records were entered. I have opened up the subform itself in design view and specified the record order. If I then switch to form view for this, the records correctly display in alphabetical order. However, when this form is displayed as the subform, the ordering reverts to the original order of record entry. How can I change this? Thanks, Gary
View Replies !
Field/tab Order On A Form With A Subform
Hi all, i have a form with a subform, the main form has a field named: "shiftname" and i would like it so that when the form is opened the cursor is on that field but instead the cursor is on the first field of my subform. Ive tried changing the tab order on the main form (selecting form header, then shiftname) but this doesnt seem to work :( is there a bit of code i can use to force the form to open with the cursor in the "shiftname" field instead?
View Replies !
Continuous Subform Display Order
I have buttons that enable and disable editing/adding information on a continuous form. When you click add the form then is set to allowadditions and shows you the * record. Is it possible to have that display at the top of the list instead of the bottom? If not, what would be the best method to move the focus to the new record when someone clicks add?
View Replies !
Subform Records Order Help Needed..
Hi, I just made a form for order entry which has a subform with order details where each line is a product number with quantity, extended price, etc... The problem is that when I add a product in the subform, I add it in the new record which is at the bottom of the form. I can add many product like that it works no problem , just adding them to the bottom of the list. But, when I close the main form and reopen it, the records are now liste is the opposite direction, meaning that the last product i added is now the first row of the subform...So the subform is now populated backwards with the latest record being the first one... What can I do for the subform to always list the products in the same order I originally input them?.... Thanks, Hugues
View Replies !
Subform Data Entry
Hello all, I'm looking for a little help on something that I'm sure is an easy problem. I'm building a form for patients (data from Table: Patients) that contains a subform containing lab values (Table: Lab Values). I'm new at using subforms so I'm in a little over my head. Both Tables contain the patients name to link them together. When I create the subform, I don't want it to display the patient name, because it is already displayed in the header. But if I don't include that field, I can't link the two tables together. I'm using one of Microsoft's templates off their website (called Contact Manager Database) as a guide, and it has exactly what I want - a sub form that only displays the relevant data for each patient, but when you add a record the data in the table automatically includes the name of the person. I just can't seem to figure out how to do this. I'm sure I've been very unclear describing this, and I'm sure this is an easy task, but if someone can give me a little direction I would greatly appreciate it. Cavy
View Replies !
Open Subform At New Entry
I have a form with a combobox to select a clients name and that pulls up that client in a subform and shows various records for the client. But it always opens up showing the first record and I want it to open up showing a blank record for keying in more data i.e. after the last record. Can you help at all on this? many thanks
View Replies !
Subform Records Change Sort Order
I have a subform embedded in a mainform which contains loan payment details over a number of months. The record starts with the payment period number ie 1,2,3 etc. The problem is that every now and again the subform changes the display order of the records so that I get 4,5,6,1,2,3. When I look at the underlying table the order is OK as is the non embedded sub form. I cannot see any reason for the change and it only happens randomly (apparently). The numbers are not autonumbering but manually input. Hope someone can help please.
View Replies !
Changing The Order Records Are Displayed In A Subform
Hi everyone. I need help on this one I have a form with a subform. The subform is basically the sale history of the item on the main form (The main form shows a record and then the subform reports its history). This all works fantastic, except that on the subform, every time a new record is entered, it goes to the bottom of the previous one, so after a while, if I want to enter more history into the subform, I have to scroll down through all the older ones to get to the more recent ones. How can I do it so that in the subform the most recent entry is always at the top and each time a new record is entered, the older ones move down one. This way the most recent records are always on display and older ones move down as they become less important. Likewise, the empty record used to enter data is also at the top! Thanks!!
View Replies !
RFT Problem And Subform Data Entry
1st: I have used the Lesban Rich Textbox Control. However, I face a problem with the control and cannot solve. The thing is that whenever I select an item from a combo box which loads a no record it refers to, it always ignore my first letter input. The second one will go just fine (e.g. when I enter ABC...., the control will ignore the A letter) Hope you get what i mean. I dunno if I made mistakes somewhere with the control. Does anyone have any idea that such thing should be done? 2nd: In the same form as above one, I also designed 2 other subforms, however, it always raises error when I enter data while the main form contains nothing. I want to disable those 2 subforms when the main form record isn't filled out. I found a similar result in the forum, but it doesnot work with Rich Textbox Control's update event.
View Replies !
Preventing Multiple Entry In Subform
Hi I have a form and sub form, the sub form is populated from a query and has a column of checkboxes. Basically these checkboxes get checked as part of the form, but only a maximum of five are allowed to be checked. Is there a way of achieving this? Cheers Dan
View Replies !
How To Require Entry In A Field On A Subform?
I haven't been able to figure out the code to require entry (for a new record) in a field on a subform - anyone can help with this? The situation is a contacts database, and each new contact should have a (or multiple) Person Roles entered as well, which is their relationship to the organization.
View Replies !
Subform Data Disappearing On Entry
Hi all, I apologize if I'm missing something terribly simple. Here's the background: I have a set of 3 tables linked to a main table based on a field called SampleID. I then have one main form (SAMPLE) with the other 3 tables (INDIVIDUAL, LOCATION & ORGANISM) all as subforms within the main form. everything seems to work well in terms of links and getting the data into the appropriate tables and retaining the SampleID link. However, during data entry using the tab key, I am unable to find an eloquent way to move from the main form to subform1, then from subform1 to subform2, from subform2 back to main etc. I have set the tab order, and used the afterupdate control to change the focus which works, however as soon as I move from subform1 to subform2, the data just entered disappears from subform1. The data makes it to the table without any problem, but just blanks out the form. From what I can see, when the subform loses focus it automatically saves the edited record and inserts a new record, thereby blanking out the fields that were just entered. Is there a property that can be set so that a new record is not automatically entered when leaving a subform? Is there a method to do this through coding? any help would be greatly appreciated!! Thanks in advance.....
View Replies !
Populate Form Field From Subform Entry
I have looked at multiple samples on this forum and others and cannot seem to get the result I want working. Have main form TmLdr made from table of same name. Entries include ReqName and CostCenter. These same entries are on a subform. On the After Update event on the CoRecDt (main form), I want the name and CostCenter entered on the subform to populate on mainform. This subform will be filled out by the user once and as long as they are using their own machine there will be no need to re-enter their name. I think that I am so close but just a touch away. I am attaching my DB with hopes someone can take a peak at it and let me know what I am missing. Thanks so much.
View Replies !
Subform Data Entry Problem Blank Line
I have a main form where the user chooses a BoxID. There is a subform on this main form that has a relationship between BoxID on the main form and subform. The users are entering data in the subform and when they have entered 10 lines of info I have a message that tells them to start a new box (I could not work out how to do it any other way as I lack VB skills). The user closes the form or clicks add new record to create a new box. If I view the previous record there should only be 10 lines of information in the subform but there are 11 as it takes the blank line as a new record....
View Replies !
Help With A Word Order Database
I am a modular housing sales consultant and I am trying to setup a work order database in access. This database would allow me to spec out a modular home for a prospective customer/client as they provide me with all of their home options (floors, exterior, doors & windows, interior, appliances, bathrooms, kitchen, etc.) and then print out an invoice with an estimated total. I am currently using an excel spreadsheet and it is very cumbersome to use. I use it as an invoice and the invoice contains the following information on it. Bill to: Dealer Name Dealer Rep Phone, Fax, Cell Ship to: Customer Name Customer Address Phone, Fax, Cell Home Options: Floors: Joist: (Structure Wood 2X8 Joist, Structure Wood 2X10 Joist, Plywood 2X10 Joist) Carpet: (Cappuchinno, Biscuit, Pebble, Summer Straw, Praline, Herringbone, Cashew, Buckskin, Shale, Botanical, Cordovan, Stone, Cascade, Black Ice) Vinyl Flooring: (Woodgrain #05296, Square Tile #57296, Mosaic #55296, Tan Stone #08296, Large Square Tile #07296) Interior: Interior Doors: (install, ship loose, 6 panel, flat) Hardware: (Brass, Brushed Nickle, Round Knob, Level Handle) Crown Molding: (4", 5") Base Molding: (4", 5") Appliances: Color: (White, Black, Bisque, Stainless) Dishwasher: (Standard, Power Scrub) Microwave: (Over Range, Free Standing) There are other options but this is just a brief listing of options as an example. Each option would have a price attached, and selected price would be added to the invoice, and once work order is completed, the invoice would have options totalled. Ready for the customer and dealer to confirm and approve. Can someone start me in the right direction on getting the tables setup for this - the one that I seem to be having the most difficulty with is how to setup the options for this invoice. I pretty well have a grasp on the others. I might also need help in relating the tables to one another. I hope this all makes sense. Any help would be greatly appreciated. Donm
View Replies !
Order Manager Database
Hi, I wonder if anyone could help. I'm in the planning stages of creating a order manager in access for multiple ecommerce sites. Database will store data on Customers, Inventory, Invoices, Returns, Shipments, Credits, Quotes etc for all sites, and also custom reports. And the idea is to have the database generate the ecommerce sites automatically as static html, which can be uploaded. As the orders come in they will be stored online, and then periodically downloaded into the database. The reason is we currently have 3 sites running and managing inventory and stock control is the hardest, as currently there are 3 databases controling stock! Also when a customer telephones its difficult to know which site they have ordered from which is unprofessional, and we have to log into every site just to find their order. Future ideas:- Meaning we are going to setup more sites which will obivously make the situation worse. We also want to branch out in into eBay using the eBay API to download transactions and sales, and will therefore need a place to store the data. Can anyone foresee any problems with such a system? Any ideas or examples? Thanks for your time.
View Replies !
Help With Clothing Order Management Database
Hi, I am trying to design and build an orders management database for a clothing wholesaler. Has anyone got any ideas on what entities i should have. I thought: Clients (Customer Details) Orders (Inc. order date, ship via etc) Order Details (sizes, quantity of orders per size) Product Details (Product Code, colour, size, stock numbers per size) Catergories (Shorts, Jackets, Jeans etc) Suppliers (Supplier Information) Delivery (Delivery Method etc) However, loads of problems when i come to planning the sizes part. I have different product catergories with different sizes And when i do the order details table, i need to enter order quantities for each different size for one clothing unit. Any ideas? I would also ideally want to link the order details and products tables by the product code number. I.e. When filling out an order In the order details table i want to type in the product code then have information from the product table automatcially fill in the gaps in the order details table, such as unit price, colour etc. Hope you understand and can help me!!! Thanks for your time J
View Replies !
Calculate Payroll In Order Database
I have an order database Access 2000 for an inspection company, tblInspectors, tblOrders, tblCustomers, I want to be able to calculate inspector pay within order database. Each inspector is an independent contractor, so it just needs to calculate percentage, for each inspection performed and total for pay period. Each inspector is paid a different percentage, which is stored in tblInspectors. Payroll is paid every two weeks . . . I've been trying to figure out the best way to do this ... :confused: Any advise be greatly appreciated.:confused:
View Replies !
Database Entry Problem
Have created database with Access 2003 , every time I create a new person (new record), the database creates 2 new blank members (blank records), can anybody help. :confused: Can upload the database (7MB) if anybody prepared to help debug the problem. Thanks in advance :) Matt
View Replies !
Database Design And Data Entry Help..
Greetings.. I am attempting to teach myself Access but I am having trouble trying to figure out how to implement into my database the features I need my enduser to have. Basically I am trying to create a Contacts database and I want the "form" that my end user enters data into to look like this (all examples are minimalist because I am looking for specific logical answers to solving my problems, not field suggestions): Name: [textbox] Phone: [textbox] Email: [textbox] Now I need to have Phone and Email each in their own tables, or in some way seperated so that I can retrieve a list of emails or phones without duplicates. My initial attempt was to create the tables: *key NAMEtable *Name Phone (related to PHONEtable.Phone) Email (related to EMAILtable.Email) PHONEtable *Phone EMAILtable *Email Now the problem with that setup is that I cannot create a new entry into NAMEtable unless the specific Phone AND/OR Email are ALREADY listed inside their respective tables. What I need to be able to do is give my user the ability to use a "form" with 3 fields, that will do the following: Allow a new Name without a Phone or Email. Allow a new Name WITH a Phone and/or an Email. Allow a 2 different Names to have the same Email, but pointing to only 1 instance of that email in a different table. (which it already does all if the Email and Phone already exist in their tables, I need it to be able to create new entrys into those tables from the form if they don't already exist). I also need to be able to enter in new Emails from a different form2 that dont have any relation to any persons in Name (which isn't a problem either at the moment since I just open the Email table and enter data). I am unsure how to execute this first forms dilema though, I am assuming my database design is fine and it has something to do with some formality or code that I am missing to be able to do what I want. If so could someone help me out and make some suggestions? Or if my design is way off and there is a better way to be able to enter and store a Name, Email, and Phone from a form that relates back to a single contact and prevents duplicates then please let me know. Thanks Also here is another post I made in a different forum but wasn't able to get quite the answers or help I was looking for. "Name [textbox] Email [textbox] if the email the user is entering isnt already in the database it will not create a new row in email.email and then link contacts.email to that specific email.email........... for example if contacts NAME , EMAIL row1 = bob , email.email row1 row2 = bobswife, email.email row1 email Email row1 = bob@bob.com then I open a form that will have 2 members, both pointing to the same email. 1 of 2 Name: [bob] Email: [bob@bob.com] 2 of 2 Name: [bobswife] Email: [bob@bob.com] Ok, lets say I go to create a new member I can do this just fine: Try1 3 of 3 Name: [bobsson] Email: [bob@bob.com] What I can't do but need to be able to do is: Try2 3 of 3 Name: [bobsson] Email: [bobson@bob.com] It will return an error stating that the email isnt in the email table. I need to know how to get Try2 to do what I want so that when I enter 3 of 3 my database looks like this: contacts NAME , EMAIL row1 = bob , email.email row1 row2 = bobswife, email.email row1 row3 = bobsson , email.email row2 email Email row1 = bob@bob.com row2 = bobsson@bob.com" Anyways.. thanks again for any help.
View Replies !
|
TRACKER
