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.
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
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.
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.
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.
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?
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?
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
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
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!
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.
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.
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?
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?
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?....
I am a VBA beginner and am using Allen Browne's method for filtering a field in a subform: URL....It works well except that I cannot seem to figure out how to order the results when the subform field is filtered. I want to order the results by CompanyName.Here is the code I am using for changing the record source from the main form to the subform:
Code: Dim sSQL As String If Me.cboFilterFavorites = Null Or Me.cboFilterFavorites = "In Business" Or Me.cboFilterFavorites = "Out of Business" Or Me.cboFilterFavorites = "Unsure" Then If Me.RecordSource <> "qryCompanies" Then Me.RecordSource = "qryCompanies" End If
[code]...
I feel as if I have tried everything. I even changed the subform record source from a table to a query (qryCompanyTypes) so that I could add the CompanyName field and sort but to no avail. I have tried adding the CompanyName field to the SQL string but keep getting errors. I have tried simply using Order By in the SQL and still get errors.
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.
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!
Initially I created a table with 11 rows. After completion of my project I added an extra of 480 rows to the main table. But the newly added rows are not coming in my subform.
Attached is my project.
Main : Main table (It consists of around 491 rows) MForm : Main Form (It shows of only 11 records which I was 1st created)
How to refresh my subform inorder to display all the rows.
I have a subform in which I display a table in Datasheet View. The problem is, I cannot figure out how to place the columns in the order (i.e. from left to right) I want.
For some reason, right-clicking on a column header in Form View and selecting Freeze Fields will shift that column to the left but I can find no consistent pattern to it and no other way of shifting a column. Reordering the columns in the table itself seems to have no effect on the order they appear on the subform and moving the controls around in the subform in Design View also seems to have no effect.
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)
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.
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?
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.
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.
