Access/VBA etc.

Tican

Tican

Tican

Soldato
Joined
14 Apr 2003
Posts
5,716
Location
Leicester
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,

:)
 
I don't think Access has any encryption, what is it you want to encrypt? If it is passwords for example use a "standard" encryption algorithm from the internet you could implement in vba and store the encrypted password.
Then when they login, encrypt the entered password and compare against the version you have stored.

Without knowing details of your database I'm not sure how you can tell how many sessions they have missed specifically. But you probably want it to run a query to find the number of missed sessions (since the last session attended) and pop the result up in a message box (ShowMsg() I think)
The nasty way of doing this would be to run a query along the lines of:
SELECT TOP 1 Session_Date FROM Sessions WHERE Session_attended = TRUE ORDER BY Session_Date DESC
This would return the date of the last session attended then use that result in the next query to get the number of missed sessions:
SELECT Count(Session_Date) FROM Sessions WHERE Session_attended > The_Last_Session_Attended_Which_Comes_From_First_Query
This is just inventing my own field names and tables so adjust them to your need :)

VBA should allow you to integrate some use Outlook, I can't say I know anything about going about that but it would surprise me if you can't
 
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)?
 
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 :(
 
Nearest thing to an exe you can get from an access database is an MDE file. Read up on it, as far as I understand it is a file such that you can't access the vba code.

I had kind of assumed you were programming your exes in a programming language from your post (and then accessing it via ADO controls or the like).

As for email, is this what you want:
http://www.febooti.com/products/command-line-email/online-help/send-email-ms-access.html
I simply googled "vba send email".

Word should be similar:
http://visualbasic.about.com/od/learnvba/l/aa030803e.htm
That seems to bring data in from word so outputting should be pretty much the same.

Suggest you do some reading on databases and access in general, you don't really seem to know enough at the moment to work out what you actually want to do.
 
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?


:confused:
 
DJ Binks said:
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?


:confused:
Click to expand...
Not sure easier is the correct word but it would sound like it is more in keeping with what you want to do. This would give you your exe files and if you are writing a lot of vba you got to think it might be better just to do it in vb from the start.
 
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 :)
 
You must log in or register to reply here.
Back
Top Bottom