Recent content by Shingouki

I have an access application front end running on a network drive. The back end is seperated from the Front End, and each user has a shortcut to a batch file that copies a local version of the front end to each users terminal to ensure they are all working from their own local copy. These users...

Just change the code to this in your select expression. if Time >= #08:00:00# And Time < #18:00:00# GetPeakPeriod = "Day" else GetPeakPeriod = "Evening" End If

Perhaps something like this, you could put these three functions into a query *the first is perhaps a bit unnecessary as a function you can just use DateDiff for the total working hours afterall* Function total_hours(t_in, t_out) 'calculate hours worked hours_worked = DateDiff("n", t_in...

Sorry if Bumping threads isn't allowed round here. Just hoping someone can help... The key thing I really need to understand is how do I pass table data into a function in an access module. EDIT ----- Never mind I figured out that what I was trying to do is totally unnecessary, I have...

Sorry about the nomenclature confusion *told you I was new to all this :)*. Basically all i did was create a new module in access, as far as I know the modules in access are written in Visual Basic? when i said VBA that is what i meant... is this wrong? As for the undeclared variables. As...

Hi sorry I should have clarified, the *response* variable is actually unecessary I just used it during testing as I was a little unfamiliar with the VB debugger. I've figured out how to use the debugger properly now so it's a bit unecessary now. As I was not sure how to pass actual table data...

Updated : Code for calculating Flexi Time Information about the way in which flexible hours are calculated is annotated in the opening comments. tbl_timesheet timesheet_no (Autonumber) "Primary Key" staff_member (number) "Foreign key with staff table" date (Date/Time) "Date of Work" t_in...