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

    Combine 2 Access Records into 1 Excel Row?

    From my database, I output to an Excel spreadsheet. The database shows two records, with some matching fields and some varying fields. I need Access to analyze the LABEL #s and if they match, combine the two records into one row of cells in Excel. I ran a macro using "ALT-Enter" to create a...
  2. 1stTimeOut

    Excel Formatting and Combining two Access Records

    From my database, I output to an Excel spreadsheet. The database shows two records, with some matching fields and some varying fields. I need Access to analyze the LABEL #s and if they match, combine the two records into one row of cells in Excel. I ran a macro using "ALT-Enter" to create a...
  3. 1stTimeOut

    Can Form Field have default formula AND override?

    I need a field (DateB)in a form where the default date is based on two criteria: 1. A specific box (BlockA)is checked 2. A date is entered into another field (DateA) If both 1 and 2 are true, then (DateB)=((DateA)-7). Ocassionally, the user will need to override the formula in (DateB) and...
  4. 1stTimeOut

    Find a record using 2 criteria

    My form pulls from a table containing two records [MDN NPA-NXX] with a date of 01/01/98 [MDN NPA-NXX] with a date of 01/03/99 I'm using a combo box to find the records. It searches fine, but will only populate the form with the first record even if I select the second record from the combo...

Part and Inventory Search

Back
Top