Recent content by latino

Beautiful. It worked great. The only difference is that I did it with GotFocus instead, so as soon as the user clicks on the field, it does the requery. You learn something new every time. Thanks!

I have a form and one of the fields is a drop down box with autofill. If I enter an information that it is new, it doesn't show in the drop down box even after I click on the Save button I created on the form. In order to show up, I need to close the form, then reopen it again. I am running this...

I have a field called CompanyName with the autofill property. (You will begin typing the name and it will be completed automatically) In the same form, I have other fields such as company's address, phone number, etc. This is what I need: Once the CompanyName field is completed by autofill I...

Hey John Thanks again. I just have a quick question On the previous one, you had this for the path where the document was objWord.Documents.Add ("C:\Temp\WordBookMarks210606\AccessTest.dot") But on this one, there is no path: bjWord.Documents.Add strDocChoice I beleive that the strDocChoice...

Great! John, thanks again. Your sample will help me a lot.

Great Solution Hi John, great and simple solution! I like the drop down where you can select the customer. I just have a couple of questions: Let's say that I have a group of letter or documents I want to send. (one would be a welcome letter, the other a copy of a contract, the other a reminder...

Great Solution Hi John, great and simple solution! I like the drop down where you can select the customer. I just have a couple of questions: Let's say that I have a group of letter or documents I want to send. (one would be a welcome letter, the other a copy of a contract, the other a reminder...

I need to generate a pre-formatted letter from within MS Access, where the name, address and other information will be pulled from the current record on an Access Form. Basically it is like a welcome letter I could send to any new client I enter into the data base. Since I am doing one letter at...

I have an Access DB with each client having a unique ClientID. I also have a spreadsheet on Excel that captures specific information on clients for later use on monthly reports (this reports cannot be generated in access, therefore I need to have them in excel) What I need to know is if when I...

I couldn't find the property that allowsme to change the unique value field to yes. Where do you find it? Is it on the design view of the query? Please help. Thanks

I have a query for clients who come to our office looking for services. I only need to report 1 visit per client during the month, in other words if the client comes several times during the month, we only count 1. When I run the query, it gives all the times the client came to the office, but...