Recent content by access4me

Unfortunately it's bad news :( My employer has said I can't even use Access - It's only Excel or Google sheets.

This is exactly why I want to move away from Google sheets as it would be very time-consuming to protect a range from each individual. I feel MS Access is the real answer. I appreciate that your still learning. I'm very surprised that no one else more experienced has stepped into this debate...

Think of the LOCAL LEAVE PLANNER as an unofficial diary. It's simply there to keep a track of how many staff are in and how many on leave. Whilst the HR LEAVE PLANNER is the official diary and is ONLY used if the person has actually already taken a day off. The structure of a LOCAL LEAVE...

Currently there are 2 separate systems, so the LOCAL LEAVE PLANNER is done on a spreadsheet and the HR LEAVE PLANNER is on a specialist website dedicated to putting your leave through, but let me be clear that neither have anything to do with each other, so you don't need to put anything in the...

I think I need to explain how our leave planner system works. Basically we have two leave systems. First one is like a "WITHIN DEPARTMENT" version, so it's called a "LOCAL LEAVE PLANNER" and second one is like the type you mentioned that goes to HR, which is respectivaly called "HR LEAVE...

Can't the excel formulas be converted to access?

Here is the google sheet which is editable:- https : // docs.google.com/spreadsheets/d/1nklSplFWG1UFqs81TnWpKFTfnDZSY_KAUvn-Lx1JC7I/edit?usp=sharing

Hi Doc Man, I'm not sure about outlook, but we all do have a shared folder where we can place files/folders for others to view/edit. Definitely not sure about Exchange Server. I appreciate and thank you for your offer of willing to address any issues to directly with our IT department, but...

Thanks Ranman256. Unfortunately I'm not sure if this is a feasible option as splitting a database and give chunks to each employee may go against their security policies and also windows is locked down by IT department, so not sure if it would pop up with username/password request and also I'm...

Hi everyone, I'm totally new to access, but looking to learn it as much as possible. Basically the reason I've taken interest in Access is because I'm trying to create a leave planner for employees that they could enter and book. I've already done this in excel and google sheets, but the...

Hi everyone, What a great forum! I've used access over 15 years ago, so I don't remember anything. I want to create a staff leave planner database and hope this is an achievable goal.