Dynamic Menu Creation Not Working After Changing From VB 2003 To VB 2007?
Jul 12, 2009
I have started a new blank project for VB 2007. I have taken the old code (VB 2003) and added it to the project.The line marked below worked on the old VB, now it does not. I get the following error:
Object reference not set to an instance of an object.
Troubleshooting tips:
Use the "new" keyword to create an object instance.
Check to determine if the object is null before calling the method.I have tried several forms of using the "New" keyword and still get the error.
Public Sub BuildChooseFileMenuItems()
Dim k As Integer
Dim numChecked As Integer
[code].....
View 1 Replies
ADVERTISEMENT
Dec 30, 2011
In the past I've used this code to create a database at runtime :-
Dim Cat As New Catalog
Dim Cn As New ADODB.Connection
Dim objTable As New ADOX.Table
[code].....
View 3 Replies
Mar 7, 2011
I have a form that requires 5 columns of textboxes that the user will populate. By design I will provide the first row but, the user will need the ability to add or delete subsequent rows. Is there an easy way to approach this requirement?
View 19 Replies
Aug 12, 2011
I need some input refactoring an asp.net (c#) application that is basically a framework for creating dynamic forms (any forms). From a high level point of view, there is a table that has the forms, and then there is a table that has all the form fields, where it is one to many between the two. There is a validation table, where each field can have multiple types of validation, and it is a one to many from the form fields table to the validation table.
So the issue is that this application has been sold as the be-all-end-all customizable solution to all the clients. So, the idea is whatever form they want, we can build it jsut using DB configurations. The thing is, that is not always possible, because there is complex relationship between the fields, and complex relationship between the forms themselves. Also, there is only once codebase, and this is for multiple clients - all of whom host it on their own. There is very specific logic for each of the clients, and they are ALL in the same codebase, with no real separation. Sometimes it was too difficult to make it generic, so there are instances where it has hard coded logic (as in if formID = XXX then do _). You can also have nested forms, as in, one set of fields on its own within each form.
So usually, when one client requests a change, we make the change and deploy it to that client - but then another client requests a different change, and we make the change and deploy it for THAT client, but the change from the earlier client breaks it, and its a headache trying to debug, because EVERYTHING is dynamic. There is no way we can rollback the earlier change, because then the other client would be screwed.
Its not done in a real 3-tier architecture - its a web site with references to a DB class, and a class library. There is business logic in the web site itself, in the class library, and the database stored procs (Validation is done in the stored procs).
I think this is a bad model in general, because one of the things I heard one of the developers say is that anytime any client makes a change, we should deploy to everybody - but that is not realistic, if we have say 20 clients - there will need to be regression testing on EVERYTHING, since we don't know the impact...There are about 100 forms in total, and their is some similarity in them (not much). But I think the idea that a dynamic engine can solve ALL form requests was not realistic as well. Clients come up with the most weird requests. For example, they have this engine doing a regular data entry form AND a search form.
There is a lot of preserving state between pages, and it is all done using session variables, which is ok, except that it is not really tracked, and so sessions from the same user keep getting overwritten, and I think sessions should be got rid of.Should I really just rewrite the whole thing? This app is about 3 years old, and there has been lots of testing and things done, and serious business logic implemented, so I hate to get rid of all that (joel's advice). But its really a mess of a sphagetti code, and everything takes forever to do, and things break all the time because of minor changes.
I've been reading Martin Fowlers "Refactoring" and Michael Feathers "working effectively with legacy code" - and they are good, but I feel they were written for an application that was 'slightly' better architected, where it is still a 3-tiered architecture, and there is 'some' resemblance of logic..
View 4 Replies
Feb 15, 2012
I have a reguirement to enable the creation of excel workbooks from sql stored procedure. To do this I want to create a vb class to generate and save the excel files. Then and ASP.net page will enable opening the excel file via the browser or enable the user to download the file.The class should be able to be called from a vareity of pages within the web app and have the ability to handle 8 to 10 separate stored procedures that will return various data sets.
View 2 Replies
Nov 20, 2009
I'm trying to build a form which generates itself as it is used. I have created a really simplistic example, loosely related to what I'm trying to do below, but which demonstrates the problem.The user types a word in the text box, clicks the Button and a new TextBox is loaded into a Panel, with the value in the original TextBox that the user has entered. The user should then be able to type something else/the same and create another text box with that in it by clicking the button, basically permitting 0,1,..,n textboxes appearing above the "txtFeeder" TextBox on the form.The problem is that everytime you click the button, it doesn't add a new control, it seems to just update the one that has already been created with the new (incremental) ID. I'm not sure if I'm doing something wrong, or if what I'm trying to do can't be done (which I find hard to believe)?Here's the .aspx...
<form id="frmMain" runat="server">
<asp:Panel ID="pnlAdded" runat="server"></asp:Panel>
<asp:TextBox ID="txtFeeder" runat="server"></asp:TextBox>[code].....
View 2 Replies
Dec 16, 2010
How can i add columns to rdlc report at runtime in windows based application using vb.net
View 1 Replies
Jul 9, 2009
I am trying to get the hang of Dynamic loading of objects from assemblies on the same machine (But NOT part of the same project).In the sample below, Form1 implements an interface built as part of the .dll I placed in C:Release. I am trying to create a local instance of Form1, and Cast it as Iform, so that the local code can access the properties and methods exposed by the interface.The assumption here is that at runtime, local code will have access to the String name of a form, and an interface which is implemented by the form (and is compiled into the .dll as well as the client application), and that is it.
When I run this code, I get a exception: "Unable to cast object of type 'WindowsApplication1.Form1' to type 'WindowsApplication1.Iform'.
Public Function fApplicationObject() As Iform
Dim sLocation As String = "C:ReleaseWindowsApplication1.dll"
Dim sType As String = "WindowsApplication1.Form1"
[code]....
I seem unable to dynamically load an object from a dll and then utilize an interface to access it's properties and such.
View 9 Replies
Aug 23, 2011
I am wanting to create a menu based on items in my MS SQL database i have 3 tables
FormTbl
FormID - Int Eg (1)
FormName - nvarchar(50) Eg (Form1)
[CODE]...................
I can get the form names to be populated in to the menu and can open it my question is how do i set where the menu items will be placed. Eg File with FormHierarch 0 will be the very first one. Exit with FormHierarch 0.1 will be the very first one under File
Private Sub Main_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim menu As New MenuStrip()
Dim dst As DataTable = User.MenuItems(Me.ToolStripStatusLabel1.Text)
[CODE].....................................
View 2 Replies
Jan 22, 2012
I am trying to make a program that will include a drag/drop view where you can arrange objects around in a view and add/delete objects as needed (objects are actually controls I create dynamically), I have made some code which I include below.If I run this code it works but not the part when I click on a newly created control, then mousemove function is not used, I should be able to move controls using the mouse functions..but these do not work. I thought code like:
AddHandler logicif(i).MouseMove, AddressOf logicif_MouseMove
should work! Can anyone give me pointers on what I am missing?
Public Class Form1
Dim logicif(20) As Panel
Dim count = 0
[code]....
View 2 Replies
Oct 27, 2010
Every time i enter set of values like Group Name,Group Abbreviation,URL in the text boxes and click the save button automatically its saves in the database and for each set of values a new details view has to be generated dynamically with a web panel and the header of the web panel should have the value of Group Name.
Example:
[Code].....
A new details view with web panel like the above has to be generated every time the save button is clicked.
View 1 Replies
Oct 19, 2010
Can i create a table with the input taken from user at runtime from vb.net.?
From vb.net in sqlserver 2008
View 1 Replies
Nov 11, 2009
I want to create a user defined menu for .pdf file right click?
View 9 Replies
Jan 23, 2010
this is my vs:but i want to get the office 2003 and 2007 add-ins in it.i am using the professional edition of vs do i need to install some components?
View 5 Replies
Apr 7, 2011
I'm currently working on a program where I'm trying to dynamically create a picture box, a button, and a label for each item in a text file. Any ideas on how to do this? What I have: a plain text file with a list of numbers. Each number corresponds to a location. When that file is read, I want to create a picture box, a button, and a label related to each number. If I want to add something to the screen, all I Have to do is add a number to the file. So, lets say the file has. 1, 2
When the file loads, it will create a unique item on the display for each location. say pic1, button1, and label1 and pic2, button2, and label2. Right now, if I add something to the file, I have to go back into the editor and manually add everything. Which is a pain.
View 1 Replies
Apr 20, 2012
i need to create sql tables based on user needs lets say a guy needs a table of 4 rows 5 columns other user needs 3 rows 3 columns each with different types so how is the best way for letting them choose like they write in a text box ( this will be the value of rows)4 and another text bvox the count of columns and i have those 2( rows and columns needed) numbers i create the table as is.based on those. by default i create type as varchar max then later on we must fill the table using datagrid.
View 14 Replies
May 20, 2010
I am doing my application with ASP and VB and I want to display a list off rows in a gridview and associate a contextual menu to each line.
View 2 Replies
Aug 2, 2009
I Am about to buy a new office, and I must decide between 2007 and 2003.
I'd like to buy 2007 (same price where I live) but I cannot stand the UI.
Is there a way to make it look like 2003 (for me Word/Excel is enough) ?
[URL]
View 2 Replies
Feb 16, 2012
I have a application VB.net which is working fine for office 2003.But one of the user has installed office 2007.I dont have the knowledge of BindingRedirect .
Old references
Interop.Access version 11.0
VBE.Interop version 11.0[code]....
View 12 Replies
Sep 18, 2009
I have both 2003 and 2007 installed on my machine. I want to create a VB Script to open a few files in 2003 and in 2007 versions. How can i do that?
View 2 Replies
Feb 12, 2012
I have a program that we converted to vs 2010. When then moved it to the users computer and they only have Excel 2003 on their station. How can we tell the excel reference to use 2003 (version 11) instead of 2007 (version 12). The program now is looking for 2007 version 12.
View 3 Replies
Aug 15, 2011
My application currently works with Access 2003 using the following approach...
strMSAccess_Connection_SQL = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDatabaseFilePath
MSAccess_Connection = New OleDbConnection(strMSAccess_Connection_SQL)
[code].....
View 3 Replies
Feb 8, 2011
I have my program set up to read the contents of a Directory, and then populate a drop down menu with the names of the files in the directory. (I am using the MenuStrip). Inside my program, it is also set up to create a new file in that directory, and I wish to add this item to the dropdown menu upon creation. The list is entirely created and populated from the code, and the contents of the list depend entirely on what's in the directory.
I have tried using MenuStrip.Items.Remove(menuItem1). Now, when this command gets executed, it does remove the top level Menu, however when I go to repopulate the menu, I end up with duplicates of my files listed in the drop down. I am stuck with how to clear these out as well?
View 2 Replies
Jun 29, 2009
I'm developing a app in VB 2005 to connect to a Access 2003/2007 DB, I manage to connect to it but I can't write to it, do I have to enable something to make it work?
View 2 Replies
Jul 29, 2009
When trying to run the exe file error codes appear and back end data is missing. I loaded the 2007 runtime application.
View 4 Replies
Dec 17, 2009
My application currently works with Access 2003 using the following approach...
strMSAccess_Connection_SQL = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDatabaseFilePath
MSAccess_Connection = New OleDbConnection(strMSAccess_Connection_SQL)
MSAccess_Connection.Open()
When I load it onto a WinVista machine running Office 2007, I get the following error the microsoft.jet.oledb.4.0 provider is not registered I was doing a little research and I guess 2007 changed a few things? Introduced something called ACE? I tried using "Provider=Microsoft.ACE.OLEDB.12.0", etc but I get a similar error to the above...
View 7 Replies
Oct 29, 2010
This code is to write text to excel 2007/2003 and also read from excel file.
Reference also need to be added, but Microsoft Excel 10.0 Object Library is ask, and my machine only got Microsoft Excel 12.0/5.0 Object Library
I not able to make it....
Imports
Excel = Microsoft.Office.Interop.Excel
Public Class
[Code].....
View 2 Replies
Oct 26, 2009
I converted one of my databases from 2003 to 2007 and am getting the following error 13 type mismatch with 2007 (did not happen with 2003 version) with the following code:
Thanks for your help!
HTML Code:
Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)
Dim strMessage As String
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
[B]Set rs = db.OpenRecordset("TblFooter")[/B] ERROR HIGHLIGHTS THIS LINE
'--- Grab Recordset Values.
strMessage = rs!PageFooter
'--- Place text onto the form Labels.
test.Caption = strMessage
rs.Close
db.Close
Set rs = Nothing
Set db = Nothing
End Sub
View 2 Replies
Feb 12, 2009
I have both Excel 2003 and Excel 2007 installed on my system. When I call oExcel = CreateObject("Excel.Application"), Excel 2003 is used in the context in my .NET code instead of Excel 2007 (which I need to be used). I have referenced the "Microsoft Excel 12.0 Object Library" but when the code runs, the 11.0 version is used.
Is it because I am using Visual Studio .Net 2003 that Excel 2007 cannot be correctly referenced or do I need to change a reference or setting?
View 5 Replies
Nov 12, 2010
After upgrading a db built in Access 2003 to Access 2007, the following code produces an error at FirstFind: Method or data member not found.
Here is the entire sub.
Sub List7_AfterUpdate()
Dim rs As Recordset
Dim Who_Name As String
[Code].....
View 1 Replies
