Recent content by Bloodlvst

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!