Search results

It is split form (so form and datasheet), if that helps you. Everyone has been helpful, and it looks like no matter what I still need to call the double-click event for every desired control. At least I know now :D

Not quite what I'm looking for since I'm still repeating code, but definitely much more friendly to read, so thanks! :)

I have a split form where if the user double clicks on any field in a particular record row, it opens a form which lets them edit the record. The below is my VBA. Is there any way to just write the code once and have it be shared by multiple control_DblClick events? Private Sub...

PaymentType is to differentiate whether the payment is for a deposit, or a "normal" payment PaymentMethod is for card/cash/paypal/etc.

Thanks! Dunno how I didn't think to try that.

Okay, I think I get what you're saying here. To clarify it, because the value of D is not stored in a table, but is a calculation, I have no choice but to first create a query to obtain the value of D, then perform another query to get the totals of D grouped by A, correct?

Yes, any fields I expect to be used in searches or filters I have indexed, and I also have a composite index in the OrderDetails table comprised of Order ID and SKU (to prevent things from getting needlessly messy). Query efficiency was my main concern, and it's good to know that I've set...

Just wondering if I can make this more efficient. I feel like overall I've designed this well and left room for scalability, but I figured it can't hurt to have a few experts check it out! Where are some spots I could improve this, or is it pretty solid already?

Thanks June! The issue unfortunately with this method is that I'd need to include each line item on the report itself would I not? The goal for this report is to just have lines with each Order number, the subtotal, the discount amount, and the subtotal after discount, which would each be...

Thanks for the kind words. Unfortunately "dabbled in" is more of a "I know how to make my webpage display VERY basic things in my database", but I'm always eager to learn!

So my predicament is the following: I am trying to get the total of all of my orders (After discounts). But I can't even seem to get the sum of the order totals to add properly. As per the screenshot, each order can have multiple line items (each row from orderdetails is a line item). These...

Hi there! I'm new to Access specifically, though I've dabbled a bit in PHP and MySQL, so I'm hoping some of those skills translate here. I've never thought about Access before, but my girlfriend has a business that gets unbearably busy around the holidays, so I've taken up Access to create a...