Search results

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

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

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

Is this possible? A command button when click will open an excel file... :rolleyes: Cheers! Sheila

I've tried using DMax codes shared by the generous members of this group. But i can't get the results i needed. :-( My table consists of the following fields: ColID - PK PolID - FK AmountPaid ORDate ORNo I added another field which i named "ColNo" - this field should assign a sequential...

I have 4 tables on my dbase. On the last table underlies all records pertaining to customer payments. tblCollectionData ColID - PK PolID - FK Amount ORDate ORNumber I want to add another field which i would name -- CollectionNumber. In this field, i need an incrementing number for each PolID...

I need assistance on one of my reports. :-( How do i limit the sum total of one record? PolicyNo PremiumAmount CollectionID AmountCollected OfficialReceipt DateOfReceipt ABC 12,000 1252 2,000 152680 21-Sept-05 ABC 12,000 1253 2,000 152681 21-Oct-05 ABC 12,000 1254 2,000 152682 21-Nov-05 ABC...

I have the following fields in one of my tables: CollectionID AmountCollected OfficialReceipt DateOfReceipt I made a query out of these fields: CollectionID AmountCollected OfficialReceipt DateOfReceipt 1252 2,000 152680 21-Sept-05 1252 2,000...

In one of my forms, i have this event procedure: Private Sub Gross_Com_LostFocus() If Gross_Com.Value >= 1000 Then Full_Com.Value = [Gross_Com] * 0.2 Else Full_Com.Value = 0 End If End Sub Is it possible to put such code in a report and query? If so, how? Thanks a million! Cheers! Sheila

I have two tables: Table1 - show details of customer payment (full payment / with credit terms up to a maximum of six (6) months) ColID - (PK/Autonumber) Col1 Col2 Col3 Col4 Col5 Col6 Table2 - shows insurance agent's prorata commission (based on cleared payment). ComID - (PK/Autonumber)...

Help! I have 2 tables with the following fields: Table1 CustID - (Autonumber/PK) FirstName MiddleName LastName Address City ContactNumber Table2 CustID VehID - (Autonumber/PK) PlateNumber FrameNumber ProdNumber.... etc. Property of all fields in Table2 are set to Indexed(No Duplicates). I...

I am currently handling an insurance operation. I have 5 Sales Executives (SE) who receives certain percentage of commission for each sold insurance policy. SE receives their respective commission on a pro-rata basis. Meaning, if they give 4 equal monthly payment scheme to their clients, they...

I have a query which i would want to show records between January 2004 and September 2004, assuming the [Current Month] is October 2005. The idea is to have a listing of sold policies between the first month of previous year and the month (of previous year) prior to the current month/year...

Please help. How do i convert a negative value to zero in a Form? :confused:

Is there a way to split the field record into 2? My field name is structured like this: De Jesus, Sheila I would want to separate the last and given name. I hate to do it manually because my record currently is now close to 5,000.

I have 4 tables with the following fields: Table1 - CustID, customer information.... Table2 - CustID, VehicleID, vehicle information.... Table3 - VehicleID, PolicyID, policy number information Table4 - PolicyID, premium collection information The bold/underlined fields are my primary keys in...

My db has 4 tables and forms Table/Form 1 contains customer information: ID, Name, Address and Contact Numbers Table/Form 2 contains vehicle information: ID, Vehicle Model, Plate Number, Chassis and Engine Numbers Table/Form 3 contains insurance coverage data: ID, Plate Number, Policy Number...