o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

populating a form from a database (SQL) -

Hello,
I am doing a project for college and I have confused myself!
I am making a booking system for a nightclub.
I want the user to be able to enter a band name into textbox1, click the check button, and if the band has been previously booked the program to populate all the relevant fields in the form i.e. Promoter, Address etc….
Now I know I have to use SQL to do this but I am having a real hard time with it!
Here is my MS access DB table I want to check

BAND (Table name)
Band
Promoter
Address1
Address2
Town
County
Country
Postcode
Telephone
Fax
email

I am using SQLOps.dll to call the database i.e.
Dim DB As New SQLOps.MSAccess (“Veroelectronics.mdb”)

So if the band name is found in the table then textbox2 will be populated with the promoter name!

If anyone can help it will be much appreciated!

Thanks for looking!!!!

Iain

 

form doesn't show before long process -
I am populating a listview with a 4000 records recordset on FORMLOAD. the thing is my form does not show before leaving the user with the impression that the system froze for about 7 seconds. Is there a way to show the form before populating the listview? I have tried populating on F

Populating Forms -
Hi, Can anyone help me with this problem? I am populating a form from a SQL Server database. Some of the columns from the database are NULL and I need to show all the info from the database. The form can then be updated. (NULL values may be written back. Problem is when I'm

Form Loading -
When is the best time to do some database work when populating a form. The form is there to allow a user to update a database, so I need to populate some Controls with data from the database. The database is fairly large, so it takes a while to load the form. I've tried the code

How to populating data to a Web Form -
Hi, I would like to know if there is anyway to populating some predefined data (eg. Name, Address, etc) to a web form (HTML Form) using VB/ .NET? eg. I have an application, to read data from a Card device and would like it to populate the information to a web page to fill in the form

Populating combo box from database -
Hi, I'm pretty familiar with populating drop-down combo boxes in ASP, but I could use an example of how to do it in Visual Basic. Does anyone know where I could find an example of a combo box being populated with data from a database? Thanks

getting data from one database to another database -
I'm attempting to learn VB.Net on my own and I have a question. I want to get data from one access database to another. I actually did it by populating invisible text boxes on my form first and then sending it to the other database, but I'm wondering if theres a way to do it directly.

Flicker While Populating Tree View and ListView -
Hi, In a project that I am currently working on in VB6, I have a treeview (showing folders) and a listview (in report view mode). I have defined database operations (Add/Update/Delete, etc) in an Activex DLL which raises events on success or failure on any of the operations. I

How to Activate an event -
I have a simple DAO database on a multi-tab form, one tab the database, on another tab a drop down combo box that is populating data the database, my problem is that the dropdown combo-box will only populate the updates only after the pogram has been closed and re-opened. Any input

Form Load Question - Hopefully Simple -
I have two forms in my program. When the first form loads, I have it populating a listbox. I have an update button which will load the second form. On this form, I make my changes to the database and then save it. On exit, I close out the second form and go back to form1. How do I

DataSet Vs DataReader -
I am new to VB.NET, For needs where I will be populating(Number of records retrieved will be around 10 from SQL Server Database) a Dropdown box in a Form what should I use the DataSet or DataReader. The populating of Combo box will be at Form Load and the Application will be used b

Autofilter with MSFlexGrid and with populating utility -
Hi everyone, i enclosed a part of my project(with its database) with utility of showing,adding,updating,deleting,autofiltering and populating the records on MSFlexGrid. (I thank for support codes)

Low perfomance populating MsFlexGrid -
Hi Forum! I'm migrating a program from VB6 to VB.NET. I used the MsFlexGrid control in VB6 and there is not any equivalent in NET, so I must keep using it. It runs ok, but populate it takes four times more than doing the same in VB6. On top of this, switching the visible property

Populating Comboboxes -
Hi All, I am having a problem when populating a combobox from a table within a SQL Server database. The combobox only returns the first record in the recordset and does not populate the Entire list with the contents of the table. Also, would anyone know how to display both colum

"proper" way of populating listboxes -
I've been trying to clean up my coding style a bit, and was wondering whats the "professional" way of populating listboxes with values from a database without having sql queries littered through out my forms. I'm trying to make it as clean and OO as possible. What about a

Populating Combo Boxes ..Help!! -
Does anyone have any code for populating a single combo box on an ASP page(Possibly using Javascript)? The code i have works fine in the backend VB FORM, however im not sure how to transfer this code onto an ASP page?? Thanks

Database compaction with vb -
I was wondering if you could compact an Access Database with VB or VBA or VBScript. I am populating the Database from txt files and the size of the Database is very large after I import the data. I have to go into Access and Compress the database back down to its original size. I wo

How to assign a key and value to item in listbox -
So I have a dropdown box in a form that I am populating with entries from a database. Each entry has an ID number and then a name. I would like the name to be what is seen in the listbox but when the backend of the program is running it should be using the ID. Is this possible in

Sort of modal type question -
I have an mdichild form which I am populating with data from a database. What I need to be able to do, is deny users the ability to click on any other forms (mdi or child) until the populate function has completed. How can I do this?

[2005] Getting Schemas from SQL2005 -
I''m not sure if this is the right place (maybe database section) but here goes: I need to get a list of all available schemas in an SQL 2005 database to populate a listbox in VB.Net form. Populating the list is not a problem but how do I go about getting all then schema names in t

Drop-down list problem -
Dear all, Im populating data from the database into a drop-down box. Its working fine as far as putting the data from the db to the drop-down. My problem is when I want a particular record's value has to be displayed after populating, how do i do that? For instance, the dro

Repeating string populating combo box -
I've got a combo box I'm populating with values from a field in an Access database. The field is a string containing week beginning dates and ending dates. The data stored in the field looks like "01 - 05". The next value would be something like "07 - 12". Each

Using a record set to get data from 2 tables -
Hi all, I have a form where I am getting values from SQL server database and populating text boxes. These textboxes are bound to an ADO which is related to a table in the database (suppliers) I have another table in the DB (products). The supplier id is a foreign key in the produ

Populating a DataGridView with Access database programmatically -
Howdy, I am new to these forums and I wanted to know how I can populate a DataGridView object on my VB.NET form programmatically. I'm using an ADODB connection to open my database and have a recordset defined. All I want to do now is have that recordset show up in my DataGridView.

populating comboboxes from database -
Can someone please help me?! I am having trouble populating combo boxes from a MS Access database and I hoped maybe you database gurus can come to my rescue. I have a database with three related tables and I want to access this database via 3 combo boxes. The tables are Core_MAT, MA

populating another form based on user session -
Hi, I have finally been able to create a successful login page thanks to your help. Now I want to fill in some textboxes on the DRI form based on the user who has logged in.Specifically the Evaluator textbox should be filled in by the evaluator field from the database. Your sugg

Using Dataenvironment for populating controls -
I'm using upto 50 command objects in a data environment( connection using DSN) in my project for populating data (from sql server 7.0) in data combos and grids by directly bound the controls to the corresponding command objects. I want to know if this type of programming is a good prac

Find/search -
What is the difference between to populating 5 combo boxes with data from the database and set databound to database?? will that bring out the same result? Thanks Brian

Asp.net customvalidator with database -
I'm new to asp.net (and to this forum), and have a question about using some validation tools. I've been given the task of making a new web based form for the fleet vehicles we release at work. On the form, the user fills out information such as the driver of the vehicle, dates the d

Just too weird!!! -
I've got a recordset open (ADO) for a record from an Access table. When I'm debugging the code I put a breakpoint where I'm populating controls on my form from the recordset. Now this is the really weird bit .... When I hover over any of the recordset's fields you get a toolti

Connecting combo box to two access databases -
Combo Box trouble. I've connected it to one access database, but I'm having trouble populating it with data from another access database. Any ideas what I'm doin wrong? Can you not have two diff data base connections on the one form? It should be easy but I'm getting no-where. Please h

Populating 1 listview from another -
Is there a quick way of populating one listview from another ? Each listbox has the same number of columns.

binding a flexgrid to a database -
I have a database made out of a delimited ASCII file at runtime. Populating the DB is a no brainer, but I don't seem to be able to bind a flexgrid on my form to the database with success. That is, the grid gets bound to the DB and the header columns are neatly filled with the DB ke

Populating 2 tables -
I have a form that captures movie info using movie table (MovieId, title, actor, producer, comment) and I also have movieInventory table (movieInventId, movieId, cost, quantity, datepurchased) The MovieId field is auto_number in the movie table. On the entry form, I have several tex

Populating data sets -
Hopefully someone can point me in the right direction with this problem I'm having. I have a table: profession, with the fields: id, & title and have a combo-box on my form which I want to populate. From what I've read so far, the best way to go about doing this is by using

database question -
ok i need to know how to copy one record from one database to another in vb I have one form that has one database and another database that has another using a data control. the one database has a add to database which is on the form that has the original database. What i want to do i

Populating Listboxes from Access database -
Can anyone help ? I am using VB6.0 and want to populate data in a list box from information contained within an MS Access database.

Updating database in datagrid -
I'm populating my datagrid with a dataset in design time. Is there a way I can use or call the UpdateCommand to update my database without rewriting the update sql query to update my database file? Many thanks in advance! ljCharlie

Populate TrueDBGrid -
Can anyone help me populating a True DBGrid from the database?

Populating Excel from VB6 -
populating cells from VB isn't a problem, but the Excel file has a CheckBox control that i am trying to set to True or False. I can't get a handle on the control from within VB. Any suggestions?

Populating a ComboBox from another form! -
How do I populate a combo box that is on another form? I am letting my users create new categories for the software and after they do that I need to update the combo on the main form with that new category name. Ideas?