Recent content by Sheila.deJesus

Thanks Rickster!! Have a nice day! Sheila

If below is the criteria for pulling records between the 1st day and last day of the current week (Sunday being the 1st), what would be the criteria for pulling records for later weeks? Between Date()-Weekday(Date())+1 And Date()-Weekday(Date())+7 For the month of February, there are 5 weeks...

Thanks for all your inputs. I am familiar with the croostab query but i don't have an idea on how to change the column heading to "Weeks".

Good day! I'm planning to create a form that would show total number of sales transaction per week: If today's month is February, i would like users to see records like this: (Week should start on a Monday and ends on Saturday) GroupNo______Week1_____Week2_____Week3____Week4____Week5___MTD...

Good day! I placed the code below on the On load event of one of my forms. My problem is it doesn't work. The [Class] field are all highlighted in red even if the value is not "CRITICAL". Private Sub Form_Load() If Me.[UnitClass].Value = "CRITICAL" Then Me.[Class].BackColor =...

Good day! Would it be possible to disable the Page Up and Page Down keyboard buttons? Also, the Up and Down arrows? If yes, how? Thank you. sheila

Hi! I wanted to create a backup schedule since i already have the code to kick off users at a specified time. I've seen many posts here, but it's too complicated for a novice like me. Most of the posts i've seen here refers to windows task scheduling to do such. Is there an automated backup...

Thanks a million Allan! Got the idea! :-) Sheila

Hi Allan! Your post is exactly what i needed! Forgive a novice but.. can you please elaborate more on how to go about the code? I mean, how do i use it? Thanks! Sheila

Hi Peter! It works! Can't thank you enough!!! :-) Sheila

Hi, I've searched the forum for a sample code on how to automatically shutdown database at a given time of the day, but i can't find any. There are lots of codes pertaining to inactivity / idle users but none on scheduled time. My idea is to kick-off all users every 12:00nn, Monday to Saturday...

Hi Peter! I did exactly what you suggested, but it has no effect on the Deductible field. Any more ideas? Thank you! Sheila

Thanks Peter! I'll give it a try! Sheila

Good day! I used this code on the lost focus event. There's a problem with it. Could someone please assist me... Private Sub Deduct_LostFocus() If Deduct.Value < 2000 And Classification.Value = Passenger_Car Then Deductible.Value = 2000 Else...

Also, it this also applicable when opening an HTML document using command button? Thanks again. Have a nice day! Sheila