What is the best way of doing this? 
Author Message
 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  
 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  
 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  
 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  
 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  
 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  
 
 [ 6 post ] 

 Relevant Pages 

1. dropdownlists and grids, which ways is the best?

2. good ways to use recordsets without autocommit?

3. Better ways to schedule?

4. good ways to use recordsets without autocommit?

5. Better ways to put text into textbox??

6. Recordset: What am I doing wrong?

7. What am I doing wrong??

8. What am I doing wrong?

9. Help with syntax. What am I doing wrong

10. What am I doing wrong?

11. What am I doing wrong?

12. What am I doing wrong?

 

 
Powered by phpBB® Forum Software