Search results

Just wanted to say "thanks" Rich, I got the sum to work in the report footer...probably where it should have been anyway... Noreene

Well, actually I may have something else wrong....I was trying to sum on the page footer. The detail section has the minutes by pickerid and that is correct. So, I tried to sum all the minutes by the page footer.... Sometimes I get an #error and sometimes just the last line number, never the...

Same problem with sum in footer. The numbers are correct in the detail section but when I try to sum in footer it gives me only the number in the last line.... What am I doing wrong? My control source: =sum([earnedhours]) and I am asking it to sum over group (actually I have tried all 3)...

Thank you, oldsoftboss It worked great!!!! Noreene

On double click event I want to be able to pull in data from the previous field into this current record. Could you please give me an answer?

Okay, I think I have found the problem, maybe. In each query that I did and that I made a field that was calculated (expression) for (1)sumofactualminutes and (2) sumoftotaltimelogged, these 2 fields are rounding the number..but since it is a calculated field, how do I get it to show as a...

I have a query that I want to figure efficiency on employees based on time logged in and actual minutes worked. My query pulls in data from 2 other queries where I have summed by ID the (1) minutes worked and the (2) minutes logged in. So, the new query has as its fields, employeeid...

Okay, it's me again. I have a form that when opened, I want it to allow the user to put in their id number that goes to the table that is the forms source. Then when they hit enter or OK, I want it to pull up a form that has only one command button on it (log in) and it time stamps that time...

Thanks Pat, It works great Noreene

I went back and looked at the combo box and I see that I chose the last option, "find a value on my form based on value I select in combo box" I changed it to another option and it seems to be working correctly now. Thanks for steering me in the right direction. Noreene

I used the wizard to write the code: Private Sub cmdnewrecord_Click() On Error GoTo Err_cmdnewrecord_Click DoCmd.GoToRecord , , acNewRec Exit_cmdnewrecord_Click: Exit Sub Err_cmdnewrecord_Click: MsgBox Err.Description Resume Exit_cmdnewrecord_Click End Sub Thanks, NOreene

I have a form that is tied to a table called Log Pending. On my form is Log in, Log out, and Picker ID. I have a button that is called new record so they will not have to use record selector (I will remove these when the form works correctly)..but each time I try to add a new record, the...

Thanks Mile-O-Phile You have been a lot of help!!! Thanks, Noreene

Yes, I am storing data as times only. I have a date field that is formatted as date() And now that I think about it, there is a shift that will cross from one day to the next so maybe my times should be with date... So, if I use this type of format (with date), what would my calculation look...

Dividing by 60 was my first choice, but for some reason it just didnt calculate correctly. Did my equation look correct to you? And yes, these will occur more than once a day, every day...When a picker swipes in to start his picking process, he will login his starttime and then at lunch, end...

Simple for you, but not for me I have a form that includes picker name, login time, logout time When I run a query on this info from the table, i want a calculated field to subtract login time from logout time (military time) and give me the total in minutes. such as: TotalTime...

dcx693 That worked just great and it was simple enough for me to do. Thanks to both of you for your help!!!! Noreene

Thanks Mile-O-Phile for taking the time to answer me...It would be wonderful for me if I knew enough about code to understand that...However, I am very, very dimwitted about code and I just don't understand what to do. I tried to replace Object with Recordset, but it gave me a compile error and...

I still get the same reaction when I inserted this code. It will go to a valid invoice, but do nothing if the invoice is invalid except go to the very first record. I replaced the last two lines of my code with this code...any other suggestion? Thanks very much, Noreene

I have a form that pulls from a table that holds Invoice #'s. I used the wizard to make a combobox to type in the info I want and it pulls up the correct invoice number. That works fine. But, when I enter an invoice number that is not in the table, it does nothing...I want it to pop up a...