Recent content by FlagDay1987

Thankyou

PS do either of you know how i could put a password on the button so that only certain users can use it?

Thank you arnelgp, It's good to see two different methods!

Thankyou Minty, That worked. I don't understand why though if I'm honest. What does option explicit do?

Hi there, It is : If Forms(frm_PatientPlan).frm_PatientSchAll_subform.Form.InvoiceCode.Enabled Then Thankyou!

Hello, I have also posted this in Command button error (accessforums.net) (I've attached the database that I'm talking about below) I have added a command button to the form ‘frm_PatientPlan’ called ‘Disable/Enable Invoice Code’, which works on a field called ‘Invoice Code’ that is on its...

Thankyou. I may need some time to read through, digest and contextualise what you have suggested. This is taxing my brain somewhat!:)

Hi CJ_London, The form with 'D_Pete' etc on is the frm_pat. I thought it was a subform but maybe not. I built it separately then dragged it onto frm_stud and added the link fields. Do i need to do something different to make it a true subform?

Thanks Pat, I've tried that and used the builder to make sure i get the spelling correct. Then I've opened the But I've opened the main form - frm_Stud, then opened the patients (frm_pat) on the Diabetes stud, then when i try to expand the patients to see the appointments (frm_appts) i get...

I'm afraid I'm doing something wrong or misunderstanding. The form i am working on is called frm_appts. The combo box within this form has a row source query as below. It's parent form is frm_pat and i have put the StudyID_FK on that form. When i run the query it is asking for the parametre...

Thanks Pat, Does that go in the row source query of the Appointment combo box on my frm_appts? If so, i can get it to work. Also I forgot to upload my database. The parent form of frm_App is frm_pat (ie patients). Am i right in saying that frm_pat needs StudyID_FK on it?

Hi Pat, I've given this some thought and I think I need to implement your suggestion. Study is a parent of Appointment, and Appointment is a parent of Activity. Therefore I would like each appointment to be specific to a study and an activity be specific to an appointment. At the moment when I...

Thank you Pat. I will have a good read and digest your advice :)

Ok thankyou CJ_London. I will take that on board. The free advice is certainly appreciated! Just out of interest, if I was to post the same question on two or more fora and posted a link to each other, would that be regarded as acceptable? The reason I ask is that I have received differing and...

Ok thankyou Gasman. I was unaware of that etiquette but i will regard myself as told (y):). I shall do that in future. I assumed the community was so vast that it was unlikely that the same people would read the question. Fortunately I have received good and differing advice from both. Plus i...