Search results for query: *

I have an unusual problem with a DGV. I have DGV with it's datasource set to a table retrieved from a database. After I set the datasource, I programatically add a combobox column to the grid. Everything works fine on my PC, but on the client's PC, when I click the drop down arrow, the...

Thanks. I appreciate your advice again.

I'm learning VB.NET and I am developing an application with a WinForms front end and an Access back end. In the SQL below, I have 4 SELECT subqueries. Each query checks if a person attended a training session, and returns TRUE or FALSE. Obviously, each subquery will be displayed as a column...

I saw a nice bit of functionality in an application at work, and I would like to try to implement it in my own application that I am developing. Basically, my application is used to manage training bookings. The user can select a CourseID and the click event of a command button will send an...

Is is possible to have a child's toolstrip directly underneath the parent's toolstrip. When the child is maximised, the parent's toolstrip is seperated from the child toolstrip by a dark gray line (the boundry of the mdi form I presume). At the moment, I have all the toolstrips used by the...

I'm learning VB.Net while developing a three tier database application. So far, the values for my database records came from textboxes and comboboxes. I passed these values to my DAL (via the BLL) and updated the database using paramatised SQL. I now need to update a database table using a...

I have a question related to the one I posted at http://www.vbdotnetforums.com/ms-access/47948-update-database-using-dgv.html, but as it is a different question I thought it best to start a new thread. I can update the database via the DGV perfectly when the DGV has the same columns as the...

Ahh, the solution is so obvious. Thanks jmcihinney. I really appreciate your help

Hi, I'm currently learning VB.Net, and I have an database application with Access 97 as its backend. Unfortunately, I'm currently restricted to using Access 97 and can't upgrade. So far, when updating records, all the values have come from text boxes or comboboxes, and that has worked fine...

Joshdbr, JuggaloBrotha Thanks for your answers. I appreciate it.

It is possible to run a VB.NET application from a CD, assuming the PC has .NET framework installed. I need to demonstate an application, and I'd rather not have to install it just for a demo. Thanks for your help, Damien.

I have the following routine in a form's load event Public Sub frmAddBooking_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load dtemp = employees.PopulateBox lstEmployees.View = View.Details lstEmployees.GridLines = False lstEmployees.FullRowSelect =...

Thanks for your reply.

Thanks for looking into this for me. OK, so I removed all AddHandlers and RemoveHandlers. Forgetting about them for a moment, when I remove the Visible=False line, no rows are selected, which is correct because I use the ClearSelection method. However, when I reinsert the Visible=False line...

My code below exhibits some unwanted behaviour which I can't figure out how to remedy. It is a sub to load a DGV with a table returned from the PopulateSessionList function. If a parameter is passed to the sub containing a row index, that row will be selected, otherwise no row will be selected...

I have a newbie question. Is there any difference between connecting to a database using the "Add Connection" wizard and manually typing the code, i.e, Dim con As New OleDbConnection Dim ds As New DataSet Dim dt As New DataTable Dim da As New OleDbDataAdapter...

Hi, I've created a simple client/server application with an Access backend. Unfortunately, I'm currently restricted to using Access 97. I have two questions. Lets say there are three fields, RecordID (Key), FirstNumber and SecondNumber. 1) I need a routine to add 1 to the FirstNumber of...

That worked perfectly. Thanks for your help.

Hi, Thanks for your reply. I want to query the database each time the user makes a selection, i.e. the database would contain: EmpID EmpName EmpSales 1 John Smith 100 2 Mary Brown 200 3 Mike Black 300 The ListBox contains the three names. When John Smith is selected, textbox.text = 100 and...

Hi All, I've been learning VB.NET for a few months, and I'd appreciate if someone could assist me with this query. For illustration purposes, lets assume I have a database table with three fields - EmpID(Key), EmpName and EmpSales. I can populate a ListBox with the EmpName field. However, if...