Search results

Until now I have used this piece of validation code on my staff holiday from to validate the [Date From] field Private Sub Date_From_BeforeUpdate(Cancel As Integer) If DateDiff("d", Date, Date_From) > 400 Then MsgBox "'Date From' Cannot Be Greater Than One Year In The Future" Cancel = True...

Thanks both for your help Had problems getting it to pick up the default value so just adpated Pauls code Thanks again

I have a button on a form which sends off detail of a staff members holiday request after it is authorised I get a number of forms each week where the field [Accept] is still on it default setting of "Awaiting TM Approval". By button has the following code, what do I need to add so that if...

Thanks for all your help As always its very much appreciated

Apologies It should read: [DateFrom] user not able to enter a date that is more than 12 months in to the future based on system date Thanks

Many Thanks Now moved to Forms

I have got a table tblLeaveRequest which has 3 date fields in; [DateofRequest], [DateFrom] & [DateTo] which are used on frmLeaveRequest I want to add some validation rules to these fields: [DateofRequest] - needs to restricted to dates no older than 10 days prior to system current date and no...

I have got a table tblLeaveRequest which has 3 date fields in; [DateofRequest], [DateFrom] & [DateTo] I want to add some validation rules to these fields: [DateofRequest] - needs to restricted to dates no older than 10 days prior to system current date and no dates in the future at all...

Quick question regarding a staff holiday form I have. Basically the line manger goes into the database and uses a drop down list (field [Accept]) to select Accept or Decline. They then click a button which emails me stating that they have updated the request On numerous occasions they don't...

I currently have a staff holiday database. When a member of staff request a holiday their manager receives an email where the holiday request number (an autonumber in the request table) is the subject. They type this in to their front end and retrieve the request. Is there any way to provide a...

I've been thinking about this problem. If I added the field [Deputy] on the TMNames table next to the correct manager and then added a Yes/No type field called say [UseDeputy] Is it possible to write some code or add something to the form that basically adds the Deputy name to the Line Manger...

Manager detail are saved in a table TeamManagers - this contains a unique id field [TMID] which links one to many to a table Staff Names. The staff are then linked to their leave requests via their unique ID called [LeaveRecordID] - Staff are in table StaffNames and Leave is in LeaveRecords...

I am using a database to collate and send staff holiday requests to their Line Manager. At the moment when the member staff selects their name their Line Managers name is automatically added as an AfterUpdate events based on the table StaffNames. When they submit the form the To: field is...

Going to DJ's comment - what code do I need in the Front end in order to link the tables with a password protected backend. Thanks

Still needing some guidance on this one if anyone can assist at all?

I currently have 6 holiday databases that have their own tables - I am going to move all the table into one Backend database and use link tables in the 6 front ends. My question - how do I keep the BackEnd as secure as possible - obviously simple passwords won't work as I assume they would be...

Thanks RG - worked perfectly

I have a report which is generated from details entered into a holiday request form. However, sometimes I get quick turnaround request where the date of the request and of the start of the holiday are very close. On my report I have fields - [Date of Request] & [Date From] When the report...

I have a holiday request database which uses a Request Form in the front end for staff to enter their request and the tables held on a server for the back end. However, one of our locations currently has a very poor (rural) internet connections and sometimes the request form cannot load...

I am moving my first database over from Access to SQL Server 2008. I exported all my existing Access data using the supplied utility to the server so the backend is now Leave.mdf My question is how do I link up Access as the front end as when I go to link data it doesn't recognise the .mdf...