Recent content by MHO

I can't thank you enough. This was a source of great stress the past few days. I did realize another mistake...and that was if the result was "true" I did not subtract the [Shift Start] date/time from the [Shift End] time. Was a simple fix, and the resulting formula was this: Hours: ( IIf(...

That's good to know, but I am in the US and my settings are for English

Can someone tell me what is wrong with this? I put it in a query, and get the message: Syntax Error (comma) in query expression...... Hours: (IIf(timevalue([Shift End]) < .25, ((datevalue([Date]) + 1) + timevalue([Shift End])) * 24),(datevalue([Date]) + timevalue([Shift End])) * 24)) -...

Thank you. Looks interesting. I will check it out.

I am trying to create an employee schedule.....with start shift and end shift times. I would like to utilize a list box that starts with 12:00 AM and lists the time of day in 15 minute intervals, and in 12-hour clock mode. I would then like to know the difference of the start shift and end shift...

There must be at least 7 forms available at any one time. You can't just make up Friday's schedule and not expect changes to it. If it's not there, you can't change it. On top of that, it would be difficult to calculate hours scheduled and so forth. I'm not even sure I am settled on this idea, I...

I would like to know if it's possible to have a control on one form or a switchboard create an entirely new form or forms, basically copying it from an existing form, but renaming it as well? I'm trying to create an employee scheduling program, and the form I want to copy would be one day out of...

Thank You! I have figured it out. I was receiving an error message when I first entered in your formula, but I sub'd the myvalue with id fields (in the criteria section), and now it works like I envisioned. Thanks again. One headache down.....

I really appreciate the reply. Can "SomeValue" be a field in a table outside of the query. In other words, my function looks something like: =dlookup("rank","querytablename","querytablename!id"="tablename!id") I set up a "relationship" between the id fields in the query and the table. Not...

On top of that, and more importantly, it appears that I cannot enter new information in a form based on a query. Does that sound accurate?

I don't think I can do that because there are at least 4 other values I want to rank separately based on at least 4 different query results. After some research, I believe I want to use the DLOOKUP function, but I cannot for the life of me get the syntax to work. On top of that, wherever I see...

I have a simple database I am trying to put together. One table, one form, very vanilla. I created a query that ranks values that I enter in a table. I would like to put the result of the query (the rank) next to the value in the form itself. I thought if I created a text box and entered the...