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.
Attached I have a database that I've been working on which has a form called "frmCriteriaSearch". It is based off of the qryCriteriaListBoxUpdate query. I am trying to get the listbox in the second tab of the results section to work. It queries fine for the checkboxes, but I cannot get the comboboxes to affect the query (unless a checkbox has already been selected)
I have a table and in that table I have multiple columns one being check boxes and another is the description. There are others but these are the relevant ones. I filter under description for HR Payroll but this description is not uniform. After HR Payroll it could vary so the description is not always the same. I want to select all check boxes under this description and was told use a query no clue how to do that though.
I currently have 3 tables within a database with student details of three different classes. I need to create a user form that has a dropdown box which I can select a student from one of these tables with a number of text boxes below which brings up all the students details, then once the student has been selected and the correct details are shown then I need to create a button which allows me to move that student from one table to another.
I am trying to make a search option in my form header. Right now I have two unbound combo boxes (CboAccountsfilter and cboCourseName) that I can use to filter my records. Currently, I can use the drop down for CboAccountsfilter and a list of accounts will appear. When I select one, the corresponding Course Names will appear in cboCourseName. This works fine...Code below. I would like to take the filtering a step farther and add checkboxes to filter the data. I my form, there currently exist several check boxes (yes/no)...(Priority, Rep Top Target, Manager Top Target, ect). I would like to have the option to use a check box to filter. I.E if I had a checkbox in my header called PriorityFilter, if checked it would only bring up those records that met the two combo boxes criteria and was a priority.
Below is the code I have so far...it doesnt have anything for the checkbox because I am at a lost of how to get started.
Private Sub CboAccountsfilter_Change() Me.Requery Me.cboCourseName.Requery Me.Check178.Requery End Sub
I have a transaction table the last record is [EquipIn]. during the equipment checkOut process all the other headings in the table are filled in. The idea is to fill in the [EquipIn] record a couple of days later when the equip is returned. How the heck can I make a equipment check in form that will update that one record? I can't do this manually as we have 1000+ pieces of equipment.
Hi, I added some new controls into existing form. I made sure I added those new control names to Table source as well. For some reason, I dont get the values either in the form or in table. Please help. Thanks. By the way, how can I attach an attachment in this forum. This if first time for me in this forum.
I have a form with a check box among other itmes. What I want to happen is, when the user checks the check box, I want the text box to the right of it to be made visible and to let the user write text. But I only want this text box to be visible when the check box is checked. The check box is if the user wish to put a comment in the form, he will click the check box and then I want my text box to appear so that he may write the comment in the text box. Please help with this. Thanks
I have created a database for tech calls that come into my office.
I have created two tables with information i need on my form
table 1 = Office Location ID and Office Location (ie Chicago and other towns) table 2 = Employee ID, Employee, and Employee Location Code (ie Chicago = 1)
I have created a form with the fields that i need to record all the data.
What i want to do is create a Combo box for office location and place the 3 office locations via a field list. I then want to setup another combo box that would display only the employees that are part of the office location that was selected in the previous combo box.
If anyone could assist me in this it would be greatly appreciated.
I am working a new solution that I figured I would try, I am normally a web based data man. I have worked with a lot of SQL and server side code, but to be honest, I have never really used Access in depth. And so I am facing some problems, that I know are possible, but I am not sure on the syntax or method of doing it. Perhaps I could get some good help:D
Simple example: I have 1 combo box on a form populated with a query, I want to be able to when that cb's data has been selected to populated another list based off of what was selected. How do I accomplish this? Thanks for any help!
I'm creating a database to assist with the sales operations of a hat shop. I have a form for creating new orders called 'Invoice' where the order number and date is set. Within this form is a subform called 'Invoice_Order' (Continuous layout), this form is used for assigning order items to an order number. Within the subform there are two combo boxes which search the Stock table.
1st ComboBox- diplays hat styles (E.g- v1/v2/v3/v4...)
Problem is; different hat styles are available in different colours based on the material used. I would like the second CoboBox to display a list of colours depending on the style of hat chosen. At present i can only get it to display a list of colours for all hat styles.
Does that make sense? Any help would be most appreciated
I am creating an orders form based of a query that has joined an orders query and a customer query. What I want is in the order form when a Customer is selected then the address & contact information is automaticly populated in following text boxes.
Hi In my tables I have set a field to Yes/No and the format to be True/False. When I activate the table it shows the field as a checkbox, however when I create a List Box on a form to that table it displays the fields as True/False, how can I get the list box to also display the field as a checkbox.
I created a check box on a form. The problem is once the box is checked, it cannot be unchecked. Seems like there should be some validation running in the background that checks the state of the check box.
I have the value of the check box to equal 1.
If the field is null, then clicking on the check box assigns the value and turns on the check mark.
If the field is already 1, then clicking on the check box deletes the value and unchecks the box.
Can someone provide me with the vba code that makes the check box operate correctly? I appreciate your help.
Is there a way to make sure that one of two box is checked. And if one is checked the other could not be. For example. If I have a check box called Father and one called mother. If father was checked Mother could not be checked, and visversa.
I have 4 check boxes represent 4 grade levels. When I click on a grade I have a query run for me a list of all 9th graders or 10th graders or both together. When I run the form for the first time, all four boxes are check, when I unclick all of them and I click which ones I want the form does not work. But if I leave them click the report will work. Basically what is happening is when I unclick them, the lose their value. I have the check box set up with a Default Value as "09" or "10" base on what Grade Level there is. So my two questions are, how do I keep the value of the check boxes after I unclick and click again and Secondly, is there a way to have the boxes unchecked when I run the program?
I have a column which are check boxes to indicate whether plants are available for sale or not. The problem is how do i put code or symbol in to check all boxes or to uncheck all boxes.
I am facing a problem. i am very amateur at access. I want to design a form on which there is one combo box and one command button. If i made a selection from the combo box and clik on command button it should show all the details related to that particular selection (say Shop Order) on a report. I dont know how to link this things.
report may be like.. Shop Order Description Length Width Hight.. Ax12 xxxxxx xxx xxx xxx Ax 12 for a particular shop order selection there may be no. of parts that should show on. like an assembly thing. Suppose Shop order for a bag is A23 and its different parts are belt and chain... now SHOP Order description ...... A23 belt A23 Chain...
i hope i described my problem.. please do help if you can.. Thank you Hemendra
I need to select information from different combo boxes. Using a command button, i would then like the information transferred onto a list box.
I have so far managed to link all my combo boxes so the result comes out on a list box. if one combo box is left blank, i get no information in the list box. is there a simple way of doing this.
I have a table that contains the following fields: township male - yes/no female - yes/no number of kids
I need to create a query that will give me the count of males and females and sum of number of kids - all grouped by township.
I have created 3 separate queries that calculate each part and they work. My question is how do I display the results of all these queries in one report, all grouped by townships?
Or if there's a way to create one query that will add all of this up? when I tried to create one query, the check boxes were not calculated properly, because Access did not distinguish between filled and empty checkboxes and would just count them all...
Any ideas or suggestions would be really appreciated.
I was just wondering if there is any way that I can create a query to find all of the records which have a tick box checked.
There is a tick box on each form and I want to know what I type in the 'Criteria' box is Query Design so that I can quickly and easily search for all those which are checked.
I know that in a normal query, to search for a particular object you can type it in (e.g. 'Mugs' - will find all the records under the name of 'Mugs' when typed under the right heading) but i'm unsure of what to type in under the 'Target' heading to make it find all those which are checked.
I have a form I am creating from a query that has numerous yes/no checkboxes. I have been able to enter over 2/3rds of the yes/no boxes. However, I'm trying to enter the last of these into the form, and they suddenly change to text boxes. When I go back and check the query, they have also changed to text boxes there as well. I've checked and re-entered the data from the table to the query and finally to the form again. Same thing happens everytime. Any idea what's going on here? Thank you ~
hi guys i have 2 questions 1. how can i count selected or not selected checkbox fields (yes/No) in a tex box ?! ( for example we have a 2 yes/no fields that are Male and another Female , and i want to make a form that shows number of males and number of females that selected in a text box )
2. how can i make a search form that when i chose check boxes and then Search button it will show me the list of selected checkbox that selected in main form
( for example if we have 3 checkboxes 1.(low) 2.(mid) 3.(high) in main database and form , and if i want to make a search form that shows me list of enterees that is (Mid) )
