FormLoad Email Mailbox List (Drop Box)?
Jan 7, 2010
One of my clients is going from Server 2000, SQL 2000 w/ VB6 to a new environment of Windows SBS 2008, SQL 2005 standard 64bit, w/ Visual Studios 2005. We have a custom built app written all in VB that has been converted. We already took care restoring the databases and setting up the odbc and such. After conversion, the app threw a couple of errors, and warnings, which have been fixed. We have a formload function that is supposed to populate 2 fields with dropdown information. One is a folders list in outlook and the other is a send recipient. The Recipient field populates fine and the outlook email box does not.Here is the formload code. I can't figure out why this would allow one box to fill and not the other.
Private Sub frmProcessEmail_Load(ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles MyBase.Load
'starts up email
start()
[code]....
View 4 Replies
ADVERTISEMENT
Apr 2, 2012
We have an old legacy SQL 2000 server (the last in the farm) - We've been unable to get rid of this server as it uses xp_findnextmsg, xp_readmail etc to monitor a mailbox (via mapi) and import all email to that address into a database. The database contains simple tables that store "from", "to", "subject", "body", "Sent Date" & so on.As you may know, the procs above are no longer in use in SQL 2005+This table is read from dozens of internal systems, for instance emails to this mailbox can be automatically picked up by our helpdesk systems & create calls etc.My question is this: what it the easiest / modern way of doing this in SQL 2008+? Is it going to be a case of writing a .net binary / service that will use smtp or something to connect to a mailbox and insert the data into SQL or is there a simpler way to do it? (SSIS / 3rd party tools / pre-existing code / projects?)
Just thought I'd ask before i start writing something - no point re-inventing the wheel as it were.
PS: The Mailbox in question is an exchange 2010 mailbox.Edit: This functionality was hinted to be re-introduced in 2008 & dbmail: http://connect.microsoft.com/SQLServer/feedback/details/126167/xp-readmail-replacement-for-sql-2005 but it looks like it failed to materialise!
Edit 2: I've just found a decent code sample here that utilises the new web services in exchange 2007+: http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/dd2b465b-b1d2-4c0d-82ec-c36c6c482d5d - experimenting in progress (has anyone ever worked with SQL and the Exchange web services?)
Edit 3: All done! I knocked up a .net service that sits on our exchange server and monitors a mailbox & pushes any new mail into SQL. Incase others have a similar question and need some sample code to get started - here is some rough code (chopped out of my service - replaced parameterised SQL with basic dynamic SQL for easy reading): (Note: you'll need the EWS API 1.1 dll)
[Code]...
View 1 Replies
Jun 22, 2010
I have looked high and low and can't seem to find some sample code anywhere.I am looking for a snippet of code that will return all the folders in a Mailbox, not so much the drafts,nbox, outbox, sent items but a custom folder created by the user.Using MS Outlook 2007 ver.12.I know how the look for items in a folder but it only shows me the items in my Inbox.I need to show all the folders available and let the user select the folder to search in Or at this point I would settle for a way to set the defaultfolder. I can make this accept anything other than olFolderInbox?
View 1 Replies
Jun 28, 2011
I'm currently having a problem dragging and dropping my label1.text to a richtextboxt which isn't created on design time...well im currently found a solution but i think it is only for a temporary solution because i use a drag and drop i drag it to a textbox then it willl transfer the data to the richtextbox....through the use of the textbox... here is the code ive come through..[code]...
View 2 Replies
Nov 22, 2004
Does anyone know if it is possible to make a drop down list control (when clicked) list its contents above the item, rather than below? Effectively, I need a drop up list rather than a drop down list...
View 1 Replies
Apr 5, 2011
Is it possible to reorder the elements of a drop down list (combobox) via drag and drop?For example, when the list is dropped down, I want the user to be able to drag the items up or down to reorder them. I tried this (and some google searching) but I'm wondering if its just not possible:
Private Sub cmbClassLists_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles cmbClassLists.MouseDown
If cmbClassLists.DroppedDown And Not cmbClassLists.SelectedIndex = -1 Then
[code].....
View 2 Replies
Dec 2, 2010
How to setup my form etc to drag and email from outlook and drop it on a datagridview.
View 1 Replies
Nov 2, 2009
I want to do drag and drop with an email attachment (Outlook). The DragDrop event handler comprises the following lines of code If e.Data.GetDataPresent("FileGroupDescriptor") Then Dim ms As System.IO.MemoryStream = CType(e.Data.GetData("FileGroupDescriptor"), System.IO.MemoryStream)which should be the beginning for retrieving the name of the file to be dropped. -- BUT, after executing the second line, ms is Nothing and stream operations (seek or read) with ms fail. Why? How can ms be Nothing if e.Data.GetDataPresent("FileGroupDescriptor") was True?
View 2 Replies
Jun 18, 2009
i want to stop accepting form drop down listbox if certrain criteria is not met [code]how i can cancel the selection of drop down list?
View 3 Replies
Aug 21, 2009
I have an Oulook AddIn project to which I would like to add a functionality to be able to drag an email item into a folder in Outlook's Main Folder Pane. I would like to have the folder in which an item is dropped into to recognige the new item and pop up a message.
I would like to know what events to use to achiev this task.
View 6 Replies
Jun 6, 2011
Protected Sub registerStudButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles registerStudButton.Click
[Code]...
View 1 Replies
May 18, 2012
how to change 2nd drop down list value after I selected the 1st drop down list value.
The best example is country and state. After user selected country, the state value should change accordingly.
I am still new in ASP.NET and I know in PHP it can be easily done using javascript.
May I know how to do it in ASP.NET using VB language?
View 3 Replies
Nov 4, 2011
I fill a dropdownlist item with the following commands
View 2 Replies
Jul 7, 2011
I am a newbie of using a vb.net. And I am eager to know everything around. I have a problem that seems hard to find for. I would like to retrieve data from database using drop down list, and select only the fields that i want to retrieve from it.
DesignationTable From my table i like to display only two in my drop down list
[code].....
View 4 Replies
May 31, 2012
I am trying to compare a calculated date with a value in a dropdown list. The value is a date.toString.This is what I have so far:
Dim sched = scheduleDateVal.toString("d"
If Holidays.Items.Contains(New ListItem(sched.ToString("d"))) Then
ScheduleDate.Text = scheduleDateVal.AddDays(1).toString("d")
End If
Holidays is a dropdown list bound to a database so that I can add a day to a scheduledate if it happens to fall on a holiday. This works if I add a string value to sched rather than converting scheduledateval to a string.
View 2 Replies
Jan 13, 2010
I'm creating a simulation programe. In one sheet I have a group of cells (AngleConf) that have a drop down list. I would like to make some operations when I change the value of one of these cells. It always works when I insert the new value manually. But it doesn't always works when I change it by selecting the value from the list. I supose that that happens because of some option that I change while I'm working but I can't find out witch one exactly.The code that I think that its implicated:
Sub Worksheet_Change(ByVal Target As Range)
If InRange(Target, Range("AngleConf")) Then
Call resistance 'Actualiser le r�sultat mecanique
[code].....
View 1 Replies
Mar 24, 2011
I am having, and it may be related to another issue i am having, but im not sure.I have a form that all of a sudden stopped executing the formload event.i checked the initialize component method, stepped through it, and it runs fine.the formload has the handles clause on it. i put a breakpoint on formload and it does not stop on the sub header. so could it be part of this issue?::: every once in a while, the code parser breaks, and reads partial lines of code (designer generated code at that)...so an error that pops up is Error in line "clearBeforeFi" not recognized....in dataset designer code, it is reading half the line, seeing it as the whole line, and i get a thousand errors. I restart the IDE, and that is fine again.....
however, this formload thing does NOT want to go away.it shows the form, runs the initialize code, so it shows the form fine, but executes nothing.[code]...
View 5 Replies
Aug 17, 2009
I'm trying to find a dropdown-style list for images I can use in a program of mine. It's fairly simple, just needs to display a few images in a grid with tooltips for each one, and I need to be able to get whichever one was last picked. For example,[URL] without the tab bar in it. Unfortunately my monetary budget is zero which means I can't purchase any controls?
View 2 Replies
May 15, 2012
My dropdownlist is set to databine like this...
dt = dal.FillDataTable(SqlConnectionString, "SELECT SQL Query Statement")
dropdownlist1.datasource = dt
dropdownlist1.datatextfield = dt.columns.item(0).tostring
dropdownlist1.databind()
This is turn populates my dropdownlist, when a user selects a value, it is then populated to the remaining textboxes on the remaining forms with a session call...
dropdownlist2.add(ctype(session.item("valOne"), String))
Through this session it populates the one value, is it possible to display the selected value but also include all other dropdownlist items in case they want to change thier selection?
View 1 Replies
Feb 13, 2011
I have a need to click on this drop down list and select a month. Here is the HTML code on the site
[Code]....
View 2 Replies
Mar 31, 2011
I cannot get the value from the drop down list and I not sure what's wrong with the declaration and the code.
Dim selectedIntake As String = intakeDropDownList.SelectedItem.Text()
Dim selectedSupervisor As String = supervisorDropDownList.SelectedItem.Text()
.supervisor_ID = selectedSupervisor(0), _
[Code]....
This is the error message I get :
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_student_Details_lecturer_Details". The conflict occurred in database "SKTM-AAS", table "dbo.lecturer_Details", column 'supervisor_ID'. The statement has been terminated.
View 4 Replies
Jul 27, 2010
i have four price values in a drop down list and i need to code these values and add them to values from a checklist object i am doing very simple coding ?
View 1 Replies
Dec 31, 2009
How to drag and drop tree view nodes to list box contol in VB.net
View 1 Replies
Mar 12, 2012
Is using Public Property the best way to achieve the following.From a drop down combobox, a list of options are available. Each option in the combobox has a number of public properties that need to be associated with it.When a option is selected, the user will then have two buttons that each call a different sub, the appropriate options are passed to the sub.Each option will always have the same properties required to be passed.So I'm looking at something like this.
Public Class Parameters
Public Property server As String
Public Property replica As String
Public Propery path As String
End Class
[Code]...
View 1 Replies
Mar 6, 2012
i have two pages.1.aspx and 2.aspx i have a drop down list on the first page and a back and sumbit button on the second page..If i make a selection in the drop down list and go the second page and then go the the first page again with the back button. the drop down list doesnt show the selection that i did.i tried the use "sessions" but didnt work, also tried postback but no luck. I read something about "Enableviewstate" also no luck.[code]
View 2 Replies
Mar 23, 2010
I have created a drop-down list box that holds 8 numbers representing a month span (3, 6, 9, 12, 15, 18, 21, 25 months). In order to prevent users from typing just anything into the text box above the combo box, I changed it to a drop-down listbox. The other requirement that I was hoping to implement was for the user to be able to type a number, after which the selection would jump to the appropriate item (i.e. the user types in '1', and the selection jumps to 12). This partially works. It will jump to 12, for example, but immediately after the user types the '1', the Selected Index event changes. The user cannot scroll down or up after typing in a number.
View 6 Replies
Nov 3, 2009
I have a dataset with a members table that has a first name column and last name column. How do I get the full name to display in the drop down list?
View 2 Replies
Feb 9, 2010
the following code allows me to drag and drop the data, so i can reorder the list box. However, is there are way of seeing the line across the list box where it will be moved to?
[Code]...
View 7 Replies
Feb 22, 2009
I have multiple drop down lists on a page. They all contain list of countries. So in the background I am getting countries from database and caching them. I would like to populate those drop down lists from another thread. I am also using AJAX controls so I wanted that it all happens at the same time. And also after a user selects a country I want that towns from that country show to the user, and I want that getting towns happens also in another thread so that user can fill other controls while the list is not yet loaded.
I have read somewhere that I should give Page as a parameter to that thread and then find that drop down lists and populate them. But that is not working.
Here is a function that is called when another thread starts:
protected void GetCountries(object o)
{
if (Session["Countries"] == null)
{
[Code]....
View 1 Replies
Feb 1, 2010
So I have an excel app with a drop down list and it contains many values. Is there a way I can just search through that drop down list in vb.net? I can't seem to find where these values that populate the drop down list even come from So I thought just searching through it is easier?
View 1 Replies
