I am just starting out with a database and last night got more success than I imagined in that I have the basic database, a usable form and a report set up and displaying mostly as I want.What I would like to do is to be able to look on a form and select certain criteria and only see records that fall into them.The database is for magazines so for example I would like to be able to select "Prima" magazines and only see those, then maybe select 2005 and only see the Prima magazines i have from 2005,
I'm trying to build an database for aircraft operators. I've got the basic tables structure and relationships but I'm stuck on building an search form to filter records by user input.I've got following controls on my form (unbound):
1. AircraftType (combo box) from tblAircrafts 2. CompanyName (combo box) from tblListOfAircraftsOperators 3. TeailNumber (text box) from tblAircraftOperators 4. AirportNameSearch (combo box) from tblAirports 5. PassengersNumber (text box) from tblAircraftOperators 6. ManufactureYear (text box) from tblAircraftOperators 7. SourceSearch (combo box) from tblInfoSource 8. CountrySearch (combo box) from tblCountry 9. CategorySearch (combo box) from tblAircraftCategory 10. EamilToOperator (text box) from tblAircraftOperators 11. InteriorPhoto (Bound object frame) from tblAircraftOperators 12. ExteriorPhot (bound object frame) from AircraftOperators
I need to enable users to search for aircrafts based on those criteria. As I mentioned I'm new to Access and I don't have any advanced coding skills. I have a query build to perform the search and this is the code I've managed to write so far:
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 drop down box which shows Quote: Code | Surname | Forename | Faculty | Team However I can only get 1 drop down box to enter its data into one cell. What I want is for 1 drop down box where there are currently 4 which will fill in all the details.
I have a form ive created as part of my database used for data input.
Someone opens the form , enters their project number, and then enters what country it is in, what region it is in, and what sub region it is in. They are all dropdown menus with the information coming from a table via a lookup wizard.
What i want is when someone choses england in the country field, i want the region field to only displays the regions in england, and then in the sub region field i want only the sub regions that are in the regions displayed in the drop down list.
Is there a way in which i can link three drop down boxes together?
I'll create an example of what I mean...
I'll attach a Excel file which contains two identical filters, one of them where the filter is turned on.
If I select the "Serviced" filter, I am left with three options for "Make" and two options for "color". If I select the "color" as "White" I am left with just one "Make" - "MG".
I understand that some sort of "hierarchy" needs to be in place so I will Make it so that "Serviced" Must be entered first, then "Color" then "Make" so that if you select a different "Service", the "Color" and "Make" will repopulate with the appropriate values.
This is certainly possible with a REDICULOUS amount of coding that would map each value to its corresponding values however is this possible some other (easier) way?
I am trying to build a database in which there is a main table and in this main table there are products and there are types of products eg.
Ringtones - is the Product and Type - True Tone(mp3), category - R&B another eg is Graphic is the product and Wallpaper is the type of graphic Category - friends .
I would like to combine this so when you are in the MAIN products table with "Code" ,"Product" ,"Type" , "Category", "Title", "Artist" and "Price" that the drop down boxes say for instance when you click on "product" and you chose ringtone then in the "type" column there are only the options from the Ringtone type and not also for graphic etc.. is this hectic to do? Hope I have explained it ok...? Thanks ! Really hope some one can help me with this ? Melissa Cape Town SA
Hello to all The problem that I am facing is the following. I am trying to create a form that has the following: 1. A combo box in which you select from a list of users 2. A list box which is populated when I select a user showing me the courses that they have to take 3. Another list box that is populated when I select a course showing me the dates available for that course 4. Finally a third list box which is populated by what I drag or double click on the dates list box basically scheudling the user to his courses.
The first 3 parts of this done what is left to do now is the hard part which is to be able to drag and drop the dates in the other listbox which basically maps that user to that course date and populates the corresponding table. Any suggestions on how to do this would be highly appreciated. Thank you in advance
I have created a database that has both English and French forms feeding information into the same table. I'm not concerned if the info stored in the table is stored in French or in English. It all works fine other then the drop down boxes in the forms, here I only seem to be able to either have the English or the French options visible on both the English and the French form. Is there a way to have the English options on the English form and the French options on the French form, both feeding the results into the same field in the table.
I've made a query and designed a report for it. Simply it includes:
Area code, customer name, other customer details.
I want other people, when they click on the report to be given a drop down box which allows them to choose a specific area code before it generate the report. So, for example, they just want to look at Yorkshire region records, they choose Yorkshire from the drop down box and it'll generate the Yorkshire report. I've searched around but can't find what these are called.
I am designing a search query that will allow the user to look up a record in a database to view it. I have everything already set up, and most of it working properly.
The user can recall a database entry using 7 different criteria--Type, Customer, PartNo, JobNo, Warehouse, Bin, and Shelf. The Type and Warehouse entries on the database are drop-down values, the other 5 values are text entries.
So far, I have been able to get the look up query to pull up the desired records on the Customer, PartNo, JobNo, Bin, and Shelf criteria using
Code: Like "*" & [Forms]![Search Form]![Customer] & "*" .
However, with Type and Warehouse criterion, the two that use drop-down boxes in the database, I have been unsuccessful in being able to call up any records using either the above partial or the more exact:
Code: =[Forms]![Search Form]![Type]
I did try to change Type to a textbox on the look up query, but that was similarly unsuccessful. On a side note, I must use drop-downs on the Warehouse field since I have another query that concatenates that value with a couple others.
How can I, without delving into VB coding unless absolutely necessary, format the lookup query so that it will read the values of the drop downs?
I want to be able to attach a date field to a dropdown check box. For example, say I have a client who we submit multiple deliverables to on different dates. I want to be able to check the deliverables submittted and add the date for that deliverable (each deliverable has a different date). image which is how the drop down is currently set up.
I have developed a small database (attached) but want to jump to the recorde selected. Anyone got any idea how I can achieve this - it seems to be 1/2 working, but I cannot figure out the rest.
I have a query which works perfectly fine, it's the report that I'm having issues with displaying correctly.
My report is a daily personnel accountability report that shows where everyone is for the day. Instead of having a cumbersome query like I did before, I have opted to just use the results of the selected drop-down option to move the X to the appropriate box of where so-and-so is for the day.
Using
Code: If [marked_as] = 1 Then Me.Morning.Value = "X" ElseIf [marked_as] = 2 Then Me.Afternoon.Value = "X" ElseIf [marked_as] = 3 Then Me.Evenings.Value = "X" End If
I was unable to get it to work accurately outside of showing the three dummy names under the same column, even though the three dummy names were each placed in one of the three test categories.
I have this set as a private function called when the report loads, which is based on a query that filters down to the exact department or office (depending on the user's selection). Like I said, that part works fine, it's getting the code to accurately display in the correct column.
I am trying to setup a database in order to demonstrate a tie in between active directory and the HR side of a business.As such, I would like to select two fields from drop down menus that reference in Department and Location tables, but use this data to actually Populate the Personnel Records table rather than Query.I know this is not normally best practice from a DBA perspective.
I have this setup already in Filemaker, just through using relationships.However, I want to move to Access, as it is more industry standard and much lighter weight, so am trying to find the best way.I have attached two pics of my filemaker database, and a zipped copy of my Access file.
Hey all, new here, question for everyone. I have a fairly large database, I need to make a form that has 3 drop down boxes on it, one will be corresponding to a field in my table called Race, another with Affiliation and the last one with Gender, race will have 7 options, affiliation 20 options and gender 2 options. I need to be able to have a search/query setup so that a user chooses one option from each drop down and have it do a search in my table corresponding to what they choose. I really have no idea howto do this and hoping someone here could help. thanks
Why is it that everytime I print a report containing Drop-down Boxes, the selected value for that particular record is blacked out?
This is a screenshot of what I'm talking about: http://ww w.hotlinkfiles.com/files/1177902_txqed/AccessReport-Error.JPG All the blacked-out bits are supposed to be the selected values for each record.
I use Microsoft Access 2002. How can I fix this so that the actual value is legible?
To recreate the problem: 1) My table contains a field (called "Colour") that can only be satisfied by certain values ("Black"; "White"; "Coloured") as defined by a drop-down list. 2) I enter a record about a white scarf. Therefore under "Colour", I select "White" from the drop-down list. 3) I make a report from my table. 4) I print the report. 5) However, when I look at the record of the white scarf, all I see under "Colour" is a box containing the values "Black" and "Coloured", and in between them, the selected value "White" should be, is a black line.
As an example lets say I have a table listing some cars:
Car Make Car Model Ford Fiesta Ford Focus Ford GT Mercades C Class Mercades E Class Mercades A Class
I am making a form with two combo drop downs with the ability to select car make or model.
Car Model is Unique so if the car model is entered, I will force the car Make into the other combo box
however, If i select "Mercades" for example in the car make, I would like the combo box of Car model to only be filled with the possible models that Mercades make.
Is this possible? (to search for the values available in Car Model based on the value entered in Car Make?)
I have a form with First name, Last name, Employee number, Information. The information box is a drop down menu with four options (contact, emergency, company, personal) I would like to be able to enter in search criteria for an employee using one of last name first name or employee number then choose an option from drop down box click a button to search and have it pull up just the info I needed.
I think I have two options but i am not sure which would be more efficient.
1. creating a query and using the criteria from design mode to have it filter the information. The only problem with this one is I do not know how to set it up with the drop down box from the form. Or would I need multiple querys for each option or just one with all of it?
2. writing code for the search button on the form that will bring up the appropriate query (I think I would then have to create a query for each drop down option)...
I'm working in Access 2010. I have a simple form that is bound to table "Jobs" in which the key field is job number.
I want to create a search drop down. I need it to display both the job number and the customer name; and I would like the user to be able to start typing the customer name in the dropdown and for the drop down to pull it up as I'm typing it.
I create a simple query for the row source of my drop down:
SELECT Jobs.Job_Number, Customers.Customer_Name FROM Jobs LEFT JOIN Customers ON Jobs.Job_Number = Customers.Job_Number;
When I run the query, I get both columns. I set the bound column to 1.
Column count = 2. Column widths =1";1"
Go to run it and it displays only the job number in the drop down after I select. In addition, it does not filter at all.
I have a main menu "MainMenuF" in my database and I would like the database to be able to be searched by any of the column headings. For example I have a table titled "NewLabReportT" this table has many column headings like "Submitted By" "Reviewed By" "Title" "Abstract" etc...
I would like my users to be able to click a radio button with the same column headers on this main menu and have a box that pops up to say "Enter search parameter" and have that parameter be searched in the table "NewLabReportT" and generate a FORM not a REPORT of all of the listings in the database that have that keyword associated to that certain category searched. That way they can "CLICK" the exact field they are looking for and have it open right up to that form.
I am using the following search function to search my database:
Private Sub cmdSearch2_Click() Dim strLastName As String Dim strSearch As String
'Check txtSearch for Null value or Nill Entry first. If IsNull(Me![txtSearch2]) Or (Me![txtSearch2]) = "" Then MsgBox "Please enter a value!", vbOKOnly, "Invalid Search Criterion!" Me![txtSearch2].SetFocus Exit Sub End If 'Performs the search using value entered into txtSearch 'and evaluates this against values in strStudentID DoCmd.ShowAllRecords DoCmd.GoToControl ("LastName") DoCmd.FindRecord Me!txtSearch2 LastName.SetFocus strLastName = LastName.Text txtSearch2.SetFocus strSearch = txtSearch2.Text 'If matching record found sets focus in strStudentID and shows msgbox 'and clears search control If strLastName = strSearch Then 'MsgBox "Match Found For: " & strSearch, , "Congratulations!" LastName.SetFocus 'txtSearch = "" 'If value not found sets focus back to txtSearch and shows msgbox Else MsgBox "Match Not Found For: " & strSearch & " - Please Try Again.", _ , "Invalid Search Criterion!" txtSearch2.SetFocus End If End Sub Which i got from here: http://www.databasedev.co.uk/text_search.html
Question #1
I have my own record counter setup at the bottom of the form via this:
Private Sub Form_Current() 'Inserts current record number and total number of records Me.txtCurrent = Me.CurrentRecord Me.RecordsetClone.MoveLast Me.txtTotal = Me.RecordsetClone.RecordCount End Sub
I would like to have this show how many searchs were found. I really don't care about how many entries at this point... but if you do a search via lastname for "johnson" I have 15 right now.. I would like to let the end user know their are 15 enteries with the last name "johnson"... how can I do this if it is possible with what I have setup..
Question #2 How do I get the search lastname field to go blank after I hit the search button??
