Search results

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...

Thanks for the quick reply CJ_London! I think that I should have named tbl_Appointments as tbl_Cycles instead as it will hold the names of the appointment eg Cycle1 Day1 etc. Point taken regarding about splitting up Cycle and Day. 'Activity required' exists because for example the 'Physical...

Hi Gasman, Can i assume that i shouldn't have posted the same question on a different forum? Apologies if so. I have received useful and differing help from both.

Hello all, I’m going round in circles trying to design a schema to allow me to build a database for a series of medical studies. For each study I will receive an excel table like the two examples below (simplified version of a real one). For now I’m not thinking about how I will import them...

Hello all, I am trying to create a search form which allows the user to multi search and return the result as a query output Using multi value list boxes combined with combo boxes with the ability to not select criteria from every box I've made an attempt but it isn't working very well. I've...

Hi there. I am new to the forum. I'm from uk and have worked with access for a long time, but mainly only with queries (and on sql server ms) and reports. I've started to need it for building a database and creating forms with search facilities. Thanks for having me.