Combo Boxes And Queries Again - Two On A Form
I have re-written this question as I think I managed to cause confusion!
(I really do need help!) My problem involves three tables. The first table is NAMES with an auto-number key field called NamesID.
The second table is a list of Dance Classes, called CLASSES again with an auto-number key field called ClassesID.
The third table is a list of MEMBERS in each dance class.
Obviously, the MEMBERS can belong to many CLASSES, and each of the CLASSES can consist of many MEMBERS.
My aim is to add a new record in MEMBERS by using a ComboBox containing records from the NAMES table.
On the form, I have a combo-box which shows me the list of CLASSES
(ComboClasses). I click on the class.
I then click on the NAMES combo-box, click on a name and want it to appear in the table of MEMBERS for the class shown in the CLASSES combo-box.
The problem
I am selecting the name using “ Select * From NAMES where Names.NamesID=[Forms]![FormName]![ComboNames] (supplied by supersubra) but how do I get the ClassesID into MEMBERS record.
At the moment, if I add a name that member appears in every class, or I have to manually insert the ClassID.
Philip
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Forms, Combo Boxes And Queries
howdy all, ive never touched Access until 2 days ago so my experience is sorely lacking but here is my question: i want to create a form with a combo box from which a selection is made (data in the combo box is simply a field list from the same table the query is searching, but my stumbling block is that i want to include the query in the same form as the combo box and have it dynamically updates based on the selection in the combo box. however for the life of me i cant get the query to update based on the input (using [Forms]![Form]![Combo1] as the criteria in the query) i have set this criteria in the CustomerID field of the query (which is also the primary key of the table)
View Replies !
View Related
Problem With Criteria In Queries Using Combo Boxes
Let me see if I can explain this. I have two tables: TblValues and TblLOC. TblValues is a table of stactic values where I have listed about nine field names with values under each that usually will not change. This way if there is a change to one of the fields later, I can just add it to the table. Then there is tblLOC. Here I have similar field names that matches each field in tblValues where I can populate them in my form. I have several fields defined as combo boxes. In the properties for each field defined as a combo box, for row source type has Table/Query selected and for the row source I have the following code in the table, which is an example for the field named Profit Code in TblLOC. SELECT tblValues.ID, tblValues.Pro1Code FROM tblValues WHERE (((tblValues.Pro1Code) Is Not Null)); Then I have my form where I have referenced my fields from the tblLOC. In the properties of each combo box, under the tab labeled DATA, the control source has the name of the the combo box field that is in tblLOC, in this case Profit Code. Everything works fine. The user selects a value from the form and tblLOC is updated. I can create queries without criteria with no problem. However, in a query if I try to add any criteria, even as simple as using "like" to identify a value in a field of the table that has been populated by the combo box, I will get no results. However, if I use the same functionality in a column where a combo box is not used to populate the field, I get the results that I expect. Here is an example of the SQL in the query that does not work for me that is applied against a field that is a combo box. SELECT tblLettersOfCredit.[Profit Code] FROM tblLettersOfCredit WHERE (((tblLettersOfCredit.[Profit Code]) Like "Misc")); If I use the same functionality with a field that is not populated by one of the combo boxes then everything works fine. I am hoping that there's a simple solution for this, maybe syntax due to the use of a combo box or maybe a property that I need to set... So far I have been unsuccessful in finding the answer. If anyone has any ideas on this one, I would certainly appreciate it. Thanks :)
View Replies !
View Related
More Than Two Combo Boxes In A Form
Hello to everyone! I have a serious issue to solve and I would like to ask for your help, as I just don't seem to know how and where to start from. I need to make a database that will have 2 tables, say tbl_item and tbl_offer. The items table will have different cardboard dimensions and other characteristics (width, height, color, photo, price etc) while the tbl_offer will have different combinations of clients' cardboard requests. The workflow is: A client comes and asks for: - two pieces of cardboard of 120x100 cm - five pieces of cardboard of 135x90 cm - one piece of cardboard of 110x125 cm I want to be able to enter the client's request in a form and the form will do 2 things: 1. Store the clients request as a record in the table tbl_offer (for current or future referrence) 2. Create a report (out of the above record) that will be printed out and given to the client (but I suppose that's easy...) Now tbl_item has different types of cardboard (their code names) along with different dimensions and price for each, for example: Type|Width|Height|Price ---------------------------- 001 | 120 | 100 | 10 001 | 135 | 190 | 12 001 | 110 | 125 | 11 001 | 110 | 100 | 16 001 | 150 | 100 | 12 002 | 165 | 170 | 17 002 | 140 | 105 | 10 002 | 140 | 130 | 18 002 | 170 | 130 | 18 The problems are 1. I don't know exactly how I can create a form (say frm_offer) that will give me the possibility to add many different cardboard types and save them as one offer to the tbl_offer. What I would like is to choose from a combobox (or any other similar function) the type (say 002) and by this selection a second combobox would be filled only with the available Width dimensions for this type (165, 140, 170). By choosing what I want from the width combobox, a third combobox would be available that would give me the available height dimensions for this width (if for example I chose Type 002 and Width 140, the last combobox would give me two choices, 105 and 130). After choosing the Height I want, I would fill in a text box of how many pieces the client wants and the form would also fill automatically the cost of all the pieces for that dimension (by taking the price/item from the tbl_item perhaps?). If 1 piece then it should say i.e. 18 for the 140x130 piece, if 10 pieces it should say 180. Finally, I want to add the photo of the cardboard automatically (pls note that same type of cardboards share the same photo) not at the form but at the report to be printed. I have already looked in the Access FAQs section of the forum for the combobox techniques but I can't understand how I can apply them to three (or more) comboboxes plus the photo. I can use Access only when little/no programming is required, and I am very much afraid that all the above will require a great deal of it, so I apologise in advance for my non-knowledge of programming :( 2. How do you think would be suitable to split all this data to tables? Is my thinking correct (2 tables, tbl_item and tbl_offer) or would you suggest something better? Will the tbl_offer get a lot of data that way? Mind you also that every once a year there is the need of updating the cardboards' prices (all will rise/fall at the same percentage) and, furthermore, we are talking for about approx. 100 different types of cardboards, each with about 15 different dimension combinations. I am not sure if I had to post this message to the Tables section of the forum or here but I think here is better as the main problem is the form part. Thank you all in advance and my apologies once again for the low level of my programming skills :( Alexander
View Replies !
View Related
Multiple Combo Boxes On Same Form
I need a form that has multiple categories, 7, listed one after another vertically. I also need the categories divided in to 2 columns. I need to have 2 combo boxes, 1 each controlling the info for each column. Can I do this on 1 form. Suggestions would be appreciated. Freddie
View Replies !
View Related
Cont Form With Combo Boxes
I have a continous form that once the combo box filters are selected, shows the applicable records. Included in records, I've put a bound combo box that allows the user to fill in that particular field. This works with the first record but when you attempt to select the other records, all the combo boxes disappear. What am I doing wrong here??
View Replies !
View Related
Multiple Combo Boxes On The Form
Hi, I need help in the following 2 problems: I have two combo boxes on the form and print button. In one combo box showing numbers 1,2,3,4 and 5. Other combo box showing logical operator =,<,> User is going to select from one combo box logical operator and from other number "means class field". Print button prints the report. Report is based on the query. In the query in criteria line I put the code [FORMS]![MAINFORM]![CMB_CLASS] It works for one combo box. Problem is to get criteria from second combo box or concatenate the both criteria’s. In query criteria line it should show like <2 or =3 or what ever user is selecting. Second problem is in the same line. Three text boxes and 2 combo boxes showing "OR" and "AND" For example in one text box user enters last_name and then he select "OR", second text box enter city and then he select "AND" from second combo box and third text box enter department. After selection he is going to click the print button to print the report. I really appreciate if anyone knows the solution or they used this type of thing in there application. Thanks
View Replies !
View Related
Autofill From Many Combo Boxes In One Form
Hi all! :D I'm trying to make a form to autofill with customer data (from a database), with 4 columns (= 4 customers). Each column contains on top a combo box and below 5 text boxes with address, phone etc. So i created a form and placed a combo-box (from wizard) with the option "Find a record on my form based on the value i selected in my combo box". The problem is that this one combo box controls all the text boxes. Even if i create an other one, it still controls all of them. So i'd like to ask: How can i link a combo box, to autofill specific textboxes?:confused: Thanks... :)
View Replies !
View Related
Filtering Combo Boxes Within A Form
I have a form that we are creating to issue project numbers. We have about 80 different clients. I have set up a combo box for the client name, where we can choose the client from the drop down menu. We want the form to filter according to the client name that you choose. For example, if you pick Lawrence as the client name, the next combo box is the project name and I want it to only show the project names that have been assigned to Lawrence in the past. Can someone please help me on how to do this and if it is even possible at all? Thank you so much for your help!! I have been wrestling with this for about a week and a half now.
View Replies !
View Related
Unbound Combo Boxes And A Form With Allow Edit Set To 'NO'
Hi folks, I have a form with a record source property set to a query which pulls the data by joining two tables. The form also has four navigation buttons (first, previous, next, last) and a ADD record, SAVE record, EDIT record, DELETE record buttons. I also have a unbound combo box (control source iset to 'empty') in the form's header section and its record source property set to an SQL (SELECT DISTINCTROW tblProjts1.chrProjectName, tblProjts1.intProjectID FROM tblProjts1 ORDER BY tblProjts1.chrProjectName;). It's columns count is 2, bound column is set to 2 and column width is set to 3.1146";0". In the edit button, I have the code "Me.AllowEdits = True" so that the user can edit the data. Also, I have the following code on form's "on current" and "after update" events so that it will flip back to allow edit to 'NO' Me.AllowEdits = False Also, I have the following code on the combo box's 'after update' event. Dim strSearch As String strSearch = "[intProjectID] = " & Me![cboProjectID] 'Find the record that matches the control Me.Requery Me.RecordsetClone.FindFirst strSearch Me.Bookmark = Me.RecordsetClone.Bookmark. My Problem: When I run the form and select a record from a combo box it populates the fields (all memo data type) in the form with correct linked record, ONLY when my allow edit property is set to 'YES'. With allow edit set to 'NO', then when a tried to make a selection from a combo box it doesn't allow me to select any record. The combo box seems to be locked up and I can't select any record. Does anyone come across such a problem with cbo box and 'allow edits' property in the forms. Your help is much appreciated. ShanVel
View Replies !
View Related
VBA Code Problem With Combo Boxes On A Form
Im using the following vba Code to try and populate a text box with multiple line based on selections from a list box. Private Sub Precautions_AfterUpdate() Dim Criteria As String Dim ctl As Control Dim Itm As Variant Set ctl = Me.Precautions For Each Itm In ctl.ItemsSelected If Len(Criteria) = 0 Then Criteria = ctl.ItemData(Itm) Else Criteria = Criteria & "," & ctl.ItemData(Itm) End If Next Itm Me.description = Criteria End Sub Its working to the extent that it adds the options that are selected from the list box but I actually want it to put the 2nd column of the list box which is hidden into the text box. How do i edit this code to add column 2 rather than column 1 when an option is clicked? Any help would be appreciated Ive attached the database (sorry its very simple) Open form tester to see what i mean.
View Replies !
View Related
Help Needed Filtering A Form Using Combo Boxes
Please help. My inability to achieve this is very frustrating. I have a tabular form based on a query, which returns a large number of records. I need users to be able to filter the records to display data relating to what they have entered in a number of combo boxes. For example I have fields showing Product ID, Manufacturer ID, Purchase Order number and due date. Each of these fields has a corresponding unbound combo box where users can select values that appear in the table. I need to be able to filter the form based on what is in these combo boxes. I.e. Filler for a product ID to show all purchase orders numbers and due dates relating to that product ID or filter for a manufacturer ID and due date to show all Product IDs and purchase orders relating to that a manufacturer and date. Ideally this would be achieved by pressing a command button. The query, table and combo boxes are all built and work fine but I am unable to get the filter to work, I am using Access 97 and am not very familiar with visual basic. Any help would be appreciated. Thanks.
View Replies !
View Related
Ghost Values In Combo Boxes In Form!
I have set up a nice timesheet form now with lots of help on this forum. I have a form with a subform(1) which has another subform(2). The form is NOT in Data Entry mode, so users can select their name from the main form, the period from subform(1), and then enter/edit timesheet records in subform(2). In subform(2), I have some combo and text boxes for each record. The first is cboProjectSelect. Column(2) of the selection made in cboProjectSelect is entered into tboProject. Additionally, the selection made in cboProjectSelect filters another combo, cboWorkstream. The records are displayed in datasheet view (I know I've been advised against this, but I've had to do this, because the users want to see all records as they enter their timesheets) All this work beautifully....for the first record. For some reason, when you enter any subsequent records, it blanks out the values in the tboProject and cboWorkstream boxes for all records! If you click in any of them, the correct value appears, if you click away, it disappears. The proper records are being entered in the relevant queries and tables, so everything is working fine. It's just annoying that the boxes go blank! Any idea if there is a way to ensure the values don't disappear? thanks in advance.
View Replies !
View Related
Open Relevant Form Based On 2 Combo Boxes?
Hey guys, I'm not sure if this is possible, and it is the most challenging thing that I have tried to implement into my database to date. What I have is a booking form which allows you to Add Bookings for camera kits. When a customer comes in and would like to book a kit, the form must be filled in with the relevant details, I have 2 combo boxes on this form. The first is the Kit selection, there are 5 camera kits. The second is an option to book the full kit out, or just components. So here's the tricky part... When the first combo box selection is made (eg. Kit 3) I need the Kit3 table to be active. Then, when the user selects "Components" from the second combo box, I need a form to open up based on both of the above. So a form based on tblKit3 would be opened and the user can manually select the components that they require to be booked out. Any help at all would be appreciated.
View Replies !
View Related
1 Parameter Controlled By Multple Combo Boxes On A Form
Hi I have been trying to set up this query via VBA code but, with no luck, have gone back to the query in design view. Basically the parameters of the query are determined by combo boxes in a form. This is fine if one combo box indicates one criteria but a problem arisis when multiple combo boxes are possible parameters for one field. i.e. Field 1 = combo box one field 2= combo box two field three = combo box three, four or five. i have found it difficult running this, especially in terms of a returning all if a combo is left blank. the problem with setting this up on field three would be that if i run combo box four and five to return all if left blank it overides the other command to set a specific parameter. Also, for some reason i can tdecide whether this is an AND or OR command, its actually both i.e. Field three parameter = combo box three and/or combo box4 etc... please help this is driving me crazy. Thanks Shapman
View Replies !
View Related
Updating Relational Table From Form Using Combo-boxes
Hi, I have two tables, tblCountry and tblLocation. With the following structure tblCountry ID Name Text tblLocation ID Country_fk Name Text As you can guess tblCountry lists all of the countries, tblLocation lists all of the locations in each country, the tblLocation.Country_fk field is linked to tblCountry.ID. I want the user to be able to edit [tblLocation].[Text] using a form. They simply select the country and then the location using combo-boxes and then add or edit the content using a textbox. In my form I have a combo-box that displays the country names, the RowSource is set to SELECT [tblCountry].[ID], [tblCountry].[Name], FROM tblCountry ORDER BY [Name]; I then have a second combo-box that lists the locations for the selected country. This uses an AfterUpdate() procedure to select [tblLocation].[ID] using an SQL query based on the value of the country combo-box. I.e: SELECT [tblLocation].[ID],[tblLocation].[Name],[tblLocation].[Text] FROM tblLocation WHERE [Country_fk] = " & Me.country_box.Value & " Order By [Name]" I want to be able to have a textbox that then displays [tblLocation].[Text] for the selected location. Thats where the problem arises. I can't find a way that will let me display any content thats available for the selected location AND let me edit it. I've tried using UpdateAfter procedures, different bindings (tables, queries based on the value of location combo-box). Can anyone suggest how I can display [tblLocation].[Text] based on the value of the selected country/location and be able to update the information via a textbox? Any help would be appreciated!!! Thanks Jon
View Replies !
View Related
REFRESH Combo Boxes For Records On Continous Form
Background: I have a continous form linked to a table and I have 3 combo boxes on the form (linked to fields on the table). The combo boxes are called JOB TITLE, SCHEDULE and SHIFT. The source for the combo boxes are queries named respectively as LKUPJOB, LKUPSCHEDULE and LKUPSHIFT. For the three combo boxes listed abpve, the bound column is the first field of the underlying query and the column width of the first field is set to 0" (so that the second field of the query is displayed). The way things should work is that for each record on the form, the LKUPSCHEDULE and LKUPSHIFT queries (queries for the SCHEDULE and SHIFT combo boxes), the queries are filtered based on the bound field of the JOB TITLE combo box. The name of the bound field for the JOB TITLE combo is called Labor_Rate_ID. Problem: Unfortunately, It seems like the value of the labor-rate_ID in the first record (i.e. first job title combo box) determines the query list used by the SCHEDULE and SHIFT comboboxes for all the other records on the form. That is, even though the form has lots of records displayed, the combo boxes for each record don't have a complete list to work with. Hence, the SCHEDULE and SHIFT combo boxes for some records are showing a blank (since available otions in the combo query list don't match the value in the table for that record. Can anybody tell me how to get a continous form to refress the list for each record on the form. I also don't know whether the Requery command for a macro could work and how to use it. I think though, that this problem can't be solved by a macro. Basically, the question is around what kind of code will let you manipulate the properties of individual controls of a form at the Record level. Pele
View Replies !
View Related
Combo Boxes Stop Working After Returning To Form
Hello all, I have combo boxes populated with all values in a particular field, then shunt the form onto that record (standard combo box for selecting records from a list in other words). Problem is, these boxes seem to stop working if I leave the form for another and then return to it. Here's the code Access puts behind: ----------- Set SerialRS = Me.Recordset.Clone SerialRS.FindFirst "[Serial Number] = '" & Me![Combo60] & "'" If Not SerialRS.EOF Then Me.Bookmark = SerialRS.Bookmark ----------- The form may be opened and closed via other processes (although never unloaded), but when I come back to it these combo boxes always stop working! Why?
View Replies !
View Related
Text Boxes Showing Information From A Row In A Form Corresponding From A Combo Box
Hi, I have a form that has several text boxes that correspond to a cell in a row. One of the columns contains just numbers 1-300. Now what I need is a combo box that contains the numbers 1-300 and when one of those numbers is selected I need it to import all the information from the same row into the correct text boxes. For example when the number 3 is selected it will take the row with the number 3 in it, take all of the cells and import them into the right text box. Thanks a bunch!
View Replies !
View Related
Multiple Combo Boxes In Form To Choose Groups Of Records
Hello, I am wondering if it is possible to have several combo "boxes" in one form. The form is based on one table. In the table there are several fields which use a look-up (combo) drop down box to choose from: Type, Description, Manufacturer and Location. In the form I want a combo box for Type, to bring up specific records in a subform, then I want a combo box for Description to bring up another set of records (within that Type of equipment) and a third combo box for Location to bring up all equipment within that location. When I have tried to set this up - it changes some of the data in the in the subform - which changes it in the underlying table. If it set the form to open in New Record, then nothing shows up in the drop down box. Is there some If, THen code I could use to make it look first in the Type, then in the Description field, then close those out and look for the set of records that match in the location field? Does that make sense? I know how to manipulate in MSAccess templates, etc., but I don't know much about the underlying codes. Thanks for any help!!!
View Replies !
View Related
Populating An Underlying Table When Using Cascading Combo Boxes In A Form
Hello everyone I have read the FAQ on cascading combo boxes and have managed to apply the theory to my DB's data input form (frmDataEntry) which is very cool and prevents a lot of errors however in doing so it no longer populates the underlying table (tblProductionDetails). I am at a loss as to how to correct this as you can see from the example I need the customer and description field to be populated with the correct data rather than the fields I am using to make the cascading combo boxes work. Any help would be greatly appreciated Regards Adrian
View Replies !
View Related
***Multiple Combo Boxes On Form To Filter Subform Records!!!!
HI All, This is been a trouble to me more than a week....already passed deadline. Please help me. I have 4 forms. First form consists of Projects. So if you choose any Project and click on command button for other forms then you can goto that form. This is ok with my work. All forms(1,2,3)....are based on the qryProjects........and Each form has subform......and linked child field of subform with master field of master form.......so I can see all the records containing the particular selected project from the projects form...................... NOW my problem???????? is I have 3 cascading combo boxes to filter the records in subforms.....and printing the results of filtered records...................This one i tried to check many posts...but i got bad luck with all the sources..........PLEASE HELP ME....HERE I AM attaching my FIle....
View Replies !
View Related
Combo Boxes / Text Boxes
Hi guys, I have a related databes with about 20 tables. My main table stores the data linking with most of the other tables. This main table stores football match records with player line ups. Initially I had a problem linking the 11 player fields in the main table to the player table, Icould only do it with 1, so someone at work suggested to link it using the lookup function. This worked brilliantly. However, now I am designing a GUI with forms but the forms have combo boxes where the lookup function was used and when i change these to text boxes, the players names are replaced with their ID numbers. Is there any way of creating the form without the unsightly combo boxes, as they won't be needed, the GUI will be read-only. I look forward to your help!!
View Replies !
View Related
Combo Boxes And Text Boxes
I have a table that has client names and addresses. I have designed a form to be able to invoice these clients and everything is fine however what I'd like to do is have the address of the client appear automatically. I have set the client names in a combo box and would like their address to appear in either a text box or sunken label automatically from the table. Is this possible and how do I do it. Please keep in mind that I've done basic programming so please be kind to this newbie :D
View Replies !
View Related
List Boxes And Combo Boxes
Hi everyone, I have been making progress with customizing a MS Access program, but one major problem is that I have been trying to make a List Box or Combo Box that I can use to enter data in the TABLE, but I find that I get a pull-down list that has the list of values from only the parameter that is primary key. More specifically, the program is set up as follows: I have two tables in this program: One that is called "invoices" and one that is called "items". In both of these tables, there is one common parameter, which is "Item Number". Item number is the primary key, and I used the "relationships" function to tie this parameter to itself between the two tables. I was successful in setting up a list-box for the "Item Number", but when I try to set up a list-box for another parameter that is supposed to display a person's initials, the pull-down list displays the list of item numbers instead of the list of people's initials. In fact, I don't know if there is an extra step I need to take so that the database stores a list of people's initials. Instead, I just fill in the initials in the field for each record for which the "Item Number" is the primary key. How can I get the list-box to pull down a selection of different people's initials, or in other words how can I get all the people's initials to be stored so that the list of initials can be looked up. Just so you know, I have tried different choices of entries in the "Lookup" tab in the Design mode of Tables, including Display Control, Row Source Type, Row Source, and Bound Column, but the outcome is that the only parameter that I get get in the pull-down list is the primary key, which is Item Number. I appreciate any help you can offer in explaining how to correct this. On a separate note, one of the parameters is "Date", and on the reports, I'm trying to figure out how to filter a specific date range so that I can limit each report to a specific month. Please advise me on this procedure as well. Thanks.
View Replies !
View Related
List Boxes Fed From Queries
Hi peeps I have a list box that contains 4 fields and the list box is located on a form. One of the fields on the form is [Date logged]. This is also colum 2 of the list box. I am trying to write some code to say that if the Date logged on the form is different to the one in the list box, run an append query. Basically, the principal behind this is to have an audit trail of when records have been ammended. The first time a record is created, a base record is created. It is this base record that will populate the list box along with all other record changes that occurr from that point on. I am trying to say that if the [Date logged] does not match the last record in the list then it knows it needs to append the record to the history table again as a change has been made. I would really appreciate some help here folks. Thanks so much! :-)
View Replies !
View Related
Using Multi Select List Boxes To Run Queries
I have a simple question that I know will have a very complex answer You have two sets of tables with identical structures. The first set contains data that is a model for the second set. The users run queries that append data to the second set of tables Here is an example of the structure TblSourceOne SourceOneID SourceOneData TblSouceTwo SourceTwoID SourceOneID SourceTwoData TblSouceDetails SourceDetailsID SourceTwoID SourceDetailsData As you can see TblSourceTwo contains a foreign key from TblSorceOne and TblSorceDetails contains one from TblSourceTwo The main table for the second set TblTargetOne TargetOneID SourceOneID TargetOneData The user adds a record to the main table (TblTargetOne) then uses an append query to add all of the applicable records from TblSourceTwo to TbleTargetTwo TblTargetTwo TargetTwoID TargetOneID TargetTwoData So now the user has a data model in TblSourceTwo which has been “copied” to TblTargetTwo Next for each record in TblSourceTwo that has been copied to TblTargetTwo that has daughter records in TblSourceDetails another query is executed to copy all of the pertinate records to the TblTargetDetails TblTargetDetails TargetDetailsID TargetTwoID TargetDetailsData Now the user has completely copied all of the necessary record for both table. Finely the question How can I use a multiselect list box to achieve this in one operation? I don’t care if it includes running multiple queries but it needs to appear as one single operation to the user.
View Replies !
View Related
Linking Update Queries To Check Boxes
Help! I'm designing a database for my A level project at college and I just can't get this one section to work. I've spent alot of time linking things up so that you can't double book one of 4 rooms. It's a booking system for a recording studio. The thing is I have 3 basic packages of equipment and you can only choose one for each booking. The price is diplayed at the bottom of each package. I want to be able to check a box and then I want this price to be added to total price. I cannot link update queries to a check box I've tried every songle way I know. I'm not too familiar with access either :S. One more thing, I want to be able to tick a box which says Discount and then I want this to update the total price field again so it is multiplied by 0.9. I have manage to figure this out in an update query and it is also based on the fact that a band has made a deposit that is bigger than £0.00. I just cannot link it to the form. If anyone can help it'd be much appreciated, I'm panicking too much over this project.
View Replies !
View Related
|
TRACKER
