I've been looking and abusing the search function on this forum for this particular obstacle but no luck.
The client im building a database for wants a search form and everyone who used the old system are used by using *'s in their search criteria.
I know how I can use *'s in queries but its fixed (I think).
I want to let the end user use * when they want to pin down a particular product. So they just type in a part of a word and use a * at the end, middle or before.
Or should I just abandon the idea of using them in input form controls?
I know this works because I have seen it before, too bad I had no access to the source of it.
I hope someone comes up with some ideas, pointers or howto's
I have a form I am using to search for records based on any number of criteria. The one I am having a problem with is a model number search. I would like to search based on a from value and a to value.......for instance........let's say you had the following items:
bird birth bill birdbath bite bitter
If I want to search for values from bir to birt, I would get bird, birdbath and birth. How can I code my query value to look for values between two text boxes in a form?
I have a parent table called patient info. and a child table called fills. The database in the future will become very large, and will be difficult to find a particular patient in the parent table to update fills in the child table. How can I search through the parent table with ease so that I can update fills? Thanks for those who help!
hi.. i am currently creating an employee database.. and there is a form on the database that needs to search on records.. i am planning to create a form with a single textbox (for the keyword entry) and a search command button that when clicked, the search results will be shown in a seaparate continuous form.
now here is my query:
SELECT tblEmployee.EmployeeIDPK, tblEmployee.LastName, tblEmployee.FirstName, tblEmployee.MiddleName, tblCompany.CompanyName, tblDealer.DealerName, tblOutlet.OutletName, tblPosition.PositionName FROM (tblOutlet INNER JOIN (tblDealer INNER JOIN (tblCompany INNER JOIN tblPosition ON tblCompany.CompanyIDPK = tblPosition.CompanyIDFK) ON tblDealer. DealerIDPK = tblPosition.DealerIDFK) ON tblOutlet.OutletIDPK = tblPosition. OutletIDFK) INNER JOIN tblEmployee ON tblPosition.PositionIDPK = tblEmployee. PositionIDFK WHERE (((tblPosition.PositionName)=[Forms]![frmSearchEmployee]![txtSearchFor]) ) OR (((tblOutlet.OutletName)=[Forms]![frmSearchEmployee]![txtSearchFor])) OR (((tblDealer.DealerName)=[Forms]![frmSearchEmployee]![txtSearchFor])) OR (( (tblCompany.CompanyName)=[Forms]![frmSearchEmployee]![txtSearchFor])) OR (( (tblEmployee.MiddleName)=[Forms]![frmSearchEmployee]![txtSearchFor])) OR (( (tblEmployee.FirstName)=[Forms]![frmSearchEmployee]![txtSearchFor])) OR (( (tblEmployee.LastName)=[Forms]![frmSearchEmployee]![txtSearchFor])) OR (( (tblEmployee.EmployeeIDPK)=[Forms]![frmSearchEmployee]![txtSearchFor]));
but when i click search, the results are empty. what could be wrong with the query? is it the query? what should be the record source for the search form and the result form?
if you want to see the actual ms access file, here it is: http://www.gigafiles.co.uk/files/636/human%20resource%20info%20system_2006-10-11.zip
the name of the form is frmSearchEmployee and frmSearchResultEmployee and the name of the query is qrySearchResult.. thanks a lot and God bless..
I would like to put a search tool on a form that does pretty much the same as the find dialogue box, with out it being a dialogue box...
I need to be able to search specific fields on the form and all the fields. It needs to "Find Next" so to speak, as in not just finding the first match.
I wanted to see if it is possible to pull a query by just entering say the first three letters of a project name and the query displaying everything from the table that begins with those three letters. Any help with this is greatly appreciated. I am just completely stuck!
With some help from this forum (esp. Pat Hartman), i've been able to code up a script that performs a check on duplicate values.
My database has a Room Bookings form which consists of the room name, periods and booking date (BDate) fields. I need to prevent a duplicate on the same date, period and room.
The only problem with my code is that it only does a check on one of the fields e.g. BDate although i select a different period or room it still comes up with an error message saying that booking already exists? This means it is only checking the duplicate value of 1 field and not a combination of fields.
Here is my code:
Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strSearch As String Dim varKey As Variant
strSearch = "BDate = #" & Me.BDate & "# And Period1 = """ & Me.Period1 & """And Period2 = """ & Me.Period2 & """And Period3 = """ & Me.Period3 & """And Period4 = """ & Me.Period4 & """And Period5 = """ & Me.Period5 & """And Period6 = """ & Me.Period6 & """And Lunch = """ & Me.Lunch & """And After_School = """ & Me.After_School & """" varKey = DLookup("Booking_ID", "Furtherbookings", strSearch) If Not IsNull(varKey) Then If MsgBox("Booking already exists Booking ID: " & varKey & ". Do you wish to continue to create a new record?", vbYesNoCancel) = vbYes Then Else Cancel = True Me.Undo End If End If
End Sub
Can any1 identify where i am going wrong?
I'd really appreciate any help/guidance to resolve this problem!
I'm trying to write an app that will allow the user to search for records based on database fields, then select a subset of those records to be manipulated by other functions. The VBA book I'm reading led me to believe that a RecordSet would be the best way to store this subset of records, but searching around on the web has pointed me toward using a DAO.QueryDef. I can't seem to get either method to work!
Here's a quick overview of the app: everything is placed on one form. I have two tab controls that make a sort of upper and lower set of pages. One of the lower pages has the search functions. The user enters his search criteria into one or more textboxes (correlating to database fields, i.e. Last Name, SSN, etc), then hits the Search button. This should query the database, then populate a listbox with the search results. The user can then select one or more records from the listbox, hit another button, and the selected records are copied to another listbox on a page on the upper half of the form, where they can be further manipulated.
Can someone advise me on the best objects to use to accomplish this? A short code sample would be awesome.
By the way, does VBA have some sort of online API reference (like Java)? I know that MS Access has the object browser, but it doesn't give descriptions of the objects, nor does it list methods that can be invoked on them. Could someone also point me towards some good programmer's resources?
Hi all, I've got one question again. Let's say. I've created several tables to store data for several categories.Note: there is no relationship between each table.In each table, there is the date field in which the record is created. Then I want to make another daily record form that is to find records from all categories which is created at the current date. Is this possible to search records from various tables and combine them to show in one form or report? Can anyone help me in this case? thanks in advance.
I have a database which has numbers for different statistics and i would like to be able to search, for example, the past 10 weeks and find out how many time a certain number has been recorded.
I have a form that runs a parameter query to search for university name and then displays 2 fields, university name and course name.
I am having difficulty with a search button that i have on the form called search_command; it is supposed to run the exact query as when you enter the form, it does this but displays the result in a dataheet, i want it to repopulate my 2 text label fields as mentioned above.
In addition i want then to be able to go to a specific record, select it and then press a button to append it to another table. i ahve not started this part yet
i am a beginner.. how i can write a code in a afunction that search a record in a table according to some conditions example: i hv table employee that contains Title field which can have one of 3 values:Admin, Rep or Driver i need to search the employee that has his type = admin i can have one or more records that have this type... so how to find first one, last one and all?
I have a database that I am creating for my work. I have a form that I am trying to get it to search the information from a table to pull the record on the form. I would like to search infomation such as employee id and wanting it to pull that information from the table.
Okay, this is how my form looks. I have thousands of records, but in a special way. I would like to make a search having the email, when and what together. The table is like this:
Okay, there's a key for finding the records, but searching by it is quite difficult. Searching by these 3 data would make it easier. But it's quite difficult for me. I would like to have 3 lists (on the picture I have 2 so far) and a button that I can press and the record would come out...
On my form i have a text box (txt_search) and a search button (cmd_search). Now when the button is pressed i want it to go to another form (that bit is done) and display the search results (the bit that is hard).
How can i get it so that when i click the button. It searches some predefined fields with the text in the txt_search once the button is clicked.
I was looking for help to find out how i would put a search facility on a form
Ive written a query with a parameter where you input a persons name in order to find it in a table
the porblem is when i base a from on this query it brings up the parameter asking me to enter the name, the query works fine it does what i want it to do.
i want to be able to open the form and if i need the facility to enter a name an d bring the details up in a sub form
I have used one of the members' code which was posted in a tread before to create a search box in a form. This code works perfectly when the form itself is open. Otherwise, when I put this searching form along with other forms in one navigation form, I get the following error: "Enter Parameter Value: Forms!FRM_SearchMulti!SrchText"...The code that was used for the Search box is as following:
Private Sub SearchFor_Change() 'Create a string (text) variable Dim vSearchString As String 'Populate the string variable with the text entered in the Text Box SearchFor vSearchString = SearchFor.Text
Hi all. This is one has been troubling me for quite a while and once more I seek for solution to the right (hope so) place.
I have imported from a Excel a table and based on that table I created a form. But when I try to add a combo box on the form header in order to search for a particular record to display on screen the error on the attachment occurs. I didn't add even a single character of code, and the error message seems weird.
I tried doing the same thing on another pc (an older one) and it is working fine...I've added search via combo boxes in the past without any problems but this time something isn't going right.
Me and my friend are making a database for a DVD rentals business and we're having trouble with searching within a form. We want to be able to perform a search in a form by clicking on a button within the form rather than using a query or filter, and we want the results to be displayed within the form in the available fields.
I have a parent table called patient info. and a child table called fills. The database in the future will become very large, and will be difficult to find a particular patient in the parent table to update fills in the child table. How can I search through the parent table using a form for easy access to a particular patient so that I can update fills? Thanks for those who help!
I have a table containing customer details and a form which allows you to view them like records.how i could make something that enables me to search their fullname that would take me straight to that record.
I have a form that assigns an Auto Reference Number to each record. Now the records are later edited. Is there a way that I can have the user enter the Reference number and come directly to that particular record that needs to be changed in the form. Like a dialog box that asks Enter Reference Number or something.
i'm doing one of my school project, but i got a big problem with this.
from the photo, i've created a form like this. and i want to have a search system, searching data from table. so i've created 2 input box with 2 different searching methods.
both methods work the same. type in the Stuff ID and then click the search, datas will show like this.
but the problem is, i can't get the Search button working, whenever i press the search, it said that the Stuff ID can not be found. but i've that stuff id in my table!
Could anyone show me a solution of this. or is this method good? coz i'm not doing that with the VBA!
PS... sorry for chinese words. coz i'm from hong kong!
I have a form that is based on a query with many fields. As an example there is a field called "Medium" which contains values such as "Oil on canvas", "Oil on wood" etc.
At the moment I have a filter which works fine but this doesn't allow me to search all records which have the word "Oil" as part of the Medium.
I would like to be able to search all fields on the form. I have looked at a few exmaples on the forums but could not find one that applies to my scenario.
