Search results

I'm sure this is an easy one but I can't find help anywhere. Maybe i'm using the wrong termonology! All I want to do is display a command button in a main form if a date field in the subform is <= Date() - 90. I've managed to do this by doing the following: Private Sub Form_Timer() If...

Hello! I am trying to report on a payment table by payment method ie 'Cash' and 'Cheque'. In the Table Design I have a text field called 'Method' which is a Value List. I have created a module with the following function: Public Function ClassCash() As Currency Dim cClass As Currency cClass...

Hi, I'm really new to this in fact this is my fist attempt at VBA code! I have a Form to keep track of Dance Students attendance. ClassID (Bound txtBox) DancerID (Bound Combo) Price (Bound txtBox) Option1 Absent Option2 ToPay Option3 Paid Method (unbound Combo Value List of Cash & Cheque)...

Hello, In my customer info table I have 3 fields containing contact info, Home_Tel, Mobile and Other_Tel. I want to create a rule on the table which will allows nulls in the individual fields but not in all 3 (forcing entry of at least 1 contact number for each record) Is this possible in...

Hi, I'm designing a simple DB in Access 2000 to keep track of local customer details. All Customers live within a 20 mile area consisting of 7 towns which border on 2 Counties. I thought rather than keep typing the Town and County information in the data entry form, I would create a lookup...