Search results

Any pointers where to start?

Thats right, if you download the db you can see the managers allocation. EG they have 180 hours of holiday to take. Looking into it I would have to chnage from the check boxes to an input a number as not all managers work and 7 hour day, some work a 6 hour day one week, a 8 hour day another...

Looking into it I will consume to much of my time and my workstack is big as it is. I was thinking of a quick fix and wonder whether this will be viable. How about using the current check boxes ( maternity, half day etc) and adding some more to the table and amending the 'maths' part of the...

Will do! I'll look into what needs to be amended, hopefully not to much.

Ahhh explains the confusion! Thanks

Unfortuntly it was inherited :s Not to worry, I know of some work arounds which i can include. Are you able to see on my second example the fact I'm not getting an error? Maybe I'm doing something wrong. One the holiday main sheet I'm choosing the employee, then in the right box I am...

:( How many forms queries etc would need to be changed? Alot? Or just a handful? I've attached a test DB with 3 people all having the same holiday booked, I didn't get a warning message?

Very helpful... and that is what i did myself intially. Like i said in my orginal post my company has changed from a daily holiday entitlement to an hourly one. So a employee could book for example 2 hours off. Is there an easy way to lets say getting rid of the half day coloum, changing for...

Ok, the title doesnt do justice to the question but its tricky to capture the problem in a line. Attached is a simple DB that has been created for the purpose of managing holiday entitlment and booking for a small group of people. It also allows you to book appointments for each team leader...

Ok, so I have a workbook with 4 sheets, on one sheet I want to have a button that will sort data on a differing sheet. I wrote some VBA code and it didn't work, so I went back to basics and used the macro record and the code were virtually like for like, I took the code from the recorded macro...

Ok.. can the FE handle multiple users using it at one time?

I dont think the users are clever enough to be messing with the tables. The whole use of the DB is using various forms that have buttons, drop down lists and input bullet points etc etc. There is no direct input into tables or running quieres as its all done from a form end view

The FE BE looks great but I just don't think the users will buy it. They are sales team leaders, not technically minded and it was a effort in the first place to get them to go to a central place. To give them each a seperate FE will mean that either they wont use it... or.... they will...

wanting to try what you all suggested by I have a user using it at the moment... maybe i should design a way to kick them out ;)

Thats fine. If I use the autoexcec that you provided then my current one will be overwritten meaning my current main form wont open?

Thats fantastic. Can i get rid of the start up form so my current form continues to startup and just import the table and log form?

I'll have to check it out when i get home from work. We only have access 2000 here... got 2007 at home

Ergh... I'm mean its not hard to set up...but knowing the users they will it complicated...oh well.. Anyway... if I could a simple clear direction in how to track users then that would be good.

Mwhahah!!! Wonderful... Can mutliple users still access the front end? Or should I create a front end for each person (please not that!!)

What i meant is that there own personal PC won't hold there profile, they're able to log onto another PC and there profile will follow them... we sometimes hot desk here.... I'll look into making 2 mdb's