That would awesome Simon, no rush either as I'm only hoping to roll this out for the next years crop, I might try and input this years data in the winter depending on time.
For the most part it is decided by the Owner/Manager of the farms/business. For example he would receive hand written...
This table was imported from an excel file where I have been doing this logging/summarizing somewhat manually after the spray applications have been completed. I believe access could be much more automated by tracking with the check lists and logging at the same time
Guthion has been...
From what I'm understanding is if I were to create these new relationships (Which would essentially be restructuring everything like DavidAtWork mentioned)
Do I leave the ones I have now intact or delete and go with only the new ones.
I must be really screwing up this many to many relationship...
Ok thanks. I remember at one point I did have Primary Keys defined in both
tblFarmsBlocksSprayed and tblPesticideItems and I couldn't get the 2 subforms linked properly, they would either show nothing or all records from their tables. But then again I might not have understood/setup that...
Ok for some reason I can't even open the attachments in my own thread. Tried using my dropbox to share the file because of the size limits of the attachments here. But luckily converting it to mdb it's under the limit.
Try the one attached this message. Sorry about the inconvienence
Hi GinaWhipp, and thank you for the help
I apologize for not getting back to you sooner.
It was created using 2013 Access. I have converted it to 2003 that is attached.
Hi,
I have been trying to get this database to work, and I thought I had it figured out when all the data was going into its proper places in the tables. But when go to make the reports it’s showing records that shouldn’t be there or at the very least be filtered out.
For an Example: In the...
Hi every one
I'm fairly new to access, have played with it years ago and remembered I would like learning more about it.
I am now working at an apple orchard farms and they are now big enough of a business were they need more data logging. I am fortunate enough to have obtained a position that...