Search results

Hi Bob! The SQL is the following: SELECT Count(Business.Comments) AS Total1BV FROM Business;

Hi everybody! I have a little issue with a query I would like to perform: I have a table with a group of people to which I should send two types of communications, there is a Column that indicates if the person should receive the first communication or the second . I have managed to make a...

Hi! I am sorry but I am running the code in my job PC's and the code now returns me error (Item not found in the collection) in the following line: TheAddress = MyRS![EntpriseID] One question, does MyRS! means something? I mean, I have tried to search in the web the meaning of that variable...

I am sorry for not posting the error, I forgot. The error that gives me is "Compile Error: User-defined type not defined" and it highlights the line Dim objOutlook As Outlook.Application only after Dim, this firt word it is not highlighted. Thanks!

Thanks for your help Pbaldy. I am still struggling with this. I have copied a code that I have found in the Microsoft page, however when I am debuggin it returns me error in the following line: Dim objOutlook As Outlook.Application I have gone to "Tools-References" and I have added the Microsoft...

Thanks again Pbaldy! In the example database it only appears one person in the query, however there will be more because I only put a few records in the table. I forgot to mention that I would like the e-mail to be sent with BCC, I know that it should be a to so I decided to put my own to make...

Thanks Pbaldy for your link. As I have said before I do not have knowldge of VBA, so I could not understand the code what was posted in your link. I have tried however to read that code and I could not find the place on where should I put the reference so the code can identify the field...

Hi! Hope everyone is great. I am here because I am in the middle of creating a pretty complicated database and I am do not have much knowledge of VBA code. Specifically what I am trying to do is send an e-mail from access trough Outlook, which I have found that can be done easily. However I...

Hi! I am a bit desperate because I was asked to prepare a project containing the following: a calendar which shows the tasks that must be performed during the month. I have tried doing it by myself but I could not do it. Instead I found a database in the net that contains tables and something...

Thanks! I had uploaded the wrong file indeed. I have uploaded now a file with two tables. There are several persons that are not included in both tables, and the information that each table contains is different. I would like to have a query, similar to the Vlookup, that can compare table 1...

Hi Thanks for your help! What I am trying to do is the following: based on my example database, where I have created two tables I would like to create a query that based on the information on table one, bring me certain information that it is not allocated in the Table 1, but it is on Table 2...

Thanks Pbaldy! What I am trying to do is the following: I have three different reports that contain information 1, information 2 and information 3. I would like to use the vlook up to know which persons from the report 1 is in the report 2 and 3. That is why I need to know if this is possible...

Hi everyone, I am new with access and I would like to make a question to see if it is possible to create a query that contains the a formula similar to the vlookup formula in excel. I have to create a data base with three different tables that include different information from the same people...

Hi guys. I am sorry to use this thread, please let me know if I should open a new one. I have a question: I have created a sort of tool in Excel that helps my team to send me the technological issues they have. This excel has userforms created in VBA that it is used to provide the...

Hi! Thanks for your prompt reply. This is what I am referring to, and what appears in the button: OnError Next GoToRecord ,,Previous [MacroError]<>0 MsgBox =[MacroError].[Description], Yes, None, Hope this helps, in the command button it appears that as an "Embedded Macro". Thanks!

Hi Guys! hope you are fine. I have an issue with a data base that I have created. I have a form that is made based on a query. In this form I have put the command buttons "Go to next record" and "Go to previous record", however when I click on those buttons they do not go the next record or...

Hi Guys, It is me again. I have a question regarding the tables and the forms. I have a table with the following information: Task, Person in charge of the task, Supervisor, Due date. Each person performs severals activities, not just one, so I have created a form with a combobox with the name...

Hi Guys! Sorry for not posting again! That data base was put on hold for now. I am working on another one, aaaand I have another question. If in a table for a same person I have multiple kind of tasks, how can I make so the form of the query can display all those task. I have made a query...

Hi guys! Thanks a lot for all your replies. This is what I see when I click on the event code: Option Compare Database Private Sub Combo0_BeforeUpdate(Cancel As Integer) End Sub Here I have some pictures: Thanks in advanced!

Hi! Thanks for the reply! I am ussing as filters three of the fields that are in the main table ( I actually have one table with all the information). I put a buttom at the bottom of the page in order to people click in there so they can be re-directed to the form with the information they...