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

    Query my Access 2007 Query in Excel 2007 VBA

    Working in Access 2007 and Excel 2007.... I have an .accdb (WellCardPilot.accdb) that pulls information from multiple tables (some linked, some built into the DB). The following code works fine to return all records from a query called BridgeportWellCard to a specific worksheet in Excel (Sheet...
  2. tammy23

    How to Tab From Subform to Main Form

    I need to be able to Tab from the Last Record on a subform back to the Header on my main form...I tried using SetFocus OnExit but then I can't scroll through every Record on the subform, only the first one. I also tried using an event procedure OnExit from the subform but the Tab just loops...
  3. tammy23

    DLookup Using Multiple Criteria

    Access 2000, Windows XP I need to lookup an entry in WellLogDetails based on two criteria in Report2 and all three of the following codes return errors....any suggestions? 'a = DLookup("[FileLoc]", "WellLogDetails", "[Well]=Reports!Report2![Well]" And "[ID]=Reports!Report2![ID]") 'a =...
  4. tammy23

    DLookup using multiple Report Criteria

    I need to lookup an entry in WellLogDetails based on two criteria in Report2 and all three of the following codes return errors....any suggestions? 'a = DLookup("[FileLoc]", "WellLogDetails", "[Well]=Reports!Report2![Well]" And "[ID]=Reports!Report2![ID]") 'a = DLookup("[FileLoc]"...
  5. tammy23

    Need VBA code to open .PDF file in different program

    I am trying to write a code and am failing miserably. I have a command button in a subform...I would like to click on that button and have a .pdf file (associated with the current entry) open in a program other than Adobe Acrobat. The file paths are entered as a field in a table called...

Part and Inventory Search

Back
Top