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!

Register Log in
  • Congratulations bkrike 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: jmgaddis
  • Content: Threads
  • Order by date
  1. jmgaddis

    Use VBA to change query criteria

    Just wanted a simple way to modify the "Where" Clause of a Query on the fly so that I can just send a Range of Records to an Excel file using Docmd.TransferSpreadsheet. Searched and found the below Sub Routine from long ago that does the Job. Wanted to express my Thanks to LittleSmudge... but...
  2. jmgaddis

    Access 2007 Runtime Service Pack 1 finally available

    Waiting months for this. Have not installed it yet... just spreading the word. Click here: http://www.microsoft.com/downloads/details.aspx?FamilyId=D9AE78D9-9DC6-4B38-9FA6-2C745A175AED&displaylang=en or here...
  3. jmgaddis

    Access 2007 Split Form

    Trying to use VBA to make the datasheet portion active. After clicking a "letter".. say Z on the Split form, VBA runs to find the first record with Z starting as their last name of the Employee... anyway... it finds the first record OK.. but the split form is active... trying to make the...
  4. jmgaddis

    Adding a Record using VBA

    Mine works fine... but possibly should be slightly different. I just simply need to ADD a record to this table... so currently I have it SELECT * from the Table and the WHERE clause will never be found so no records are contained in the recordset. Then I add the Record. Is there a better way...
  5. jmgaddis

    Excel: Click Button for S takes to First Name Starting with S

    Have a spreadsheet with 3,000 names in a column... would like to have a button at the top of the spreadsheet for each letter... Button A would take you to first row of names starting with A, Button B to First B etc... Any coding to get me started would be great. Thanks in advance. John

Part and Inventory Search

Back
Top