Search results

  1. R

    Time Picker Question

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

    A better date picker

    Thank You Isladogs, I got it to work right after I posted my question. Great learning tool.. If I want add a Fix Time after selecting Date. Example: 08/07/2019 07:00:00 AM or 08/07/2019 03:00:00 PM, how would I do that by using this Calendar? in my old Calendar I used: Me.Start_DATE.Value =...
  3. R

    A better date picker

    I would like to utilize this Calendar on my form contained. Start_Date and End_Date.. How would I code this so that your Calendar popup so that I can select Start_Date from Calendar and End_Date from this Calendar? Please advise.. Thank You..
  4. R

    Activex Calendar Office Pro Not working of O365

    FYI, Many Thanks to dedicated group of users at this sites.. Thank You.. I'll take a look to so what will be my best option and solution.. Again, Thank You all..
  5. R

    Activex Calendar Office Pro Not working of O365

    Hello, DBguy, I'm currently using Office Professional on Win10.
  6. R

    Activex Calendar Office Pro Not working of O365

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

    IF, End If Select Statement

    I'm 100% agree with you. I will take a look at that option as my knowledge in VBA getting better.. For now, I have to stay with 7 calendars for 7 shifts, since each shift starting at Diff time.LOL.. Thank You Minty.
  8. R

    IF, End If Select Statement

    OMG, Minty, you are the greatest.. Thank You.. I used your code.. it's working.. I'm new in VBA world..
  9. R

    IF, End If Select Statement

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

    Calculating Average between two number on Report

    Thanks You.. I may have to restructure my table .. I thought there may be an easier way to just put Avg function on the report and let it rip.. Thank You sir..
  11. R

    Calculating Average between two number on Report

    Yeah, Divide by 2 would work if either field is Not Null, when one field is blank, I got wrong answer.. I'm looking for Avg function that would make my report dynamic.. Of if I have more than two fields.. etc..
  12. R

    Calculating Average between two number on Report

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

    Sum Error on my subform

    Any help on this...?:banghead: Thanks
  14. R

    Sum Error on my subform

    OK.. I'll let you guys take a stab at my problem.. See if anyone have any idea. Seem to be simple but turned out to be a major headache.. All I need is to sum up the last column on the Subform or Main Form just like what I have on other column. Thank You for you time..
  15. R

    Sum Error on my subform

    Great idea, I may have to that.. jdraw, how do I post a database in this forum?
  16. R

    Sum Error on my subform

    Still got the error message..Is there a command that I can copy the result and paste the value to a new column. So that I can sum up the new column..?
  17. R

    Sum Error on my subform

    Thank you.. I will definitely try this out.. I will let you know, how this goes..Again, Thank You for taking your time helping me out..
  18. R

    Sum Error on my subform

    can you give me an example base on the formula that I have on my screen? Lets see If I can get this corrected.. Thank You...
  19. R

    Sum Error on my subform

    Thank You for trying to help.. I really appreciated.. May be i'm not too clear about this.. I have a form that contained subform, Everything work as I wanted to, except when I try to apply the TotalSum on One column on the footer of my subform, See Attach screen. I wonder if there is any other...
  20. R

    Sum Error on my subform

    Thank You for respond.. To my post..Here is error message. In attach pic below. I got Error on all Calculated field..anywhere on that form..
Top Bottom