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!

Recent content by tadimil

  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!

    My last post above was for lameid...it worked. MajP, I will also apply your suggestion...and will post the outcome as soon as I try it. I appreciate your taking time to look at this!
  3. tadimil

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

    Okay...you did it! Thank you a thousand times over!
  4. tadimil

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

    Yes...I understand it better...I will try it and let you know how it turns out...thank you!
  5. tadimil

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

    Sorry..I tried to do as you suggested but it's not working. The ReportTable ends up with 2 fields with the same content just two different names, "MonthToMark" and "DateFinished". The ReportOne table is my final table and its not mentioned in your suggestion, it contains the fields for the...
  6. tadimil

    Creating an array for month/year fields

    Could I possibly trouble you to look at the following thread? thread705-1185517 I am working on something similar and am having trouble. I'd appreciate any help...thanks in advance.
  7. tadimil

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

    I appreciate you getting back to me. I do need it to show the 3 year range on one report. But, I apologize, I am just not understanding as to how this is going to update consecutive months if the application is a 3 month duration...how do you get the next two consecutive months updated to the...
  8. tadimil

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

    Anyone have any ideas for this?
  9. tadimil

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

    get from ReportOne to the ReportTable" It should be from ReportTable to ReportOne. Here is the query. First the ReportOne Table is emptied and the Append/Insert query loads the destinct records from ReportTable to the ReportOne. Then the Update queries bring in the colors according to month...
  10. tadimil

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

    I'll try to be a little more clear...sorry...it's kinda confusing. Below is the report: Here is the table/ReportOne that is updated using 36 update queries that are set in a module/called on report Open, using table/ReportTable below it: Basically...using ReportTable to create the...
  11. 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...
  12. 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 |...
  13. tadimil

    NotInList Open Form from another database and update combo box

    PHV, I sure do appreciate your patience with me...but, that did not work...the field is still blank when the form opens. It's like it doesn't see the combo box value on the parts form. I'm not sure. Could it be something with the ONLOAD of the Inventory form?
  14. tadimil

    NotInList Open Form from another database and update combo box

    Forgot to mention...my last post does not work. Still need help... Thanks
  15. tadimil

    NotInList Open Form from another database and update combo box

    Below is a function that is called by the NOTINLIST event on the parts form: Public Function OpenUpdateForm() FormOption = "Add" DoCmd.OpenForm "UpdateItems", , , , , , NewData End Function The following is in the ONLOAD event of the Inventory "add" form: If...
See more

Part and Inventory Search

Back
Top