Search results

  1. L

    Not Saving Info Until I close the Form

    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...
  2. L

    Fill out different fields automatically

    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...
  3. L

    Generating a letter from MS Access

    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...
  4. L

    In Access, opening an Excel Spreedsheet that belongs to the same client

    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...
  5. L

    Eliminating Duplicate on a Query

    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...
Top Bottom