Search results

Ok Plog, Thanks again. Please look at the attached picture which I hope it will help to explain the mater more. Thanks Abbosy

Hi Plog Thanks very much for looking into the my post and for trying to help me with it. The calculations aren't done in the table. They are done in the form of the table, then everything is stored in the table. Now I just need to update the data that are stored in the...

Hi There Forum I'm back again with the need for your much appreciated assistance. I have this table "tblPreventativeMaintenance" which calculates when the next appointment for service. Stored in the field "NextDueService". I have three fields in this table. "SerialNumber", "NextDueService" &...

Thanks for the reply Paul This much I know, and if you see the attachment. It picks up the right column head but displays wrong data. The data should be names of cities but it sometimes displays them and most of the time doesn't. Drove me crazy Many Thanks Abbosy

Dear All I have this combo box in a form which picks up data from the table. Auto Filling other records. It fills up 4 records with data. I've set up the column head to "yes" so I can see names of the columns I'm picking up. The name on the head of column shows the name correct, which is...

Hi guys of the Forum I managed with your help to make a new control checks two records and displays the largest of them. You adviced me to put this in OnCurrent() event. It did very well and was working fine until I added a new record that picked up both days automatically (auto fill)...

Great one Paul Thanks very much. It did work perfectly well. :) Regards Abbosy

Hi there Forum In my Form I have an "Option Group" which has 5 radio buttons or option buttons. The option buttons are there for the customer to pick up number of years to buy extended warranty. I have managed to work out how it works and adds to the existing "DateExtendedWarrantyTaken"...

Thanks a lot for your help Paul It's really helped a lot. Regards Abbosy

Good day Forum :) I have an "ExtendedWarranty" that is calculating ([DateExtendedWarrantyTaken] + [NumberOfYearsExW] * 365) DateExtendedWarrantyTaken =Date(). This is working fine until "InitialWarranty" exceeds "DateExtendedWarrantyTaken". I need your help guys to set my extended...

It is working now thanks to all of you. Much Obliged Best Regards Abbosy

Hi Missinglinq I appreciate this and do agree with you. I know I'm not an expert in Access but I'm getting most of the results with your help. The guys are really fantastic and helpful and I will definitely take the time to learn. I will get there eventually. Thanks again for your advice...

Hi again Paul I asked without even checking the code? So embarrassing. I do apologise. Thanks for everything

Thanks very much Paul One Last advice; In which event shall put the code?

It's in a Form view

Hi Paul I have a "InitialWarranty" record and "ExtendedWarranty"; they are both Date records. I need another field "Warranty" to check which one is larger then to display it. If Access can't find any warranty records in either of them then to display "No Warranty" or to display "00". Many...

Hi Forum I have two date records that I need to check if first one is larger or equal then display the first date, otherwise to display the second in a new record. :confused: Many Thanks Abbosy

Hi Kerrydunk The ComboBox has to have this in the event - in design view > Event tab, which you get to it by selecting the "Property Sheet" in Design tab. This needs to be in the event "AfterUpdate". It goes like this Private Sub Suburb_AfterUpdate() PostCode = Suburb.Column(2) End...

Hi there guys :) I'm trying to set a query with 6 fields. My question is: Is it possible that the query shows me a combo box to select what is connected to this data. :o Example fields: HospCode; HospName; Dept; ModName; SerialN; DatInst I'm looking to select name of a hospital from...

Hi again Paul and NitroN1ck :) I am using MS Access 2013. I was trying to actually find the method you mentioned but embarrassingly couldn't find it. Instead I went to the Event and chose "On Click" and clicked on the event builder. It openned in this new and amazing "Macro Tools". It showed...