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

got pulled off this project temporary. wanted to let you know the Conditional format works great. Thank you very much.:)

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

Your right, I was having null issues. Corrected my query and it runs great. Amaizing how you can not see the things starring right at you face...:p Thanks

It's working on another form that I have. Same code just different name, instead of using tbl85%ComplRawData_Pack it's using tbl85%ComplRawData. All the same fields except for one and that's the [tbl85%ComplRawData_Pack].[Pack Comp Date] The other one has [tbl85%ComplRawData].[Bkt Comp Date]...

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

To Rich fellow Texan FoFa, when I run the macro it stops when there is no data in the report, I have nodata set up in my reports. I need the macro to continue on if there is no data on one of the reports but it is stopping when it finds no data. bjackson I am trying your code now. Sounds pretty...

Macro Sendobject I'm afraid this code won't work since I am using just one button. I was having the button open the macro up which had the sendobjects for each report. That is where the problem lies, if one of the reports does not have data the macro stops because I do not want to send a empty...

Reply Hey bjackson, I am using a query that has a criteria for area of responsibility. Each area has a seperate query and a report.

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

Have you tried Union query? As long as all the fields are the same you can do a Union query.

Now I am thoroughly confused......... The field is not a date field, it is a part number field with seven digits no slash or dash just seven numbers. Is Access thinking this is a Date field????

No I have to leave the fields as text due to the second table is also linked and can not be changed. I can not use a third table due to this has to be automated. I have worked on this for a while now and due to the automation everything is getting hung up. Do you know why Access brings the field...

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