Search results

here is the database. Please check it out. When I apply your code it does not filter. The form I use is Project list. click in the search customer and type a letter. Thats when I get the error.

Your code still does not filter the items anymore and also does not put the drop down to the first letter.

yes thats what I need.

I will make it easier. My code does exactly what I want except it is allowing me to erase what is in the drop down menu completely and thats when I get the error. Any way I can just not allow the customers text to be deleted.

sneuberg, Your code does not give the error but it also does not go to the section of the list and the filter not longer filters.

Any help would be highly appreciated. I am getting the following error when I erase the text and type a letter. I want to be able to type a letter and it takes me to the list that starts with the letter. I can select the drop down and select the customer and it works but I get the error when I...

Alright so I was able to finally Figure out how to make all my tables work. I have a quick question. I am trying to use an Invoice Report but I cannot seem to figure out why the Text boxes dont link up. In Project Details if you click on the Repair tower project and then hit Print Invoice I...

Can someone please help. I have finally continued this database and here is my problem. I added another Table name Customers Employees so that I could have multiple employees to one customer. I cannot seem to figure out how to link the two tables so that in my Project details when a customer is...

Re: [SOLVED] Close all reports with VBA I figured it out. For some odd reason you cannot close the report after I have used the sendobject to email. The fix is to use the "ON Deactivate" feature on the report itself which will close the report when you click on the form. Thanks for the help guys.

yes but it does not close the report. I tried many different ways and still not closing report. I edited my first post with the code and code brackets.

You say it is the caption name but when I use the DoCmd.Close acreport, "invoice". It does not close the report... I am adding it under the send object... Any ideas?

I did.... this is what I found DoCmd.Close acReport, " Report name" But this will not work because I am changing the report name to add the [ID]. If the report name always stayed the same then I would not have a problem. So I was looking for a VBA code that would close all reports no matter...

Can Someone please help I am trying to close the report whether or not the email is sent. This is the code I currently have. The reason I need to close it is because the next one that I do for somereason only changes the report name but keeps the existing data causing the pdfs saved to be the...

IF I dont put a COMPANYID in customers how would I link it ?

Ok. So I followed your directions and It worked. I believe I have everything the way I want it. Took me a lot longer than expected but I believe I got it. I still have one small problem if you do not mind looking and letting me know what is wrong. In my customers table I have link the companys...

I am not access savvy at all. Sorry for all the questions but have been working on this all day and have repeatedly read your response. I am doing something wrong with your quick fix so I have decided to add a table for the companys. How will I be able to link the companies table to customers...

I dont want to sound dumb but the database you returned is not doing what I need. I want to be able to select only customers that are from the company I select. Right now it shows all customers in the customer list. The reason behind it is that I have many customers at one company. and when I...

Oh sorry. That was a typo should be Company. I did what you said but I get an error that says "microsoft access cannot find the object customer" any ideas.

CJ where do I find combo61. I have looked through the project list and details and cannot find it.

Can someone please give me the best solution to making groups. I have attached the file I am working with to make it easier to understand. What I need is in the project "Test" when it opens there is a spot for company and customer. I want to only be able to select the names that are in the same...