Search results

Thank u for your reply. Have done what you suggested and now have a combo box to choose either 'woking' or 'manufacturer' here is the code i have put in the on click property and is working perfectly on my form. Private Sub RepairBy_Click() '/By default make all questions invisible...

Hi David, did u get a chance to look at my last message, nearly working, just needs a tweak somewhere but i have no idea what i need to do so if you help me this would be much appreciated Jane

Nearly working but this is what it is doing now. firstly here is the code: Private Sub RepairByWoking_Click() '/By default make all questions invisible Me.DateSentToManu.Visible = False Me.TargetDateForWokingToInspect.Visible = False Me.DateRepairReportRecdByManu.Visible = False...

sorry David but what does mean exactly

I have done this for the following fields (i assume its only these ones that I hide) RepairByManufacturer DateSentToManu TargetDateForWokingToInspect when i opened the form they were not visible but when i ticked the yes/no box, still none of them appeared. I dont know if this has...

Hi David, thanks again for your prompt reply. How do i do this, sorry not very good on access!

i put in the code and when i entered a record to test it, I ticked the yes box for the first question and i assumed some of the questions would then appear. All the questions appear as soon as you open the form. sorry for not being clearer

thanks for your reply. i have put the following code in the on click event for the first yes/no question and it looks as follows but its not working Private Sub RepairByWoking_Click() '/By default make all questions invisible Me.RepairByManufacturer.Visible = False...

I have a form and would like to hide some of the fields based on other fields being answered. For example some of fields on form : 1) is pump to be repaired by woking - yes/no box 2) is pump to be repaired by distributor - yes/no box 3) date sent to manufacturer 4) date repair report...

Thanks for your reply. I am still a little confused. in my form, i have opened the properties box for my field 'followupdate'. do i add in some code in the 'default property'. i have tried adding in '=DateAdd("d",3,"LogDate) but it just errors. Many thanks

many thanks for your reply

Hi, I am creating a database and one of my fields is called 'LogDate'. I have another field that is called 'follow-up date' and i want it to be the value of the 'log date' + 3 days. I have tried using the 'default value' to automate this but it keeps erroring. I have managed to get the field...

hi Bob, does that mean i do need a multifield index created on the two fields thanks

i have done this but it says there are duplicates so it wont save it the data i have already in the table is MainID 2 DrwgNo 1 MainID 2 DrwgNo 2 MainID 2 DrwgNo 3 MainID1 DrwgNo1 MainID1 DrwgNo2 MainID1 DrwgNo3

I just downloaded yr zip file again and deleted all my old forms so i was just left with your 3 new tables. i created a quick form from the sub table and it allows me to duplicate the record, ie i have now have two records with main Id as 2 and drawing no as 1.

I have been looking a bit more around the tables and yes i know understand a bit more. Additionally to what you did i added a multifield index for the MainID and Drawing No in the Sub Table was this correct?

Hi Bob Thanks for working on the tables. i have looked at the attachment. i dont really understand how the tables work (i guess thats because i am so used to look ups). i cant see the drawing no sequence in the sub table. i am very confused now. sorry to be a pain but can you help me further please

Cheers Bob, i look forward to hearing from you

i have zipped it so hope u can open it ok, many thanks

thanks Banana