Search results for query: *

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...

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!

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

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

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...

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.

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...

Anyone have any ideas for this?

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...

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...

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...

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 |...

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?

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

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...

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...

Skip and cLFlaVA ~ Thank you...thank you...very much! I ended up using cLFlaVA's code. It worked exactly as I needed. As soon as I can figure out how to do the stars...Stars for you both! Thanks!!!

Wow! quick response thanks! I tried that and I get "2004" as a result. Our current date is July 29, 2004...which should fall in the school year of 2004-2005. I need the forms!formname.[text year] to default to "2004-2005". It's a combo box that the user can change years. But, I want it to...

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...