Search results

Thanks Paul I think I've cracked it But can't exactly be sure as our Exchange server has just gone down so I can't email - no errors were thrown up in the code though so hopefully it is working as planned

The code for one of the commands is Private Sub Command26_Click() Dim mess_body As String Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Set appOutLook = CreateObject("Outlook.Application") Set MailOutLook =...

Hopefully this should be a quick one to sort I'm currently using two seperate pieces of code via two button on a form to send automated emails to staff. Simply, I would like to only have to press one button to send both the emails at the same time. Is it easier to merge the to pieces of code...

Still needing some help with this one! I'm sure this type of question has been answered before but I haven't found quite the right one. I have currently got staff annual leave requests on a database. Once their request is accepted we have to send an email informin them. I would like to (in...

Thanks for that I will give VBA a try

Not sure how easy this one will be but here goes. I currently have a database which collects details of event effecting our business and am using a simple query that displays events within a defined date range. I have also set an excel sheet which on the main worksheet appears as a calender...

Just a quick one I hope when I have been going through the Report wizard in Access 2003 I get to the layout page and then I get an error saying 'Application Defined or object defined error' and the wizard closes. What causes this error and how can I resolve it? Thanks

I believe he will be listed as a standard user - I'm wondering looking at some other posts whether its a case of his acvcount not being able to create on the network drive

Bit of strange one that I can't work out. We have an annual leave database on a server (G: Drive) - the database is just a simple set of tables and one search form. Staff input a leave request via an InfoPath 2003 form which adds the info to the table in access 2003. All users have access to...

I'm sure this one has been asked time and time again! I currently have a set of staff questionairres each on a different table. Currently when I want to export all the scores for one employee to excel (eventually) I have a macro which runs 7 queries, but each asks for the same criteria (Date To...

What would I need to to set up the force refresh, so that it adds the score in opposite field, I'm a novice at this Thanks

Hi I have a questionairre set up as a database. All the questions are set as fields with yes/no answers from a check box on the form. Once each question is answered there is a score field next to it giving a score of either 0 or 20 which is currently a combo box. How would I set up the form so...