Recent content by NatAccessNewbie

Thank you, I've done it

Where do can I find which column number I need to refer to? I'll be honest I copied that code from my "OngoingOrdersSF" subform because I can click on the Customer ID in that and it brings up the relevant record. Thank you so much for helping! ps. I've just realised in the screenshot in my...

Hi Gasman thank you so much. I've just gone into event properties for my list box and typed the following code in the On Dbl Click but I'm getting an error. "DoCmd.OpenForm "CustomerDetailsF", , , "CustomerID=" & Me.CustomerID.Value"

Hello I've created a database for my customers. Upon opening my database, I have like a homepage "MainMenuF" that shows current orders "OngoingOrdersSF" and unpaid orders "UnpaidOrdersSF" It also has buttons to create a new order "NewOrderF" or to create a new customer "NewCustomerF" I've also...

I'm sorry but I've not a clue what any of that means 🙈 :ROFLMAO: I'm a complete beginner when it comes to coding in access, actually coding in general haha

No that was for my a button on my Dashboard form that opened the new order form on a blank record, which I managed to do. What I'd like to do now is have a button on my Customer Details form that opens the New Order form but linked to that customers record (so it will already have their name...

I'm a complete beginner at this so need more information please. I've located the OnCurrent section on the form property tab and I've opened the code builder which says... Private Sub Form_Current() End Sub I've not a clue what to do next haha 🙈:ROFLMAO:

Wow this forum has been so helpful! Thank you! I just need help with a couple of last things and then its done :) The first thing I would like to know how to do is when I open my customer details form how do I set it up so that the relevant customer's name appears in the header. At the moment I...

That works perfectly! thank you so much :)

Hello I want to be able to open a customers details by double clicking on their CustomerID from my Ongoing Orders Subform. I've tried the code below which opens up the correct form but doesn't open to the relating customer that I clicked on. How do I define which customer's record needs to be...

I've done it! Thank you :)

Hello, I'm building a database that will include VBA for the very first time - eek! Its a simple database consisting to track my customers and their orders. I've used Access for years but never used VBA or macros. I'm hoping someone can talk me through how I place a button on my customer...

Hi all, I'm Nat I'm a sole trader and I've just started to create a database that will help me track my orders and customers etc. I've used Access for 10 + years in my old job but only for manual data entry. I'm now realising that Access can do sooo much more so I've joined this forum hoping to...