Search results

I have a user form with a listbox at the bottom of the form, I want to able to select a record to edit or ad new record but when I select the a customer the form fields doesn't shows the record on form to edit. here it's the code on listbox: Private Sub ARLIST1_DblClick(ByVal Cancel As...

Thanks. I tried: Controls("textbox" & a + 1) = ContactForm.Column(a)but still getting same error. any other suggestion? thanks again.

I have a user form with list box at the bottom and when i click in a record in list box i get this error: run-time error '-2147024809 (80070057) Could not find the specified error message says: Could not find specified error, and when click debug goes this part of the code: Private Sub...

I realize what the problem is: there's graphical bar that shows the percentage for saving/deleting/exiting the form but for some reason that frame doesn't appear in the userform. any idea how solve it, here it's the code that points when getting the error: Private Sub CommandButton4_Click()...

I am getting this message when I exit a userform, Run Time Error 424, object required, Code: Private Sub CommandButton4_Click() ProgressBar1.Visible = True For i = 1 To 10000 ProgressBar1 = i * 100 / 10000 Next ProgressBar1.Visible = False Application.Visible = True Unload Me End Sub Please...

Hi, I have a user form (Attaching picture of it) the problem I am having is doesnt' show the the record of the last two boxes, is blank even though there's record in excel cell, Here it's the code for the userform: Private Sub UserForm_Initialize() Sheets("ContactsInvoicing").Activate...

Every time i search for customer name i get this error: run-time error '1004' application-defined or object-defined error excel 2013. here it's the code: If ComboBox1.Value = "" Or ComboBox1.Value = "-" Then MsgBox "Choose a Filter Field", vbExclamation ComboBox1.SetFocus Exit Sub End If For...

I did comment the line and now goes to the next line "16". Thanks

Sorry I am not that good in vba. How do I commenting out the line? thanks

I have userform when I search by Customer I get the run time error 380 could not set the list property, invalid property value Here it's the code: Private Sub CommandButton5_Click() 'Search Button Dim sat, s As Long Dim deg1, deg2 As String Sheets("ContactsInvoicing").Activate...

Thanks for all your help. I figure out the 424 error, now the problems is when i click any customer doesn' send email: here it's the complete code: can any help me to get it work i send invoices every month and this will be very helpful, hope somebody help me, thanks. 'For More ...

Can anybody help me please with this error? Thank you.

Thank you for the reply. I had to rename the listbox1 to ContactForm because i have listbox1 already. here it's the code: Private Sub ContctForm_Click() Dim Customer As Variant Dim Name As String Dim firstaddress As String Dim rng As Range Customer =...

Hi I have this code from another excel file, How can i add this code to the the userform "ContactForm" for the file Contact list for Invoicing-Demo2.xls which I am attaching it. Here it's the code I would like to add the above so I can double click on the customer and send an email: Private...

Thank you. I tried but doesn't work. on the form i have G/L text box from the Contacts table and I want to be able when type that number display account name on text box G/L from the contact table so i want the dlookup to look that number on the "Chart of Accounts" table. thanks.

Here it's the screenshot of Chart of Accounts. thanks.

thanks. I tried both but I get an #error display on the G/L name textbox Is my mistake didn't explain well, Here it is what i want to accomplish: I have form Contact Details with the With the text boxes: 1. G/L from Contacts table 2. G/L Name from Contacts table as well so I want when i...

I have form access with field G/L and a field Account which is the name of the G/L account comes from table Chart of Accounts. I want to type the GL on the textbox automatically get the name in the Account display on the textbox Account on the Contact Details form. the Formula i have I am...

Hi, is there a way to create a button that when i click it will show me the forms available and and select the one I want to open by clicking from the list. How can i do it? Thanks.

Thank you very much worked perfectly.