Search results

Last question - when the query updates the combo box - the box remains blank until you click onto it and select the result - is there anyway to make the combo box automatically display the result of the query instead of selecting it Thanks

Right, I have set up a query which uses the username selected to search the tblEmployee and returns the form to go to. To test it I had the query result returned to a combo box on the logon form and then the code picked up the form name to go to from there. How do I now get the code to pick...

Mailman How do I use a query to set levels of access - for example if the person logs on normally and is sent to the main switchboard how do I use the query to disable functions they do not have access to: E.g If the switchboard has Forms Reports Users and I wanted to disable access to...

Thanks for your quick reply. I did look at example a while ago which used a qury to set access levels on forms etc. Any advice on how I would go about doing this?

I am using a basic logon form on my database which checks the username and password. Originally it then took all users to one screen, I have added in a SelectCase statement in order to try and direct users to their own form but whatever user I put in it still sends them to the old splash screen...

Need some help again, thought all was well with my form but I am getting a runtime error now and its pointing towards Me.cboEmployee.Value on the DLookup line. I have tried using SelectCase aswell and it also halts at cbo.Employee for some reason. Any ideas why this might happen?

Thanks for your help with this one, the second option works perfectly. Very much appreciated Matt

Hopefully an easy one to sort out I am using a basic login screen from databasedev.co.uk which suit my security needs. However at the moment it simply checks user and password and sends those entering recognised details to a single main screen. How can I adopt the code below to send the user...

Can anyone suggest a good way of generating numbers, rather than the primary key that could be used as a unique reference for each record submitted? Thanks to all for your help

I have three questions regarding a staff holiday request database I have created. Hope someone can help! 1) When a member of staff fills out a request form, the primary key is an auto number which can obviously then be used to track a request. I collect requests from 3 locations for now...

I thought this might be the case. Backups it is then! Thanks

I've currently got a database whihc collates staff holiday requests. At the moment it is backed up daily by our main IT dept. Because of the way our network is set up its difficult or at least causes access problems if I alter file permissions. My question is, is there anyway from inside the...

Thanks for your help, works perfectly! Don't know why I initialised Outlook twice, I think its because I've used this code elsewhere to send 2 separate emails and its been left behind Thanks Again

Just a quick one! I have attached some code I am using below - it sends an email summary of a holiday request form using the data from the current record viewed. Once the email has been sent via Outlook I just want a Msg Box to pop up to say it was sent succesfully with an ok button. What...

Thanks for your quick reply Could you tell me how I could edit this code in order for it to check the password against what has been entered into a pop up form - for now called frmpassword? Thanks for your help

I am currently using the code pasted below, it simply pops up a box on click and checks the password entered. Problem is that when you type in the password you can see it on screen. I know on forms there is a password input mask - how can i right this same thing in to code so the typing appears...

Thanks for your reply Has anyone got the answer to sending a form as it appears, rather than as just the data or is the solution to convert it into a report prior to sending?

2 Quick questions, which I hope with have easy answers I have a Holiday Request form on Access which basically looks like an old paper version our business use to use. I have replicated the format on he access form but I have two questions: 1) The form only prints properly in Landscape, but...

This one might be very easy or very difficult, but here goes. Currently we collect staff holiday requests with an access database. The table Leave Request stores the date of request, staff name, start date, end date, total days taken. However the Rota is on Excel and looks very roughley like...

It worked once the exchange server cam back on this morning Thanks