Search results

Thanks for following up on your post! I had the same problem, but your shortcut did the trick! I appreciate it :)

This works for me. I got it from another topic here on the board... Hours: IIf(((([endtime]-[starttime])*1440)<0),((([endtime]-[starttime])*1440)+1440),(([endtime]-[starttime])*1440))/60 Works fine on 24-hr military time

Thanks, namliaM! Just what i needed! You Rock!

both are numbers

Anything other than 7.5 is paid clock. Confusing, I know. Thanks for the help, namliam. I copied and pasted the formula you provided, but now I'm getting "#error" in every row, regardless of shift. I'm gonna play with it a little more... there may be some other way to capture this anomaly.

I have a table in which we put clock in and clock out times for employees that tracks weekend coverage (plus all other relevent ee info). I have done a query that calculates the hours the ee is at work, which is functioning just fine, but in order to properly calculate "paid hours" I need to...

allrighty, then... i made a brand new form exactly like the old one, entered the same code in the afterupdate event, and it works perfectly fine on the new form. go figure. Thanks for the help, guys! don't know why it wasn't working on the other one, but the delete key works just fine. :)

how do I do (or where do I put) the debug.print me.employee.column(2) thing?

i did the trusted location add thing, but nothing changed. I still get the same error msg ( "Procedure declaration does not match description of event or procedure having the same name"). I never had this kind of trouble with Access 2003 or 2000 (ps - that would be HER syntax. LOL)

This is making me nuts. I have scoured this forum, and tried everything I've seen as far as writing this event, but it's still not working. All I want to do is take items in the list of information in the selected row of a combobox and pass it to a text box. I'm stuck with Access 2007, and if...

i would love to, but it has some company-sensitive information in it... If i get a chance tomorrow to make a copy and empty it out, I'll send it to you. i'm on my way out the door right now. thanks for your help!!

Neither suggestion worked, but it definitely has something to do with the links. i had no error messages or misbehavior when it was sitting in the db that i was working in; only with it linked. obviously, i'm going to have to find a way to keep it local. crazy. thanks for all your help! i...

tblWeekend_Coverage no special characters, and not the only table I have with an underscore. the others work fine. Nothing special in the field names, and no spaces.

i already removed all the data in it, so there isn't anything to be corrupt. it's still a work in process, so it didn't have any "real" info in it yet. No probs with the primary key field. i did have the issues when it had data in it, so i get it both ways. i'm about ready to trash the whole...

and yet, i can't find anything wrong with it. and access fails to fix it when i try to repair and compact. just kicks out the error and logs it into an error table. meh.

I keep getting this error whenever a particular table is linked (including after splitting the database): '|' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. I cannot, for the life of me, figure out what is going on with...

Thank you!!:o

this is going to sound ridiculous, but i can't find the splitting utility in access 2007... can anybody direct me to it? i'm not terribly thrilled with the new access. :(

Oh, man. Am I a goof... Yes, everything was actually working correctly, I just made a stupid error. I had it set to Long Integer and what I needed was actually Double. It was rounding, and the amounts were actually rounding to zero. It was working fine most all of the time. :o I feel like...

OK...I'm halfway there... by unbinding the textbox from the query, the formula works fine as posted by Rak. Now, I just need to pass the value to the table. Should I pass it to another textbox that is bound to the material quantity field of my table? Whaddya think is the best method? Thanks a...