Recent content by smally

It never occurred to me to use a report. It doesn't matter anyway. Using a report, even without the aggregate data the info doesn't update after the changes are made in the dialog popup window

I've discover that the continuous form did not refresh because it was linked to a query which used COUNT and GROUP BY. If the query does not have this, the continuous form would refresh as expected.

I have created a Continuous form and locked all the fields from editing. Each row has a button, the button opens another form in a dialog window so the data can be edited. The issue I'm having is when the user updates the data in the dialog form, the continuous form does not update. I have...

I've used this and it works as expected Function MakeTables() DoCmd.SetWarnings False DoCmd.OpenQuery "qmakExportTrainingMatrix", acViewNormal, acEdit DoCmd.OpenQuery "qmakExportRequirementsMatrix", acViewNormal, acEdit DoCmd.OpenQuery "qmakExportLGVMatrix", acViewNormal...

My medical table fields are: ID - autonumber MedDate - date of the medical EmployeeID - foreign key to the employee Result - satisfactory, sub-optimal, unfit Type - full assessment or review Using the function on a medical review it would give an incorrect date if the review was satisfactory...

Hi. I'd like a bit of advice for how I need to design my database to log medical information for my employees and calculate their due date(s) for another medical. Each of my employees are required to attend a medical assessment for them to work on a construction site. The medical simply covers...

I've yet fully get my head around how VBA and Access work so my efforts are not great. The best I've done is create a macro that performs 6 OpenQuery commands. But this method doesn't hide the 3 warning messages. Which means I have to click yes 18 times. I tried your method but I get a debug...

Hi. My Access DB contains 6 make table queries. I use these to create/overwrite tables to a different access DB. The different DB is stored on a shared network folder which is based at a different office, so every time I run one of these make table queries it has to go through the internet...

Thanks, that works perfectly.

Still not working. If parameter 1 is null, and 2 is not null, the result is null.

Hi, I need to use a function that works out the earliest date from different fields. I'm currently using the following code provided from a Microsoft webpage: Function Minimum(ParamArray FieldArray() As Variant) ' Declare the two local variables. Dim i As Integer Dim currentVal As...

Thanks CJ, that works. I always stumble when it comes to using sub-queries. I changed IsLGVDriver to true for it to get list what I wanted (active drivers that are missing the category 6 requirement).

Hi, I have a database which keeps records of employee's training they have done. It also keeps a record of which training is required. In my employee table is a field which is a yes/no called IsLGVDriver. This is to determine whether the employee is a truck driver or not. (LGV = Large Goods...

I've chosen to use DepotID only because I am wanting to sort by the ID, but show the depot name. And in my full database I have more fields that I may eventually want to sort/filter by. Since posting those pictures I have realised that the sub-query doesn't need to know about tblEmployees and...

Brilliant! I think I've done it properly. This is what I tried: and: Thanks for your help.