Search results

I'm banging my head again the my desk because to this..Something suppose to be simple.. I have a form that have a calculated field which generate a series of numbers. Correct and usuable numbers. Now, all I want to do this is to total (Sum)that numbers up at the Form Footer.. I have a Text Box...

I have a user Prod Table that contained many records in my table. One of the field in the record I have Over Time Field "Y or N "check box". I'd like to have a IIF statement put in to my control box on the form to calculate User Prodcutivity if there is OT exist in record? See attach screen...

I'm using MS Access 2007, where in my form I have Calendar Running durint Startup. I got this Calendar from Activex Control 12.0 from MS Office 2007. Now, I'm testing MS Office 2010, when I open my database where It would launch this Calendar Form, I got Error message "MSCAL.OCX Version 7.0. I...

Hi Mihail, I just noticed that.. can conditional formating do work with two Words. Example, if there SAD and MAD in the column, would format both words? Thanks So much for a quick responsed..

Folks.. I have a Form Display Data in my Access Database, which is working really well. However, users was asking if there is a way we can make Font Color Could/would change if The text in A field or Any field in my display form contained the word "SAD or MAD". Is there code for such thing in...

I'm trying to Export one of my Access Report to Excel, I kept getting this error message.. "There is an Invalid used the Dot, or ! Operator or Invalid of Parentheses..My report is working fine, except when I try to export it to Excel, then this error message pop up.. what does this mean or how...

Thanks I got to do this other way..Thanks

I'm in a complete lost, something that should be easy, but I can't get answer.. I have an access report that there is One column among 9 of them, refuse to give answer.. Its suppose to Sum all the total of each line in the column. See Attachment. This report is group by ID and sort by Shift...

Thank You everyone so much For taking the time to answer my post. I will try to use all the recomendations that is suggested to me and determine which work best for my user..Thank You..

The Date Field from UNIX after I extract, it looked like this 20130305. I would like to change it or Format it to look like this 03/05/2013. Is there an easy way for me to format this date field in Access? I'd like to do this on a Form.. Thanks in advace..

Thanks So much for a quick response...I'll try this out...Again .. ThankYou..

I have Date Field in my database which I want to setup a calculation. Exaple, If the Curent Date is NOT FRIDAY, it would Add 1 to the Curent Date, on the other hand , if Current Date is FRIDAY, I would like to add 3 on to Current Date.. Reason behind this is that if users signed out a book...