Search results

I want to be able to create some tables in code. I have queries defined to make the tables. Rather than specifying each query to run, I would like to be able to create a loop to execute the queries with names that start "qryMAKE". In this way, if more tables are added later on, I do not have...

Does anyone know if there is such thing as a calender date picker which displays a whole year rather than just a month at a time? If so, can you tell me where I can get hold of one? This would help me very much. Thanks. Heather

My task is to create a capacity forecasting database that can calculate how many patients a doctor is likely to see in any given time period. A user will be able to define an event and say the occurrence of that events, ie Clinic A occurs every Tuesday. Clinic B occurs last Friday of month...

I have an image of a 'tick' which I want to appear on my form to indicate that everything is ready for the next step. This appears when the user hits a button. If a user then amends antyhing on the form (which is not allowed as then it invalidates things) I want the tick to disappear so that...

How do you set the number of records displayed in a continuous form? I want my form to be of a certain size and it will only show 8 records. How can I increase this?

I have a combo box which looks up pathology test names based on the discipline selected by the user on the form. Eg a discipline is a 'type' like haematology or biochemistry. The combo field works by using a query as the rowsource and the query criteria specifies that the test displayed must...

I need to use the dlookup function in a subform and just can't get it to work. I have a patient form (frmPATIENT) and a subform (frmSPECIMEN). I want the discipline name displayed when the user selects the appropriate discipline (Using a toggle button of four)...