PDA

View Full Version : MS Access Database questions


maximus
09-11-2005, 09:09 PM
There may be an easier way of doing what I am about to explain but access is what I ahve to work with (I actually own VB.Net as well but I do not know much about it).

From FOF2K4, I will be "printing" or using a great utility created by Chris Willoughbt called TCY/FOF Export Utility (0.1.3). What I plan on doing is creating player cards for each player in my FOF2K4 universe. Obvioulsy this will be done outside the game. I then plan to have them output (from access) to HTML format - maybe.

I know how to get the data in the database - thats easy. I also know how to build a datatbase, which is actaully really easy considering there is a wizard one can follow. What I don't know how to do is adding player images for each player card. When cycling through each card I want the player image to correspond with his respective card. Is there an easy way I can do this?

Here is what I have so far;

I know that the folder which will contain the images must be near the DB. There also must be a field in the table (lets say a QB league leaders table) that must have a name associated with it such as - img1.jpg. However, isn;t there a code that must be written as well somewhere in the DB.

Unless there is an easier way of doing this I would love to see it. I appreciate any and all help. Thanks.

maximus
09-12-2005, 01:50 PM
just a bump back to the front page.

maximus
09-13-2005, 06:02 PM
Just one more bump.

Any sites that could assist in this would be great as well. I have done some looking and actually did find some sites but would like some more if anyone has them.

also edited the title since the question may be used for other projects.

Guys, I do have VB.Net. Is there an easier way to make such a utility using that and access?

Mr. Wednesday
09-13-2005, 06:15 PM
OK, if you're working off of an external image, you're going to need to do something to display it. I'd guess that would involve code. If you aren't trying to hide the Access part of things, then it would be easier to do it in Access, certainly, and Access VBA is largely the same as VBA elsewhere (though different in some important details from VB.NET).

Antmeister
09-13-2005, 06:17 PM
Well in order to accomplish what you want to do in Access, all you have to do is learn how to create a form (for cycling through the players and viewing the data) and a report (for printing and/or exporting into HTML).

With that said, if you are doing this for online purposes, I would go through the route of learning PHP/MySQL.

gottimd
09-13-2005, 06:18 PM
Just one more bump.

Any sites that could assist in this would be great as well. I have done some looking and actually did find some sites but would like some more if anyone has them.

also edited the title since the question may be used for other projects.

Guys, I do have VB.Net. Is there an easier way to make such a utility using that and access?

Check the boards/forum at mrexcel.com.

There is an Access section and the forum moderators are very helpful and pretty quick in responding, especially if you post from 9-5EST.

maximus
09-13-2005, 07:13 PM
Well in order to accomplish what you want to do in Access, all you have to do is learn how to create a form (for cycling through the players and viewing the data) and a report (for printing and/or exporting into HTML).

With that said, if you are doing this for online purposes, I would go through the route of learning PHP/MySQL.

Yeah, I have already created a form and reports. All I need to know is how to display it more "nicley" with player images.

Like I wrote earlier, this database will be my outside source where I keep all of my stats for each of the players careers. I basically would like to create a "CATOBASE" like feature but I know that will be next to impossible for me right now. So something simple would be just fine (whch I have done about 50% of so far).

maximus
09-13-2005, 07:13 PM
Check the boards/forum at mrexcel.com.

There is an Access section and the forum moderators are very helpful and pretty quick in responding, especially if you post from 9-5EST.


that site sounds familiar. Thanks gottimd.