Search results

Hi guys, I am trying to delete rolling 12 months records from the table. Can you please amend the query accordingly? Dim sSql As String sSql = "delete from tblReturntowork where Datecreated=#" & Format(Date, "mm/dd/yyyy") & "#" MsgBox sSql Thanks

Thanks Arnelp, I tried it but nothing got populated in the listbox. When I step through the code then I can see the values get stored in variable 'v' but nothing shows in the listbox : Public Function fnFillList(l As ListBox) Dim m As String Dim vList As Variant Dim v As Variant m =...

Hi Guys, I am trying to use ini files which will act as a mini database for outlook. So Outlook/VBA code will create a text file (ini file) and data is stored in a text file so everytime you need to change the data then it doesn't require changing the code . The code works fine. The highlighted...

This is for outlook . The form is designed in outlook VBA . In order to make it dynamic , I want to store data in a notepad and the listbox will get populated with the data stored in notepad.

How can we do the same thing if the data is stored in excel spreadsheet . I have to write outlook vba code as the form is in outlook .

Hi guys, My code is written in outlook vba and I am trying to figure out the issue with storing different data each time in the listbox based on the relevant option selected on the form. So, If we need to update listbox based on the 'option' selected in a frame , I have written a sub as...

Got it working. Thanks a lot.

Hi Ranman, Can you please tell me the steps needs to be performed ? I have not idea how to start with. Many Thanks

Hi Guys The following line of code exports the file in comma separated format but not sure what change needs to be made to export it in pipe delimited format. Any help will be much appreciated. With db.CreateQueryDef("QryTest", strsql) ' create a temporary query named QryTest...

I got the following code but not sure how to make it working for multicolumn listbox . My text file stores data as below: 1,A 2,B 3,C 4,D I need to make 1st column of the listbox hidden so that users can see A,B,C,D in the listbox . Private Sub UserForm_Initialize() Dim fn As String, ff As...

I am working on Outlook VBA so I have a userform and there is 2 column listbox on it. I want to store data in a .csv file or any other file that will reside on the network and want to write a piece of code that will store data in a listbox from that particular file on the network. What is the...

Yes the procedure is in outlook and if I remove ".jpg" and ".jpeg" from my select case statement then it automatically excludes embedded attachments as below. It is as simple as that so why do we need to use Property Accessor class ? Private Sub SaveAttachments(olItem As Object) Dim olAttach...

Hi Guys, I am thinking of a way to populate 2 column listbox based on data stored in a notepad (on the network). I don't want this to be hard coded so if anyone wants to change the options then just make changes i notepad and listbox will get updated automatically. Can anyone please help me...

What about converting .txt files to pdf then ?

The other thing I just realized is that if I try to convert '.txt' file into .pdf and save down on the network then it doesn't work with PropertyAccessor. Please see below the code. If I don't use PropertyAccessor class then text files get converted to pdf and get saved down but otherwise it...

Thanks a lot sxschech. It works like a charm to me. Many Many thanks for all your help :)

Thanks so how can i change my code so that it excludes embedded attachments. Sub ProcessSelection() Dim olMailItem As Object If Application.ActiveExplorer.Selection.Count = 0 Then MsgBox "No Items selected!", vbCritical, "Error" Exit Sub End If On Error Resume...

Thanks Gasman, ANother question I have is around validating multiple account numbers. This code works when there is one account number only (txtAccount1)but if there are multiple account numbers stored in multiple textboxes then how can I use the same function MortgageNoValidation_New on that...

MortgageNoValidation_New is located in a module.

Hi Guys I am writing the following code on the OK button of the outlook form. Actually I want to display the value stored in a textbox and caption of a label. But when I run the form and click OK then it doesn't display anything for the texbox and label caption. It's really strange. I have...