Search results

Can't beleive I spent so much time on it when the solution ended up being so simple! Think I need to take five (weeks off work!)

Thanks for that George. I set Min([ProcessDate]) in the footer of the subform and put a hidden text box on the main form just like you said. I kept the on timer event but changed it to If Me.txtMinDate <= Date - 90 Then cmdProcess.Enabled = True Else cmdProcess.Enabled = False End If...

Not sure the On Current event is what i should be looking at. When the subform is queried, the current record will be record 1 If the process date does not match the first record returned in the subform, but the second or third records do, will the command button be enabled or disabled using...

I get runtime error 438 when I open the form using this method Object doesn't support this property or method

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

This on works "ToPay=No AND Method= ""Cheque"" AND DateUpdated=Forms!ReportDates!txtFrom"), 0) Thanks dkinley!

Nearly There! I don't get the error now but the value returns Null

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

Think I was going about it all wrong! Chaned my Code to: Private Sub cmdUpdateAttend_Click() If Me.frAttendance.Value = 1 Then DoCmd.RunSQL "INSERT INTO Absent (DancerID, ClassID)" & _ " Values (Forms!Attend!DancerID, Forms!Attend!ClassID);" End If If Me.frAttendance.Value = 2...

OK - I changed all the names of the variables prefixed with i=integer, s=string etc. Now when I click update, I am prompted to enter values for all fileds. Why is this?

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

Genius! Much Appriciated.

Its a bound form

Thanks mlai, any idea what code to use? Thanks

Would that only work if the form was closed after the record was entered? or can you enter multiple records. Any help with the code :)

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

Thanks V-Much! Good example. (unlike my Town, County saga)

You're probably right about the County field neileg - I would still like to know how to autopoulate fieds when selecting data from a drop down menu. Town and County was the first thing I came across to experiment with.

It makes no difference in my case as the area is very small.

Thanks DCrake for the speedy responce - You can probably tell that I'm new to Access - I can't seem to find an After Update property anywhere on the Lookup properties in Access 2000. twoplustwo - The DB is for a Dance School. It doesn't have products as such only students who live locally...