ACCESS/SQL needs minor fixes

ACCESS/SQL 1.A way to deselect all customers or show select as a number not yes or no. 2.I can't create a new product without an error coming up. [login to view URL] I try to delete a song product is comes up with an error. [login to view URL] and Unprinted should be in date ordered order. Starting with the oldest. [login to view URL] the OMS startup and operation faster and operate faster over the network. One [login to view URL] a school name can now take a while to start (before it was fine). [login to view URL] backup working, script fails because mapped drive letter keeps disappearing. [login to view URL] stock taking, a note warning if there are any unsent invoice with that component in it. [login to view URL] emails appear in customer search [login to view URL]'t change printer after printed (locked). [login to view URL] adding a new song title to a component, it should automatically put that component code in the CompCode column. 11.A warning when someone trys to change a delivery from the past."Are you sure you want to change this delivery record from a previous day? Y/N " 12.A form that allows me to move any products in a single parent directory to a new SeqNumber. Basically so I can see all the products in that parent directory and move any one of them with ease. [login to view URL] imput (when another person is starting a new invoice) your invoice can jump to another when you add a product.