• Advertisement
Sign in to follow this  

for Applications, not games

This topic is 4409 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

Hey all, My professor gave us this assignment; Create a game using Microsoft Access 2003. I had never programmed in Visual Basic nor Visual Basic for Applications so I started learning. I got it all under control now, but then I dived into creating an actual game in Access. I found that Microsoft access doesn’t support any reasonable method for creating even a simple sidescroller. Two questions: I was trying to use D3D8 but it doesn’t work because the form doesn’t show before creating the device or something. Does anyone know how to use Direct3D8 in Access 2003? And then, did anyone create a sidescroller or something in Access 2003? GBS

Share this post


Link to post
Share on other sites
Advertisement
Well what did you expect???
I've never heard of Access being used for a sidescoller and I'll bet you that if it had functions to do that, it would be the downfall of MS. :)

The only reasonable way of using Access for a game is storing data in the database. Programming DirectX with VBA code is no joke it's torture.

Just build a tic-tac-toe and store the highscores in the database :)

Which school are you in?

Cheers

Share this post


Link to post
Share on other sites
Quote:
Original post by ernow
The only reasonable way of using Access for a game is storing data in the database. Programming DirectX with VBA code is no joke it's torture.

Assuming that VBA is the same thing as VB (never heard of VBA before) it isn't that bad. I did DX in VB6 for awhile, made some pretty neat stuff.

Granted, if you've never done it before, it'd make using it for a project a real pain as you'd have to learn it. And it can be hard at times (especially to set up).

Share this post


Link to post
Share on other sites
Mhhh, a game in Access... Actually, I can see 2 types of games that could go well with that:

- The text RPG, which presents under a "form" style, with a text describing the current situation and buttons giving you choices

- Management kind of game, (could be business, football team, or whatever), where you set some data at the beginning of the turn, run your algorithm to see how the situation evolves. In the football team kind of game, you can buy players, decide in which cup you want to compete, launch an algorithm that tells you if you win or loose, and what revenues you get. Then you can buy some more players, etc.

Share this post


Link to post
Share on other sites
Personally I'd recomend trying to do something like pong or breakout. It'd be rather simple to setup you can just layout image elements on the form and use the mouse for control. I'm sure there's a mouse move event you can utilise.

Share this post


Link to post
Share on other sites
Along time ago I made a 'game' with excel with no programming knowledge. It just used formulas to calculate how many units I would sell from a virtual store and the 'player' would have to adjust prices/wages/advertisement/etc. to sell the most units. It had no graphics and no programming, but it was a 'game'(it had a goal, it had a challenge, it had player input). Is your professor looking for something like this since I'm pretty sure that Acess could be used to create something like that too?

Edit:didn't read small_duck's post, but the second suggestion is pretty much what I am talking about.

Share this post


Link to post
Share on other sites
Quote:
Original post by Mushu
Quote:
Original post by ernow
The only reasonable way of using Access for a game is storing data in the database. Programming DirectX with VBA code is no joke it's torture.

Assuming that VBA is the same thing as VB (never heard of VBA before) it isn't that bad. I did DX in VB6 for awhile, made some pretty neat stuff.

Granted, if you've never done it before, it'd make using it for a project a real pain as you'd have to learn it. And it can be hard at times (especially to set up).


VB and VBA are entirely different. VB is multiple purpose. VBA is Visual Basic for Applications. It's not meant to really deal with anything other than the extreme basics.

Share this post


Link to post
Share on other sites
I got directx online in VBA(yes, Visual basic for applications)! The only thing that didn't work was rendering! :S Well I gave up on that.

I looked for many things I would be able to make in VBA, but eventually I got an idea. Do you remember the game gorillas, in qbasic? Well I cloned it in VBA access. And I've got to say it looks pretty nice! (for access)

I'll post screenshots when I have one!

GBS

Share this post


Link to post
Share on other sites
Your professor sounds like a bit of a sadist though..... creating a game is tricky enough in a real language, never mind one as cut down as VBA.

Share this post


Link to post
Share on other sites
My guess is your teacher is just looking for some sort of simulation, guess the number game, or the like.

EDIT:

Also, if the teacher is teaching you VBA and Access or whatnot, do you really think shes going to give you bonus points if you use DirectX? Probably not. He/She is probably looking for your knowledge of using Access and/or VBA. Dont get caught in something too big and not getting it done if its for school (i have done that before)

Share this post


Link to post
Share on other sites
Your are missing the benefits of the given tool... Access in this case. Instead of trying to do something that this tools is not designed to do, focus in the things you really can do.

I.E. You can do a text based RPG. Like the old Hitchhikers Guide to Galaxy or Zork. You could desing a little game that takes you from a place to other and describes the environment in each moment. Like:

-----------------------------------------------
You are standing in a tavern. A fat bartender is cleaning the tables and a not really pretty barmaid is serving some drinks.
You are hungry.
There is a door to the west.
There is a window to the north.
There are stairs to the south.
----------------------------------------------

So you enter:
west

The game looks into the DB and finds west is a street. So it writes:

-------------------------------------------------
The lamp in the front of the 'Red Dragon Inn' allows to see only some meters before the darkness of the moonlees light devours it.
You hear a moaning that comes from a nearby alley to the north.
There is a door to the east.
There is an alley to the north.
There is a street to the south.
----------------------------------------------

So you enter:
>Draw sword

--------------------------------------------
You draw your sword and feel the cold steel in your hand. You feel more confident.
You hear a moaning that comes from a nearby alley to the north.
There is a door to the east.
There is an alley to the north.
There is a street to the south.
-------------------------------------------

.............

And so on. There are lots of games of this type and I'm sure you can program a simple one for your assignment.

Other games that make heavy use of a DB are games like HatTrick.

Luck!
Guimo


Share this post


Link to post
Share on other sites
Quote:
Original post by PaulCesar
Also, if the teacher is teaching you VBA and Access or whatnot, do you really think shes going to give you bonus points if you use DirectX? Probably not. He/She is probably looking for your knowledge of using Access and/or VBA. Dont get caught in something too big and not getting it done if its for school (i have done that before)

You are right, I didn't see that at first. I Got directx out of my head, it's just to complicated. (And it also didn't work :D)

Quote:

Your professor sounds like a bit of a sadist though..... creating a game is tricky enough in a real language, never mind one as cut down as VBA.

That's the whole point isn't it. He wants to see how we handle the situation.

Quote:

Your are missing the benefits of the given tool... Access in this case. Instead of trying to do something that this tools is not designed to do, focus in the things you really can do.

My prof also gave me the following instructions: Player must be able to change some parameters and it must use a physical model like rigid body dynamics. How can I implement this in a text based game?

GBS

Share this post


Link to post
Share on other sites
Sounds weird.

Aren't Access a program used for setting up and using databases? Are you sure he didn't mean that you should make a game using a database made with Access?

Share this post


Link to post
Share on other sites
Maybe this guy has bought into the concept of "a database being at the core of almost every game"? While I know that's essentially true, I've never seen it taken so literally.

I was under the impression that while VBA is an ok language, it sucks for anything that's more than slightly complex...

Share this post


Link to post
Share on other sites
I told you I would post a screenshot. Here it is so far

First screenshot available

Quote:
Original post by Cinder
Aren't Access a program used for setting up and using databases? Are you sure he didn't mean that you should make a game using a database made with Access?

Well it sure isn't a must. We could make whatever we wanted (as long as it's game\model like). I'm planning to actually using a database for a highscore list or something, but not for difficult things.

Quote:
Original post by MrTufty
I was under the impression that while VBA is an ok language, it sucks for anything that's more than slightly complex...

That's correct, VBA is quite usefull, but I always get stuck on more advanced topics.

Btw. Your goal in the game is to destroy your opponent. You can choose an angle and a force. Press Throw and voilla, your character outputs a yellow ball, which should (if you entered the right values) hit you opponent.

Tell me if you like the shot! :)

GBS'

p.s. never mind me drawing..

[Edited by - GraphicsBas on January 28, 2006 8:39:42 AM]

Share this post


Link to post
Share on other sites
I'm quite impressed you managed to get that much out of VBA and Access, so well done :)

Share this post


Link to post
Share on other sites
Beta available from,
www.bassie-entertainment.com\downloads\gorrel.zip

It's only dutch for now,.. You will need access 2003

GBS

Share this post


Link to post
Share on other sites
Sign in to follow this  

  • Advertisement