Wild Card Searches
Ive read loads of posts about Wildcard searches but am unable to find the answer to my problem. In one of my boxes on my search form the user places in the search criteria value, this can be from A1 - A16 all the way to G16. At the moment i'm using this as my seasrch query:
[Forms]![Search]![BoxNo]
So if I put in C1 then I get all the C1's, great. If I want to wildcard then I put in Like "*" & [Forms]![Search]![BoxNo] &"*", and again it works, this time it call enything with C1 in it i.e C13.
How can I adjust my query to do both, sometimes I only want the exact match othertimes I want to wildcard :confused:
View Complete Forum Thread with Replies
Related Forum Messages:
Using A * (Wild Card) In Pop Up Box?
Is it possible to use a * (Wild Card) in a pop up box for a query? I read the previous post about pop up boxes for quires and it worked worked great! I created one for my month field My criteria in my search fieled is a follows: 05-May 06-June 07-July 08-August etc... As you can see someone would have to type a 08-August to get the results for August, can a wild card be used? Example 08* would return all of 08-August data. I tried it but it wouldn't return any data. Any help would be appreciated. Thanks, Scott
View Replies !
Wild Card In IIF Statement
I am using a criteria entry form as the source of parameters for a select query, and I am using IIF statements in the query so that if the user does not want to specify for that particular field, the search still works based on the other parameters specified. Therefore the statement I am using is; IIf([Forms]![Criteria Form]![Customer Account] Is Not Null,[Forms]![Criteria Form]![Customer Account],[Data]![Customer Account]). This works. However for some of the criteria I want to also use wild cards, so that the user can enter just part of the data, and the relevant records will be returned. I understand that wild cards cannot be embedded into the IIF statement above. I have tried many methods, and trawled the web for ideas, but I cannot get this to work. I either want the user to enter the wild card themselves ie "100*" returning records starting with "100", or for the query to append the wild card itself. Can someone help please?
View Replies !
Wild Card Name Searching Help
How would I make a query find a person like this: Inputted Data: Smit Outputted Data: Smith, Smithy etc.. The formula I have entered in the criteria of my query is: Like [Enter the person's last name] With this formula, if I type Smith, then the data that comes out is Smith. But if I type in smit or smi, Smith doesnt come out. Thanks.
View Replies !
Access Wild Card Search Help
Hi I have a query that depends on the input (several parameters) from a form. The form has a list object that shows the results of the query. For example, when I type in "s" in last name and "b" in city, it shows everybody whose last name starts with s and city name that starts with b. The problem is that it excludes all the records with blank cells in either last name or first name or city. In another words, the list is already pre-filtered with records that contain all three fields (city and first name and last name). For example, the record (Last name: Mosby, First name: Ted, City = blank) will be excluded from getting displayed because it contains no characters. Can someone help me out with this issue? I would like to include those people on the search even though their city is not entered in the table. With the query parameter empty, I would like to show a very raw list (a list that is not filtered at all). The Query is built as follow: The criteria for the field "Last Name" is Like [forms]![simform].[lastnamesearch] & "*" The criteria for the field "First name" is Like [forms]![simform].[firstnamesearch] & "*" The criteria for the field "City" is Like [forms]![simform].[city] & "*"
View Replies !
Wild Card On Search Form Issue
Hi all, I need a little help with a wild card issue, Ive looked and looked and cant spot whats wrong. I have two forms "Requisitioner" & "Engineers", each form has a subform. These are basic search forms (unbound) that find related records in the subforms. The work is done in the query of the subform and then the form is refreshed. I have used this approach many many times without issue until now. If the engineers form is opened "G*" is entered into the text box then all the entries beginning with "G" are found in the subform. If the "*" is then removed from the text box leaving "G" no results are found in the subform, (Working Correctly) Now if the "*" is added again "G*" then the subform shows all the entries beginning with "G" Everything is good with the Engineers Form, If the same steps are made on the Requisitioners form after adding the "*" again no records are displayed. I could change the way this works by doing a recordset find but i really want to know why this is working on one form but not on another. I would appreciate any help with this. Garry
View Replies !
Converting Filter From Wild Card To Extact Match
I have a search box and it looks up project id number. the orginal code works but filters anything with that particular number. I like to adjust the filter to equal to the number enter. ex,, I enter 22 , i get records with 622, 223, etc I want it to be only 22 I can't seem to figure this out.. here's te code Private Sub txtSearchString_AfterUpdate() ' Find the record that matches the control. Dim rs As Object LSearchString = txtSearchString 'Filter results based on search string LSQL = "select * from [Projects - Active]" LSQL = LSQL & " where ID LIKE '*" & LSearchString & "*'" Form_frmSearch_sub.RecordSource = LSQL lblTitle.Caption = "Project ID: Filtered by '" & LSearchString & "'" 'Clear search string txtSearchString = "" End Sub
View Replies !
Searches
Hello, I am creating a database for a client and have come across a small problem. The basic background of the database is that it will be used to record and maipulate the results of observations that are conducted on members of teaching staff. The client wants the ability to search for people that have not had an observation or have an outstanding observation. The observations are made on a termly basis (so there are three terms. 1, 2 and 3). When an observation is entered into the database, the term number is selected from a drop-down box. I was woundering if anybody could help me with this as I am unter the impression that I am going to need to search for records that don't yet exist and I am unaware of how to do this in a database. Any help will be much appreciated. Many Thanks Jason.
View Replies !
Speeding Up Searches
My Access DB has two Number fields and five Text fields (each having field size of 200). They contain text. The DB is organised year-wise. I have now crossed 15000 records. I find that the search is very slow. Search is done on all these text fields for each word typed. Some one suggested that I index the fields to speed up the search. When I tried to change the indexes to Yes, it didnt accept. Is there any other way to speed up search? As an alternative, I created an append query to append records of the year I select in my form to another table so that I can search that table instead of the main table which contains all years records. But the append query is not appending records. Any solution would be appreciated
View Replies !
Boolean Searches? Possible?
I have a search tool, but right now it is 100% case sensitive in the sense that if i search for "test" and my entry is "Test" it will not return any results. is there any way to setup so I could say search for "Test" and it would find "test" properly? Or even to the extreme where I searched for "Tes*" and it came back with the "test" entry. Thanks,
View Replies !
Item Searches
Hi everyone i was just wondering if anyone new how to do the following; Data is entered into a text box named txtItemNo on exit a search is performed and the next textbox txtDescription displays the results. There is a table with itemnumber and item description in it the results would be the description. Any ideas? This is on a subform, dont think this amkes any difference though Thanks in advance :)
View Replies !
Combo Searches
Hi Guys, I apoligies in adcance, this has probably been asked several times, but I tried searching the forum but couldn't find anything. Just now I have a report running from a query were a name is input, the data is pulled out the table and is presented in the report. I want to take out the potential for user error by having them select the name from the drop down and then running the search. Years ago (I'm a little rusty) I managed to figure it out, but for the life of me I can't remember! Any ideas? Thanks Steve
View Replies !
Wild Cards For Both Text And Numbers....
Hi, I'm trying to search a field which has both names and numbers in it. For purely text entries the wildcard search works just fine.... like this: Like "*" & [What is Last Name?] & "*" I can type in "Smi" and get all of the Smith, Smiths, etc. However, when I try to use this for entries which include numbers (123), which should return "Smi123" I don't get any results at all. Any suggestions? I can put in the SMI123 as straight text in the criteria box, and will get the appropriate record.... so I know it is there! Thanks ..... Gordon
View Replies !
Mutlpe Searches For One Query?
Hi, in my attached databas ei have a form. If you look at the form you can see what it does. Where it pulls records for a student, i would like another button, that when pressed, will search all records for that student, with these records it will, then scan all the dates and the attended field. if the attended field for one date is all absent it will return the number 1, if theres two date where the attended field is all absent it will send back 2 and so on... the number will be outputed to a textbox any thoughts Thanks Chris Lynch
View Replies !
Newbie To Searches Through Forms
I have a form with a search text field, inwhich i want the user to type in a value to the search text and then I want a query which would search two tables and return which table the results in. i.e Form: Search Text Field ----> ABC12345 Table 1 Date Container Number -----> No Record of that number Table 2 Date Container Number ------> Number Found Result of Search Date Container Number ABC12345 Table 2 Can any one advise how to do this??
View Replies !
2 Issues With Combo Box Searches...
Hello, here goes... #1 I have a form with a combo box to be used for navigating to records (created using the wizard), based on a query with these fields: 1 - Last Name (Sorted Ascending) 2 - First name (Sorted Ascending) 3 - Company 4 - CustomerID (PK) The combo box only partially works, it pulls up a list, but here is the problem: If the name comes up 'Hartman, BillyBob', and there is only one Hartman, then all is well. But if you have several Hartmans, say: Hartman, Ace Hartman, Bob Hartman, Stan and say you try to select Bob, it always goes to the first Hartman in the list (in this case Ace). It is a pain in the ace, what am I doing wrong? Thanks for any help... (I will ask #2 after this is resolved)
View Replies !
How Do I Record Searches Done On A Database?
Hi there, I am using an Access database with Dreamweaver and ASP. In this database i want to create a column with a number that increases every time someone searches that particular record. Anyone know how I should do this? Thanks Mal.
View Replies !
Disable Wildcard Searches
Code:If Me.Search_Criteria_textbox = "*" ThenMsgBox "Please enter a full part number" & vbCrLf & "Wild cards are disabled", vbCriticalGoTo Exit_cmdSearch_ClickEnd If This is the code I am using to stop * wildcard searches and it works fine. My problem is when users enter partial number enclosed like this *1345*. Is there a way like above to stop them from entering that? Thx!
View Replies !
Forms, Queries And Reports (Searches)
HI folks I have a db. I have created a search form which when you click the search button executes a query to find the required records. The query is currently outputting to printpreview of the query. What i want to be able to do is have the option to select the correct record and then print it. The search can either be exact and return 1 record or use a wildcard and return a few records. I have the report setup and working I just can't for the life of me figure out how to link everything. Maybe I've missed something I don't know.
View Replies !
Form That Searches Query With 30+ Linked Xls Files
I've been looking around and have found some posts that pointed me in the right direction, I just can't get it to work. What I have is 37 excel files of competitor cross references. There are 2 columns in each excel file, our number and their number. I have inserted them as a linked table in the db. What I want to do is create a form that has a field for every part number and make all of those fields a search field. That way they can type in any number and get all numbers back. I have created a query but once I get past 4 linked excel sheets then I get errors about a type mismatch in expression. Also I can't get the form fields referencing the query to show up when I open it. If I leave the query at 2 or 3 fields and use [Forms]![CrossRef]![txtItemNumber] in the criteria of our number in the query, it works. I get a window that pops up when I just open the query asking for a number, I type it in and the query returns the number and competitor numbers. Am I doing this the hard way?? Thanks for any ideas...
View Replies !
Make A Querie That Searches For Other Queries That Contain A Certian Word
ok, i wanna make a query that will display the information from other queries containing the word "complete" in their title. All of these queries have the same columns names to them so they should fit together nicely but if someone adds a new query in the future with the word "complete" in the title i want this query to pick it up. Is this possible?
View Replies !
Fried Graphics Card. What Do I Do?
Hi, I'm in a a lot of trouble. My graphics card has stopped functioning, leaving me with a perfectly good computer that I cannot use. In order to retrieve the information from the harddisk, I got a cable between this computer and another one. This is my plan: When the "blind" computer is started, I will enter the cmd. From there I would like to be able to "share" one of my folders on the small network (ie the two computers). Is there a DOS command for this? second question: If I have VNC server installed, will I be able to see the desktop from another computer allthough I can't see it on the blind computer? Does that information go through the graphics card before it is sent over the internet, or after it has arrived in the VNC viewer computer? Fuga.
View Replies !
Magnetic Card Reader
Looking at creating a database that looks up records based on a number from a magnetic card. Has anyone ever come across any code that will pull the info from the serial port? I have been looking for 2 days and not able to find anything. I have the card reader but do not have any software to get the info from the serial port and my limted coding does not even come close to what I need. Any help or a push in the right direction would be greatly appreciated. Thanks, Matthew
View Replies !
Business Card Scanner
I want to use a business card scanner, and use the data for my Access 2000 order database. Most card scanners, can send data to Outlook, can you go from Outlook to Access? Any advise would be appreciate it . . . THANKS!:o
View Replies !
|
TRACKER
