Search results

Thanks Again Bob Thanks Bob, your sample really helped me understand some issues I was having difficulty getting my head around. I've managed to get 'frmSelect' to open my report with the employee name as criteria, however I can't seem to get the date filter to work. Would you mind having...

Thanks for you help Bob Sorry I should have been more specific; I want to select the criteria from a combo box and Microsoft Date Control on my form 'DateTrainerPicker' I would like to run the 'TotalHours' query with these criteria and then preview the 'TotalHoursByDay' report based on the...

Thanks for this, where do I place the code?

Hi All, I have searched for this on the forum and found a few threads on the subject, however I still can't seem to get this to work in my database. I would like to view a report 'DailyLog' based on criteria selected on form 'DateTrainerPicker'. I would like to search by employee name and/or...

Hi all, Is there any way to set the preview of a report so it appears as a two page view and to fit? Many thanks Cathal

Thanks boblarson This was exactly what I was looking for. Thank you for you explaination as to why the original code wasn't working, always nice to know where I'm going wrong for future application. Also thanks to Adam for your assistance. Cheers Guys

My Database I have uploaded my database that someone might take a look at it and assist in preventing the updaing of the start time. I have tried a few different combinations of code in the On_Current of the form but to no avail. You help is much appreciated. Cathal

Thanks Adam Agains Thank you for your help Adam, I have done as you suggested however this doen't seem to work. The button is no longer active at all, even on a new record with no value in the Start Time field. Can you help? Cathal

Doh! Thank you for you quick response. But I'm a but of a newbie and don't really know what to do with the code you have given me. If you could advise me where place the code I would be very greatfull! Thanking you in advance Cathal

Hi All I am working on 'daily register' database. I have a form where user presses a 'Start time' button and it updates the form with the current system time another button updates the finish time and the total hours for the day are displayed in a text box. Is there anyway that I can stop...

Probably Best thanks for this Pat, I was thinking that this was the case, I was hoping there was an easier way than restructuring my whole database. Probably best in the long run though. Thanks again

Thank Neileg I've been able to attach to my previous message now.

Yea I have a linked table for every employee, which isn't good! The DailyLog Table fields are Trainer TodaysDate StartTime FinishTime I would like to create a relationship with Employee Table EmployeeID (KeyField) TrainerName Client and from Employee Table to Clients ClientID (Key Field)...

APPEND Query Thanks for this Namliam If I use an APPEND query to create one table instead of many linked tables, can I also create a relationship?

Each employee has their own database containing a table of log in and out times. The main database links to that table in each of the employess databases, a UNION query compiles all these tables. Is it possible to have a create relationships with linked tables?

Hi Everyone I'm not too sure if this request is a query issue or not so please excuse if this is posted in the wrong section. I am creating a database that picks up the start and finish time of each employee and displays the total hours worked by day and week. I would like to be able to...

Great! Thanks! Thanks for this your code worked a treat. Eaxctly what I was lookin for. An just in time 2! Cheers every1! :)

Still not successfull Thank you for your responses. Howver, this still doesn't seem to give me that results I am expecting I'm probably setting up incorrectly! I have a table containing the following: Log ID Trainer Today's Date Start Time Finish Time I have created a query adding another...

Hi All, me again, now that I've got over the working hours hurdle I'd like to sum by week. I'm quite new to access so please excuse my simple questions. My fields are: LogID {EmployeeID&Now()} EmployeeName StartTime {date&time} FinishTime {date&time} I have created a query to give me the...

Thanks for you help thanks everyone for your assistance and explainations to help improve my understanding. The [finish time] - [start time] - 30/60/24 worked a treat as staff will never be working past midnight or over two days, well not at the moment anayway! Thanks again All! :D