Preserved Topic: Database Coding in Visual Basic

Well...I'm trying to make a database in Microsoft Access and need some help with some coding pieces I want to add to it. The database will be used for booking a computer (well...one of ten actually) in the library I work in. It should be pointed out right now, that while I have an idea of how a structured programming language works, I have no idea how to write Visual Basic Code. I want to perform several actions.

*I want to take information from a form, and using three form fields I want to determine the table to place the information in, which rown to put it on, and which column to place it on. The fourth form field, which will be a list box with a list of names, will be the information to place in that cell, and the fifth will be a password which must be entered correctly in order for the information to be placed in it's proper area. Ifthe password is not correct, then the data will not be entered in the table, and a dialogue box will come up telling the user that the password was invalid.

*A validity check on the data being entered into the table, so that if that particular location already has data in it, then the user cannot enter a different name there without going through the cancelation form, to which only admin users will have access.

*A piece of code that will take the current time fro mthe computer's internal clock, and depending on what that value is, dislpay a different value. This will be used to tell the user what period they are currently in, so it needs to be between two times to be in one period, between the next two times to be in the next period (eg: if it is between 9:10 AM and 9:57 AM, then it is period one, but if it is between 9:57 AM and 10:44 AM the it is in period 2). This clock needs to constantly up date itself so that it always displays the current time.

*On two of the computers, only a select group of people can book the computers, in this case, it is students currently completing their last two years of high school, the VCE students.

*I want to have a seperate report in a seperate data base that will bring up a list of computers currently booked and currently free, but have no access to edit any of the lists.

*I want the cancelation form to require a user name and password, and only 6 people at the most will have a user name and password for it.

*I want a log to be kept of all bookings and cancelations, so it will write one line per event, kind of in the format of 'so-and-so booked/canceled computer number whatever for Monday/Tuesday/Wednesday/Thurday/Friday on this date at this time'.

*Lastly, on Monday, at 9:05 AM, or Database start up, whichever comes last, it will clear the previous week's booking lists, so that they are free and ready for the next week. ( I should point out that my school runs on a two week cycle, so there will be 10 booking lists, one for each day. At the start of the week only five tables, the previous week's five, will be cleared, and the current weeks will be left alone. This is for teachers who wish to book their classes into the library, and have a certain number of computers waiting for them a week ahead.)

I know this is alot of individual things, but any help anyone can provide would be much apreciated.

Cheers

[edit]damn fingers, really gotta teach them to hit one key at a time some time soon.[/edit]


In the beginning, there was the word...and the word was 'God', although by the time it reached the other end of the phone line... the word was 'Gznd'

[This message has been edited by Skaarjj (edited 07-09-2001).]

For a start, you should forget about MS Access and Visual Basic...

Sorry Max, but it's all I've got to work with.




In the beginning, there was the word...and the word was 'God', although by the time it reached the other end of the phone line... the word was 'Gznd'

Next you should move the thread to the Server Side forum...

Being that it is the only thing you can work with, I offer total pitty, for you, as well as the computers which will have to front the horrible load.

Next I will redirect you to: http://vkliew.tripod.com/vbtutor.html

or
http://www.astentech.com/tutorials/VBScript.html

It just goes to show you that as you get in towards the microsoft developement languages the site qu****y just drops off the face of the earth. I would feel horrible accepting information from a site that looks like those above.

Maybe you could attempt to talk them into using Java/MySQL and ask them for a raise because you will be increasing productivity.

I can understand why VB might be a decent thing, because it is easy to point and click your way into a GUI... yet when you actually have to code... I am so sorry for you...

Thnx for the help Warmage...and just to pioint out, I'm a student at this school, but I work in the library.

It's official...I'm a geek.




In the beginning, there was the word...and the word was 'God', although by the time it reached the other end of the phone line... the word was 'Gznd'

No, geeks *don't* use Visual Basic...

Hey! *I* use visual basic!

Wow slime... I am so sorry...

MS Visual Basic is the shittiest programming language, period.

I love it when I am in good company... <<sniff>> i just feel all warm inside.

<edit>Max: have you taken notice to how many different ASP, VB people who have been popping up, and we (collective asylum) have been squashing... I am starting to feel a bit bad about it. There must be something that could be done to help instead of killing thier hopes. Maybe a custom message for all. "Click here for ASP help". From there were give a breif into on why ASP sucks, why picking another language would be better, and then some links to better places, along with some helpful information about it. It could work out... but it would save a lot of people form completely giving up on the developement aspect.</edit>



[This message has been edited by WarMage (edited 07-10-2001).]

So what other applications would you guys suggest that I use, as opposed to VB, Access, Java or MySQL?




In the beginning, there was the word...and the word was 'God', although by the time it reached the other end of the phone line... the word was 'Gznd'

Ok, for a database, I would reccomend anything over access. MySQL tends to be my DB of choice (partly because I haven't used oracle I am sure) because it is free, and very easy to set up.

For the programming language, if you need to create a real world application to handle all of this stuff, then I would sugest Java, or C++.

If you are going to be doing this via the web (which would be easier) then I would switch to PHP, Perl or Java. I think PHP or PERL would be the easiest options because you do not have to worry too much about database dlls with them.

I don't know why you would want to stay away from Java and MySQL I can understand staying away from Java but not MySQL.

If you need to make native Windows application, I would go with Inprise Borland Delphi and MySQL...

Ya, keep talking your crap :P

Skaarjj, I don't envy you trying to make a full fledged application like that and not knowing anything about VB, it's going to take you a while. I might suggest you poke around http://www.planetsourcecode.com for some code examples. The API will come with time and experience. Also, the MSDN Library will be your best friend (shudders at the thought).

And might I suggest you find a forum that specializes in VB, you won't get much help from these folks, too much vb bigotry going on :P

Cheers



-It never hurts to always be right-

Oh well...no more replies for me.




In the beginning, there was the word...and the word was 'God', although by the time it reached the other end of the phone line... the word was 'Gznd'