Search results

Hi everyone, I coded a function to send emails via Access, and it works fine. But I'd like to know if there's a way to catch the error if the email is not sent? Is there a way to catch and handle this error in Access? Thanks in advance for your response! :)

Hi Jackal077, It looks like you are already executing some code and because of that, Access don't want to stop until the code is not finish to execute. You should look in your Visual Basic Editor and press on the stop button in the toolbar. you can access it whether by pressing ALT + F11, or...

Hi everyone, I will have to deploy my access application that I have built with Access 2003 english version on an Access 2003 French version. I wondered whether there could be a problem because of the difference of the language? Thanks for your response.

Hi everyone, Now, I'm totally lost! When I create a query with the Query Design view in Access with this SQL query: SELECT T_Cryzout_Disponibles.LCLCL_Disponibles_Total, T_Cryzout_Disponibles.DateEmission, T_Cryzout_Disponibles.NomReceveur, T_Cryzout_Disponibles.Ordre FROM...

all right, I was able to eliminate one of the to warning, and decided to let the ohter one on. Though, I have an other question: How can I determine If the message was really sent? In the case that the Internet connection is deactivate? I know that there is a .Sent boolean property that tells...

the first warning that I receive is: And the second one ask for a confirmation to send the mail. Here is the code I used: Public Sub SendMessage(DisplayMsg As Boolean, Optional File1, Optional File2) Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem...

Hi everyone, I'm trying to send an email with an Excel attachment. At first, I tried with the code published by Microsoft that use Outlook, but because of the Warning messages that cannot be bypassed, I'd like to find an other way of doing it. I've eared about the MAPI stuff, but I'm not very...

Good!! It works perfectly. Thanks a lot for your help! I appreciate!

Thanks for the code. But Is there a way to access the textbox in an ordered way?

Hi everyone, I'd like to know if it is possible to access the value of every textbox that I have on my form in a for loop? Because I Have about 30 textboxes in which the user can enter data, and I want to retreive all of these data and insert them in a matrix. But I don't know how to do that...

all right, I found my problem. I changed the format of the textbox in my code, but I changed it the wrong way. Thanks a lot for your help! I appreciate.

Hi everyone, My problem is the following: I have a textbox where the user input an amount to be saved in the data base. But when I enter an amount and I get out of the textbox, this one modify itself to put 1 instead. And if I come back in the textbox, the amount that I have previously...

All right, Thanks for the help! I appreciate! :D

Hi everyone, I don't understand why, if I insert a summing field in the Detail or in Report Foorter, my sum field gives the right result, but if I insert it in the Page Foorter, I get an #Error message. I don't get it. Thanks to help me understand! :)

Hi everyone, Here is my problem: I Have a form that shows bills in a continuous form. My problem is that I want to put a textbox or a label that will display a kind of counter for each bills. For example, If I have 3 bills to display, I want my label or textbox to display 1 for the first...

Hi everyone, I would like to know if there is a way to verify if an ADODB connection is open? Is there a boolean property that we could check? Thank you in advance!

All right, I found my problem...

Hi everyone, I cannot figure out how to link my tables. Here is my problem: I have one main table that contain informations about contracts (No folder, name of the provider, etc.) And I have 12 other tables. Each of them contains informations about one specific type of invoice. for exemple...

All right, I fixed it! The problem were the where clause. Thanks anyway :)

Hi everyone, I'm trying to execute an update query by using the DoCmd.RunSQL. Here is my statement: DoCmd.RunSQL "UPDATE T_Facturation SET TotalQuantiteDiesel = TotalQuantiteDiesel + " & Me.TxtQuantiteDiesel.Value & ", " & _ "TotalInst = TotalInst + " & Me.TxtInst.Value & "...