Search results

Maybe it is not your DLookup that doesn't work. Could be the Not Is Null .... If Not IsNull(varX) Then Try If Not Isnull(varX) or varX Not "" Just a thought .......

Hello Ken Yes, I could do this but I thought it might take longer. Now that I have things working, it seems to drop the tables and recreate them very quickly which is good. However, I am not sure what effect this has on memory, bloating of the database etc - do you? Obviously, I'm after the...

Thanks - taking out the Exit sub certainly did the trick! Can't see the wood for the trees! The reason I am making tables is to refresh lookup tables that I am using. The lookup tables are updated in an Oracle database and to use these tables for combo boxes for forms is very slow. When user...

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

Thanks everyone for all your help on this. KKilfoil - I've taken your advice and downloaded the database from lebans.com. It's exactly what I need and is perfect. Thanks so much for recommending this.

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?

Think I've sussed it. On the after update event of the discipline field I've added in a 'me.refresh' and seems to do the trick.

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

Just thought I'd update you on the reason why this was not working. Although I'd called my subform "frmSPECIMEN", because it was linked to the patient form, the name given by access automatically is "frmSPECIMENsubform" (can tell this by looking at the properties of the subform from the patient...

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