03-29-2012, 07:59 AM
Thanks Ed,
That is one of the interesting things about Access. You don't need to save the data. Once entered, it stays entered! This can also be a problem though, as if you make a mistake, you can't just back out like you would in a 'normal' programme. If I ever need to do any development work I always make a back up of the current copy first.
In an earlier version of the database, any of the look up fields would refresh the list as soon as it was closed. So, if you did add a manufacturer, it would appear in the drop down list without the need to exit the main form. However, in the process of adding in the find as you type feature this was lost. I have been unable to figure out how to restore it.
However, in reality, once you have made a list of all the manufacturers and added them, this isn't such a big problem. Same with tool locations, you add a new one when you get a new tool box or peg board etc.
I'll look at updating the manual but I have to set some time aside, as I have lost the Word document that I used to create the pdf
That is one of the interesting things about Access. You don't need to save the data. Once entered, it stays entered! This can also be a problem though, as if you make a mistake, you can't just back out like you would in a 'normal' programme. If I ever need to do any development work I always make a back up of the current copy first.
In an earlier version of the database, any of the look up fields would refresh the list as soon as it was closed. So, if you did add a manufacturer, it would appear in the drop down list without the need to exit the main form. However, in the process of adding in the find as you type feature this was lost. I have been unable to figure out how to restore it.
However, in reality, once you have made a list of all the manufacturers and added them, this isn't such a big problem. Same with tool locations, you add a new one when you get a new tool box or peg board etc.
I'll look at updating the manual but I have to set some time aside, as I have lost the Word document that I used to create the pdf
Hunting American dentists since 2015.