Search results

Hi everyone, hope you are great. I was looking for some advice. It turns out that I have a pretty good "tool" in excel that basically whats it does, you enter information in the cells and returns you a number based on a calculation. This formula contains a simple "IF", if there is an "X" written...

Thanks Pat for your help! If it is not too much trouble, how can I do what you have said before. Should a create a query with the field Leader and count? Sorry but I'm a little burned out and do not know how to do it. Thanks!

Thanks Eduardo for your reply. I would like, however, to receive assistance modifying my code in order to make what I want possible. I am pretty new at VBA so I would need some guidance. Thanks!

Hi everybody, Hope you are great. I have a question about something I want to know if can be done or not. I have an access database that sends one e-mail to each individual in a table, that works fine. Now I would like to send an e-mail to the leaders of these individuals, however, some leaders...

Hi everybody, I am new at access and its components. I have a web database on access 2010 that contains a simple table with information. I downloaded North Wind web database template to have references and I would like to make a report like they have there, that for example in the customer...

Hi everyone, Hope you are great. I have a question that I am trying to solve since a lot of days and that I cannot find an answer in google or the forum. I have a web access database to publish on a sharepoint. I have a table with a lot of information and in the normal access database I used to...

Hi everyone, Hope you are great. I have a simple question: I have used the web database template "Contacts" that Microsoft Office offers you. Since my database should have different fields I have modified it. So, when I update the table in the table itself, the data gets saved. However, when I...

Hi everyone, Hope you are great. I have a question: I created a database in my PC with Access and I would like people to view it and edit it, so I uploaded it to a Sharepoint site, as a file. However, in order to edit it, when you download the database from the SP it asks customers to save it...

Thanks for your help pillai! I have a question: we have noticed that the form appears in blank when the database in not saved on the PC of the person that is trying to access to the database. We need to have the database to be on a SP and the same to be used directly from it so every update...

Hi everybody, Hope you can help me out on this. I have an issue with a database which purpose is to be a storage of the list of process documentation we have in the team I am. If we want to change any process document I have put in place a simple process in which you have to complete a form...

Your help has been great! I am going to try that out. Have a great day ahead of you!

Hi pr2-eugin, Thanks for the data you provided. I am taking a look right now. At my company we use outlook and we have emails which are called enterprise IDs. My name is Marina Silva, so my enterprise ID is marina.silva@companyname.com. Since the company has an address book, all the enterprise...

Hi everyone, Hope you can help me. I have a database that sends emails trough outlook, the code works fine, however when the outlook does not recognize the email (because there is no person with that email in the organization that I am in) the macro stops and I have to start all over again...

Hi everyone! Hope you are all great. I am in a rush and I need help urgently. I have created an access database that sends e-mails to certain list of people. This email is on HTML body and it works just fine, however there are a few things I cannot accomplish and that I have search in the web...

Thanks Tallbloke for your help. I could finally sent the e-mail as HTML, I have another issue now but I would really appreciate if someone could please help me. I have created a table with the wording of my e-mail and since the data is set as rich text it keeps the hyperlinks and colors, etc...

Thanks Tallbloke for your reply. I am kindda new with HTML and access, I have always used plain text,could you please be so kind to guide me with this. Because you had put the code, however, the text I have to sent is pretty long and contains hyperlinks, as I said on my first post. How do I...

Hi everybody, Hope you can help me. I have a database to send e-mails from access trough Outlook. The issue is that I would like the body of the e-mail to have hyperlinks, colours, bolds and that I can get it from plain text. This is the code I have: Dim MyDB As Database Dim MyRS As...

JDraw, I am sorry for posting the database wrongly. Here you can find the picture. Thanks again por all your help :)

Hi JDraw! Thanks for your reply! I am uploading my database here, is kind of a mess, I am still trying to figure out somethings. The form in which I am having issues is "Contact Details". Again, I am sorry for my database, I am still new at this and I do not have much imagination, so I am...

Hi everybody, Hope you can help me out in this. I have a database created for HR purposes where I have all the team members of my team. I created several tables with personal information, vacations, leave of absences and study days. I have created a form that contains several tabs and each one...