Search results

Thank you! That seems to have done the trick. I don't know why doing that didn't occur to me.

I have form that can pop up a second, modal form. The modal form contains about 6 subforms. Everything was working peachy until this morning. Now when you hit the button to call up the modal form, it asks me for all the parameter values for all the master/child relationship fields for all the...

Thanks for the tip, I ended up storing both the "time" as well as the duration in minutes in my table. Storing time durations seems like such a common need I can't believe there isn't a more elegant way to do it, but at least it works now. Thanks!

I have a table that stores time worked by number of minutes. I want to display those times for editing, but of course I don't want to show the user a number of minutes, I want to show him times. But then I also want him to be able to type in a new time in HH:MM format and then store it back as...

I swear I saw this on here a few weeks ago but I've spent the last 2 days searching for it with no luck: I want to make a form with several subforms that can be expanded / collapsed in the traditional + / - method. I could have sworn I saw an example database posted here that did exactly that...

I have one form that is opening extremely slow, I'm trying to troubleshoot why and I'm looking for some general info. The form contains 4 subforms and one thing I'd like to do is keep the subform on the main form but not load it, so that I can keep stuff on there but diagnose if any of them are...

No, they don't get paid by the minute, but they need to keep accurate records of who did what, they get paid on the 1/4 hour. I have it all worked out now, thanks for everyone's help. I wrote some functions to fluidly convert times into Integers (number of minutes) and back again for when I...

That is how I am currently storing everything, though I question whether I am storing everything in the best format. TimeIn/TimeOut are stored as "Short Time" as I said and adjustments are stored as number of minutes as Integers. Should I bail on the Date data type and just convert everything...

True, they do need to know the date the work was preformed, however that is linked with a FK to another table that holds data for the day (as I said, very convoluted). Certain adjustments are made at the "per-job" level, others at the day level, and still others at the week level, depending on...

Currently? I'm not storing them, they are being entered as TimeIn and TimeOut and then stored as Date data types formatted to Short Time. I calculate the actual intervals as needed for display, but I've begun to run into problems adding up various intervals for various reasons. This is all for...

So I should convert everything to minutes then store that value as text? That seems like a good idea...thanks.

I have a payroll system that is dealing with a lot of time intervals as opposed to an absolute time (ie; 8:30 is 8 hours and 30 minutes, not 8:30AM) and I need some advice. I've searched this forum a lot and read this: http://www.mvps.org/access/datetime/date0009.htm Which seems like it would...

Yes, of course! Thank you, that did the trick. Amazing that one can stare at that for 45 minutes and never actually "see" what the problem is.

I have a query that if run alone, returns the records I would expect. However, when I bind a form to that query, I get no records returned no matter what I do. Is there any reason this would happen? My other forms bound to different queries work as expected. The query (the hardcoded date is...

It's funny, since today is Thursday I'm running into the issue you mentioned, it's giving me yesterdays date when what I want is next Wednesday. I have the same issue when I use the DateAdd function you suggested. But you are correct, I am trying to find the next occurring Wednesday.

I've been developing a payroll problem recently and it started blowing up when it was 2009 but the next payroll ending date was in 2010. I abandoned what I was using (it had other problems) and recently went to the DateSerial function, but I feel like it will have the same problem: Public...

Thanks for all the replies. In the end I think I'm going to just keep all the raw data (without totals), and then have another table of the manual overrides, if any. This will allow me to keep all the raw data should it be needed, easily pull out the most recent override, and keep an audit...

Let me try and explain better: My problem is that I have values that are *sometimes* based on underlying data, but sometimes they are not. There are additional values that are *sometimes* based on that first level of data. So: Level 1: Number of hours per job per day Level 2: Total of Level 1...

I've been pulling my hair recently with table design with regards to values that are sometimes based on other data but sometimes not. The problem is this: the company I'm consulting for enters in the hours each employee worked on each job. The total hours for the day is sometimes accepted as...

Oh I love you guys, it works perfectly now. Thanks so much.