Search results

Hi everybody, I hope you are all right. I have a couple of questions regarding an access database I have created and that I would like to improve. This database sends e-mails from access trough outlook. This is the following code that uses to perform this action: Dim MyDB As Database Dim...

Thanks everyone! I have managed to perform the function just fine. I would like to add a second question. I have a table where people can upload days on which they have worked overtime. Generally on public holidays some people work, so I have created this table so people can add the days they...

Hi everybody! I have an issue with a query I would like to perform. I have a table with the field 'Hire Date'. I have performed a datediff between the hire date and today. This returns me how many years the person is in the company. Depending on the amount of time, the person will have...

Hi everyone, You have always helped me a lot, so I hope you can do it now too :$ I have a database created in my PC and it is created based on one table that is linked to an excel spreadsheet that I have in my computer. However, obviously when another person wants to use it in their computer...

Hi everyone, for the last two days you guys have been saving my life, hope you can give me a hand with this too. I would like to perform something, that I believe is really difficult. I have a database that has users and passwords to login. This database sends e-mails to a list of people that I...

You all have been great to me! Thanks again Pbaldy for all your help to me and thanks to Pat Too! This issue has been resolved

You are awsome! Thank you very much for everything! Can I make another quick question? I am using office 2010, which was updated in my PC two days ago. I used to use this code with Office 2007 and Outlook used to send my e-mails directly, now it asks me for a permission. How I disable that...

Thanks pbaldy! You are always here to help me. I have changed this part of the code: TheAddress = [Enterprise] to [CODE]TheAddress = MyRS![Enterprise] However, it continues to do the same, it sends the e-mail to the different people, however the wording of the body brings information for...

Hi everybody! I had an issue: I wanted to send personalized e-mails to a group of people indicating how much money they had to refund to my company. I have a table which includes First Name, E-mail, Manager and Amount to reufund. I have managed to create a code which send an e-mail to this...

Hi everybody, Hope you are great. I have an access database and the purpose of it is to track the number of leave of absence people takes in my team for being sick or having to study. I have two tables for this, because at my country people who is studing can take up to 10 days per year for...

Thanks pblady! It worked!

Hi everybody, Hope everything's alright. I have a quick and I believe dumb question that I cannnot find a work around. I have a form for people to complete and after they complete there is a button that sends that info to an assigned user. I wanted that after the fields are completed and the...

Thank you all for your answers. 1)I have created a table with that contains the memo, so if I would like to indicate the access to go there I should put the following? : .body= tables!table1!memo Where "table1" should have the number of the table and "memo" the name of the field where the...

thanks for your reply! If I create a Table with the information I want. Could I indicate the .body property to look the body of the message on that table? If so, how should I do it? Thanks!

Hi everybody! I would like to make a quick question. I have a code in a form of my database that sends an e-mail to the people in it. In the code I have ".Body="; I have written the following: .Body= "Please read information attached." I would like to know if there is any possibility to...

I would like to thank everyone here because I have managed to obtain what I was looking for! One last question (please don't kill me). I have performed some reports, where I have put an analysis, in which I would like to include theree text boxes which each one sums different information...

Thanks Alan for your post. I will close the other thread, the reason why I posted my issue in two places was because I needed an answer. Here Bob could help me properly, however I did not find a solution for my issue so I will continue to ask here and not in the other place. Continuing on what...

Thanks for all your help! I finally obtained it. I am really happy. Can I ask you one more question? I am really embarrassed that I did not bring this up before, however, I would like to know if it is possible the following: this database contains all the people in my company that has...

Bob! You are a genius!!! That worked, it returned me the firgures of each communication. How do I obtain the percentages of this figures? Sorry for asking this, I am really thankfull for all your help! Thanks and regards!

Thanks Bob! Yes, it only returns me one count, I could not make a single query to return me the count for the two comments. I am sorry for my ignorance but my Access knowledge is pretty basic. Is it possible to make a single query to return me the count of both comments? Even more, is it...