Answer Questions

• Soe VB Microsoft access concurrency issue

  Our company has this internal application which is basically an access application with the backend code written in Visual Basic. Now whenever the administrator wants to make some changes to the document the following message pops up 'You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later.' Only when nobody in the entire company is using the application can the administrator go and change the code. Is there a way around this problem, some sort of design modification that can be made such that the code is changed without any sort of conflict Any help will be appreciated. Thanks In Access, manipulating code is just like ...Show All

• WoFe How do I show a confirmation box instead of a MessageBox?

  I am trying to find a relatively simple way of showing a MessageBox with a "Yes" and "No"(Confirmation box). Can anyone help me please MsgBox is the VB6 way of showing the messagebox. But in vb.net it is replaced with MessageBox. So If You are working in VB.Net then use it's provided method. But there is no problem in using MsgBox because it is still supproted by .net. This is how i do it MsgBox("Message To Display", MsgBoxStyle.YesNo, "Title") if you can go if MsgBox("Message To Display", MsgBoxStyle.YesNo, "Title") = MsgBoxResult.Yes then . . . End if HTH Andrew Create your own dialog form and place the "Yes" and "N ...Show All

• Forbes.Pu Setting a dropdown combo to read-only in visual studio 2005 in vb

  Greetings, I don't want the user to be able to write in a combo box. How do I set the combo to read-only. Thank you, Set the DropDownStyle property to: "DropDownList" this will allow the user to only select those items that are already in the combobox....the other solution owuld be to use a listbox control Thank you, very much. ...Show All

• JohnDough Check if remote computer is locked

  Is there a way in visual basic to check if a remote computer has been locked Cool! Thanks Sven. This is a great help. Hi there, I find this an interesting question. I did some searching on the net and found some VB6 code that uses the OpenDesktop & SwitchDeskop API methods. With a little more searching, I found this article on the codeproject website which does the same in VB.NET http://www.codeproject.com/Purgatory/DetectWindowslockunlock.asp Hope this helps, Luckily it's still morning here, so my IE history wasn't too big This is the original VB6 article I found http://www.developersdex.com/gurus/code/902.asp Hello ...Show All

• Barry Kwok updating totals

  I have a form which shows total sales from an Access database, via a SQL string, when it is loaded. My form also allows me to add additional sales, however, I am unable to update the total sales field without closing and reopening the form - could anyone help me please Happy Christmas. I am using VB2005. can you post the code you are using are you trying to update the database from further totalling fields on your winform application as well So according to your logic this should work - but it doesn't. Not only that but I get an update sales failed message. Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Butto ...Show All

• Can-Ann Is there a DataGridView RowDirty Property?

  I am running some code in the DataGridView.RowValidating event. What I need to do is figure out is the user actually "changed" anything in the current row. Unfortunatly I can't seem to find a IsDirty property for the row, or even for the cells (worst case senario I could have looped through each cell checking the Dirty flag). When I try to check the RowState of the DataBoundItem, I get back "Unchanged". Now in reality, that is not true. But when tracking the code, it appeard that when I change a cell, the change immediately get's pushed to the underlying table object, before the RowValidating event fires. That seems a bit backwards to me. I thought changes made to the data on the grid should only get pushed to the under ...Show All

• robertlamour VB 2003 & .Net 1.1 - Data Write/Read Issue

  Hi, Working upon an embedded application and have conclusively found the following issue. I have an application that was written before in VB6 that has been upgraded successfully to VB.Net 2003. All issues resolved except the following. Previously, we used the Win32 API to make data writes to a logical disk upon the PC. With the current code, we have upgraded to use the FileStream .Net approach to make all data writes and reads. For interest sake, this is an embedded application that keeps some data in a specific logical drive. The issue is as follows, when I power off the PC and power on, the data is being trashed upon the logical drive where it is being written. I am almost certain that the VB.Net approach we have imple ...Show All

• libyan DLL Creation

  I want to create a DLL for editing HEX Data I want that if it is referenced for editing any bytes you need write this line: WriteB (File , Seek, Byte) File= Files to open with FileStream ( Imports Sytem.IO is necessary obviously) Seek= For moving the pointer in a offset Byte= Byte to write in the Offset Now if i want to edit a byte i need write this code Dim str As New FileStream(OpenFileDialog1.FileName, FileMode.Open, FileAccess.ReadWrite) str.Seek(&H18D, SeekOrigin.Begin) str.WriteByte(CByte("&H" & ComboBox3.Text)) And i want to create a Function in the DLL Imports System.IO Public Class Class1 ' Start Function Public Function Nome_funzione As CallType ......... ...Show All

• Glenn Skene SQL and variables

  I am having a problem with an sql statements in my VB.net form. The DB is access and the sql is as follows: SELECT [firstname], [surname], [activityId] FROM tblTraveler WHERE [bookingID] = booking Booking is a integer variable, I am not to sure if I have entered the variable correctly into the sql. When I run it it says that there is a missing parameter. Can anyone see the problem here Thanks in advance Graham Hi, your Query should look like this: Dim Query as String Dim Booking as Integer = 1 Query = "SELECT firstname, surname, activityId FROM tblTraveler WHERE bookingID = " & booking There are many other ways to put Parameter / Variables into Query-Strings. This is just one. al ...Show All

• ubergeek2 tabcontrol pages collection within splitcontainer question

  I would like to have tab pages in a collection on the right side of a split container be dependent on which tab page is selected on the left side of the split container. If I have 6 pages in a tab collection on the left side of a splitter then; 1. If the left most tab of the control on the left of the splitter is selected, then 3 specific tabs of the rightmost tab control should appear on the right. 2, If the next tab (second from the left) is selected on the left side of the splitter, only 2 tabs should appear on the right of the splitter and are different tabs than the 3 that were displayed previously. Is there a way to achieve this at design time If not, how would I achieve this at runtime. Thank you, -Greg ...Show All

• sanjeeva.s Information on working with services

  Hello, I was wondering if anyone could point me in the right direction for writing a wrapper app that interacts with a service we're developing. All I'm looking for is a general management program akin to the way Microsoft SQL Service Manager works with the MSSQLSERVER instance, although a more in-depth look at interaction with services would greatly tickle my interest as well. For now, however, just simple syntax on how to start, stop, check the status, etc. of a service would be wonderful. Hi, take a look at ServiceController class . Andrej I was wondering if it is possible to use the Site member of ServiceController/ServiceBase class to set the parameters for exchanging between the Servic ...Show All

• johnny_no1_boy How to upload files

  Hello I got a problem with uploading files. Look at the code: My.Computer.Network.UploadFile ("D:\file.txt", " http://www.onh1986.com/file.txt ", username , password ) And I set permission to "777". And it couldn't to upload the file. What's problem, please Thanks & Regards I don't know if I'm right, but if you send a File to per HTTP, you will have to write some script on the HTTP-Server, which will handle the File-Upload. Something like < php Check POST-VARIABLES for uploading File If (IS_FILE_TO_UPLOAD) then MOVE THIS FILE TO SOME DIR end if > Okay...is the reason why a secret Do we need to guess I've had success using FTP ...Show All

• byronfromwesleyan How do I get number of days between 2 dates?

  I have been trying to think of a way to get the number of days between 2 dates, for a program that I have been working on, and can't work it out, so could someone please help me with this. Thxs for that this should really help :) Hi, Your welcome. :-) Don't forget to mark this thread as answered.     Regards, S_DS.     Hi, Example taken from the MSDN library help files. These are the System.Timespan or subtraction operations. [Visual Basic] Dim date1 As New System.DateTime(1996, 6, 3, 22, 15, 0) Dim date2 As New System.DateTime(1996, 12, 6, 13, 2, 0) Dim date3 As New System.DateTime(1996, 10, 12, 8, 42, 0) Dim diff1 As System.TimeSpan ' diff1 gets 185 ...Show All

• RICH525234 How to launch Windows Explorer with a special path

  I want so launch an Windows Explorer Window wich shuld show a choosen directory and select a file in this directory. But how To lauch explorer with the specific directory showing. Process.Start("Explorer", "D:\school") This will loaded windows explorer with the directory d:\school as the default directory. I'm dont think that windows explorer takes in any additional parameters to determine default selected files etc. I knew this way, but I want to select a speacial file in the opened directory not only opening the folder. S_A_S, Try the method show in thhe foll ...Show All

• KLankford Help needed on defining Event Handlers via Function

  I am having problems associating event handling with Menu Item clicks. My application has many screens and I need to ensure the same "look & feel" for the Menus on each screen. I have created a function that can be called during a Form Load routine, that will add standard Menus & Menu options to any screen form. I need to be able to associate an appropriate Event Handling routine with, say, the Click Event for each Menu option but the Event Handler must be a different one for each Form so that it can deal specifically with the dataset displayed in that screen. I can't use WithEvents as the actual MenuItem objects are created via the public function and just added to the screen form menu I get the this exception from the ...Show All