Recent content by Samantha

Oh no I must not have refreshed my screen in some time. I will take a look - you don't know how much time and frustration you've already saved me. The lady that normally does this in excel, manually, quit and now I get the pleasure of making sure everyone gets paid. Last Monday was a disaster...

Pat, I tackled the easiest parts first, which happens to be backwards. #3 - Was a simple resolution went with InStr; and I saw a similar example but kept trying to throw in a * for good measure. #2 - again I was working backwards and was trying to pull in a total before the crosstab qry...

Good morning, I have been working to create a solution to get our payroll from our time keeping app, build a report to review, and prepare the data for upload to our payroll processing company. My specific questions today (or this moment): 1.) On the report when I replaced December dates...

Pat - sorry to throw you for a loop. PTO is not included in the calcs but otherwise its simply anything over 40. We are a federal contractor, comply with Beacon Davis (certified payroll) private corp- non-union in Maryland. Tell me your in California? They are their own country :-) with lots...

Thanks for your time and direction, I will try and dig into this!

Hello, Thanks for all the replies! Hope everyone enjoyed the holidays! I had to take some time off and not check my emails. I am going to try and effectively respond. Love programmers! You're all so detailed oriented and want to get into the nitty gritty. The legal OT rules in my state is...

Thank you for all of the replies! I am attaching a pdf to try and illustrate/further explain in hopes of direction. Multiple employees, over weekly pay period Mon - Sun. I could create a feed to access through a link to an excel data sheet. I don't need access to remember/store the data so...

Hello, I want to determine if Access can automate some of my Payroll woahs. So my example table is what pulls out of a timekeeping app. The first column is an employee ID; so we are looking at one person. The last two rows from 12/01 was originally one line that I have manually split into...

For anyone searching: I resolved by deleting the normal.dotm file from AppData/roaming/microsoft/templates and forcing Word to recreate the file. I came to that conclusion from the below link. How to unblock macros blocked by Office 365 - Microsoft Community

Hi All, I'm back for more advice. I've got my database up and running and it has been for a long time. Haven't made any recent changes to cause an error. Running split DB - back end lives on the server front ends (accde) live on users c drive. I am on Office 365 subscription on semi-annual...

I suppose my first and second points Ive talked myself through. I just want to be reassured that I am not way off base. 2a I have the structure part covered and can proceed without fully thinking through the end result. As much as that is opposite to my personality I suppose I will live. #3...

I currently have an HR database which contains as you would imagine employee information. It also contains training records, and most recently I am adding wages and raise history. My questions are more related to the attached pdf. We use this excel sheet internally for payroll and we use...

It works for the purpose of determining length of service and in a year/month format. Sometimes its hard for a novice like myself to really understand what is going on with a complicated db like yours making it intimidating to use. For me its hard to determine which pieces go together. I am...

Thank you Arnel, much appreciated. I went from #Type! error to a #Name! error which ended up being me naming the module the same name as the function which now I learned you cannot do that. Once I ironed that out works beautifully. Pat, I will need more time to dive in and understand what...

Thanks Pat I will check that out too.