Visual Basic, What is the best way of doing this?

What is the best way of doing this?

Author	Message
Mortar M #1 / 6	What is the best way of doing this? Hi all. I would like some advise from the experts on this group please. I am trying to create an .exe file for the use of travel organisers in my company. I want the user to be able to start up the .exe file and be able to do the following: 1. Input and amend requested personal details, 2. Input and amend requested travel details (flights, times, ect...), 3. E-mail or fax those details to our travel agent, 4. Generate a fixed set of reports, 5. Have the ability to save, amend and recall each travel request, and 6. Search for previous requests based on fields ect. Firstly, can the above be acheived with VB6? I need to make this application as idiot proof as possible given the varying degree of computer literacy of the potential users. Secondly, what is the best way of tackling this problem? I plan to design the forms needed and place all the controls on the forms where required. I then plan to program the controls and design the reports. Is this the best way? Any other advice? Thanks in advance. PD
Sun, 11 Dec 2005 15:23:23 GMT

Gunter Schmid #2 / 6	What is the best way of doing this? Quote: > Hi all. I would like some advise from the experts on this group > please. > I am trying to create an .exe file for the use of travel organisers in > my company. I want the user to be able to start up the .exe file and > be able to do the following: > 1. Input and amend requested personal details, > 2. Input and amend requested travel details (flights, times, ect...), > 3. E-mail or fax those details to our travel agent, > 4. Generate a fixed set of reports, > 5. Have the ability to save, amend and recall each travel request, and > 6. Search for previous requests based on fields ect. > Firstly, can the above be acheived with VB6? I need to make this > application as idiot proof as possible given the varying degree of > computer literacy of the potential users. > Secondly, what is the best way of tackling this problem? I plan to > design the forms needed and place all the controls on the forms where > required. I then plan to program the controls and design the > reports. Is this the best way? > Any other advice? > Thanks in advance. I recommend MS-Access. You can program it just as VB6 and some things are way easier, e.g. creating reports. Most problems you describe can actually be solved in Access without much programming. You can make a standalone-exe from it with the developer edition. Your second question, I do not understand. Gunter Schmidt
Sun, 11 Dec 2005 15:33:45 GMT

Frank Ad #3 / 6	What is the best way of doing this? Quote: >Hi all. I would like some advise from the experts on this group >please. >I am trying to create an .exe file for the use of travel organisers in >my company. I want the user to be able to start up the .exe file and >be able to do the following: >1. Input and amend requested personal details, >2. Input and amend requested travel details (flights, times, ect...), >3. E-mail or fax those details to our travel agent, >4. Generate a fixed set of reports, >5. Have the ability to save, amend and recall each travel request, and >6. Search for previous requests based on fields ect. >Firstly, can the above be acheived with VB6? Yes. A DAO/ADO database and a few controls. Not a big drama. Quote: > I need to make this >application as idiot proof as possible given the varying degree of >computer literacy of the potential users. Now you're pushing it. The source of idiocy of users is still an unchartered territory. You can however make that sort of program fairly idiot proof, but don't get complacent. Just when you think it's rock solid, a user will find a way to do something that my 5 month old puppy would find ridiculous. (actually he is typing this for me.) Quote: >Secondly, what is the best way of tackling this problem? I plan to >design the forms needed and place all the controls on the forms where >required. I then plan to program the controls and design the >reports. Is this the best way? LOL.. That's how i would do it. Without a form it's just a {filter} to code up form code.. .;-) Quote: >Any other advice? It's a fairly simple program. I'd say get into it and call on the group when you hit a specific problem. -- Regards, Frank
Sun, 11 Dec 2005 15:36:41 GMT

Mortar M #4 / 6	What is the best way of doing this? Quote: > You can make a standalone-exe from it with the developer edition. > Gunter Schmidt Thanks Gunther. I was thinking of doing it in Access but I only have Professional Edition not Developer Edition, thus I don't believe I can create .exe files in my version of Access. Your help is appreciated. PD
Mon, 12 Dec 2005 12:25:27 GMT

Mortar M #5 / 6	What is the best way of doing this? Quote: > Yes. A DAO/ADO database and a few controls. Not a big drama. Frank, Thanks for your help. Excuse my ignorance but what does DAO/ADO stand for? I assume they are terms relating to types of databases. Am I on the right track? PD
Mon, 12 Dec 2005 12:28:00 GMT

Frank Ad #6 / 6	What is the best way of doing this? Quote: >> Yes. A DAO/ADO database and a few controls. Not a big drama. >Frank, > Thanks for your help. Excuse my ignorance but what does DAO/ADO >stand for? I assume they are terms relating to types of databases. >Am I on the right track? Kind of.. DAO and ADO stand for Data Access Objects, and ActiveX Data Objects, respectively. Both are interface objects to provide connections to MS Jet (and other) databases. DAO is the older (and reportedly still faster), ADO is the newer one that arrived with VB6. You can find an almost ready to use DAO control in the standard toolbox, but you have to dig the ADO control out of the components list. As for types, they can connect to Access, DBase, Paradox etc.. -- Regards, Frank
Mon, 12 Dec 2005 14:52:05 GMT

Page 1 of 1

[ 6 post ]