detoxx

I find that combobox.SelectedValue doesnt work very well with database updates. I personaly use combobox.SelectedItem. Which sub are you having trouble with? paste just that one sub :) When you say updating your DB, I assume you mean adding new records? This is how i would do it; [code] Imports …

Could you provide a bit more information? what happens when the program refuses to run?

I'm currently in the process of creating a Windows application much like "Steam". The problem I'm having is that I need to be able to add new games to the list which auto generates a button and the code behind it. I have no idea how to do this. Can …

the combo box in the SQL statement is wrong. it should read: [code]sql = "Select Unit_Price from Inventory_Price where ITem_Code = '" & combobox.SelectedItem & "' And Ending_Date is null" [/code] I hope this helps

That can be solved through the Access database itself. Look in the design view of the table and in the field properties you can set a primary key or set that particular field to allow null values

[code]Imports System.Data.OleDb Public Class Form1 Private objconnect As OleDbConnection Private objcommand As OleDbCommand Private objreader As OleDbDataReader Private Sub BtnOK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnOK.Click objconnect = New OleDbConnection objconnect.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; " & _ "Data Source = YOUR_DB.mdb" objcommand = New OleDbCommand objcommand.CommandText = "INSERT …

for one, using the connection wizards are always harder than actually coding it yourself. It creates more problems than the worth of it, you will learn this in time. One thing I found when I used to use the connection wizards were that when I'd use the SQL query builder, …

Here is my problem. I'm creating a program for my workplace which stores hours worked, calculates pay and all that stuff. Problem being, the database will be accessed through the network and i want to be able to select the database from an openfile dialog on first use to locate …

steveneaster: Datatable is a function to do with the database controls not a table. Aldius: Its a bit long winded, but one way you could do this is through comma delimited view in a text box. You can read from the field names and input them into variables and use …

[code] USE YourDBName GO SELECT * FROM sys.Tables GO [/code] hope this helps

I hope you can help me. I'm working on a program that will open any Access database that might be on the system. The problem I'm having is that I cant get get the SQL statement to show all the tables within the database. The code im using is as …

Hi there. My problem is that when i click play to resume a paused song it starts the song from the beginning. I added an IF statement to the play button to say basically ... IF PAUSED THEN PLAY (RESUME) ELSE PLAY FROM IMPORT LIST. The problem with the IF …

Can anyone help me please? i need to create a program in which you enter a distance and the program will tell you how long it will take to get there in hours minutes and seconds. My trouble is that they all display independently and not seperately ... for example …

Hi, im new to this forum, and searched for everything to do with 2D array, but found nothing to no real avail. My problem is that i have to write a 2D array in pascal that stores 15 student ID's and 5 marks for each student. I've managed to write …