Answer Questions

• hopark16 Help with Writing to Excel

  Can someone please help me write to Excel (Office XP) from Visual Studio.Net (2003) using a Data Adapter Here is my code: (I have been able to connect to Excel, import the data, and fill myDataSet with the Excel import) myConnection.Open() myAdapter.UpdateCommand.Parameters.Add( New OleDb.OleDbParameter("@col2", OleDb.OleDbType.Integer)) myAdapter.UpdateCommand.Parameters.Add( New OleDb.OleDbParameter("@col1", OleDb.OleDbType.Integ ...Show All

• Ragas my.application.log

  I have a Data Access Layer dll file to talk to datatabase, I am trying to log data change action in this DAL assembly using My.Application.Log, can I just add a app.config file to DAL to make it happen I tried, but not work. Since the post above, I am trying to use the exe assembly app.config to log database changes. it works, but I have 3 questions, 1. can i use filter to tell if log entry type is INFORMATION, then go to one cust ...Show All

• ViKing.Net Word.Application

  How can i identify which is the actual page and actual line. I need to know, because the window is invisible. Tks.. Sorry, and thanks... No need to be sorry, from your original posting it just seemed that these would probably get you an answer quicker from people that are more into office automation. The fact that you want to call it from VB.Net (I assume because your really didnt state it) shouldnt be an issue. If you ...Show All

• zmy How do you use sound in your project?

  Ok, I'm trying to make a cool project but I can't put sound in. Can sombody tell me what's wrong dim soundengine as new media.soundplayer soundengine.load("explode.wav") Just to correct your code : Dim soundengine As New System.Media.SoundPlayer ( "explode.wav" ) soundengine.Play() He might have imported system... And you can use Microsoft.DirectX.AudioVideoPlayback namespace ...Show All

• SMFX mp3 encoder sample application

  hi everyone, thought you guys would be interested in this application, it converts a low bit mp3 into 128 bits pretty cool, its in vb.net express 05 its in rar format http://www.savefile.com/files.php fid=4163675  the sourcecode is inside the rar just wondering how do you make a ctrl+n to open new window in a application The way I usually go about it is make a menu item that opens t ...Show All

• Rama.NET numeric calculations problems

  Hi guys, I have a problem in working out some calculations within a form. My form is called, claddagh_database, which is linked to data from an access database using Jet 4.0 I have some fields with money values in, Total value inc VAt, Deposit, Stage Payment & Balance Payment. In access I had a field called Money Due, which was calculated using the expression  Sum=([Total Value Inc Vat]-[Deposit]-[Stage Payment]-[Balance Payment] This t ...Show All

• Taurineman Filtering Data from Access DB into windows Form

  I am able to pull the data from my access database into the windows form fine.  What I want to do is filter this data so only one record is displayed, or even if there was a way to skip to a selected record by doing a search. The user is going to be required to enter two peices of information Job Number and Skid Number.  I then based off of that information want to display the data that matches these two variables. With Access I was a ...Show All

• renard DrawRectangle method creates oversize rectangle

  Why does the DrawRectangle method generate rectangles that are 1 pixel too big I'm unsure if this is a bug (which it certainly looks like) but if you draw a rectangle and use the FillRectangle method, it fills correctly, but when you draw it using the DrawRectangle method, it's one pixel out. I know the obvious solution is to reduce the size of the rectangle by 1, but it's most annoying, especially if you use the Rectangle.Inflate method to draw ...Show All

• Rosario M Cannot initialize array

  I'm wondering if somebody could help me resolve the infamous ""Object reference not set to an instance of an object." when I try to execute the following: I have a class like the following: <code> Partial Public Class BinaryTreeSrchCrit Private intFldNum As Integer Private strSrchValue As String Private strOperator As String Private intSrchID As Integer Private intGrpIdx As Integer Private intPropIdx1 As Integer Private intP ...Show All

• Craig Shaughnessy pb : Query with parameter

  HI I use an Access Database and want to create a query in VB TableAdapter Query Configuration Wizard. The query contains a parameter like : select Field1,Field2,Field3 from MyTable where Field1= @Field1 When I Try to validate the Query the Wyzards sends me the error : Error in WHERE clause near '@'. Unable to parse query Text. Can you help me Thanks. Hi, So... There is no way to use named parameter with a ...Show All

• Vedat ARAL How to enchance text area in forum?

  I had build a very simple forum. May i know that how can i enchance my forum like gave some function in the Textbox For example , Bold, Italic,Underline, Color of Font and emotion icon . Can anyone gave me the example of code I need it so much. Thank you. Hi in VB2005 (and VB2003 I think) create a FontDialog and then go         ...Show All

• JMcL A complex coding for me

  Ok this is some kind of thinking. I tried thinking of a way to structure the code but couldnt. Maybe this is not even possible Items on my Form: MonthCalendar1 Label1 Textbox1 Button1 Ok this is a kind of to-do-list. So everytime i select a date on the monthcalendar1, it should show me what things i have to do on label1 like "today collect laundry" Now how do i set the to-do-things. I select a date on the monthcalendar1, i type som ...Show All

• Chuck H Refactor and Module?

  Started today my first experiences with VS2005 Beta2. I also installed the Refactor! AddIn and tried with the most simple project: A console application! Extracting a method was not possible. I think the reason behind it is that the wizard creates a Module, not a class. (With a Windows application all went ok. Great product by the way!) Strange, it now works. The only difference I see is the fact that the firs ...Show All

• Rulez how to disable the Validating-Event when Form Close

  i have a form hold some textboxes ,writed validating-event code and sometime set cancel=true in validating now,the problem is,when i click the close button of the form,the validating-event fired,and the form can't close when the validating set cancel=true,but this not i want.i think click "close" that meaning abandon all the form's data,so it not need validate. how can i do Hi,   The Field-Validatio ...Show All

• Morteza Hashemi Photo Matching Database

  User selects a picture and querys the database for a match. How do I write the Code for this SELECT id, image, description FROM pictures [database] WHERE image EQUALS picturebox1.image I am concerned that the "image" format stored in the db will not match  picturebox1.image and that I probably will have to convert picturebox1 into a binary array to match the format already in the database.  Furthe ...Show All