Search results

I have a list of schools for which we manage property projects. Each project has the same default set of related tasks. I want to be able to start a new project for a school (chosen from a combo box) and have set of tasks attached to it. tblSchool Primary Key= EID tblProject Primary Key =...

I need to return dates that occurred between today and the previous 1 June (the start of the financial year). Can anyone help as I seem to be spending lots of time and getting nowhere.

I have a table that holds company information for the user - eg farm name, company name, manager, phone number and email address etc. Its simply used to provide headers for reports, so that the same generic database can be used on several farms. There is only one record in this table...

I have a form based on a table which includes the mid field. I want to have a macro that takes the value of the current mid, and makes a new record in a 1-many related table (consisting of record id (auto), mid and trmntdate), paste the mid and insert the current date.For the life of me I cannot...

Hello all I've been dabbling in Access for years, but at a very basic level. Currently working on a dairy farm daily management system on an 800 cow farm. Its working well, but could work a lot better! Its about to be trialled on two other farms, before hopefully going to a professional db...