p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Visual Basic 2012 Programmer's Reference (http://p2p.wrox.com/forumdisplay.php?f=694)
-   -   Missing a concept somewhere (http://p2p.wrox.com/showthread.php?t=89073)

DaveF January 3rd, 2013 11:50 PM

Missing a concept somewhere
I go back a ways as an amateur programmer, and the data abstraction and object orientation of today's systems leaves me feeling a bit disoriented. What I used to do to pass information around, write some data to a file in one application, and open the file in another has become vastly complicated trying to decipher the names and functions of data objects, and finding that what books and sample codes do are never what I want to do. It leaves me wondering whether I'm wanting to do the wrong thing...that there's another approach to the problem, or whether my interests are obscure.

With that preamble....what I am doing is using Access to create and manage the user side of data organization. I'm managing collections of photographs. I'm using Access rather than coding the whole thing in VB because I can crib from Access stuff I've done for work. Most reuse of experience, code and form design. Now to actually do something with this information I need to work in a programming language, and most of what I want to do can't be done in VBA, but seems accessible VB2012 or VB.Net.

Fine...but what I want doesn't seem to be discussed. All I want to do is pass the data I have in my tables to VB. Simple, but for the life of me, I can't find an example that
1) dimensions something to be the receiver of that data
2) gives me a sample line of receiver(contents)= databasetable (contents)
so I can
3) do something with receiver(contents)
4) somewhere in there is also a description of how some wizard does most of this that I'm not following.

I suspect the example is in the book or the sample code.... but I'm just not OO lingo savvy enough to see it. I go back to Fortran punch cards folks and I don't program for a living. All I'm trying to do at the moment is get a working prototype going. A real programmer could probably do it all properly in a few days, but I need to having something to get to that point.


Rod Stephens May 20th, 2013 11:32 AM

Sorry for the slow reply. I missed this post.

It sounds like you're stuck getting the Access data into a VB program.

You might want to look for a book on database programming in VB .NET. There are a lot of details that you might need to consider.

Here are also a couple examples you can look at:

Note that working with images inside an Access database (or any database) is fairly tricky and annoying. You might get better results if you only store the file names for the image files in the database. Then you're only working with plain text, which is a lot easier.

Sorry again for the later reply.

DaveF May 20th, 2013 12:07 PM

I've long ago solved all of this. Thanks anyhow. My project involves VB.net, a web side of things, the Access data base as common between the two.I even use the data base to pass information between the webside of things and the basic side of things. Pretty clunky....but eventually I'll have enough proof of concept that we can get someone who knows what they're doing working on this.

Rod Stephens May 20th, 2013 12:58 PM

I was afraid of that. I never subscribed to that forum so didn't realize there were posts in it. I have subscribed now so it shouldn't happen again. (Thanks to my editor Bob for noticing that I wasn't subscribed.)

I don't know all of the details of your program but sometimes it's nice to have the separation provided by files or a database between two very different processes such as a web application and a program. It may seem clunky but the separation can make managing the two pieces a lot easier. (This is the idea behind multi-tier applications, although the separation might not be as wide.)

Anyway, I'm glad you figured it out and I promise to get back to you sooner in the future!

All times are GMT -4. The time now is 04:22 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.