Search results

Yes of course, I guess I more meant I didn't realize the date/time data type still allowed me to calculate the stuff I thought I needed to convert to integers in order to calculate. Either way, you guys really helped me wrap my head around how Access stores time data which helped me achieve...

Thanks so much CJ, ebs, and The Doc. I didn't realize I could just store times in a regular date/time format with hh:nn:ss and just run the calculations directly without a bunch of convoluted background mess. I tried a few things based on your advice, and my report is now running perfectly...

While I do like the simplicity of this approach, I'm worried about problems when running reports. My total entered value will never be more than maybe 12 hours. However, the problem is that there will be several reports where we further average these. For example, if we're entering their...

I can give it a go for sure! Where exactly in my form or field properties would I put these statements?

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

Sure I'll try to post this sometime in the next few days

Just want to thank you all. While I didn't directly use any of your solutions, your advice pointed me in the right direction to develop exactly what I was looking for, so a big THANK YOU to all of you. PS - If anyone is interested, I'm more than happy to post the solution :) Cheers!

So essentially, an "orphan" table that does nothing but temporarily hold records until I use the append query to write them to the "real" table?

I just took a look at append queries. I don't fully get it, but I'll give it a go later this evening and see if I can get it to do what I'm looking for!

Hi all, sorry to raise this thread from the dead! Some personal life events happened which forced me to give this thread an ol' Irish goodbye. Things are well now, so hopefully you folks are still willing to help me out on this. :) @Galaxiom - Thanks for the example, but unfortunately it wasn't...

Is a temp table just a table with the same columns, and I use it as a sort of cache until I commit the record (and then copy the rows into the "real" table)? Sorry, not the most well versed in Access unfortunately.

I think I understand what you mean...Let me see if I have it right. So I could: 1) Have logic to check if there's already an entry matching InteractionID when I open the ScorecardSummary form. If there is already entries, just display those as normal. 2) If not, change the form source to the...

Almost forgot to attach my relationships

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

Thanks so much, I never really understood OpenArgs, but having my own example to work with has made it all click! :) Cheers!

Thanks for all the replies! I've tried some of the suggestions, but I don't think I'm getting it. Here's what I currently have for when a user clicks the "New Order" button for a customer: DoCmd.OpenForm "Order Form", acNormal, , "[ComboBox]='" & Me.CustomerID & "'", acFormAdd, acDialog I am...

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

The people using this wish to have more of a browser-like experience. So I wanted to prevent automatically saving the record upon closing the window (the form opens in a dialog/modal) and instead they can either explicitly save or cancel the entry/modification, or if they close they're prompted...

The code isn't what's trying to close the form. The prompt appears when you try to close the form. Sorry if I'm misunderstanding something? Wouldn't this cause the update to occur? Or does "On Unload" occur prior to the "Before Update" event? And trapping the event, I'm a bit noob at VBA, but...

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