Search results

Good morning. I've added your code in and it does work, apart from a couple of very minor things which I'm hoping you may be able to advise on please??

That's super helpful - thank you so much! I will crack on with this right away...I'll reply back here to let you know either way. Thanks again!

Yes. The query that runs this form pulls data from the Wholesaler table, which has a field that denotes which type of media (Fax/Email) the company wishes to receive. So instead of generating a number of Faxes or Emails at the end of the order checking process, the preselected media would...

Apologies...I'm a bit confused here...would it just be a case of copying the above code into the AfterUpdate event of the tick box?? If so, how would that work when the user is pressing the Fax or Email buttons? The overall idea for the DB is so a user can go through orders one by one, ticking...

Hi James, Unfortunately that didn't work!! :( I put it at the end of the procedure (along with rs.close and SET res = nothing), right before the closing End Sub.

Hi there - thanks for replying. The form is bound to a query which pulls in data from two tables, one with order and customer information and one with wholesaler information on it (ie where the order is going). The way I need the form work is to be able to view the orders that need...

Ha, ha - yeah, you can't beat it!!

Hi James, I'll give that a go...thanks. How'd you get the Maggi Gravy connection?! :)

Hi all - apologies if any of the following is unclear, I'm just starting out on my VBA career and my boss/tutor is away from the office today!! I have created a form which is used to check transfer orders placed on another form elsewhere in the database - once the user has checked the order...

Hi all. My name is Jeff, and I'm a DBA from the UK - will mostly be on here bugging your more experienced members for their boundless knowledge! Look forward to chatting with you guys. :D