Recent content by annaisakiwi

Thanks everyone! I'm working through the changes / suggestions now

Hi all I've tried to replicate code from another database, and feel like I'm going in circles. In the attached - using Form1 - I'd like the user to be able to select different options and select Search. It's been many moons since I've used Access - and I'd appreciate anyone having a look at...

Thanks again... I've done some tidying up with my naming - and played around before getting your response and got it working... on one list box. Can I just copy and change the names in the code for the second list? This is what I have now: Private Sub cmdOK_Click() Dim db As...

Thanks Paul - I've been enjoying looking through all the posts on here - have been so much help to date! this is the first time i've needed to start a thread thou.... I am very stuck.... this is totally confusing me! Now my open report button isn't even working... I'll attach a copy of my...

Thanks Paul... to be honest i'm a bit overwhelmed by all that code - but I will have a go!

Hi guys I havn't been using access for quite a while - but jumping back into it. Hopefully someone can help - I'm not too familiar with SQL or VBA at all.. I have a form with two list box's first one: Access Type Value List, "Direct Freight Web"; "Tikitour" second one: Status Value...