Search results

Hi Minty, Point taken. I don't know how i did that unless i meant to put that in the Caption? Anyway i have changed that now. I eventually got it working with this: SELECT Casualty.CategoryID, Casualty.DateOfIncident, Casualty.CasualtyName, Casualty.TradeID, Casualty.InjuryTypeID...

Hi everyone i have been chasing this problem around but still not really there with it. I have a form with a combobox (cboMonth) with the RowSource - 01;January;02;February;03;March;04;April;05;May;06;June;07;July;08;August;09;September;10;October;11;November;12;December On the AfterUpdate...

Right i have sorted it by adding this in the OnCurrent Event of the subform DoCmd.GoToRecord , , acNewRec

Here is a screenshot showing the settings

Hi Arnel, I can but it still displays the first mileage recorded? Let me try again to make sure

Hi, Quick question really. I have this subform on a tabbed form and no matter what i try the form is showing the first mileage recorded for the vehicle whereas i want this form to only be an input form. I have tried loads of different settings and other things but still it wont do it. I have...

Ok so i had a think after i shutdown and realised that i didnt need to open another form in order to change the status of the component. I had been overthinking and over complicating the process! So i changed the 'Status' textbox to a combobox where the user can simply change the status instead...

Hi Bob and thank you, Its not even getting that far now? Its saying it can't find the form referenced. I'll try again tomorrow, i'm off for a bottle of Whisky!!

Incidentally This is the SQL i have tried in my query of the form i am opening (EditMaintenanceComponent) SELECT Maintenance.VesselID, MaintenanceComponent.ComponentID, MaintenanceComponent.ComponentName, Maintenance.MaintenanceDate, Maintenance.Status, Maintenance.Comments...

Once again my senility and early dementia are preventing me from seeing this! After two days just on this pathetic task i am still no-where! I have tried setting parameters in the query that the form to be opened is based on as well as the different lines of code attempting to achieve similar...

Hi Arnel, I have managed to get it working from your code. Thank you once again and thank you for all of your suggestions and help as always

Right, it is saying - Values 1 1 Even though the subforms are both blank? I suspect the query is not filtering correctly?

Hi Minty, I put the debug.print code in and also stepped through the whole lot but nothing really happened? Not sure if i put it in the right place though?

Hello once again, Been trying all kinds of things to achieve this nut so far not successful. I have a main form 'ViewVessel' which has a tabbed form on it 'TabCtl15' in one of the tabs i have two subforms 'MaintenanceListSubform' and 'ServiceListSubform' What i want to do is to mainly change...

Hi Minty, I will see if i can get my head round this now. If you use the bypass key you can get to it all

In the attached DB from the view by status button i need to display the Status in the 'StatusVisible' Textbox and the 'Status' Combobox will be hidden. Two days i have spent and i just cannot fix this. I really am just not clever enough for this shit so will be packing it all in soon. Thank...

Ok, that is it! I just corrected the variable names and this works perfectly now so thank you all SO much! Dim TotHrs As Integer Dim ServInt As Integer Dim ServHrs As Integer TotHrs = Nz(Me.TotalHours, 0) ServInt = Nz(Me.ServiceInterval, 0)...

Yes, sorry for not explaining better from the start. And your second point is correct too. There is a separate form where the user logs the hours. I will have a go with it right now

Hi MajP, The form 'ViewServiceHistory' opens when the user selects the particular component so the hours and ServiceInterval is for the selected component. The service intervals are fixed by law so are rigorously adhered to but that is up to the Boat Team. It was what they asked me to set up...

Hi everyone i woke up with an idea this morning and it worked. So i removed the 'FlagInterval' and 'WarningAt' fields completely. I also removed the '=[Divider]*[ServiceInterval] from the 'ServiceHour' Control Source and inserted this line in the code: Me.ServiceHour.Value =...