Question About Creating A Search Function

Oct 17, 2004

Anybody here know how to create a search field on a form to pull up a certain record?

I am practicing with Microsoft Access by creating a database that tracks my college degree progress as well as my wife's college degree progress.

Here is the Database Structure:

tblStudentID
---numStudentID (AutoNumber)
---strFName
---strLName

tblQuarter
---strQuarter

tblDegreeAudit
---numStudentID (Lookup field from tblStudentID)
******(Displays the First and Last Name according to Student ID number)
---strCourseCode
---strCourseNumber
---strCourseTitle
---strDegreeProgram (Yes/No field)
---strQuarter (Lookup field from tblQuarter)
---strYear
---strCredits
---strComplete (Yes/No field)

frmDegreeAudit
---tblDegreeAudit

Now, on the form (frmDegreeAudit), I want to put in a search function that allows me to drop down a list with the Student's name and all of their courses next to the name according to the Student's ID. Below is how I want to list to look when you drop the list down:

First Name-----Last Name-----Course Code----Course Number

If I can't do that, then this is what I want to do then. I want a drop down list that has the first and last name. Then right next to that drop down list, I want another drop down list that lists all of the courses associated with the Student ID. It would look something like this:

List #1=========================List #2
First Name-----Last Name->->->->->->Course Code----Course Number

Anybody understand what it is I'm looking for? I hope so because once I figure this out, I can figure out the other database I've been trying to create for the longest time.

View Replies


ADVERTISEMENT

Modules & VBA :: Creating A Function That Counts Records And Use That Function In A Query

Dec 11, 2013

So basically I need making a function that will count the number of records from another table/query based on a field from the current query.

View 2 Replies View Related

Creating A Function That Cannot Be Greater Than .2

Dec 5, 2006

I have a function that I would like to max out at .2 and I don't know how to go about doing that.
Currently it is
Equip Inf: (([Equipment]*(0.03*(2006-[Letting Date]))+[Equipment])/([Equipment]))-1
and then I multiply (1+[Equip Inf])*[Equipment] to get my inflation. What I want is for Equip Inf to never be greater than .2 or 20%
What is the best way to do this?

View 2 Replies View Related

Search Function

Apr 6, 2005

Whenever I search a table using Ctrl+F it always says access returned zero results, even though I am searching for stuff I know is there.

How do I make a search field that will return in a table form all the results.
(Software inventory database, so I need to be able to search by serial number, as well as peoples names that are using those serial numbers)

View 1 Replies View Related

The Search Function

Sep 1, 2005

any way to set the searchfuntion to only search for part of the word as standard?
or is it any other way to make a search function where u can write like 133 and get all the numbers starting on it.

View 3 Replies View Related

I Would Like To Add A Search Function.........

Sep 7, 2004

Hi,
I would like to add a search function to a form. There will be a textbox on the form to let user to type in there searching criteria,
the grid (on the same form) will display the result records (search from the database) on the grid base on the searcing criteria. How to acheive this? Any example that I can refer to?

Thanks!

View 1 Replies View Related

Help With Search Function

Oct 16, 2006

hi guys... i am currently working on a search form for my database.. here's
how my form looks like:

http://i114.photobucket.com/albums/n...clientform.jpg

when the user will type in for example "ABC Company" in the "Search for" field and will choose "Company Name" in the "Search by" combo box, the database will look for all the "ABC Company" entries under the field of "Company Name" in a table. There will be a lot of category to search from such as Position Name, Company Name, Dealer name, Outlet Name, Employee Name and Employee ID..

the results should be shown in a continuous form...

i've already tried this code:

Code:SELECT " & cboSearchBy.Text & " FROM TABLENAME WHERE " & cboSearchBy.Text & " LIKE '*" & txtSearchFor.Text & "*'

but it didn't work...

does anyone has a sample SQL query or VBA code for this function? i've been searching for it, but unfortunately i wasn't able to find what i was looking for. thank you very much. all your replies would mean so much.

if you want, you can also check the actual ms access file:

http://www.gigafiles.co.uk/files/636...2006-09-27.zip

the name of the form is frmSearchEmployee...

thanks a lot... =)

View 2 Replies View Related

Search Function

Jul 30, 2007

Hello everyone,

I was trying to make a query in access that will search for approximately what the user types into a textfield. I can only make something that searches for EXACTLY what the user has typed into the text field, but I want a more versatile search query that includes wildcards etc. so that anything related to the search will also be found. I was trying something like this but I just cannot get it to work:


SELECT FirstName, LastName, City, Major
FROM Students
WHERE FirstName LIKE '" & FirstNameToolStripTextBox.Text & "* '

I am using Visual Basic 2005 . NET and Access database, but the query is being made through access.

Thanks in advance for any suggestions you have

View 2 Replies View Related

Creating A Search Command

Oct 4, 2007

I have a table that was set up from a parameter query. Before the form opens it ask you for a part number. You type in the part number you want the information for and the form pops up to that particular part number. The problem that I am having is that if I want to move to another part number I have to close out the form and reopen it to type in another part number. I tried using the Access Find/Replace feature to do a search for a another part number to open up the information to that part number and I have even tried to create a command function that will do a search, but when I use them they both come up with no records found.

Is there a way to make a search function in a form created from a parameter query? I am not a script writer and am just really getting indepth with Access at the moment.

Thanks
Steve

View 3 Replies View Related

Creating A More Efficient Search

Jul 13, 2006

please see the example attached, it is a very basic search, double clicking on the return number opens that record.

what i would like to do is show the account name and date is the same box.

below is the code that i use. can someone please someone help me incorporate something into it?

rivate Sub cmdSearch_Click()
On Error GoTo Err_cmdSearch_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmSearchReturn"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_cmdSearch_Click:
Exit Sub
Option Compare Database
Option Explicit

Private Sub List2_DblClick(Cancel As Integer)
Dim rs As Object

DoCmd.OpenForm "frmquery"

Set rs = Forms!frmquery.Recordset.Clone
rs.FindFirst "[RETURN NUMBER] = " & Str(Nz(Me![List2], 0))
If Not rs.EOF Then Forms!frmquery.Bookmark = rs.Bookmark

DoCmd.Close acForm, Me.Name

End Sub

Private Sub TxtSearch_Change()

Dim vSearchString As String

vSearchString = Me.TxtSearch.Text
'Me.txtSearch2.Value = vSearchString
'Me.List2.Requery
'Err_cmdSearch_Click:



End Sub

View 14 Replies View Related

Creating A Search Engine Help

May 27, 2005

Hello,

I have a form with about 30 fields on it, all connected to a table with file information. I want to create a search form using all 30 fields, so that if a user inputs information in any one of these fields and clicks search, it will find records based on the combination of what he/she inputted in the fields. For all the fields that he/she leaves blank, the search engine will ignore in its search.

I have already created a query that does this somewhat. For each field, I have used this as the criteria:

IIf(IsNull([Forms]![File Search Form]![SearchFieldName])=False,[Forms]![File Search Form]![SearchFieldName],[FieldName])

I have put this in the criteria and they are all linked by an And statement. It works fine, except that the program does not seem to match Null fields together. So, if the user leaves a field blank, the search won't ignore that field, it will only show records with some piece of data in that field. All records that are Null in that field are cut out.

So, I guess my question is: how would I make the program be unbiased towards fields that are Null and let it include records that have null in the field? Am I going about this the wrong way?

Any way, hope it was clear. Thanks in advance. =)

View 3 Replies View Related

Creating Admin Function To Validate Time And Task

Feb 19, 2007

Hi all,
was wondering if there was a simple way out there, or if someone could give me some ideas on how to use an admin function to either approve or deny a users time and tasks... this wouldnt neccesarily have to a be a daily function... but i would like to have this done before the end of a pay period(2 weeks).
i feel like this could be as simple as using a check box to show approval, but i wouldnt know how to have the users submission go into a place where the admin could view to approve or deny.. has anyone seen something like this done before?
thanks in advance

View 8 Replies View Related

How To Run A Search Function In MS Access

Sep 6, 2006

Hi there,
I would like to run a query which will allow me to search a specific column in a table. Any help would be greatly appreciated!!
Thanks

View 5 Replies View Related

Search Function On A Form? How To?

Jan 4, 2006

Hello!
I am sure this is a common question but anyway:

I have a form based on a table which I use to fill the table with data.

I would like in the header of the form to have a text box where if I enter a keyword it will display the corresponding entry.

Illustration:
Table:
field 1= first name
field 2= second name

Form:
Textbox 1= first name
Textbox 2= second name

Search textbox I type: "john" I want it to display/filter to show only the entries where first name=john

I hope my question is clear, I know most DBs do this but I can't seem to find a way of implementing it...

Thanx for your help and suggestions

View 2 Replies View Related

Creating A Search Field In A Form

Oct 5, 2005

Hello

I want to create a single search field inwhich the user can search data within two different tables. So for example in both tables there is a field called Container Number. When they type in the number into the search field i want a query to search both tables and return if it is in table one or table two.

I hope this make sense!

View 2 Replies View Related

Creating A Search Button For Key Words

Apr 27, 2012

I havent used access before and need a easy way to seach through 1300 records i have created in a form. Each record has 6 criteria, some with drop down options. I would like to create a button that when you type into a box and click this button it will search all my records and bring up a list of all the records containing the key words searched for.

View 10 Replies View Related

Creating A File Upload Function Where Selections Save The Document?

Sep 12, 2014

I work in a school where teachers have to archive their assessments and other documents monthly. Currently they email them to a set email address but I was wondering if it would be possible for me to make something with access whereby they can do this. I'd like to make a form where they selected their name and then attached a file, this file would then be saved in an area I would have assigned that persons name to, does this make sense? I want it to be very simple so just a name section from a dropdown then a file upload section and done.

View 11 Replies View Related

Search Function In Microsoft Access

Jan 12, 2006

Hi everyone,

Thanks for taking the time to read this.

I will firstly give you the low down on the business that I am doing the database for. It is a Car Restoration Business, where we deal with vintage/classic/muscle cars and restore them to the former glory.

I do not know Microsoft Access very well, I have attached a file with what I think is a databae I could be wrong. The main function of this database is to search for suppliers for a specific car part for a specific car.

So if I want to find a doorhandle for a 1970 Ford Mustang, I need the suppliers pertaining to those criterias to come up.

How do I get this to happen?

Thankyou for your help

Jess

:confused:

View 1 Replies View Related

Search Function Returning Zero Results On 2nd Use

May 15, 2007

Item: Access app front end for an SQL database (production tracking/job logging utility)

Problem: The app has a main search page that allows job entries to be located and opened by varies criteria (job#, job name, etc). I can currently run multiple searches on different criteria successfully but if I open a job window(which has been returned as result of my search) and then close that job window to do a new search my search function will no longer return any results(other then “Calculating….”) unless I close out the access app and reload.

Thanks in advance for any ideas that can point me in the right direction to hunt down my bug.

View 1 Replies View Related

Quick Search Function On Menu

Mar 17, 2005

Quick question.....I have a menu that links to 4 main forms displaying data from 4 different tables. I wanted to add the facility to quick search on the menu(i.e enter a record (the primary key) into a text box and click search. I would then want it to open the exising form at the relevant record or produce an error message stating no record present. I would have 4 quick searches on the main menu (one for each form)).

If anyone could help me on this i would greatly appreciate it, or if you could point me in the direction of an example it would also be great (although i have been looking and havent seen one i can get my head round)

Cheers,

Marky

View 2 Replies View Related

Adding A Search Function Into Switchboard

Nov 22, 2006

What is the best way to implement a search function into a switchboard? I need this search function to allow a user to check a database for specific names, so that they do not enter duplicates. Thanks in advance for all advice

View 7 Replies View Related

General :: Search Operation Function

Oct 5, 2012

The following search operation have to search some operation in the database, but there is a bug and I don't know why..

View 4 Replies View Related

Create A Search Function In Database

Aug 13, 2013

I've been trying to create a search function in my database and a " TmprryQryFrLnkFldsCrtn0123456789 " Query has appeared that I cant alter or change.

View 6 Replies View Related

Another Noob Question: Creating Search Form

Apr 25, 2006

I think I can achieve what my boss wants with just one table.

I work in a legal department and we track employee contract complaints/issues. Simple data entry is used and one table (Complaints Table) has been created with fields like: employee name, emp #, what union rep issues the complaint, who from our department responded, when the complaint was sent, when the response was sent, two memo fields to describe the problem and the resolution, and ... perhaps most importantly... contract section.

It is possible that one complaint could touch on multiple contract sections.

The data-entry form I've created has the following fields:
contract section 1:
contract section 2:
contract section 3:

Now I need to create a Search Form and I'm having all kinds of headaches trying to understand how to make this work... trouble with setting up the right macro, too.

I'd like the main form to contain the following search fields:
Rec # (which is set as an autonumber in the "Complaints Table")
Employee name
Employee #
Contract Section
...or perhaps just a "contract section" search form...

1. If a contract section # is entered, I want to push a button and have every record of that contract section # filtered from the database and show exactly as the data-entry form beneath the "search" portion of the main form.
(did that make any sense?). I know how to create a general form and subform, but the subform always shows up as a table object rather than a form object. How can I fix that?

2. Some contract sections might be numbered: 3.A.2. ....others might have a longer name like 22.C.3.a.vi.(b). ....
Obviously, the filter/search needs to catch all records which include the contract section specifically, regardless of which of the three "contract section" fields from the main data-entry form contain data.
What's the easiest, non-VBA way of setting that up?

I just know nothing of VBA.

Any help is greatly appreciated...
tango..

View 3 Replies View Related

Help Creating A Multiple Field Search Form

Nov 2, 2007

Hello, i have a database that simply holds all the information on one table at the moment and what im trying to figure out is how to create a form that i can enter data onto that searches all the different fields at once, instead of one search for one thing and another for another. Some of the fileds are Headset number, gasket number, make, model, engine cc, etc.. so what i want to be able to do is have a form with a text box for each of these fields that then searches the table to narrow down the search results. at the moment i have a search for each, say for one i enter the headset number, it searches and pulls up all records with that headset number, then i have a search for engine cc, but what happens is it searches all records again for the engine cc not following on from the search for headset number so i end up back with a load of records with diferent headset numbers but with the searched engine cc. Basically the search form needs to take data entered into each text bow for each field then the combined results from each, narrowing down the results. can anyone help? in laymans terms!!
Thanks
Paul:

View 5 Replies View Related

Creating A Form To Search Field In Database

Nov 6, 2004

I have created a form to search a field in my database by running a query. i can only get it to search for direct matches as I am having no luck getting the "LIKE" Operator to work for me. the format should apparently be, like "A*" , this works but i woud like to replace "A" with a variable from a txt box in my form. which will be a combination of letters and numbers

followed what i think is the right instructions and pasted the appropriate bits in the expression builder to tell it where to look but doesnt work
cant fathom out why its not working, it just produces blank queries

Also in the query design page do i need to do anything with the optional "Total" row dropdown menu?


help much appreciated

View 3 Replies View Related







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