When I use Export Template in VB2010 Express, it exports to different place every time even I set up the User project templates location and User item templates location in Tool -> Options -> Projects and Solutions.It seems it exports to a path the same as used in the last Add Resource path.How can I export to where I want?
View 10 Repliesi make my textboxes to export data into an excel template....it works fine but there are few errors too..but i don't know how to fix it...here is my code.
Dim objExcel As Object
Dim objWorkBook As Object
Dim objWorkSheet As Object
[Code]....
for the objworkbook.SaveAs,it will always ask me to replace to file and i would like to use SAVE command...bu it not works..anything happen?sumore everytime i run this process,it will tell me the file is read-only while the setting doesn't shows that the file is read-only...and i have to go to task manager and end the EXCEL process by myself to run the process again
I want to creat office addins with my VB 2008 express, but i can NOT find the template.
View 3 RepliesI originally created a project in Visual Studio Professional 2010. I then saved it and was hoping to be able to open it in the Express (2010) version. When I try to open the project it directs me to a page: [URL]
Do I have to go into the Pro version and export it in a specific way?
Note: By export it I mean just copying the directory (and sub directories), the solution was in.
I'd like to make a program module that exports all records from three tables in a database into a file at once(I means not adding row by row, maybe like BULK). how to code for exporting and importing?
View 7 RepliesI am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 3 RepliesIn VB.NET,I want to create template at runtime and save it the template with name. for ex : Administrator design a page with 5 fields like using firstname, lastname, dob,nationality and job. He want to assign this page to the user with some restriction like user1 need to enter the all the fields and save it the forms as user1profile, but user2 need to enter only firstname and lastname and save it as user2profile.(in features, he can remove the fields from the form).
View 1 RepliesI'm using the 2008 express edition. Now, I created an application that will allow the user to choose transaction in the combobox.text and input its price and quantity using an textbox.text. When the user click button1, it will be push in the datagrid/datable I created. And when the user click the button2, it must be save to excel file. The only thing I need is how to save the data from datagrid/datatable to excel. This is my code.
Imports System.Data
Imports System.Data.SqlClient
Imports Excel = Microsoft.Office.Interop.Excel
[Code]....
I'm working on my first T4 code generation tool to add some Stored Procedure helper code to my project. I've created custom types (e.g. StoredProcedure and StoredProcedureParameter to help with my code generation and have included the assembly and namespace references in my code:
<#@ template debug="false" hostspecific="false" language="VB" #>
<#@ output extension=".generated.vb" #>
<#@ assembly name="$(TargetPath)" #>
<#@ import namespace="StoredProcCodeGenerator" #>
This allows me to use my custom types in my T4 template code. However, because my custom types exist in the same project as the T4 template code, I can't recompile my project once I run the template code without restarting Visual Studio. This isn't very much fun.
I read a great article that addresses this exact issue by using the T4 Toolbox, but it's not working. Either I'm implementing the VolatileAssembly directive wrong or the T4 toolbox simply didn't get installed. I'm not sure that the toolbox got installed correctly (I'm using VS 2010 on Win XP).
I tried to start using VB 2010 Express with a program I originally developed with VB 2005 Express that I moved to VB 2008 Express successfully a couple years ago. It uses a database file (*.mdf) that is on the computer ( not out on a server). When attempt to run the program in debug mode, I get the following error "An attempt to attach an auto-named database for file C:Documents and SettingsTomMy DocumentsQuizzing StuffQuestion Database 2010QuizQuest ionGameQuizQuestionGameinReleaseQuizQuestionDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
I first made a copy of the entire project folder that was working in VB 2008 Express and gave it a different name. In VB2010 I opened the project in the copied folder and it said it successfully converted the project. I am able to open the Data Source inthe Designer and see the database structure as I expect. I think the project is still using SQL Server 2005 Express (because it is what is checked in the list of prerequisites on the Publish tab).
Note, I have programmed off and on for many years, but fairly new to using databases and SQL Server.
Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 1 RepliesI am trying to re write a VB6 program using MS Access, many years ago, using VB 2010 express and SQL server 2008 R2 Express. I have a database with several tables, which I created using the designer. I am able to connect to the database and select data and display it in textboxes etc in vb code. What I have not been able to in code is to INSERT rows DELETE rows or UPDATE any data in the tables. I can do any of these operations using the Query Designer, but I want to do it in code. I can post some code if necessiary, but I thought it might just be some property that I had not set in the designer.
[Code]...
Is VB Express 2010 slower to compile and run that older versions of VB Express? I've installed it this weekend and it seems a little sluggish on my quad core computer with 1 gig of RAM. I have VB Express 2005 installed for my students at school and it seems to fly just fine. Those school computers are older P4s with 512k of RAM.
View 7 RepliesInitially my app worked with excel fine, now it causes my computer to reboot only after Excel has been opened (two or more times). I have opened and closed Excel files 20+ times without running thru either of my apps (they all uses identical code for excel) and it has never caused a reboot or a crash.
run either of my apps and have the app control excel has become a crap shoot, it will reboot my computer. Adding to that I then have to do a manual shutdown because the reboot process after is unstable. (System doesn't respond properly). My code in this app is small, should make for a good example. I can provide the entire project to anyone who would volunteer to test it. (First I need to know how to send the project).
[Code]...
I'm working with 2010 now, but I have an old project that was created in 2003. I started that project with a 2003 vb.net template. I would like to use that template again, but I want to develope a current 2010 application. Does that make any sense? How do I get the vb 2010 express to recognize my old 2003 vb express template?
View 2 RepliesHow do I create a Windows form template? want to avoid adding all graphics setting up all other objects each time I create a new form. I am sure there must be an easy way of doing this but I just cant see how.
View 7 Repliesthere Dream in Code Community! Im an okay programmer as far as skill right now I am still learning as we all are I need some help from some experienced VB.NET programmers in the community, Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords.
[Code]...
I can't get this to work. My program fills all the values into an Excel spreadsheet- no problems there. What I'd like to do is a print preview/print function. I can't seem to get my code right, all I get are blank pages in the print preview box.
Dim oExcel As Object = CreateObject("Excel.Application")
oExcel.Workbooks.Open("C:DailyLogsDailyLog.xlsx")
PrintPreviewDialog1.Document = PrintDocument1
PrintPreviewDialog1.ShowDialog()
oExcel.Sheet1.PrintPreview()
So as I see it, this should open excel, then navigate to the actual excel file. The print preview dialog should come up, which it does, and the excel sheet1 should be previewing, but it's not? I don't have any errors, just a blank print preview. At least thats how I see it, but obviously I'm wrong because it won't work.
I have a project that will need several forms with a similar structure - a Data Grid View control, a few buttons and some textboxes. They are not similar enough to use just one form and change things programatically so I would like to create a "template" and add several copies of it into my project. My first attempts have failed miserably, ending up with lots of "conflicts" and "duplicate items".
So, how should I save a form from my existing project in such a way that I can then load in multiple copies (giving them suitably different names) without having name conflicts?
In the Designing Class section of Sam's 'learning 2010 in 24 Hours', it prompts you to type the following two statements:
Private m_intHeight As Integer
Public Property Height() As Integer
After you press Enter, VB is supposed to fill in the rest of the property procedure template but when I try it, this doesn't happen.I looked for a setting in the options dialog that might need to be set but didn't find one, if it exists.
I am developing an application using VS 2008/MySql and I am trying to export the crystal report on runtime using my own code. I get an error saying:
Quote:Invalid export DLL or export format.
My code is:[CODE].....
I work for a somewhat large company.There are about 160 Windows XP Pro users. We are still using Microsoft Office 2000 for the most part.We have upgraded some users to Office 2003. We are not using Microsoft Exchange.I have to export every users' Outlook 2000 or Outlook 2003 Contacts into an Excel or CSV file every 6 months as a way of backing the Outlook Address Contacts.Currently I am doing this by physically going to every pc and manually exporting the contacts.This is a large pain.I am trying to find out if I can use or create a Visual Basic 2008 Express program or script that will export the contacts from Outlook and save it as an Excel or CSV file.The name of the file should be the same as the computers net name.It should be saved in the same location, on the network, each time.I am new to programming and new to VB 2008 Express.I do not know or have any code to start with.
View 8 RepliesI have been searching the net and these forums for a couple of days to find a solution that will allow me to export my data to .csv Are there any resources around for this function?
View 15 RepliesHow do you export your project as an .exe in VB 2010
when you go Project > Publish "Project Name" it just makes an Application Reference rather than an .exe
I have vb form with 5 DGV to show data on where matched condition on date parameter. Now I want the application to export the filtered rows from every 5 datagridviews to a single mdb file but in different table for each DGV.This should create and insert the rows in the mdb tables files and get it saved at the user defined location.
View 31 RepliesHow can I export everything in my listview? And I want to to export it in parts.
For example if I have 2 colums: Name, Email
I want it to export all the data in those columns as:
Name:
Email:
I use this simple code to export data from my dataset to excel. Now i want to export that data with a condition from the "cbVecka" combobox. I can't figure out how to do that. Any Ideas?
View 13 RepliesI've google so many examples but none of them work. Well they do but they don't perform the way I need it to:
1) Check if excel file with specific file name exists in application.startup path
2) If doesn't exist, then take DataGridView contents (including header names) and write it to a new excel file
If exists, then take DataGridView contents and append to the existing excel file (excluding header names)Can someone for the love of VB.NET paste some code that can do this? I've been at it for 3 days with no sleep and nothing has worked so far I make the smallest changes to code I find online and the bloody thing doesn't work anymore. I don't know why it does that...I already have Imports.Microsoft.Office referenced to my project so I can create Excel Applications on my form.
I am exporting the data in a DataGridView control using the Excel interop. It is working fine, except that it is not creating the headers. How do you include the column headers with the export?
View 2 RepliesI want to make an Export / Import function in my application .. I found some code online that should be able to do this.
[Code]...