Access/VBA etc.

[Tican]

Hi all,

I am currently trying to make some things at work a little more efficent, so what I am doing is using access to create a database and then hopefully have 2 EXE program's (Must not be an install though) one for Bookings and one to log other little bits and also to pull the info from the bookings program.

I have done this to some degree, but I am now having problems compiling it, as I have not got a clue what I am doing in all honesty.

Also how can I encrypt part/all of a database?

Is it also possible for a warning system to be in place; for example if a client has missed 5 sessions it could pop up on load (of the program, or when ticking the FTA box) that they have missed x times etc.

The booking program;

Is it possible once information has been entered into the database it could be emailed in a table to people Via Outlook?



Sorry for all the questions, I have tried google, but did not really help, but I suck at google skills! lol. I am using Access 2003

I am just trying to learn access as it seems a powerful tool and the company already uses it in a few of the other databases.


Thanks in advance,

 

[Tican]

Just the database in general, but it isnt a must.

With the session thing, I am unsure what I want to be honest, thats just an idea to work on for now,

I already have the Session days and times (i.e Monday 9:30 - 11:30) is it possible that on a monday I could print off the list of clients due that day to ensure that if they dont attend I can FTA them? With a list of the session times next to them? (Only pulling 3 bits of info from the database, First name Surname and Session time)?

 

[Tican]

I have been looking around t'internet and I cant seem to find anywhere to be able to make it into an EXE which is a shame .

Same to output into Word and Email

 

[Tican]

I am using this as a learning curve. I have used VB in the past, but have forgotten it all now


Would it be easier if I was to code the program in VB (i.e Learn it etc) then make it read from the Access DB?

 

[Tican]

I shall have to look into it!

For the time being I am going to be implimenting the Database for a weeks trial to see how it copes, find bugs and the like