Search results

i have customer database and got userform with listbox, but every time open form and click a record on list box get the run time error, could not find the specified object, and highlight this line (in red): Private Sub ContactForm_Click() Dim say As Long, a As Byte For a = 0 To 11...

Yes, i tried when click send give me Run-time error -2147024894(80070002) and highlight this line (When click send button): If Len(Me.txtAttachment) > 0 Then oEmail.Attachments.Add Me.txtAttachment.Value thanks again.

one question, is this (booleanField) the checkbox field name? thanks

Thank you. I tried when when i select two files it highlight them but when i click ok nothing on textbox attachment, doesn't show any. and i click send, not files attached.

thanks. I tried but didn't work. the combo has after udpae macro. and here it's the query based on: SELECT [Contacts Extended].[ID], [Contacts Extended].[Contact Name], [Contacts Extended].[Company], [Contacts Extended].[E-mail Address] FROM [Contacts Extended] WHERE ((([Contacts...

I have browse button to attach multiple files, even if I select multiple files and only show one in the textbox attachment, if add this line more than once on the send button, oEmail.Attachments.Add Me.txtAttachment.Value when click send it repeats same file, how can i select multiple files to...

I have a form with combobox to find companies and in the form, also in the form there's a check box for terminated/inactive companies, how can I make it if the check box is checked not to show the company in the combobox and if want it to enable back, how? The combo has afierce update macron...

any help please.

I have this code works fine, but when sending invoices will be easier to drag and drop the files being attached into a textbox because i use two monitors, also if just show the files names instead of folder in the textbox. is it possible? here it's the code: Private Sub btnBrowse_Click()...

Re: Send Email "Body Message. (SOLVED) Thank you for all your help. everything works.

Because this switching from excel to Access and we have a list of customer that approve to withdraw, so in excel type message depending on the customer. how can i use an If/Then/Else to add the appropriate text. any idea?

Sorry, i have one more question if you please can help me, depending on the customer, some of them already approved us to withdraw from their wallet, and other one has to confirm how can i make that to work, here are the two messages: 1. ="Here is the monthly invoice # for " &...

Thanks so much, it worked.

it's a combo, how do i know the column number? thanks

Thank you. I tried the suggested code below, but it gets me the id number instead of company name, how can i make to get the Customer name instead. Private Sub btnSend_Click() Dim oApp As New Outlook.Application Dim oEmail As Outlook.MailItem Dim sBody As String Set oEmail =...

Hi, I have this code that i want send as body message in email but i want to pickup the company name according the company i am sending the invoice, but giving me error 2465 cannot find the field, Here it's the code: Private Sub btnSend_Click() Dim oApp As New Outlook.Application Dim...

Thanks. But I am new on VBA so any sample code, please.

how can i create a vba code to send email to current record in the form with body message and cc as well. is there any sample code to start with? thanks

how can set a text box default value to this in access forms: Here is the monthly invoice # for [Contacts]![Company] . Please confirm if we may collect the payment from your wallet. Please contact me if you have any questions.Thanks. thank you

how can i change the message line of this code to display no only column c details but also column "D" and "E" and popup dialog. Here it's the code: Dim lstRow As Long Dim i As Long Dim msg As String msg = "Alert!!! The following schedules need attention, payment will be due soon:" & vbCrLf &...