Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gr8R
  • Order by date
  1. gr8R

    Mail merge problems

    I have a macro in Access that runs a query then starts the mail-merge wizard. I hope this means that that it will merge the records found by the query. The problem is when i try to link this query to a word document. When i get to the part of the wizard in word where you select a data source...
  2. gr8R

    Checking for Birthdays using D.O.B.

    I originally had: Between date() And date()+5 but there is a big problem with this. It takes account of the year. I want it to select dates of birth that have the same month and day (not year) because birthdays happen every year, not just this year. I need an expression that will match the...
  3. gr8R

    Checking for Birthdays using D.O.B.

    I have a table with the usual details about customers. I want a query to check to see if there are any customer birthdays within 5 days of todays date. I put the following code into the Date of Birth field criteria: Between DatePart("m",Date()) And...
  4. gr8R

    How do i not show a query that has no results?

    I have a query that checks something everytime the database is run. I only want it to show itself or alert the user somehow if it finds something. So, How do I not show this query if it doesn't find any records?
  5. gr8R

    Mail Merge data selected by a query from Access?

    How do i make a macro or button or something like that, which will bring up the word mail merge wizard for the data selected by a query?
  6. gr8R

    How do i relate 2 customers to 1 sale record?

    I am an inexperienced user of Access so please reply in non technical language. I have 2 tables. 1 table has specific details about the sale of a product (e.g. dates) and the other table has customer details. Most of the time 1 record in the sale details table is related to 1 customer...

Part and Inventory Search

Back
Top