Search results

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.

I've just tried that. It hasn't worked. Still shows 1557 records.

Thanks for everyone's help. I have now received all the join dates and leave dates from our payroll system, an I've entered this into my own database. I've used your query plog. I'm having a small issue with it. If an employee were to join our company, they sometimes supply training...

You have described it perfectly. An employee's training goes with them no matter which depot they are assigned to. But these training courses are provided/paid by the depot the employee works at. I had considered adding a foreign key depotID field in the table that stores training but felt...

Hi Minty. Unfortunately I can't create a new record for them if they rejoin. The main goal of this database is to track what training courses the employee has done, but it also does much more. All of which are always linked to the employee. So if an employee leaves and joins a year later...

I have just over 600 (and rising) employee records, thankfully an employee changing depot is not that common. And this is my first database that I've extensively used so I'm not entirely sure what constitutes as 'too many records' I do however also want to track employee join dates and leave...