access and vb.net 2005 help

B&W · 13 Jun 2007 at 17:43

Hi, I have a datagrid in a form that displays information from a access database.

To add data to this database, you have to open a form enter all the details into textboxes and then use a parameterised query.

I've heard that its possible to edit data directly from the datagrid control, how would I go about doing this?

Also when I search for a unique ID (reference number for me) that each record in a table has I want this to be displayed on textboxes.

Eg, I have a textbox on one form and using this I can search for a particular reference number. How do I make it so that the results of this search are displayed on a series of textboxes on the same form.

B&W · 13 Jun 2007 at 22:18

Also is there a way I can get a professional installer program?

eg, when you download a program from the internet, the main file is usually setup.exe.

Can I get something like this for free?

B&W · 14 Jun 2007 at 14:38

If anyone knows something that could help me with the problems I listed in the first post I would be grateful, if anything is unclear then let me know and I will clarify it.

B&W · 14 Jun 2007 at 14:51

yes the datagridview control

B&W · 14 Jun 2007 at 16:11

thanks for that but found another way to do it.

what about this though, any tips?

Also when I search for a unique ID (reference number for me) that each record in a table has I want this to be displayed on textboxes.

Eg, I have a textbox on one form and using this I can search for a particular reference number. How do I make it so that the results of this search are displayed on a series of textboxes on the same form.

B&W · 14 Jun 2007 at 19:45

B&W · 15 Jun 2007 at 20:51

update query

Need help on a update query. Basically I select a record from the datagrid, then press a button that opens a new form where I enter all the stuff I want changed into textboxes. Then I press an update button which calls a parameterised query.

At first it would update all the records to what I entered, so I put in SELECT TOP 1 and now it updates just the top record of the table.

How do I get it to edit JUST the record I want.

I presume I need some code in the button I use to open the textboxes form?

B&W · 15 Jun 2007 at 22:17

lol its orite m8

B&W · 17 Jun 2007 at 21:04

can any1 help me on the following

Also when I search for a unique ID (reference number for me) that each record in a table has I want this to be displayed on textboxes.

Eg, I have a textbox on one form and using this I can search for a particular reference number. How do I make it so that the results of this search are displayed on a series of textboxes on the same form.