Search results

Hi All I am still working on this issue and I am pleased with my progress. the formulas work although I have still to put them in a routine (haven't quite worked that one out yet) but at the moment they are working on one of the form fields after update event. My issue is rounding up. I...

Hi I changed the name and its now saying Sub of Function not defined???

Hi Moke123 I'm sorry I am missing something. I added the following to an ON Click event and I have a Compile error - Expected variable or procedure not Module. I have created a module called IsValidForm and added the code you gave me Sorry

Hi Moke123 thank you for your input. I have never used functions in modules before but I have put your code into a module I just not sure how to call it. so I put something in the Before update event of the form properties? Sorry to be a pain but I am gaining very slowly!!

Hi Minty I did have a button before and I removed it. If I put an on click DOCmd.close event on the button will the Cancel = true then cancel the event? Sorry I cant try it now I have left work but I will try it first thing. Thank so much for your help, I have to have it up and running by...

Hi Minty Thank your code works better but after the initial message about missing information I am still getting the 'You cant save this record at this time - do you want to proceed anyway option' I need to stop this and just return to the initial form to complete data entry.

Hi Cronk thank you for your reply. I am sorry but although I understand the concept of using the module I don't know how to create a separate routine, I have been looking on line but I haven't found anything that not too in depth, can you point me in the right direction please?

Hi I have an input form that collects attendee details and need to make sure that each field is filled in. I have used the code below on the before update event of the form but when I try to close the form, the message box works and when I click ok I have the you cannot save this record at...

Hi Thank you for your help in this I am nearly there, I have walked it through as Mark suggested. This is my code and it works fine now: Private Sub cboRoom_Type_ID_AfterUpdate() BIO_Room_Type = Me.cboRoom_Type_ID.Column(1) BIO_Room_Cost_Per_Hour = Me.cboRoom_Type_ID.Column(2) BIO_Vat =...

Hi Mark it is in the after update event of each of the fields - BIO_Start_Time, BIO_End_Time and BIO_Number_Of_occurences.

Hi I am using the line below in my vba but it is not working for the minutes, eg half hour etc BIO_Total_Duration = (DateDiff("n", [BIO_Start_Time], [BIO_End_Time])) * [BIO_Number_Of_Occurences] / 60 the code used to work when it was in the underlying query of the form.

thank you Mark - this would be a great help, the more the company relies on this database the more concerned I am that it is not robust enough.

I have added information to Company booking BT John. the first time I add a room type works fine but the calculated fields on the after update event eg Vat rate in the table will not update if the room type changes

I have looked into this and think it is because the total fields are calculated in the table. I cannot find a way to change these, so I need to leave them as calculated in the table only? I only wanted the calculation all in the sub of the after update event because they were all in one place...

No its not locked and its enabled. It works first time but the second time (if the room changes), the error comes up with this line highlighted: BIO_Sub_Total = BIO_Total_Duration * BIO_Room_Cost_Per_Hour but the room cost per hour does change, its the other fields that don't, they are all...

Hi I have tried your suggestion above and in the after event of time fields and number of session fields I have put the datediff for the occurrence which is working fine. I then put the following in the after update event of the room type selection combo: Private Sub...

Hi Mark I had put the calculations in the query the sub form was based on and then added the following to the after update of the room selection combo to send the form information to the table. Private Sub cboRoom_Type_ID_AfterUpdate() Me.BIO_Room_Cost_Per_Hour =...

Hi I have put sent the following values from the form to the underlying table: time duration discount rate vat rate would you send the other calculations such as sub total, vat total and amount due to the table or because I have sent all other values there, calculate them in the table too...

Hi, sorry Mark these are the calculations I am using on my form at the moment, what do you mean by sub? BIO_Total_Duration: (DateDiff(“n”,[BIO_End_Time]-[BIO_Start_Time]))*[BIO_Number_Of_Occurences]/60 Sub Total BIO_Sub_Total...

Hi Thank you for your replies. Mark I wish I had your reply sooner, we have had price changes which is why I had to relook at my set up, I did such a major workaround, as in IFF calculations everywhere for before the date and one for after the date of change - headwork!!! Next step: To store...