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

Quote:

Originally Posted by maximus

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

Quote:

Originally Posted by Antmeister71

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

Quote:

Originally Posted by gottimd

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.

09-13-2005, 06:02 PM	#3
maximus Banned Join Date: Oct 2003 Location: Where the system is screwed	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? Last edited by maximus : 09-13-2005 at 06:03 PM.

09-13-2005, 06:15 PM	#4
Mr. Wednesday Pro Starter Join Date: Jul 2003 Location: South Bend, IN	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). __________________ Hattrick - Brays Bayou FC (70854) / USA III.4 Hockey Arena - Houston Aeros / USA II.1 Thanks to my FOFC Hattrick supporters - Blackout, Brillig, kingfc22, RPI-fan, Rich1033, antbacker, One_to7, ur_land, KevinNU7, and TonyR (PM me if you support me and I've missed you)

09-12-2005, 01:50 PM	#2
maximus Banned Join Date: Oct 2003 Location: Where the system is screwed	just a bump back to the front page.

09-13-2005, 06:17 PM	#5
Antmeister Pro Starter Join Date: Dec 2003 Location: At the corner of Beat Street and Electric Avenue	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.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)