Search results

Hello, Joe.. Thanks for the Post was very helpful.. I'm using Isladogs Calendar on my database, however, now my users are asking if I can add time on to the Calendar after I selected any date from the Calendar.. Ex.. 08/19/2019 07:00:00 AM Or 08/19/2019 03:00:00 PM.. can you help? Thank You..

Need expertise advise. I have a lot Calendars build using Activex Control in my forms in access. However, in recent conversion that my company is moving toward is Office365. I noticed that in O365, all of my Calendar will NOT work. And I'm so pissed because why Microsoft did not incorporate...

Since we changed Shift from 1 to 4 to A, B,C,D,E and F, the Calendar that belong to the respective shift is not Open up any more. No Error message either.. Doe anyone have any suggestion why? This code is behind the Dropdown combo button.. Please advise.. Thank You.. Private Sub...

Need advise. I have two fields in my Access report that I want to find the Average. Field1 is "Pick%" and Fields2 "HL%". How should I do to find Average between these two fields? seem simple but I just can't get right. In Control Source: I have the following. =Avg ([Pick%]+[HL%]).. Not...

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

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

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

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

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