Recent content by hokiewalrus

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.