2 Questions About Search Boxes On A Form

May 26, 2006

Hi all..

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??

Thanks
R~

View Replies


ADVERTISEMENT

Queries :: Multiple Combo Boxes And Text Boxes On A Search Form

Mar 24, 2014

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:

SELECT AircraftOperators.RegistrationNumber, AircraftOperators.PassengersNumber, AircraftOperators.ManufactureYear, AircraftOperators.EmailToOperator, AircraftOperators.ExteriorPhoto, AircraftOperators.InteriorPhoto, tblListOfAircraftOperators.OpratorName, tblAircrafts.AircraftType
FROM tblAircrafts INNER JOIN (tblAirports INNER JOIN (AircraftOperators INNER JOIN tblListOfAircraftOperators ON AircraftOperators.CompanyName =

[code]....

View 2 Replies View Related

Forms :: Search Form Using Both Combo Boxes And Check Boxes

Jun 5, 2014

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

[code]...

View 1 Replies View Related

Searching Combo Boxes -- Several Questions

Jun 17, 2005

I have a form which shows contact information. I have added a combo box which automatically shows the information of the selection in the combo box. So, far no problem.

However, what I would like is that (since there will be a lot of contact in it) you can search inside the combobox. Say, for instance, you have the following info:
1. Albert Einstein
2. Ally McBeal
3. Anastacia
4. Bob Dole

When you enter the 'A', only the first three items stay in the combo box. After entering 'AL', only the first two items stay in the combo box.

How should I go about creating such a combo box? I already saw that when entering characters, it selects the first item that corresponds with the characters entered.

Also, when placing a combo box on the form, linked to the form (a standard function in Access) ... how do I select the first record of the form in the combo box?. Say that Albert Einstein is the first item which is shown in the form, it should also be selected in the combo box. Now, the combo box stays empty.

Any help is appreciated!
Jazz

View 1 Replies View Related

Forms :: Using Combo Boxes For Search Form In Read Only Mode

Jun 4, 2013

I would like to take advantage of using combo boxes to search records on a form but do not want user to be able to edit or change any of the data. Setting the form to read only of course, disallows use of any controls on the form.

View 2 Replies View Related

Forms :: Start And End Date Text Boxes In Search Form?

Nov 7, 2014

I have a pair of captioned text boxes for taking the criteria for the search result. Currently the text boxes are tied with a date field. I would like to give the user's choice of a number of date fields. After some research, I believe option group control fits for this purpose. Unfortunately, I never try this function before.

View 1 Replies View Related

Forms :: Search Form With Each Field In Separate Text Boxes

Dec 8, 2014

i want to search a phone number in contact information table with column names - number, name, address, dob, gender, f-name, m-name etc and show them in a form with each field in separate text boxes in access 2010.

View 4 Replies View Related

Forms :: Filtered Search Form Using Asterisk As Wildcard Default Value In Combo Boxes

Aug 23, 2013

I'm trying to make a filtered search form using "*" as a wildcard default value in combo boxes, this works for all the text fields except for the account number field (Numeric primary key). After quite a bit of reading up and searching, I tried using the following as the row source;

SELECT customers.ACCOUNT_NO, customers.CUSTOMER FROM customers; UNION SELECT "*", "All" From Customers;

But am still getting "#Error" in the combo box.

View 2 Replies View Related

Queries :: Search Without Using All Search Boxes

Dec 18, 2014

My search form has, say, 5 search boxes. Eg.

Vee
Cathederal
RIB
Keel
Lifting Keel

I need to have all the boxes visible and searchable. BUT I only want to search one or two at a time. How do I do this?

View 1 Replies View Related

Forms :: Text Box Search On ID And Populate Other Text Boxes In Same Form

Nov 12, 2013

I am trying to search on EmployeeID field and populate corresponding data like EmployeeName, EmployeePay in other text boxes in the same box .

In my Unbound Form I have three unbound Text Boxes and one Command button:

txtEmpID
txtEmpName
txtEmpPay
cmdFind

In my table EMPLOYEE i have three fields

EmpID -- Autonumber
EmpName -- Text
EmpPay -- Text

View 2 Replies View Related

How To Search Via Drop Down Boxes

Mar 1, 2013

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,

View 2 Replies View Related

Multiple Search Criteria With Combo Boxes

Dec 7, 2004

school has thrown me in to a bodemless ms access pit. can do a bit of VB but queries...I´m new to this stuff. i am glad to have found this fine forum.

i have:
-1 table: tblSpeler (65 entries)
-1 form: frmSpeler (already conected to a search query)
-1 search form: frmZoeken
*2 combo boxes: zoektekst (mp3 player make), zoektekst2 (mp3 player type), search button (cmdZoek).

my question:when i select a make, and then the type » i want that the form shows me the mp3 player with the selected make and type.

if more info needed, just ask. thanx

View 8 Replies View Related

2 Combo Boxes (2 Search Criteria) Won´t Work

Dec 12, 2004

i have a search form (see atachment1) with 2 combo boxes.
i have a pruduct form that runs on this query:

Code: SELECT * FROM tblSpeler WHERE (((tblSpeler.merk)=forms!frmZoeken!zoektekst1) And ((tblSpeler.type) Like forms!frmZoeken!zoektekst2));

if i start the the product form, it asks me for the make, and then for the player » it finds the right player in the form.
but via my search form it won´t work. it only opens the product form and no records are shown.

so: in the search form, when i select a "make", and then the "type", and then press search. i want it to show the right record in the product form.
+
when i select a make (eg "apple"), i want the type combo box to exclude all the types that are not from apple (eg only: ipod mini, ipod 20gb. right now it´s like in atachment2.

i know this is a common question, been trying to figure it out with a eg database, but i can´t get it done. all help is welcome

thanks,

-d

View 1 Replies View Related

Form Questions

Dec 21, 2004

I have a form that I am working on. I have enabled queries to be run by selecting on command buttons. All of my queries have a year field. I want the user to enter the year in a text box and then run the queries based on the selected year. I do not want any of the data in the queries to update except for the year field. I am not sure how to link the text box that I put on my form to my queries and get everything to update correctly.

If anyone could give me advise I would appreciate it.

View 1 Replies View Related

Queries :: Query By Form With Check Boxes / Combo Boxes Not Working

Mar 25, 2013

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)

View 6 Replies View Related

Forms :: Multiple Field Search In Combo Boxes?

May 1, 2013

I would like to have 5 combo boxes from which users can choose fields to search, e.g.

cbo1 - choose YEAR, TYPE, LOCATION, COST, COLOUR, SIZE
cbo2 - choose YEAR, TYPE, LOCATION, COST, COLOUR, SIZE
cbo3 - choose YEAR, TYPE, LOCATION, COST, COLOUR, SIZE
cbo4 - choose YEAR, TYPE, LOCATION, COST, COLOUR, SIZE
cbo5 - choose YEAR, TYPE, LOCATION, COST, COLOUR, SIZE

criteria are stored in txtbox1, txtbox 2 etc. so the search string could be

WHERE cbo1 = txtbox1 AND cbo2 = txtbox2 etc.

If the user doesn't choose anything for a combo, the search should ignore that field.

View 6 Replies View Related

Using A Form To Score Yes/No Questions

Feb 9, 2005

I am trying to figure out how to count the number of Yes's and No's on one record to produce a score. There are 39 total questions and each question gives the user a choice of Yes, No, or N/A. Each record will need to have a score attached to it. I appreciate all the help I can get.

View 7 Replies View Related

Continuous Form Questions

Jun 28, 2005

Hi,

On a continuous form, i have discovered how to enable/disable fields by checking/unchecking a box, but is there a way of enabling/disabling the fields for only the relevant record and not for all records?

Also in a continuous form, i would like no further record additions after the first record until a button is clicked on. Is this possible?

Mant thanks, in advance.

Lampy

View 3 Replies View Related

Form Design Questions

Jul 25, 2005

I have attached a copy of an excel sheet that my company has been using since the ice age. I would like to set up an access db, so as to eliminate the multiple files and make it easier to create new orders, rather that saving as a new file name all the time. However, does anyone have an idea of how I could use this same format for order entry? I need to ease our sales staff into this new idea and don't really want to disturb the form they have been using forever.
Thanks for any and all suggestions,
Chad

View 5 Replies View Related

Sub-Form And On Click Questions

Mar 30, 2006

Hi all, i got a problem which i hope you guys will help me on. I created several forms, the main form with command buttons that leads to other forms where users can key in their conditions for queries, i.e. parameter forms

After building the SQL string using createquerydefs

i use the code:

DoCmd.OpenQuery "Requests_open_module", acViewNormal
to open the query.

all these is assigned to a command button on click event. however when i click on the button in form view, the query result appears in a window behind the parameter form instead of on top of it.

so i tried:
DoCmd.OpenForm "weekly_open_requests_result", acFormDS, , , acFormPropertySettings, acWindowNormal

where weekly_open_requests_result is a form linked to the Requests_open_module query. And i get the same result, upon clicking, the form appears at the back instead of on top.

finally i went to the weekly_open_requests_result form and enabled popup in properties window and it worked! however...it doesnt have "File" which i need as the user upon looking at the result, needs to export it to excel.

so what is wrong here? or is there any code that i can use to make the exporting to excel automatically; i will need the form to prompt the user for a name and directory to save to.

View 1 Replies View Related

Forms :: Hide / Show Text Boxes Based On Search

Aug 2, 2014

I have a form (employee info) that requires the user to do a search to find the employee before then editing anything that needs to be edited.

I have a search box that will find the relevant record without any problem, however what I am looking to do is hide text boxes on the form and have them appear only once the search has found the matching record.

If no matching record is found, I would then like a message box that states 'No matching employee, would you like to add an employee' and when the user clicks OK, it then reveals the same hidden text boxes and sets focus to the first one of the bunch.

Now, I have used the 'me.textboxname.visible = True (or False) elsewhere, however, I am not sure how to trigger that after a search.

I assume I am looking at an If statement, but I am not sure how to construct it, hence turning to the experts.

Code:
Private Sub txtEmployeeSearch_AfterUpdate()
If txtEmployee = DLookup("EmployeeNumber", "tblEmployeeInfo") Then
Me.txtboxname.Visible = True
Me.txtboxname2.Visible = True
DoCmd.GoToControl "txtboxname"
Else
MsgBox "Employee Not Found", vbYesNo
<<<<<<<<<<<<<<<<<<<<<<
End If
End Sub

I know that there is a massive gap where I have put <<<<<<<<<<<<<<<< - but I am stumped as to what to put in there?

View 3 Replies View Related

General :: Search Records Based On Multiple Check Boxes?

Jan 3, 2013

I have a table of data regarding companies (contact info, etc). The company I work for provides these companies with up to 10 different products. On my input form, I have created 10 check boxes (and thus, 10 columns of Yes/No data in the corresponding table).

Each company has at least 1 product checked off, and up to all 10.

I would like to create a combo box that lists all 10 products, and upon selecting one, a list box then populates with the names of the companies (primary key) that use that specific product.

So, for example,

Company A buys CATS and DOGS from us
Company B buys DOGS
Company C buys CATS and ELEPHANTS
Combo box options: CATS, DOGS, ELEPHANTS

If I choose DOGS, then a list box gets populated with:

Company A
Company B

and when I click either of these, the record should be brought up for the respective company.

All of this should take place in the header of the form, while the form itself can be updated based on search selections.

View 3 Replies View Related

Modules & VBA :: Unbound Text Boxes And A Search Button Adjacent

Jul 23, 2013

I have two unbound text boxes and a search button adjacent each that allows me to search for a user via two methods:

1) Payroll ID
2) Surname

They have the following code:

txtPayrollIDSearch

Code:
Private Sub txtPayrollIDSearch_AfterUpdate()
Dim sWHERE As String
sWHERE = "[PayrollID] = " & Me.txtPayrollIDSearch
sWHERE = "[PayrollID] = '" & Me.txtPayrollIDSearch & "'"

[code]...

Then minor differences between the above and the Surname search.I have two questions:

1) How do I make the search more friendly by allowing it to find partial matches, i.e., a user has a surname of 'Smith' but I want to search for 'Smi'?

2) How can I display further error messages if there aren't any matches?

View 14 Replies View Related

Queries :: Search Query Using Multiple Combo And Text Boxes

Aug 13, 2013

I have a table with all information on it, that is input via various forms, I then have different queries pulling information from all information to run reports off. These all work fine, my problem is my 'Search Form' - below

I have created a query that finds information from 'all information' using

Like "*" & [Forms]![SearchAll F]![txtDateRasied] & "*"

This is working on all text boxes, It only half works on the combo box's when I use

Like "*" & [Forms]![SearchAll F]![combofailureanalysis] & "*"

If a selection is made in the combo box the query brings the correct results, however, if all the fields are left blank it should bring up every record, but it doesn't do this. I am certain it is the combo box's that are causing this anomoly as when I remove the combo box criteria it works perfectly again.

View 11 Replies View Related

Two Questions- (two Frames And Html Form)

Apr 28, 2005

First quetion
how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever.
i am trying to build somthing like asp with two frames and a record set and i dont know how.

the second question i have is how can i put an html frame in a form? i have some link to sme web site in my database, andd i want this data base to be open inside the form of the access and not with my browser in a new window.

please advice.

thanks.

View 3 Replies View Related

Two Questions- (two Frames And Html Form)

May 4, 2005

First quetion
how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever.
i am trying to build somthing like asp with two frames and a record set and i dont know how.

the second question i have is how can i put an html frame in a form? i have some link to sme web site in my database, andd i want this data base to be open inside the form of the access and not with my browser in a new window.

please advice.

thanks.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved