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 wOOdy-Soft 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: adgesap
  • Content: Threads
  • Order by date
  1. adgesap

    Running a Mail Merge from the Excel Data source with a Macro

    Hi, without boring you with the background, I am trying to run a mail merge from the excel data source, rather than from a word document. I have a table similar to the one below (but much larger), and a number of word documents that use the same mail merge fields. the table below and the two...
  2. adgesap

    Macro to select dates from a pivot table

    I need to select items from a pivot table based on dates. The pivot is based on a list of employees who have left, and I have grouped the leaving dates by month, using the =Date() function, ie: Date Month 15/03/2008 01/03/2008 26/04/2008 01/04/2008 02/03/2008 01/03/2008 I...
  3. adgesap

    Passing values from one variable to another

    I playing with some code where I want to set up a list of values, that can then be picked up in a loop. The loop works fine but what's being written to the spreadsheet is wrong. The code: Sub Macro3() ' Dim Franchise1 As String Dim Franchise2 As String Dim Franchise3 As String...
  4. adgesap

    reassigning access to DB users to reflect changing company structure

    Hello, I look after a database of employees for a company that is undergoing massive restructuring and I'm going crazy trying to rework the views/permissions for different users. Background: The company divides the country into regions and each of the regions is subdivided into separate...
  5. adgesap

    Keeping Line Manager information up to date

    I look after a database for my HR department. One of the most difficult areas we have to keep up to date is the Line Manager - "Direct Report" relationship. As is (I believe) fairly standard, each employee has on their Jobs table (one to many with main table) a field for recording who their...
  6. adgesap

    PHP with mySQL Insert statement using session variables

    I have been trying to use and insert statement with the following PHP code: <?php session_start(); $_SESSION['SentenceText'] = $_POST['SentenceText']; $_SESSION['SentenceManner'] = $_POST['SentenceManner']; echo'...
  7. adgesap

    accessing a form from a parameter query?

    I have created a parameter query, which I can access from a form with a combo box. (see: http://www.fontstuff.com/access/acctut08.htm) The idea is to allow users to select from a predefined list. This works great when I access (no pun intended) it via the form, but if I try to run the query...

Part and Inventory Search

Back
Top