1,001

(27 replies, posted in General)

Hi Derek,


Great stuff. Thanks a lot....................


Having totals in a field for invoice purposes, from totals field I can add tax, gross, discounts etc fields and calculate final balance.
Grid totaling also is very useful on different circumstances. Thanks for this too. However, screen cap about grid totaling seems didn't come through, unless I'm getting blind or something.


"If I have some time, I will try and re-work a bit of your project to show you the approach to lookups with just one table that I use.  I can also include the way I create a 'help file' and a simple 'menu structure' that I often use, if that would be of any interest to you."
BIG YES PLEASE!

1,002

(27 replies, posted in General)

Hi JB,


Thanks a lot for the sample totals project... Simple calc fields are OK. I meant complicated ones. Those ones on customers and products transaction history tabs + on search form (form1)


I have couple of questions within this sample project:


1. How do I calculate totals of a table grid. Assume, form1 table grid used for invoice and it contains invoice items. How do I add qty and total columns numbers and display them in fields below the Tgrid?
Please see the same attached sample project with said fields added.


2. How do we get numbers aligned to right on Tgrid display?

1,003

(27 replies, posted in General)

Latest "Business 101" project attached. That's what I could do so far.


Tasks I couldn't do in general:


1. Calculated fields
2. Settings of certain buttons
3. Ability to add data items on same form. i.e. adding invoice items on invoice forms. Same could apply to lookups form. Rather than creating many lookup items add forms it could nice to add them on same lookup forms. Derek, I couldn't get my head around to apply your method in here. Perhaps you can have a go at it.
4. Adding "Help" (linking help document in project file folder) and "About" menu items under main help menu.
5. I pasted codes to Script page but couldn't get splash and own about windows showing.
6. I'm sure there are some other things.


I come to conclusion that I cannot complete this project myself.  Any suggestions?

1,004

(27 replies, posted in General)

I have reduced the scope of 101 business project to bare minimum but I cannot get it working fully. It needs some scripts in certain areas and I don't know the coding. Learning pascal from zero would take some time for me. I cannot allocate enough time to do it. This project was an attempt to do very basic accounting for my tiny business. It's not a commercial one.


I thought If I do the forms, db tables, and settings (as much as I could do) other knowledgeable members may fill the missing bits. Then it'd have been used by other members also according to their needs. Perhaps I was bit naive to suggest to do a work for free. However, I come across couple of kind members such as JB and Derek in this community offered their help freely.


So guys, is there anybody can complete my project? I'm willing to pay for their help. Please contact me. My forum email is valid one.


I have sent couple of emails to Dmitry at support to do this project for a fee but to date I got no reply. Perhaps he didn't receive them?

Thanks a lot guys for splash examples....


Now, hopefully Dmitry does the mentioned menu item and puts it altogether.


Derek, once again interestingly nice approach.

Hi Dmitry,


Could you be so kind to add couple more items to template project file "About form and EULA" please...


1. Help menu item on the menu bar that opens application help file placed within project folder. Therefore, current Help menu would have Help and About menu items. I'm only asking for menu and link, creating, compiling and and adding .chm file to project folder task will be mine / users.


2. Ability to display splash screen.


It'd be a great help for nobs on coding like myself, adding comments to script such as:


//This function shows about
.........
..........
//This function shows EULA with agree and disagree buttons on application first use
.........
..........
//This function displays splash
.........
.......
//This function launches application help file etc.
.........
..........

1,007

(27 replies, posted in General)

Hi Derek,


Thank you very much for taking time to explain your approach. It's very kind of you.


I'll certainly study and try to implement it.

1,008

(27 replies, posted in General)

Hi Derek,


Thanks for the sample project and your kind explanation.


In my case, I have too many lookup items to put in one list may not be a user friendly. Hopefully I'll get some help from others.


However, your suggestion is very valuable for me. I like it. I'm sure it'll come handy with other projects. Very interesting approach. Could I possibly ask you to explain how you did it step by step in details please.


Thanks again.

1,009

(27 replies, posted in General)

I have tried to reduce many forms in design level as we don't have a treeview in MVD yet.



Could somebody answer  please, is it possible to have functional form as detailed on the image below?


http://prnt.sc/ca29uv

1,010

(27 replies, posted in General)

Hi Dmitry,


Excellent news.  Looking forward to it.

Great Stuff,,, Thanks a lot Dimitry...


Appreciated very much.

1,012

(27 replies, posted in General)

Hi JB,


This project definitely needs your participation imho.


Is MVD 2.7 beta project compatible with MVD 2.6?


ps/. I have organized bit better and updated lookups form as on images below. If and when needed I can save it as a single form project and upload here

http://prnt.sc/c7vhpl
http://prnt.sc/c7vi67

1,013

(27 replies, posted in General)

I have started an basic accounting project for small business after reading somewhere here something like "it's possible to create a full accounting software without coding with MVD" as I don't know anything about coding. However, I discovered later on that I still need to learn certain aspects of database and components used.


For instance, lately I stuck with foreign key... Thanks to JB I understood how to use it. While there is a basic help document and Vid tutorials, they are not enough for those like me without any programming experience. Every aspects needs to be explained in details (in a walk-through fashion) step by step with plenty screen caps. Unfortunately, creating such detailed help document is quite time consuming task. Perhaps, one brave soul with programming background could undertake this task. We don't want to ask to Dmitry to spend time on it as we'd want him to improve MVDB as it needs few components to be implemented.


One work around (learning to use MVD for non programmers could be working on a shared project with the help of knowledgeable members. For this purposes I share my project with a generic name business 101. I have mainly done some forms etc starting with customers, products and sales. I can do missing forms and logic of the application if there are enough interest. If we can complete it then perhaps Dmitry can check it up and correct errors and shortcomings to have fully functional small accounting program made with MVD. I would suggest, Dmitry could sell fully finished application if he wishes to. I would be the first customer to buy it, as long as priced reasonably.

Thanks a lot Dmitry......


Could you also add End  Users License Agreement (EULA) window to About window sample project please. It's important on legal front when we pass apps. we design to others as I'm sure you are aware of. Before application start (on first use only) EULA window displayed where user must click on "I agree" button for the application to run.


It'd be a nice template project to use to start a new projects for non coders like myself.


Adding sample URL and Email links on about form would also be a nice touch where we can just replace sample URL and Email.

1,015

(2 replies, posted in General)

Hi JB.

Thanks a lot for your kind explanation together with image. It's appreciated very much...........

1,016

(2 replies, posted in General)

I wanted to use combo box for dictionary tables but stuck with foreign key settings on object inspector. Could somebody please explain how to use it? On tutorial video 2, I see there is a "table name" instead of "foreign key".

1,017

(187 replies, posted in General)

is there any plan/schedule to implement at least item 1 and 2 on my previous post above?

1,018

(187 replies, posted in General)

I had a chance to play around with My Visual DB. It is a great application especially for people like who are not programmers. Instead of adding further features to existing ones, adding some core components would be better approach as they are sourly missing. After core components completed enhancing existing features may be looked at.


Core components I like to see. In order of importance in my view:


1. Ability to add my own About window and application exe icon. (Perhaps these futures are already implemented. If so, please direct me to an info how I can do them as I couldn't find a way.)


2. Treeview. We can work around this by using tab pages at certain degree but not enough.


3. Menu.


4. Toolbar. (It's not as important as above ones)


5. Editable grid. (this can be added later on too)


Once again, thank you for your work to offer us such a great application.

1,019

(2 replies, posted in General)

Thanks a lot for the quick reply Dmitry...


Now, I can delve into exploring it further properly.


And Now, I can say you have developed GREAT database development application for non coders.


Most likely, I'll come across features that I'd want to see adding but they will not change my mind about how good job you have done with My Visual Database.

Keep up the good work....

1,020

(2 replies, posted in General)

You have created a nice software application. I like to say nice software development application for non coders but I'm not sure about it in proper sense. I had a look for answers on your website but couldn't locate.


Is My Visual Database for home hobby uses or we can create self contained database app, where compiled version can be distributed.


Say, I created a db app with My Visual Database and compiled my db app. I sent compiled db application to somebody. Can he run the compiled application without having My Visual Database in his computer?