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

    Excel Macro/change connection to SQL database

    Below is code used in a macro in EXCEL. I need to change the connection to use a SQL table instead. It is currently using a database in Access 2000. All the data has been moved into a SQL database. The Database name/DSN is Lab. Thanks in advance for your help! Sub Mud() ' ' Mud Macro...
  2. tadimil

    Duration issue in updating a table...NEED HELP!

    I have a fertilizer report completed and working which shows a legend of Analysis number and it's color. It spans a 3 year range and by month. The fertilizer applications are shown under the month and colored according to which fertilizer was used. Currently, it just shows the month of...
  3. tadimil

    Creating a legend with colors from a table

    I'm trying to create a legend for a report that appears to be a chart. It is located in the page section of the report layout. The query gives the following data and layout: ------------------ Analysis | Color | '(Field Names) ------------------ 18-2-3-0 | Red | 18-6-0-0 | Blue | 26-20-4 |...
  4. tadimil

    NotInList Open Form from another database and update combo box

    I've searched but can't seem to find what I'm looking for. This is my first experience in working with two databases. I have a Vehicle Maintenance program and an Inventory Program. The Veh.Maint. has a form where the user can add parts used for a repair. If the part is not in the list it will...
  5. tadimil

    Need to default to current school year

    I have a form currently with a combo box [test year]listing years: 2003-2004 2004-2005 2005-2006 2006-2007 and so... I need it to default to the current school year. Range of date is June 30, 2004 to June 30, 2005 are the for the 2004-2005. The month and day will always be June 30th...it's the...

Part and Inventory Search

Back
Top