Re: Populating an Access database with VB

Tech-Archive recommends: Fix windows errors by optimizing your registry



Neil P wrote:
Hi all,

Im very new to VB so please bear with me, here is what i want to do

I currently have a shop and want to develop an application to show me
sales, items in stock etc.....

I have done the basics in that i have got the application looking how
i want it to, the problem that i now have is that i dont know how to
get the information to the database and also how to get at the
information when it is there

What i would like to do is to fill in a screen and then this
populates a table in Access, e.g. Stock item table with Cost price,
selling price, supplier, etc...., which can then be queried, like how
many items have I bought for less that £10

Also i would like to have another table, which lets say has clothes
sizes, which i would like to be able to populate into a combobox, if
that makes sence

Any help on this would be really gratefully received as i am really
struggling with this now

Thanks for reading this post

You best solution is to go to your local technical bookstore, and purchase a
book on VB6 DAO (Data Access Objects). The topic is broad, and in all
seriousness, you will struggle to get all that you require on a forum. A
book is definately the best option.

There are some stuff on the web
(http://articles.techrepublic.com.com/5100-3513-1045296.html being one I
just found) that could help, but database access is a subject all in itself.


--
Regards,

Michael Cole


.



Relevant Pages

  • Re: Populating an Access database with VB
    ... Im very new to VB so please bear with me, here is what i want to do ... items in stock etc..... ... What i would like to do is to fill in a screen and then this populates a ... table in Access, e.g. Stock item table with Cost price, selling price, ...
    (microsoft.public.vb.database)
  • DropDownList Confirmation
    ... I have been struggling with this for a while, ... related postings, but nothing that answers this ... the syetm should prompt with a confirmation to ask ... I have the code behind that does the save, populates the screen etc. ...
    (microsoft.public.dotnet.framework.aspnet)