Search results

Well mate I'm fairly new to Access but I reckon if you drag a button onto your switchboard in design view the command button wizard gives you the options, one of which is Miscellanious. In there is a Run Query option. Follow that and you should be away. Hopefully. Cheers, Lol

Right gents, I've had an epiphany and sorted it through calculated controls. I didn't realise that I could put VB code as an event procedure (like I said I'm effectively self taught). This I have done and it works a treat. Thanks for your advice, especially Doug, for the proper syntax for...

To be honest Rich I've tried the query/calculated control method and not got very far. Part of the problem is that as part of the order details per line there is a volume discount to be considered. i.e. if the quantity ordered is a certain ammount then a further discount applies. Whilst in Vb I...

Doug, the code worked a treat! Thanks a lot. However, it only worked on the first record displayed on the subform, i.e. if the order details comprise 3 lines, only the first line is worked upon. I have tried putting in a Do-Loop but this just causes Access to lock up. This loop approach works...

Thanks doug, will give it a try and let you know the result. Cheers, Lol

Hi, new to the forum, wonder if anyone can be of help. I'm currently studying an HNC in Business IT and have to complete a small database in MS Access. My part relates to stock control (surprise). I have, for example, a main form with an embedded subform. The main form contains such details as...