[Morals]

I'm waiting for the machines at work to be upgraded to something capable of running Windows 3.0...

[Gaspode_The_Wonder_Dog]

local government y'see leading the way as usual.... hmmm

[Morals]

I don't work for the government anymore.

[Gaspode_The_Wonder_Dog]

i meant me fool.

[Stephen.]

Ok bringing this back up, I'm stuck with my ICT Access coursework too and wondered if I may find some help here... Hmm this could be difficult... Anyway it's not the database I'm having problems with, that is up and running, it's the paperwork. Quite a simple question to start with really but I don't know the answer... What are the advantages of Access compared to another piece of database software such as Excel?

I'd appreciate any help and I might be back with more questions!

Stephen.

[magenta]

I'd say to help with that you need to look at your objectives and what exactly it is you want the database to do - then compare & think about why Access is superior to Excel in what you NEED from your system. Plus if you have a look you can find loads of information online on the features of both Access and Excel, maybe do a table comparing the features and so on as well as a bit of writing discussing what Access offers to your specific system that Excel doesn't...

[Stephen.]

Ok ta, I think I'll go for the table and then written on why I am chosing Access over others!

[Stephen.]

One more question then I'm done...
Is there any way to password protect a form without password protecting the whole database?
If not here's the situation:
I want to be able to have a customer main menu and a staff main menu. Obviously I don't want the customers gaining access to the staff menu so I would like the staff main menu form to be password protected.

Hope that made sense and I'd appreciate the help...

Stephen.

[Stephen.]

Anyone know?

[Morals]

I'll look into it and come back to you on that one. Oh, and Excel isn't a database application anyway, so seems a bit strange to be comparing it with Access as they are both designed to do completely different tasks.

[Stephen.]

Well I'm only doing what I've been told to be honest.
I'm sure you can create databases in it though.

Cheers for the help, it's gotta be in on Tuesday
If there is anything else that you would compare it with then let me know that too and why you would use Access over it...

Cheers,
Stephen.

[Morals]

If you're comparing against other database applications you have a few to choose from, such as dBase, Lotus Approach etc. If you're comparing against Excel (which you can't create databases in) then that's pretty much your answer. If comparing against other DB apps look at things like the user interface, functionality (forms, reports etc), the fact you can use VB to enhance the functionality of your database etc.

[Sidders]

One more question then I'm done...
Is there any way to password protect a form without password protecting the whole database?
If not here's the situation:
I want to be able to have a customer main menu and a staff main menu. Obviously I don't want the customers gaining access to the staff menu so I would like the staff main menu form to be password protected.

Hope that made sense and I'd appreciate the help...

Stephen.

I'm having a similar problem. I'm supposed to be pasword protecting a database using a ODBC/JDBC driver but for some reason I can't do it. Anybody got any ideas?

[Morals]

One more question then I'm done...
Is there any way to password protect a form without password protecting the whole database?
If not here's the situation:
I want to be able to have a customer main menu and a staff main menu. Obviously I don't want the customers gaining access to the staff menu so I would like the staff main menu form to be password protected.

Hope that made sense and I'd appreciate the help...

Stephen.

I'm not sure about protecting an individual form, but I know it is possible to set up a database where you make the user log in when they first open your application, and then certain functions are disabled depending on their status (Admin, Guest etc). Please don't ask me how to do it, as I don't know, but it is possible, although not easy.

[Stephen.]

Ah it don't matter then. As with all things that I'm unable to do... It will go in the evaluation

[Stephen.]

One more question then I'm done...

Well it was a lie... So sue me

I've just got this to do I think and then I'm done...
Is there anyway that you can have a form close when you leave it.

E.g I have a main menu which leads to a customer menu and a staff menu but when I click one of the command buttons I want the main menu to automatically close other wise it is left running in the background.
(This becomes a problem when I want to do a repeat search later on)

So is there a way to have the form close on exit?

Stephen.

[Morals]

Yes. You should be able to do it in VBA quite easily - something like DoCmd.form.close or something - check the Access help file.

[Stephen.]

VBA? is that visual basic? coz thats apparently too much for our level of coursework!

[Morals]

It's Vis Bas yes, but it's only one line of code. Two tics and I'll check if there's an easier way

[Stephen.]

Ok cheers Morals, I appreciate the help

I really shouldn't have left it 'til the last minute!

[Morals]

You can do it using a macro. Create the button, choose event on the properties box and click the down arrow next to on click - choose macro builder, then the first part fo the macro opens your new form and the second bit closes the first form.

[Stephen.]

Ah right ok then, cheers. I'll take a look soon but for the mo... I gotta go to work

Cheers,
Stephen.

[Stephen.]

Tried, tested... Succes

Thanks for the help, only some paperwork left to do now!

Stephen.