Microsoft Access Beginner

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to "front-end" an access dbase that I created. I have gone through all kinds of articles and technet information regarding connecting to my database and that sort of thing. I have successfully connected to it (with an OLEDB Connection) but I do not know how to pull data from it. The database has a main Table (Servers) with various columns in it, specifically one named [Server Name]. I want to be able to have a form where I can enter a Server name and then it returns all the data from the other fields (Serial number, description, etc) into text boxes.

Could someone please help me with a real example as opposed to articles that I don't understand. I also tried to figure it out using the VB.NET Resource kit, but I don't understand their examples as everything is in SQL statements.

Please help!

Sarah
System Administrator
 
I'm not sure what development tool you plan to use (VS6 or VS.NET) but
either one of them should allow you to use a Data Form Wizard. This Wizard
is designed to generate a complete form with Load, Delete, Update, or Add
buttons and it will bind all the fields to textboxes. You could use the
form generated as is or modify it as you need.

I'm not sure but looks like you are not a programmer so it will be hard for
you to modify the resulting form to accommodate for the search capability
that you want in the application.

I hope this helps!


Thanks,
Hussein Abuthuraya
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2004 Microsoft Corporation. All rights
reserved

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
 
Back
Top