Hello all,
In a schema xsd file, the connection string information is stored in a Connection element. What are the possible named attributes within that element and what do they mean? Thanks in advance for any ideas and/or suggestions!
Hello all,
I have both MS Office 2003 and MS Office 2007 installed on my laptop. Whenever I switch Access versions, I get the Preparing to initialize Dialog. After impatiently waiting, it then opens up fine in which ever version. How can I get rid of the dialog? Thanks in advance for any ideas...
Hello all,
I am opening up another access file and iterating the controls collection. I have a variable named AccessApp that I use to get a reference to a given form using DoCmd as follows:
AccessApp.DoCmd.OpenForm "MyFormName", acDesign, , , acFormEdit, acWindowNormal
I can iterate over the...
Hello all,
Any ideas and/or suggestions on implementing version control with Access? I am working on a project which will require modifications to a 3rd party written Access database. There are a couple dozen forms, a few classes and modules, etc. Any ideas would be much appreciated!
Can anyone help me translate this C# Linq code into VB.Net? It came from Comparing DataSets using LINQ: http://sql.codeproject.com/KB/linq/Comparing_Datasets.aspx?msg=2784336#xx2784336xx. Thanks!
var orig = dsOriginal.Tables[0].AsEnumerable();
var updated = dsChanged.Tables[0].AsEnumerable()...
Can anyone help me translate this C# Linq code into VB.Net? It came from Comparing DataSets using LINQ: http://sql.codeproject.com/KB/linq/Comparing_Datasets.aspx?msg=2784336#xx2784336xx. Thanks!
var orig = dsOriginal.Tables[0].AsEnumerable();
var updated = dsChanged.Tables[0].AsEnumerable()...
Hello all,
If you mouse over a dll file in a file browser, you see the Assembly Information such as Company, Description, Version, etc. How do I retrieve that at run time from a user's selection out of an OpenFileDialog? Thanks in advance for any ideas and/or suggestions!
Hello all,
I would have guessed that an overridden Finalize would be called when the object goes out of scope since at that point it is no loger accessible in code. However, it appears that it is not called until the parent object goes out of scope. I have a class with an overridden Finalize as...
Hello all,
We have a 3rd party app that we control via the Win32 API. I can get the 3rd party app to display its Open File dialog, but I need to change the path displayed if the Look In combo box is dropped. I think I need to use DlgDirListComboBox but I can't get it to work. It either returns...
Hello all,
I seem to recall an attribute that can restrict where a control or component is sited. I would like to restrict my component to being sited on a form. Can someone help me? Thanks in advance for any ideas and/or suggestions!
Hello all,
We have a custom container control that has some controls added to it automatically by a custom designer. The designer sets some default properties for the embedded controls using code similar to the following:
With TypeDescriptor.GetProperties(component).Find(name, True)...
Hello all,
We control a 3rd pary app by using the Process class along with ProcessStartInfo because the 3rd pary app is loaded locally on user machines. This is done from a front end Windows form. When the required information has been loaded, the user fires off the 3rd pary app by clicking a...
Hello all,
I have a browse button which allows users to select a Word document. I then load it into a RichTextBox control using the following code: With New IO.StreamReader(Me.txtInputFile.Text.Trim)
Me.RichTextBox1.Rtf = .ReadToEnd
.Close()
.Dispose()
End With The problem is that...
Hello all,
We have a 3rd party engineering application that we need to automate (even though it does not support automation). Using file associations, I can start the application with the following code: System.Diagnostics.Process.Start(Me.txtOutputFile.Text.Trim) It has a menu shortcut for F10...
Hello all,
I am using the following T-Sql to retrieve permissions granted to a given user. -- Return permissions granted to specified user.
SELECT sp.*, so.[Name]
FROM sysProtects sp inner join
sysObjects so on sp.id = so.id
WHERE sp.uid = USER_ID('UserName') One of the columns returned is...
Hello all,
I am wrapping an extended class in a component so that I can have a Design time presence. At Design time, how do I access the Component (Name) property (eg MyComponent1)? My extended class exposes a Name property which I want to set to the Component (Name) property when I instantiate...
Hello all,
I created a custom EventArgs class by inheriting from System.EventArgs. I have several ReadOnly properties so I set them from the constructor like so: Imports System.ComponentModel
Public Class MyCustomEventArgs
Inherits System.EventArgs
Public Sub New(ByVal myArg1 As...
Hello all,
We are getting ready to redo an old text file system in which each data row was basically a slab of data (think icons in Office) which was parsed in code based upon various positional codes in the beginning of the data. If we normalize the data into Sql Server we are going to end up...
Hello all,
We are getting ready to redo an old text file system in which each data row was basically a slab of data (think icons in Office) which was parsed in code based upon various positional codes in the beginning of the data. If we normalize the data into Sql Server we are going to end up...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.