Advanced/Complicated Form(s)

Submitted by: 

[inline:Sample Form.JPG=Invoice Form]

Please take a look at the form view, this was written in Visual Basic Microsoft Access Environment, we have to hide the company and some characters alike for security purpose, But at the bottom of the form is another subform for Accounts Receivable Forms, this means that with respect to the invoice, whether it is cash or credit, it will automatically creates Accounts Receivable for 30 Days, 60 Days, etc. Since it is being printed in A4 Size bond paper, expected that they are creating automatic invoice number (See invoice number (Our Ref-IA09-)), this is a file server database (split-database), but works perfectly in 2 to 3 computers, asides from this, take a look the back of the main form, you can notice the main menu in explorer-like menu items.

The invoice will show in .pdf format, so it can be send thru e-mail via attachement. Behind all these buttons/texts are thousand lines of codes that enables them to work perfectly.
e-mail me if you have any questions.....thanks.....
Your Database Assistant (db_assistant2002),


Are you sure that form is complicated and Advance? you're so funny...

Hello can u give me some idea for blob db?

BLOB(Binary Large Object) is likely an image files i.e .jpg, .bmp, .png etc. Take a look in Invoice Form, you see a lot of images, but I manage to compress the database itself. If you are using the Access 2003 Environment, it would probably 10 times bigger than we expected. All you need to do is to store the links in a table, something like this:
C:/My Database/My Images, where you store all the stuff regarding images.
Of course, this link must reside in a table, say in a textbox.
Last two years, we have a tremendous problems regarding storing images of Welder's picture, a certain Welder is being tested in different Levels, say TIG Welder is different Welder, ARC Welder is also different Level and so on and so forth, everytime the Welder passed on such level/category, the software is able to print his Welder Card which stored his image file. In this instances, a Welder could have a lots of Welder IDS based on AWS/ASME Categories, probably one Welder could have 5 to six IDS based on his capabilities. It's quite challenging, we did'nt notice that we are dealing with huge amount of image files!
But thanks god of simplicity, we avoided that by simply re- aligning our image files.

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.