Recent content by JohnAcc

Thanks PHV worked a treat

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 removed the userform and tried to call the stored procedure but it still doesn't work. Here is my code if anyone can shed any light ! Sub TestDateRange() On Error GoTo ErrHandler_ Dim cnPubs As ADODB.Connection Set cnPubs = New ADODB.Connection Dim strConn As String strConn =...

Hi all, Thanks for all your help but I still can't seem to get this to work: I'll give a fuller explanation of what I'm trying to do: I am running the following stored procedure from vba. I get an error when I try to open the query and I have concluded that it is the dates that are causing the...

It is entered as 01-Jan-2005 Rgds, John

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

Cheers Tony ! A star is on it's way. 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

Thanks Roy - Worked a treat!

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 =...

Thanks PHV! Easiest Star you've ever earned Mate!

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