Search results

So, I have a form where I am saving an average length of time, which we enter manually from another source. For ease of use for the people using the form, the length of time needs to be entered in a format like hh:mm:ss on the form, and then converted to seconds and saved as a long integer...

I'm not sure if this is even possible, but hopefully you all can help. I've attached my relationships. So I have a form for ScorecardSummary. There is a subform within this form for ScorecardItems, which is a continuous form. What I'd like, is a way that when you open the scorecard summary...

Hey all, Not at my PC until the morning, so hopefully I can be detailed enough. I have a customer details form which shows their details. Then an order form with order details, one of which is the customer ID in a combo box. I have a button on the customer details form, which has VBA code to...

I have some VBA I've written for my form, which prevents the record from saving until the user clicks the "Save" button on the form. If they just close the form, it will prompt them if they want to save with a vbYesNoCancel. The cancel prompt DOES work...sort of. The problem is that if a user...

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...

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?

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...