Search results for query: *

Hi All, Does anyone know how I can automatically reply to an e-mail if it contains a certain word in the body or subject and then move the e-mail to a seperate folder. i.e if the e-mail contains the word "help desk" in the subject box or the body of the e-mail then I want to automatically...

Hi All, I have a text box where the user enters a date. This is stored as a string within vba and I need to convert it to a date. Any ideas ? Rgds, John

Hi All, Does anyone know how I can create a sub menu off a custom menu in excel ? Similar to File > Print Area > Set Print Area Here is what I have at the moment...... Private Sub Worksheet_Activate() Dim cbWSMenuBar As CommandBar Dim muCustom As CommandBarControl Dim...

Hi all, I would like to retreive data from a table within SQL Server 2000. The problem I have is that my log in to SQL is different to my log in to windows. What code do I need in vba to log in with my correct log in ? Thanx in advance for your help. Rgds, John

Does anyone know how to add a menu bar into a user form ? Thanx in advance for any help! Rgds, John

Hi there, I am trying to add data from Excel into access using the following code but it doesn't work. I do not get any error message: Private Sub CbAdd_Click() Dim Db As Database Dim Rs As Recordset Set Db = OpenDatabase("T:\Accounts\John Cox\db1.mdb") ' open the database Set Rs =...

I am new to access and would like to know how to populate a combobox on a form with the values Yes and No. I am familiar with vba in excel and would usually type the following code in the form's initialize event. combobox1.additem "Yes" combobox1.additem "No" How can I can do this in access...

Hi All, I have a userform that has some textboxes on. When the userform is initialized the textboxes are populated with data from cells in the workbook. Does this trigger the textbox_enter event procedure ? Rgds, John

Hi All, I have the following problem. I need to highlight the entire row a different colour if a date is entered in any cell in column D. I was thinking of using the Selection Change Event but I have no way of knowing the previous cell reference. Any ideas ? Rgds, John

Hi all, How can I disable all commandbars when openening a spreadsheet. At the moment I have: Private Sub Workbook_Open() For Each cmdbar In CommandBars cmdbar.Visible = False Next fmMain.Show End Sub I would also like to reset the commandbars when closing the file. Any...

Hi all, I have several forms with text boxes on them and I want to be able to provide the user with a prompt as the mouse pointer scrolls over the text box. (Similar to the comments in the cell within excel). I have looked at the events associated with the textbox and mouse down / Up etc...

My code crashes when it gets to the msgbox line and i can't for the life of me see why! Any ideas ? If i step through the code it works fine. Thanx in advance for any help Sub PrintReport() On Error GoTo ErrHandler ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True MsgBox...

Hi all, I can't work out how to change a string variable to uppercase. I know excel has an upper function but vba does not appear to haev one. I have tried the following to no avail: NewString = Upper(Stringvariable) Any ideas ? Rgds, John

Hi All, I want to be able to add items into a 4 column list box. Can anyone help me? Rgds, John

Hi All, I have a countif formula that I'm struggling with. I thought it would be really easy and I've come very unstuck! My problem is thus: I have a range from B3:B400 that contains the text "Yes","Starts","-" or "Ends". I have a range from N3:N400 that contains department names. I want to...

Hi There, I have an input box that requires users to enter a password. Is there any way to to make the characters wildcard characters (*) so that no one else can view this password. Thanx in advance. John

Does anyone know how to update all the pivot tables on a sheet with a for next loop? I can't seem to get the coding right. Thanx in advance Rgds, John

Hi There, Does anybody know how to show normal distribution curves in excel graphs? The one that looks like a hill ! Thanx for any help in advance! Rgds, John

Hi All, I am plotting a graph with 2 sets of data and i want to supress zero values. Does anyone know how to do this ? It sounds pretty simple but i can't work it out for the life of me! Thanx in advance John

Hi There, I have some data in an access database that i am importing into excel with the following code. My problem is that there are more than 65536 records. How do i get excel to continue importing the data onto a new worksheet ? Sub GetEnquiryTable() Dim Db As Database Dim Rs As...