Search results

Hi All: I have created a query based on 3 tables. tblPotential_Partner (PK- CompanyID) tblOpportunity_Team( PK- CompanyID,Opportunity_ID) tblBusinessOppurtunity (PK- Opportunity_ID) As you can see that I have a many-to-many relationship. I want to create a search engine based on this query...

Anyone?????

Here is the sample db.

Hi All: I am trying to create a search engine. I saw an example of this code and want to implement it in my database but I can't. The database consists of 3 functions that return True when the source string passed to it contains "All Words", "Any Word", or "Exact Phrase" of the keyword...

Thanks AncientOne, I figured it out. Somehow when my computer went down this file got deleted. So I downloaded it from the web and saved it on my C:\WINNT\System32 folder and now it works fine. Ekta

Hi Everyone: When I click on any button on my form in Access it gives me an error: File Not Found: VBA5.DLL. Any ideas why I am getting this?? Today my computer restarted for no reason and then it would not start. The Network Adm. fixed that but now when I start access it gives me this error...

Thx for your reply dcx693 and Pat. I get an idea but I will need more help. I would really apprecite it if you could tell me in more detail how to go about it. When the user logs in my database I use append query to store his UserID in a table, tblUser. The field, Action_Date, based on which...

Hi All: I am trying to create reminders for my database based on a field on one of my subform. Let me first explain what's goin on in my database. As soon as the user open the database he has to enter his user ID and password to login. Once their password is authenticated, main menu opens which...

Go to your Log table Design View and change the order of fields. Rightnow you have ID, MRN, InitialVisit, LName, Fname... Move InitialVisit field after FName or in whatever order you want it. That might work. HTH Ekta

oh i c. The lines were not commented so I thought they have to be included in the code. Not very good with programming but I try. I am still learning. Neways..it works gr8 now. Thanks for your help again Ekta

Figured it out. At the beginning of the code there are these 3 lines where = Null where = where & " AND [ShipCountry]= '" + Me![Ship Country] + "'" where = where & " AND [CustomerID]= '" + Me![Customer Id] + "'" where = where & " AND [EmployeeID]= " + Me![Employee Id] I added them to my code...

If Left(Me![Name], 1) = "*" Or Right(Me![Name], 1) = "*" Then where = where & " AND [Opportunity_Name] like '" + Me![Name] + "'" Else where = where & " AND [Opportunity_Name] = '" + Me![Name] + "'" End If I did take a look at that. If I type file* or *file* it...

Jack: I fixed that error..I forgot to put single quotes for the third field. It works fine now. You are right about users doing the data entry. For this field I cannot create a combo box. It's a memo field and users want to search by this field. That's why I was asking if they could just enter...

Jack..I have one more question I am filtering my form based on 3 criteria's. 2 are combo boxes and the third is a text field. For the text field it only works if I type the entire text. I want it to work if I type just part of the text. For example lets take 'technical support'. If I just type...

Thanx Jack..works PURRRRFECT...:)

Jack: I am a littlt confused. In this example they r running the query on button click and that is where they added the code. In my case I will open the form but then where will I add all the query. I have one form where the users will enter their criteria. I created a query and based my...

Jack I am reading the article right now.. will let u know how it goes Thanx again

I am using the code below to filter my form. DoCmd.OpenForm "frmBusinessOppurtunity_Main", , , "Capture_Lead = '" & Me!CaptureLead & "' AND Opportunity_Type = '" & Me!Type & "' AND Opportunity_Name = '" & Me!Name & "'" It works fine but I have to enter all 3 criteria's to make it work.I...

I tried Me.undo and it works Thanks for your help Jack.

Thanx Jack..this works gr8888:) Juss one more thing. If DCount("[CompanyID]", "tblIntersection", "[CompanyID] = " & Me![CompanyID] & " And [OpportunityID] = " & Me![OpportunityID]) > 0 Then MsgBox "Duplicate Company Name, please select a different option" DoCmd.CancelEvent...