carlosm06
asked on
Displaying an Access database through a VB application
I have a VB frontend application and Access as the backend database. The fields that I have are 1. model (list box) 2. OS (list box) 3. RAM (listbox) and 4. HDD (list box) 5. MONITOR (YES/NO) 6. ship date (date/time) and description (memo). These are the fields in the access database. I would like to display these fields with VB. What code can I use for this
ASKER
well all I did so far on the VB side was create the controls and have not linked the controls to the fields in access. Is that all I need to do to accomplish that?
you can use the table or a query as the record source of the form that you created.
to display the records in the form, bind the related controls to the field from the table.
to display the records in the form, bind the related controls to the field from the table.
ASKER
Elaborate on specifically how I go about doing that. Am I doing that from the VB side?
Am I doing that from the VB side? yes
see if this link help
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=753872&SiteID=1
see if this link help
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=753872&SiteID=1
ASKER
I looked at your link, but that's VB studio 2005. I 'm doing it in VB6. Are there any links for vb6 or help with coding. Basically, I would like to use this form for input as well as navigating through the database.
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
select * from nameoftable