Recent content by new_2_prog

BEAUTIFUL!! Worked!! Now I see where you are coming from, I determined my min1 and max1 in a seperate query, it took the max number of blah so I ran that query and yes it aligned left so I changed the property in that query for Min1 and Max1 to standard and then opened query #2 that used query...

The fields in question align right in the query. I did notice in the report and query looking at the properties that I can choose standard for the format for QtyBlankstoCut but I can't for Min1 or Max1, does that mean anything? Thanks.

This makes absolutely no sense: I have a field on a report in the detail section called "QtyBlankstoCut", next to it are 2 more fields "Min1", "Max1" so what I want to do and did in Excel is if QtyBlankstoCut > Max1 turn yellow QtyBlankstoCut < Min1 turn red QtyBlankstoCut between Min1 and...

I used this in the criteria box: Between DMax('[beginDate]','export_thruput_dates') And DMax('[endDate]','export_thruput_dates') And it worked. :D Thanks.

Ok, guess I am having a brain fart of the day. I created a table that determines the current monday of the week and then 12 mondays ago to be put in table "export_Thruput_Dates" with columns enddate, begindate respectively. Then I need to run a query "qry_summary" that takes data from table...

Currently I have a form with a button that exports data to an Excel template, save as new file and done. I need this to run nightly so in the morning upper management can view without anyone needing to do anything. Since I am an intern I can not setup the task scheduler to run on my pc for...

I have a main form ShiftInput and I have a subform ManHours. Before the main form closes I need to check if there are ManHours entered. Structural background tblMaster = ID_Master, ShiftDate, Dept, SupID, Shift tblManHours = id(auto#), MasterID, SysProcess, HrsDirect, HrsIndirect...

Great! Thanks that worked, I added a msgbox under the case else to let them know to choose from the drop down.

I have a combo box that contains dates, works fine but I have 2 other text boxes that based on the date in the combo box it either subtracts x amount of days and another that adds x amount of days. What I have noticed in my combo box if I type 6/6 (for 6/6/2011) the other text boxes have...

Sorry, it's a crosstab query and that is one of the many downtime codes and depending on the day chosen for the query that could be a reason, another or even none. I think I have to somehow force it to always be in the query. Btw, the code didn't work in the query or the table. Thanks.

In my underlying query I have a field "Elec" that sometimes is populated and shows up in the query and sometimes its not and doesn't show up in the query. Obviously if its not there my report won't open because it's looking for that field and doesn't see it, how do I account for this? Is there...

Works perfect, thank you!

What I am looking to do is when todays date is entered, determine what the Monday date of that week is, i.e. Enter todays date 6/21/11 and in another field "Monday Date" 6/20/11 is populated. Thank you!

I started this thread here because this is the end product I need, this may need to be in queries and/or tables forum as well but I will start here. I have data from multiple tables that with 1 query gives me: Dept,ShiftDate,Shift,Machine,Process,Family,Ratio,GoodPcs,Scrap,Reject,Capacity...

I have linked tables and I check the save password checkbox when creating the links; the problem is when I close the database and open it back up and open the table it asks me for user name and password even though I already saved it. What is the issue and is there a fix?