Search results

I currently have a database in Access 2003 that I sue to collect staff holiday requests. The back end is on the company server and then there are two front ends. One is for managers wishing to approve requests and the other for staff wishing to enter requests. Like any database of this type...

Thanks for your reply Doesn't the MoveSize function only work when sizing forms etc. I want to resize the actual MS Access window itself to fit tight ot the form rather than taking over the screen - and I want it to be that way when anyone opens the database Any ideas

Hopefully an easy answer to this one I currently have a database which starts up with a form in pop up mode as the form look alot neater this way. My question - how do I make it so the main MS Access window opens in a pop up style to fit round the form which is a square around a 1/3 of the...

Thanks for your reply - I've got my form prefilling now, thanks again your advice was spot on

Thanks for your help - i've got it up and running now

I am currently have a basic LogOn form on my database, when the user selects their name from the username field and enter the password the code runs a basic select query to open their form I would like to change this to a DLookup which will find which form to open based an entry in the...

I have a staff holiday request form in use. Each time they have to fill in their name [Staff Name], Line Manager [Team Manager and their Id no. [Staff Number] They select their name from a combobox but I then want them to click a button 'AutoFill' which sets the value of the Staff ID and...

it would appear that its the DoCmd OpenForm part that causes the problem as the close form function executes correctly Also a quick - how do I get a macro to trigger on opening a Dbase

Thanks Ken When I first launched this database it had a an initial form which came on at startup which just welcome etc. after 10 seconds it would close and the leave form would open. On the thin client the welcome box opened and disappeared after 10 seconds but the actual holiday form never...

Thanks Ken Do you or does anyone know if its possible to insert some code that would force the opening of the initial form and stop the 2501 error occuring

I'm hoping someone has come across this issue or a similar situation before. I use a holiday request system in 6 different locations all with their own front end which is as simple as it comes - on opening the database the form frmannualleave opens in data entry mode - thats it We have Dell...

I am currently using access to collate staff holiday requests, at the moment they enter [Date From], [Date To] and [Total Days] I have been trying to use the DateDiff function to auto fill the Total Days field but it does not seem to work, I am using this expression in the fields default value...

I currently have a Form 'frmLeaveRequest' which staff fill in and submit using a SendObject Function. They select their name on the form from a table 'tblStaff' which contains they name as Surname, Firstname and their email address. The Staff appears as Surname,Firtname on the form but the...

Bob, you've done it again! Many Thanks

I am currently using a database to collect staff holiday forms. When the form is complete the employee clicks the submit button which triggers a SendObject code, which sends a report called Leave Form. The report populates from a query based on the current reocrd number showing on that...

Thanks Bob, working perfectly!

Thats got rid of the error but it now only stay keeps frmUpdate open for a second before closing? If I change the timer to 5000 the form does the same and obvioulsly the text does not flash

Bob I have changed the code and timer as you suggested - it is now coming with an error pointing to the code: Me!UpdateFlash.Visible = Not (UpdateFlash.Visible) saying object closed or does not exist - any further advice?

I have got a form as part of a database which I use as a pop up upon loading the database to warn users of upcoming changes to the system etc. I use this code on the forms timer event to close it and open the main screen after 10 secs. Private Sub Form_Timer() 'On the forms timer event...

Thanks Bob & Mailman Your help has been very much appreciated