program design

Expand Post »

Im starting to design some software/system for work even though its not in my job description, and learned a little of it at college so thought id speed the process up rather than waiting for the IT monkeys downstairs to get their act together.

I will be including a database which needs to be written into by forms and info displayed.

I have a small question too
Is it possible for me to have a field in my table that links to one record, and has either the file path of one or multiple files to it or be actually attached.
If so then would i be able to pull up the data from the database, then launch the actual file via the program, view it withinin the program, or view it with the external sofware that relates to the type of file (likely to be pdf)

Basically im wanting to scan loads of files, and depending if i can get one file or one section scanned into one pdf file, or if i have to save them as seaparate pages determines this. These are gonna then be linked into the database where i will create records for each.

Im trying to speed up Paperless office in a way, even though i have problems with the scanner and the way it can save the scans, but thought id at least start designing a reasonable system

anyone help??

Similar Threads

Web Graphic Programs....Design? in Graphics and Multimedia
Executable program design question.... in Java
program in C
Program design (help) in C++

leeegglestone

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Aug 2004

Permalink

Aug 11th, 2004

Re: program design

You would have to have two tables.
Record Table

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
Record_ID  (primary key)
[ record information...  ]
Record_ID  (primary key)
[ record information...  ]

Record_Files Table

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
RecordFile_ID  (primary key) <-- not entirely necessarly, but might be useful
Record_ID_FR  Foreign Key that points to a Record Table Entry
Filename
RecordFile_ID  (primary key) <-- not entirely necessarly, but might be useful
Record_ID_FR  Foreign Key that points to a Record Table Entry
Filename

For example:

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
These entries in Record
0      Joe    .... more of joe's info...
1      Max   ....
2      Dani   ....
These entries in Record
0      Joe    .... more of joe's info...
1      Max   ....
2      Dani   ....

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
Record_Files
    0  JoeFile1
    0  JoeFile2
    1  MaxFile
    0  JoeFile3
    2  DaniFile
Record_Files
    0  JoeFile1
    0  JoeFile2
    1  MaxFile
    0  JoeFile3
    2  DaniFile

To find Joe's files, you know Joe's ID is 0, so get all from Record_Files that has the Record_ID_FR = 0.

Good luck! I'd recommend picking up a book on database design practices. Usually just reading the intro chapter can give you a good idea of how to do things.

Ed

cosi

Reputation Points: 17

Solved Threads: 1

Junior Poster

Offline

153 posts
since Aug 2004

Permalink

Aug 11th, 2004

Re: program design

The previous posters advice is good, but didn't answer some of your question. Yes you can open some files in VB forms given that they support OLE. Try searching your MSDN documentation for OLE. So word, excel and so on will definitely work.

I'm not sure about PDF. You'll certainly be able to open it using the ShellExecute API call, given, of course, they have Acrobat Reader installed.

Cheers,

mnemtsas

Reputation Points: 16

Solved Threads: 1

Posting Whiz in Training

Offline

200 posts
since Jul 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Printing in VB

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: How to list the record orderby id when selecting distinct

DaniWeb Message

Cancel Changes

User Name
Password