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
Last Comment
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
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
select * from nameoftable