Search results

I've inherited this database that is a nightmare the way it was structured. I have this query where I have to type in yesterdays date and it then populates the appropriate fields. Here is the SQL statement. SELECT [SOLTEX_Daily_MTD/FGI].[PART NUMBER], [SOLTEX_Daily_MTD/FGI].SOL_PART_NUMBER...

I'm trying to set up a conditional formatting for the quantities. So if Cell E7 had BLANK and the date in K7 is <= today() and qty in K7 is <> 0 then color the cell RED. If Cell E7 had BLANK and the date in K7 is = today() and qty in K7 <> 0 then color the cell YELLOW. If Cell E7 had BLANK and...

I'm trying to run this code in Excel 2003, but am having problems with it. Sub DoItAll() Application.OnTime TimeValue("00:00:05"), "Refresh_Chart" newHour = Hour(Now()) newMinute = Minute(Now()) newSecond = Second(Now()) + 5 waitTime = TimeSerial(newHour, newMinute...

I have a form that calculates percent complete and has a record counter so when the SumOfcountOfCompl qty >= 0.85 it will add a check mark. I keep getting this error code 2147217904 that states that No value given for one or more requred parameters. Here is the code. Appreciate the help...

I have a database that counts how many work orders have been completed by date. Here is an example of the data. Work Order - Date Complete -Qty Complete - Work Order Qty 20001 - 9/2/09 - 5 - 50 20001 - 9/3/09 - 25 -...

Help!!!! I have created a form that has a command button that sends reports to pre determined recipients. As long as there is data in the reports the macro runs fine, but if there is no data in one of the reports (I have NoData Event setup in the report) the macro stops. I need it to keep going...

Having problems with "time mismatch in JOIN expression" I need to link to an excel spreadsheet. I have a column of part numbers that are set as text. When I link this sheet to access the field data type comes in as a "number". I can not change this field since it is a linked table. I have to...