Launching and controlling MS ACCESS through my windows form

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Winforms
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - I really, really need smtp help I am trying to get some help on how to send email via a remote smtp server. I have posted here several times already. I need to be able to send email using winforms, vb.net 2003 or 2005 through a remote smtp server. The server is hosted by Web.com and I have talked to them but their support is NO HELP at all. I keep getting the error: Could not access 'CDO.Message' object Here is the code that I am using: Public Sub sendEmail(ByVal hostname As String) Dim objMail As New MailMessage Try objMail.To = "address@to.com" objMail.From = "address@from.com" objMail.Subject = "Testing" objMail.Body = "Body" objMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpserver", "smtp.registeredsite.com") 'basic authentication objMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpserverport", 25) 'basic authentication objMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", 1) 'basic authentication objMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusing", 2) 'basic authentication objMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", "myusername") 'set your username here objMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendpassword", "password") 'set your password here SmtpMail.Send(objMail) Catch ex As Exception Throw ex End Try End Sub I really need help on this so that I can finish this project. -- Thanks, enak Tag: Launching and controlling MS ACCESS through my windows form Tag: 105073
  - 2
    - MDI Child jiggles like a bowl full of jelly. One of my continuing series of postings explaining why VSTS 2005 is not ready for prime time and asking for help. Create a mdi parent form. Add ToolStripPanels to all four sides. Put a flow control menustrip in the top panel and a toolstrip below it. All very reasonable things to do. Now create a child form and set its initial state to maximized. (The customer wants it that way.) Add it to the parent and show. The child gets the chills and jiggles in size like a bowl full of jelly. With apologies toi Clement Moore this is not a laughing matter. Suggestions please. -- Regards, Al Christoph Senior Consultant Three Bears Software, LLC just right software @ just right prices @ 3bears.biz Microsoft Certified Partner (ISV) Coming soon: Windows Mail for Vista. Tag: Launching and controlling MS ACCESS through my windows form Tag: 105070
  - 3
    - Controls.Add changes .Visible Visual Studio 2005 (Ver 8.0.50727.42) / Framework 2.0.50727 / XP Pro SP2 Given a Form, A, and another Form, B, that derives from A. Form A has 4 controls on it. When A.InitializeComponent (a compiler-generated method) executes, those 4 controls are added to A's Controls collection thusly: this.Controls.Add(this.Control1); The problem... Immediately prior to the above statement the control's Visible property is True; immediately after the statement the control's Visible property is False. Why? When similar statements are executed for Form B the Visible property is not changed on its controls. -- // Lee Silver // Information Concepts Inc. Tag: Launching and controlling MS ACCESS through my windows form Tag: 105069
  - 4
    - KeyDown messages lost with .NET message loop Hi, We're developing an application that has some .NET and some MFC components. Currently the application is started as an MFC application, but using a managed message loop (invoking Application::Run() in MFC's application class). With this configuration we experience some problems with keyboard messages. For example, some WM_KEYDOWN messages (for example for arrow keys) does not make it through to the MFC window class. I've registered a message filter to the Application class and I can see the message being received with the correct HWND handle. For some reason, this message is later lost and is not received by the WindowProc() method of the MFC window class. Interestingly, all simple keys (letters) are received correctly. Does anybody has any idea what is going on here? (We've thought using the MFC message loop, but MS docs suggest using a managed loop if .NET components are used). Genady Beryozkin, Algotec Systems. Tag: Launching and controlling MS ACCESS through my windows form Tag: 105068
  - 5
    - Field is never assigned to, and will always have its default value private struct MySTRUCT { public IntPtr hwndMyObj; public Int32 idMyObj; public Int32 MyCode; } In Vb.Net 2005 code above, I am getting a warning message "MyProj.MyClass.MySTRUCT.hwndMyObj is never assigned to,and will always have its default value." The same message for idMyObj and MyCode. How do I resolve it? Tag: Launching and controlling MS ACCESS through my windows form Tag: 105061
  - 6
    - Textbox with blinking cursor does not receive key input In our Windows Forms app we are having an issue that our login dialog (a System.Windows.Forms.Form) does not always receive focus. In this case the cursor blinks in the textbox however the field does not receive any key inputs and therefore does not display any text entered. The user needs to click manually in the textbox which is obviously not the ideal option. I would appreciate any suggestions on this topic. huli Tag: Launching and controlling MS ACCESS through my windows form Tag: 105054
  - 7
    - Log in I need to write two forms, frmMain and frmLogin. I would like to show frmMain after i pres a button in frmLogin. any ideas ? tnx Tag: Launching and controlling MS ACCESS through my windows form Tag: 105051
  - 8
    - Bug with ComboBox selection? I'm having a problem with the .NET ComboBox control and I was wondering if this is a bug, or if there is a workaround. When I programmatically select an index in the combobox, the correct index isn't selected when the combobox is expanded I have a WinForm and I've added a ComboBox and a push button control. In the Form's Load method, I have the following: private void Form1_Load(object sender, EventArgs e) { this.comboBox1.Items.Add("bbb"); this.comboBox1.Items.Add("ccc"); this.comboBox1.Items.Add("aaa"); } // I should point out that the combo box is unsorted. private void button1_Click(object sender, EventArgs e) { int nIndex; nIndex = this.comboBox1.Items.Add("cc"); // at this point, the text displayed by the combobox is // "cc" and nIndex is 3 (correct, as expected) this.comboBox1.SelectedIndex = nIndex; // at this point, comboBox.SelectedIndex is 3 (correct) and // comboBox.SelectedItem is "cc" (also correct), yet when I // continue and then click on the drop-down button, "ccc" is // selected // this also reveals the bug //nIndex = this.comboBox1.FindStringExact("cc"); //this.comboBox1.SelectedIndex = nIndex; } Am I doing something wrong? If not, does anyone know of a workaround? Thanks, JB Tag: Launching and controlling MS ACCESS through my windows form Tag: 105044
  - 9
    - C# Wanna BE Hi i have a url that if i paset it into IE it returns to me a zip file from a remote server. it asks me where do i want to save it then creates the zip file. the file contains the data that i have requested I have created a desk top app that makes the same request to the same remote server using and HTTPrequest when i get the response back. how i write a zip file to my c Drive but it contains 0 bytes. how do i extract the Zip file from my web response and save it to my computer. thanks. Tag: Launching and controlling MS ACCESS through my windows form Tag: 105043
  - 10
    - Combobox droppeddown property and strange mouse cursor behaviour Hello, When I set the droppeddown property of a combobox in my form load procedure, it sets the mouse cursor to the hourglass for the whole form - but I'm not sure why. I would like it to keep the default mouse pointer but when I set the droppeddown property it changes the cursor and it won't change back until I select something from the combobox. Even weirder is that if I keep my mouse cursor over the place where the form will eventually appear, the cursors behave properly. It only changes to the wait cursor if my mouse cursor is outside of the application form as it loads. For a quick example make a form with a single combobox and then: Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ComboBox1.DroppedDown = True End Sub If you run this form with your mouse cursor far away from where the form will load - you should see that the cursor for the whole form is an hourglass. Does anyone know why this might be happening and what I could do to make it behave 'properly'? Thanks a lot - Cam Epp Tag: Launching and controlling MS ACCESS through my windows form Tag: 105039
  - 11
    - Assign Combined FontStyle on the fly Hi all, I know for fontStyle, I can specify FlagAttribute to get a combone FontStyle like so FontStyle.Bold | FontStyle.Underline The problem I'm having is, depending on what users clicked, I need to dynamically concate the FontStyle together. How do I do that? FontStyle fontstyle; if (Bold.Checked) { } if (UnderLine.Checked) { } If (Italic.Checked) { } Font myFont = new Font (.... , fontstyle, ) Thanks a lot. Tag: Launching and controlling MS ACCESS through my windows form Tag: 105038
  - 12
    - Resizable winform Hi there I'm using .NET 2.0. When I have a winform with controls how do I make it resizable ? I have tried each of the LayoutManagers that stick with Visual Studio 2005, but they do not look like they have the desired funtionality... Thanks in regards, Jess Tag: Launching and controlling MS ACCESS through my windows form Tag: 105035
  - 13
    - Unable to edit/move/remove controls in Subclassed form Hi, I am subclassing a Form and cannot edit, move or remove controls - or change their properties. A little lock appears by each control. This is in VS2005. How can I control what can be done to subforms, for instance if I were to give my forms to someone and let them derive subclasses and modify them in a controled way? -- Thanks in advance, Juan Dent, M.Sc. Tag: Launching and controlling MS ACCESS through my windows form Tag: 105034
  - 14
    - mousemove not getting to event handler we have an application in C# in which MouseMove is not behaving as expected. We have a form which has a TreeView, and the TreeView has a ContextMenu assigned to it (which is set to AutoClose). We have an MDI Child window that has a PictureBox on it. Mouse Event handlers are hooked to methods when the child window becomes the active window. We have a ToolStrip and ToolStripButtons, one of which when pressed adds an event handler to the PictureBox's MouseMove event (and several others). Normally, when the ToolStripButton is pressed a propery of the active window is set. When the mouse is moved into the picturebox the event handler is fired. If the user brings up the context menu and dismisses it by choosing one of the entries, and then clicks the ToolStripButton, the application works as expected. However, if the user brings up the context menu on the TreeView and then clicks directly on the ToolStripButton, and then moves the mouse into the PictureBox, the event handler for the mouse move is never called. Other mouse event handlers (such as MouseDown and MouseUp) will get called. Eventually, the problem becomes persistent enough that closing the application and restarting it is not enough to "fix" it. Windows has to be restarted. The "work around" we have found is to bring up the context menu and then click one of the options, and then the mouse move messages will be sent to the PictureBox as expected. Tag: Launching and controlling MS ACCESS through my windows form Tag: 105031
  - 15
    - Past due query I am trying to create a past due query of active quotes but instead of giving me a sum, it gives me multiple sums all equal to 1. I assume it is due to the "group by" being different but it won't let me do the query without it. What am I doing wrong? SELECT COUNT(QuoteDueDate) AS Expr1 FROM Quotes GROUP BY QuoteDueDate HAVING (QuoteDueDate < @Date) Tag: Launching and controlling MS ACCESS through my windows form Tag: 105029
  - 16
    - System.UnauthorizedAccessException Access to the path "Filename" is denied. Hi All, I have a windows Application in vb.net. I have a file copy function the program copies a file from a network share to a temp directory on the local machine then launchs this file from the Temp directory. When the program executes it raises the above exception when copying the file. Everyone has full control of the network share. Public Function ViewFileRecord(ByVal sGuid As String) PropProperties(sGuid) Try If File.Exists(sPathTarget) Then File.Delete(sPathTarget) End If File.Copy(sPathSource, sPathTarget, True) AttachProgTypes(sExtnFile) Exit Function Catch eFile As FieldAccessException ExceptionMessage(eFile) End Try End Function Any body any ideas. Thanks, Pete. Tag: Launching and controlling MS ACCESS through my windows form Tag: 105026
  - 17
    - Dowload File Hi, I have problem with downloading a file using WebRequest and HttpWebResponse. Inorder to download this file i need to call to url that tells to prepare the file for download, and then i call to another url that downloads the file. I have a problem with that because: 1. i do not know when the server finished the preparetion. 2.i checked the HttpStatusCode but he doen't changes (myresponse.StatusCode). the problem causes the application to download only a part of the file and that because the server hasn't prepared the file yet. if i give him Thread.Sleep(100000) i do get the full file, but the file can be 100Mb and 10sec won't help. the code is: //Preparing the file todownload... //--------------------------------------------------------------------------------------------------------- HttpWebRequest webRequest3 = WebRequest.Create(d1) as HttpWebRequest; webRequest3.KeepAlive = true; webRequest3.Headers.Add("Keep-Alive", "300"); webRequest3.Headers.Add("Accept","text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5"); webRequest3.Headers.Add("Accept-Language", "en-us,en;q=0.5"); webRequest3.Headers.Add("Accept-Encoding", "gzip,deflate"); webRequest3.Headers.Add("Accept-Charset", "ISO-8859-1,utf-8;q=0.7,*;q=0.7"); webRequest3.CookieContainer = cookies; HttpWebResponse myResponse3 = (HttpWebResponse)webRequest3.GetResponse(); Thread.Sleep(10000); Stream ReceiveStream3 = myResponse3.GetResponseStream(); //----------------------------------------------------------------------------------- //Downloading .... //-------------------------------------------------------------------------------------- Console.WriteLine("Connecting to download link..."); HttpWebRequest webRequest2 = WebRequest.Create(re) as HttpWebRequest; webRequest2.ContentType = "application/x-www-form-urlencoded"; webRequest2.KeepAlive = true; webRequest2.CookieContainer = cookies; HttpWebResponse myResponse2 = (HttpWebResponse)webRequest2.GetResponse(); Stream ReceiveStream2 = myResponse2.GetResponseStream(); Console.WriteLine("Downloading..."); Common.SaveStreamToFile(@"C:\scrapingtest\file.csv", ReceiveStream2); Console.WriteLine("Done Downloading"); Thanks, Rony Tag: Launching and controlling MS ACCESS through my windows form Tag: 105012
  - 18
    - How to display unicode characters using a special codepage. hello all, Using framework 2.0 I have to display a text, given as a xml data file. The given text contains extended unicode data (see below 'â??' represents arrow up decimal code # 8593 given as direct unicode # 2191) <?xml version="1.0" encoding="iso-8859-1" ?> <help> <display>&x2191 ;</display> </help> The codepage for iso-8859-1 is WindowsCodePage 28591 which is mapped to codepage Windows-1252. No culture settings displays the right sign on my DotNet Form. The TextInfo properties are readonly. How is it possible to display unicode characters from changing encodings on my form. Tag: Launching and controlling MS ACCESS through my windows form Tag: 105011
  - 19
    - Maximum size of a form created using VB .NET 2005 Is there a limitation with the .NET 2005 VB form designer that prevents a designer from creating a window larger than 2972(w), 1062(h) pixels and if so, is there a way I can get around the limitation? I need to design forms having the same size as my screens 1600x1200 and 1200x1600, and am not having any luck; even setting the value at runtime rather than as a property of the designer. Does anyone have any suggestions? Thanks. Tag: Launching and controlling MS ACCESS through my windows form Tag: 105009
  - 20
    - System.net.Mail class a html images I'm trying to send html mails from my .net app and I have problem putting an image file in mail body without putting it into attached files. How can I do? Thks Tag: Launching and controlling MS ACCESS through my windows form Tag: 105003
  - 21
    - ListControl/DataGridView/PropertyGrid Ellipses...how to? In Visual Studio, if you select Tools->Options then expand the Projects and Solutions node, and select VC++ directories, you get a grid like (or list box like) form that allows you to type in directories. If you double click on a line, you get an ellipsis that displays the directory dialog browser. Is this implemented with a data grid and two columns, and the ellipsis is hidden until there's a double click? A list box? A property Grid? There's not much documentation on ellipses, so I gather it's not part of a standard MSFT control. I haven't found many *recent* messages on the topic in these groups. I want to emulate this behavior for an app (although I'll be selecting files, not directories). The place I work for also has Infragistics controls...I may be able to get something from there, but they're tough to use. I'd rather go with something from MSFT if I could. I'll be using C#, but that doesn't make much difference, as long as it's dotnet, it should work. Thanks, Jeff Tag: Launching and controlling MS ACCESS through my windows form Tag: 105002
  - 22
    - RTL Treeview Control Problem Hi, i'm having a problem with RTL Treeview to enable Mapping Trees with Left and Right TreeView. On the right-hand side is a Right-To-Left TreeControl showing up some nodes. Between the left tree and the right tree there are some connection lines. And now comes my problem: everything is working fine on the natural box. But if i'm switching to remote desktop the connection lines on the RTL Trees are incorrect painted by Graphics.DrawLine(). Realy curious. (wrong direction!) Ideas, suggestion,.. are welcome. Greetings, Ralf Tag: Launching and controlling MS ACCESS through my windows form Tag: 105000
  - 23
    - Controls of a form Hello I have a form that containes a lot of controls including panels those contain other controls. Is there a way to simply get all contained controls either directly or indirectly through other containers such as panel or GroupBox controls? Tag: Launching and controlling MS ACCESS through my windows form Tag: 104999
  - 24
    - How to trap Application Form Change event? Hello, I had to disabled Form Inheritance because bug in VS 2005 in inheritance and localization. ANy suggestion how to trap form when it is to display or something simmiliar, in order to set common properties for all forms. For example: (Not to show in taskbar) thanks MilanB Tag: Launching and controlling MS ACCESS through my windows form Tag: 104998
  - 25
    - A little help on understanding properties ?? Hi, I'm currently working on an scenegraph editor. I have a treeview, and when I select a node, it shows its properties in a propertygrid. Each node has a link to the scenegraph node, and I override the property accessors to modify the scenegraph node when the user change something in the propertygrid. For example : // this is a custom 3 dimensional vector object. [TypeConverterAttribute(ExpandableObjectConverter::typeid)] public ref struct CVector3 { CVector3(void) { x = 0.0f; y = 0.0f; z = 0.0f; } CVector3(float X, float Y, float Z) { x =X; y = Y; z = Z; } property float x; property float y; property float z; virtual String ^ ToString(void) override { return("" + x + "; " + y + "; " + z); } }; Now, in the treeviewnode, I have something like : property CVector3 ^ Position { void set(CVector3 ^ value) { // when the Position property is modified, I want // to send the new position to the scenegraph node. m_pNode->SetPosition(value->x, value->y, value->z); } CVector3 ^ get(void) { // I always get the position from the scengraph node. return(gcnew CVector3(m_pNode->GetPositionX(), m_pNode->GetPositionY(), m_pNode->GetPositionZ()); } } where m_pNode is a pointer to the associated scenegraph node. Now, the problem is that when I expand the Position property, and modify the x component, the CTreeViewNode::Position::set() method is not called. I overrided the x, y and z accessors in the CVector3, and they are correctly called, but I need to "notify" my CTreeViewNode that its Position property changed, and I really don't know how to do that :/ If anyone know how to do this, I would really appreciate a little help ^^ And I apologize for my english :/ If you didn't understand my problem, tell me, I'll try to be a little clearer ^^ Have a good day. Damien Tag: Launching and controlling MS ACCESS through my windows form Tag: 104996
- Next
  - 1
    - Arrow keys work in opposite direction in panel Hi, I have a panel in my project (C# .NET 2003). I have multiple radio buttons placed in it. When I press UP Arrow key, The focus in the screen moves one radio button DOWN. ofcourse if I press DOWN Arrow key the focus in the screen will move one radio button UP. I guess this is because of the way the radio button controls are arranged in the panel control collection. Could anyone suggest a way to override this behaviour in a way that when pressing UP Arrow key the focus in the screen will move one radio button UP and so on... TIA Kuchuk Tag: Launching and controlling MS ACCESS through my windows form Tag: 104995
  - 2
    - Scollable property in Listview class breaks column headers When setting the Scrollable property of a listview and resizeing it the headers will be painted wrongly. This defect is documented in MSDN as: In versions of the .NET Framework prior to version 2.0, the column headers were not painted correctly when setting this property to false and resizing the control to make it larger. To work around this issue, set this property to true in a ResizeBegin event handler and set it back to false in a ResizeEnd event handler. I honestly don't understand this workaround mentioned. The ResizeBegin and ResizeEnd event are available only on .NET framework 2.0 according to MSDN. Does this mean the provided workaround is valid only in versions of .NET framework where it is not needed? Does anyone have a .NET framework 1.1 workaround around? Tag: Launching and controlling MS ACCESS through my windows form Tag: 104994
  - 3
    - Override OnPaint vs Handle Paint event I am creating a set of User Controls with a lot of custom painting. Is there a performance hit in doing the painting by handling the Paint event versus putting the painting code in an overridden OnPaint method? I will be creating a a few thousand instances of the custom control. Tag: Launching and controlling MS ACCESS through my windows form Tag: 104993
  - 4
    - Resizing Controls that are contained in a docked Control I'm surprised that I'm only know discovering this problem, but I suppose I've never needed to change the dimension that is opposite to the docking of the control. That is, when I've docked a control to Top, I've never needed to change its height and vice-versa. But, now I would like to do this and I'm not sure what the "right way" is to perform this. Should I just add an extra container (panel, usercontrol, etc) around the control whose dimension I want to change. For example, if I have a UserControl whose width I would like to set manually and which happens to be set to Dock to Top. Should I just house it in another UserControl/Panel/Etc and then not Dock it in that container? Thanks, Novice PS If my problem is not abundantly clear - create a windows application, Add a Panel to your Form, then in the Contructor - put this: for (int i = 0;i < 50; i++) { Label label = new Label(); label.Dock = DockStyle.Top; label.Text = "MyTextMyTextMyTextMyTextMyTextMyTextMyText" + i; label.Width = 1000; label.Height = 1000; //label.Size = new Size(1000,300); panel1.Controls.Add(label); } for (int i = 0;i < panel1.Controls.Count;i++) { Console.Out.WriteLine("control width: "+panel1.Controls[i].Width+" control height: "+panel1.Controls[i].Height); } Then notice how the controls all get set to a height and width of 1000. Then try changing the panel1 to be docked - either to Fill or just one side and you'll see how the dimension changes you try to make will be suppressed. Tag: Launching and controlling MS ACCESS through my windows form Tag: 104983
  - 5
    - q; DirectoryInfo.Exists DirectoryInfo.Exists(myDir) gives an exception if I run the exe though a mapped drive, what might the problem be? Tag: Launching and controlling MS ACCESS through my windows form Tag: 104981
  - 6
    - 1.1 datagrid Column Styles I am trying to change the column styles i na datagrid, ive been over exampel after example and cannot seem to figure it out. I am however quite close the following code works but the datagrid onyl displays one column in the datagrid and its the last one that had a column style applied to it 'make table style for the datagrid Dim tst As New DataGridTableStyle tst.MappingName = dsInspections.Tables(3).TableName tst.BackColor = Color.OldLace tst.AlternatingBackColor = Color.OldLace tst.HeaderBackColor = Color.Wheat tst.HeaderForeColor = Color.SaddleBrown 'add column styles for each column Dim col1 As DataGridColumnStyle = New DataGridTextBoxColumn col1.MappingName = "ID" col1.Width = 50 tst.GridColumnStyles.Add(col1) Dim col2 As DataGridColumnStyle = New DataGridTextBoxColumn col1.MappingName = "Item" col1.Width = 100 tst.GridColumnStyles.Add(col2) Dim col3 As DataGridColumnStyle = New DataGridTextBoxColumn col1.MappingName = "Description" col1.Width = 220 tst.GridColumnStyles.Add(col3) Dim col4 As DataGridColumnStyle = New DataGridTextBoxColumn col1.MappingName = "Quantity" col1.HeaderText = "QTY" col1.Width = 220 tst.GridColumnStyles.Add(col4) 'add table style to the datagrid dgMods.TableStyles.Add(tst) dgMods.Refresh() Tag: Launching and controlling MS ACCESS through my windows form Tag: 104979
  - 7
    - How to create a TreeView node with no image? Hi, I have a TreeView with an associted imagelist. I want some nodes to have no icon. How do I do this? How can I create an "empty icon"? -- Thanks in advance, Juan Dent, M.Sc. Tag: Launching and controlling MS ACCESS through my windows form Tag: 104978
  - 8
    - .NET 2.0 Webbrowser control I am using a Webbrowser control in a Windows form application. I need to be able to read the server variables values. This is very simple in web apps (request.servervariables()) but i am unable to do so using the webbrowser control. Am i missing something or is it not possible with the Webbrowser control. I would very much appreciate any help in this matter Thanks MB Tag: Launching and controlling MS ACCESS through my windows form Tag: 104977
  - 9
    - HWND - What can I do with it? I am working on extending an NSIS installer and I want to use .NET windows forms controls within it, can I create a .NET control on the NSIS parent form with just the HWND of the parent form? For example, I want to create a .NET listview on a form in NSIS, is this possible? I am pretty ignorant as to the capabilities of the Windows API for things like this and would appreciate any comments or help you could offer. Thanks! Tag: Launching and controlling MS ACCESS through my windows form Tag: 104973
  - 10
    - custom gridviw column Please help, easily reproduced: 1. Create a class inheriting from System.Windows.Forms.DataGridViewTextBoxColumn . 2. Add a simple property to that class (see below for the code I used). 3. Add a column of that type to a DataGridView. 4. Try to set the property you just created using the "Edit Columns" dialog at design time. 5. Close and reopen the dialog. The value is gone! Am i doing something wrong? Setting the value in code works. Thanks for any help. Here's the class i used: Public Class MyColumn Inherits System.Windows.Forms.DataGridViewTextBoxColumn Private _MyProperty As String <System.ComponentModel.Category("MyProperties")> _ Public Property MyProperty() As String Get Return _MyProperty End Get Set(ByVal value As String) _MyProperty = value End Set End Property End Class Tag: Launching and controlling MS ACCESS through my windows form Tag: 104969
  - 11
    - BackgroundWorkerProcess and GUI updates (progress windows) Hi, I'm writing a little application that scans a large number of media files for processing. The main application currently uses a backgroundworkerprocess to perform the scan. Each media file has meta data extracted and is added to one of a range of lists (pseudo-queues) for later processing. This is all fine. But, I want to provide more feedback to the end user as to progress as the process takes a considerable time. To do so I have implemented a new modal dialog which outputs counts on queues, and the current location in the filesystem that the scanning has reached. However, I have problems with this. Firstly, I tried creating the new progress window in the main form class, that then failed as when I tried to update the labels and controls on the progress window I could not as the window was created in another thread. Then, I tried to create the progress window within the method that the backgroundworkerprocess thread runs. This did not allow me to create a modal dialog as I could not pass "this" into the constructor, because the variable was not created in the same process. I don't really want to move the logic into the progress window, because I need to deal with the queues when populated. This is just all seeming to be too much of a mess. Updating a progress window is such a COMMON thing that applications do all the time. There /must/ be a tried and tested pattern for doing so, I can't beleive that .NET doesn't have a nice simple way to do this. However, I've failed to find it so far. I'm new to .NET and winforms. I've done some limited GUI programming in Delphi and a tiny bit in VB6, I'm primarily an enterprise web application developer. i.e. I can code well in the web paradigm, but my thick client gui stuff is almost completely non-extant. Any pointers to RTFM greatly accepted. (Oh, .NET 2.0 in C# Express 2005) Cheers, Mike Tag: Launching and controlling MS ACCESS through my windows form Tag: 104968
  - 12
    - PAE at WindowsXP64edition. Dear all I think Windows64edition has a limitation of 2G memory for each software. WindowsXP has 4G memory limitation problem and 2G limitation of each software. I have 2 WindowsXP 64edition computers. One has 8G memory. Another one has 12G memory. Even if I am using such big memory machine, "memory Out" shows me on a screen. I have used boot .ini file on WindowsXP, and get PAE. Is there anyone who knows how to expand the 2G memory for each software??? Akihiko Japan Tag: Launching and controlling MS ACCESS through my windows form Tag: 104964
  - 13
    - Font size based on the client rectangle of the control. Hi, I have a control that render text. This is done in OnPaint() override by drawing the text. When the control is resized, the text inside it should also be resized according to the size of the control. Either height of the text or width of the text or both need to be resized. So I need to determine the font size based on the current client rectangle. How do I do this? Is there any other way of resizing the text? I am using .Net 2.0. Your help is highly appreciated. Thanks in Advance. Regards Kiran Tag: Launching and controlling MS ACCESS through my windows form Tag: 104962
  - 14
    - Howto create semi-modal popup form in MDI application I'm creating an MDI application in C# 2.0. I need to show a popup form (similar to a dialog) on an MDI child form, such that the popup form is modal to the MDI child form, but without blocking other MDI child forms and obviously without blocking the main application. I know that I can't use Form.ShowDialog() as it disables all windows on the thread, but I'm hoping there's a way to simulate the desired behavior. The popup form has to be associated or parented to the MDI child form so that the user can switch between the open child forms. More than one MDI child form can show a popup form at the same time. Hope someone out the has a suggestion... Regards Henrik Rasmussen Tag: Launching and controlling MS ACCESS through my windows form Tag: 104950
  - 15
    - Windows Forms Disabled Text Hi, I'm trying to modify the tabCrontrol so I can enable/disable tabs. I've got it all working except it doesn't look like I want it to. When a tab is disabled I want the text to look like a disabled button's text (indented grey?). Is there a simple way to do this (is there a "disabled" font??) or do I have to overlay the grey text over the top of the white?? Thanks Gareth Tag: Launching and controlling MS ACCESS through my windows form Tag: 104949
  - 16
    - Minimized Forms won't restore Hi, I have a Windows Forms App, written in c# in VS2005 Professional. The application requires the user to log on, and after a period of inactivity they are automatically logged off. The Logon is done on a seperate form, which then shows the main form. The application requires 1024 x 768 resolution (due to graphics), and so if the screen resolution is set to that it runs with no borders / title bars etc. Otherwise it runs normally in a window. I have a problem, in that if the user minimizes the main form, then when they are logged out due to inactivity, the logon form becomes shown minimized. The problem comes when the user then wants to display that form in order to log back on. If the app is running full screen (no title bar etc.) then it will not restore and remains firmly fixed to the task bar. Has anyone seen this problem before and is there a solution? Thanks. Paul Tag: Launching and controlling MS ACCESS through my windows form Tag: 104948
  - 17
    - Adding a UserControl to the Component Tray I have a base UserControl class - DataModule - to which I have added a SqlConnection and a DataSet. The idea is that users will build on this base class, adding their own SqlCommands as needed, but always using the same connection/dataset (i.e. a simple API). The reason for using a UserControl, is to allow users to drag-and-drop SqlCommands etc. from the Toolbox directly onto the design area; they can then select those objects from the Component Tray and edit their properties. These subclasses of DataModule will then be placed onto another UserControl containing a DataGridView, and the user will connect the DataModule's DataSet to the grid's DataSource. So far, I've got the above working great. However, when I drop a DataModule subclass onto a UserControl, the DataModule is placed on that UserControl's canvas. Because DataModule itself isn't meant to be used as a visual component, it makes more sense for it to appear in the Component Tray instead; however, I can't seem to get this to work. (I've tried the DesignTimeVisible attribute, as well as others.) >From what I've read, it seems that any component that's a subclass of Control cannot be displayed in the Component Tray. Is this correct, and if so, is there any way to work around this? Also, if you think this implementation is incorrect, please tell me! (I am using .NET 2.0 with Visual Studio 2005 Professional.) TIA. Tag: Launching and controlling MS ACCESS through my windows form Tag: 104946
  - 18
    - How can I control positioning of child windows in an MDI form? Hello I have a question about CHILD forms in an MDI form. How can I have a neat positioning of child windows in an MDI form? When I open a new child window in my MDI form it is opened in a new cascading position but when I opens a lot of forms, it goes out of the borders of the MDI form and a scroll bar appears in the MDI form. Is there a neat positioning of child windows in an MDI form? Any help (or link) is appreciated. Hamed Tag: Launching and controlling MS ACCESS through my windows form Tag: 104942
  - 19
    - MDI Form Position Hello Two questions about positioning: When I run my MDI application developed by VS.NET 2003, the MDI window is opened in a new place and after some run again and again, it opens in a position that some borders of MDI form goes out of the desktop. The WindowState of MDI form is in Normal state. Q1: How can I open my form in a position that the form is not gone out of desktop Q2: How can I position in the same position as previously opened in the last run. Thanks in advance. Hamed Tag: Launching and controlling MS ACCESS through my windows form Tag: 104941
  - 20
    - How to suppress new-data row in datagrid with parent-child data Hi All, I have a form set up with a data source which has a parent-child relationship. The parent table is bound to a combo box, and the child to a datagrid. I want the datagrid to show the child records for the parent selected in the combo. I know how to do this, and it all works fine. But I cannot suppress the datagrid row with the * against it, where a new row can be entered. >From what I have read, the way to do this is to make the data source for the datagrid a DataView, with the AllowAddNew property set False. That's fine, but as soon as I do that I lose the parent-child behaviour - catch 22! Is there a way to suppress the new-data row in the grid, AND preserve the parent-child behaviour I need? It sure as hell isn't intuitive! Tag: Launching and controlling MS ACCESS through my windows form Tag: 104940
  - 21
    - FileDialog (SaveFileDialog & OpenFileDialog) does not add extension I use FileDialog's quite often, but this one thing really bothers me: The FileDialog.AddExtension property is supposed to control whether the extension of the selected filter is automatically appended to the filename or not, also depending on the CheckFileExists property (according to http://msdn2.microsoft.com/en-us/library/system.windows.forms.filedialog.addextension.aspx). However, with FileDialog.AddExtension set to true and regardless of the state of FileDialog.CheckFileExists propetry, the extension is NOT appended to the filename. Can someone please help me why this is? (For information, I used the filter "C-Sharp Files|*.cs|Text Files|*.txt|All Files|*.*" and DefaultExtension "cs" if it makes any difference) Tag: Launching and controlling MS ACCESS through my windows form Tag: 104932
  - 22
    - .NET Framework 3 Can Framework 3 be used with VB Express? Tag: Launching and controlling MS ACCESS through my windows form Tag: 104929
  - 23
    - Form.TopMost behaviour I'm a bit confused regarding the behaviour when setting the Form.TopMost property. If setting the property to 'true', does it make the form top-most of all windows in all applications, or only the form's application ? Searching google, I've found people claiming it's enough to set TopMost in order for the form to be top-most of all windows in the system, and other say that a call to Win API's SetWindowPos (with HWND_TOPMOST as a parameter) is needed. So, which is correct? Tag: Launching and controlling MS ACCESS through my windows form Tag: 104928
  - 24
    - how to show a form or process command line args Hello. I would like to write a console application and windows form application all in one. If there are command line arguments, then I would treat it as a console app. Otherwise, I would display a form. I'm having trouble doing this. Any ideas?? Here's what I did so far: 1) Create a new console application 2) In the Main, i use this code, but it only briefly displays the form, then it goes away. The code looks like this: Sub Main(ByVal args() As String) If args.Length = 0 Then Dim frm As New frmMain frm.Show() frm.Focus() Else '.... End If End Sub Thank you in advance for your response! Steve Tag: Launching and controlling MS ACCESS through my windows form Tag: 104925
  - 25
    - Consuming JavaScript events fired in AxWebBrowser control I have an AxWebBrowser control in a C# app. I'd like to have my C# app capture, say, an OnClick event of an HTML element in the AxWebBrowser document. Is this possible? TIA Jared Tag: Launching and controlling MS ACCESS through my windows form Tag: 104923

I am trying to open a MS Access Front end through my windows form app.
It opens fine when the file doesn't need a password.

System.Diagnostics.Process.Start("C:\DBFrontEnds\Employee.mdb")

Is there a way I can pass the password to Access in this case? I have
looked into the startprocessInfo but I am not sure if thats the right
direction to head in. Any help or suggestions are much appreciated.

Also if this is something that is not possible is there a way to
terminate any MS Access application running on the machine so that I
could then delete the file?

Top

Re: Launching and controlling MS ACCESS through my windows form by Norman

Norman
Wed Sep 20 15:28:50 CDT 2006

You can use COM interop to automate MS Access easily. You create an
Access.Application object and use that object to open an *.mdb file. If the
*.mdb file is password-protected, you can pass the password in
Access.Application.OpenCurrentDatabase() method.

"NathanJ" <NathanielAJohnson@gmail.com> wrote in message
news:1158783629.572067.253070@b28g2000cwb.googlegroups.com...
>I am trying to open a MS Access Front end through my windows form app.
> It opens fine when the file doesn't need a password.
>
> System.Diagnostics.Process.Start("C:\DBFrontEnds\Employee.mdb")
>
> Is there a way I can pass the password to Access in this case? I have
> looked into the startprocessInfo but I am not sure if thats the right
> direction to head in. Any help or suggestions are much appreciated.
>
> Also if this is something that is not possible is there a way to
> terminate any MS Access application running on the machine so that I
> could then delete the file?
>

Top

Re: Launching and controlling MS ACCESS through my windows form by NathanJ

NathanJ
Wed Sep 20 15:34:53 CDT 2006

Excellent thank you!!!!

Top