Search results

Brianwarnock, I tried what you suggested. The result was if I search for partial I get the error. Example: In the live table "Description" field had "6632456,Cap Broken", the ID was 6502. If I type in txtSearch "6632456" no issues I get the record everything works fine. On the other hand...

Ok, so I did some digging and it sees when I use a partial keyword I get this error. If I use the exact keyword then the module works. On the other hand I dont see this issue in tbltest but again the live table has 6300 records some records might be causing this issue.

Brianwarnock, I transferred the fsearch function to the live database to be able to allow the USERS to have multiple word search. Well once I replace tbltest wit hthe actual table that I have in the live database I get this error Run-time error '94' Invalid use of Null. I look at the debug...

Thank you all for the help, thats great. I will take what you did and use it in the live database. So you used the split function to create an array with all the words in "txtSearch" then you fed the array into the Instr() function which looks into the description field and then uses the...

Thats exactly what I wanted. LEt me see how you did it and make sure I understand the logic

The criteria will be All words or part words in any one field. So the translation will be based on my database. The vba/query should search the "Description" field in tbltest for anything the USER types in txtSearch in frmtest. e.g. if the USER types in "663,may" in the txtSearch field the...

I looked at this database. It only looks one word at a time which what I have currently. I am using Like "*" & [Forms]![frmSearch]![txtSearch] & "*" in the criteria part of the query. I am trying to be able to type in multiple word or partial words separated by commas and get all the records...

I have attached a copy of my test database. So what I have been trying to do is instead of having the records show in the list I want it to open up in the query format so I can move it to excel for further analysis. Currently when I type lets say "66345,may" in the search field it will only...

I did add the comma, but it seems that it only searchs for the first word I have in Text0

So the below code does the search but how can it be modified to allow "Text0" multiple words separated by commas Option Compare Database Private Sub search_Click() Dim sWords As Variant Dim whereClause As String Dim sql As String sql = "SELECT * from dbo_Items where " Me.Text0.Value =...

Yes, i am looking at it and trying to understand how it works. So it seems i need to look at "Private Sub search_Click()". I cant understand still how it combines the words from text0 and show the records. Also i typed 2 words "physics,biochemistry" and thought that it will give me all records...

I am actually using a form were the USER enters a word and click search button to run the query. Ofcourse they have to enter one word at a time to search the "description" field in tbltest.

So from the below "Field1name" I presume is "tbltest.Description" so what is "Field2name". I am only searching the field "Description" in tbltest for multiple criteria. So if the USER enter in "Text1" multiple words separated by commas how will the below work. I will need an or function and...

Hi, I have a query currently with one word search criteria. So the user can enter a word and the query will bring out everything equal or similar to the word entered by the user. I am using Like "*" & [Forms]![Search]![Text1] & "*". So far so good I was asked if I can allow the User to run the...

It has to be something simple. the command "DoCmd.RunCommand acCmdPrint" is opening the dialogue box. I am chosing the printer but its not printing the report but it prints the image of the form but the report still prints on the default printer

Thanks mdlueck So do I replace my code with yours. I want Users to be able to chose printers that are located in their departments. Your code seems to set the printer to "strBarcodePrinter". In my case I dont know what the printer names are. So what way I should do to enable the user to chose...

Hi, I have been working on this for few days but I dont seem to figure out what I am doing wrong and why I cant get it to work. When the user opens the report (rptSchedule) a form (frmPrintEmailPopup) is opened infront of the report. The form has 3 buttons: Email (works with no issues)...

Ok so I have now a working vba to delete duplicate records since I am using an append query. The problem I am trying to resolve now is how do I delete the newer record duplicated as a result of the append query and keep the older one since I have other fields with or example I have a supplier...

Hi, Well I am getting stuck or maybe looking at it in a wrong way. So will appreciate any comments/feedback or help on this matter. I have attached the database if someone have time to look at it. Well I have a table that list all the Suppliers critical and non-critical "tblAVL". I have to...

thank you David.... Totally make sense. I was trying to use one query to accomplish what I wanted but your idea is so simple ands effective. Thanks works like a charm