Derek i see 2 reports there how do i run them?
Alan
1 2024-05-30 16:52:13
Re: Trial Balance. (12 replies, posted in Reports)
2 2024-05-30 14:37:32
Re: Trial Balance. (12 replies, posted in Reports)
Hi thanks yet again.
The trial balance is one of the sheets in the attached spreadsheet. It is just all the sums of each account attached image and I send it as a report to the charity commission.
3 2024-05-30 07:37:58
Re: Database ID (3 replies, posted in General)
I think what my confusion also was when i was trying to import a csv file I had all the id's in the file and it was coming up with too many or too little fields. Again thanks a million and will keep studying this brilliant package and this forum. Keep up the brilliant work.
Alan
4 2024-05-30 07:35:27
Re: Trial Balance. (12 replies, posted in Reports)
Derek wow that exactly how i was hoping to go. That must have taken you ages to do and looks so professional, in my eyes. Thanks a million.
Just the trial balance would be the icing.
I sometimes do seperate projects like we got funding for solar so i would presumably do another table for them.
Again thanks a million.
Alan
5 2024-05-29 20:44:58
Topic: Database ID (3 replies, posted in General)
Hi folks I'm a wee bit confused. Vdb creates its own id for each table. How do I go about adding my own id names from my tables. Or do I not need ?. Also do I just use the relational option for the foreign keys.
Thanks.
6 2024-05-28 14:48:06
Re: Trial Balance. (12 replies, posted in Reports)
What a numpty forgot you would need the database file too. Thats it now.
PS is there a good place to learn SQLlie language ie sql or just google and youtube.
Thanks again.
Alan
8 2024-05-27 13:09:53
Re: Trial Balance. (12 replies, posted in Reports)
Hi there I have attached a very basic mvd file and the excel file with the trial balance tab which is what i am trying to create. Thanks for any help.
9 2024-05-27 01:25:39
Re: Trial Balance. (12 replies, posted in Reports)
Hi Derek
Thats excellent once i get a bit more done i will attach at some point. Thanks again for getting back.
PS Just out of curiosity where is the fastreports situated in mvd.
10 2024-05-23 14:06:27
Topic: Trial Balance. (12 replies, posted in Reports)
Hi folks I run a charity accounts system in excel. It is just a nominal ledger. One sheet is a journal of in and out amounts.
I was wondering if it is possible to do a report or anything with eg. Account for subscriptions and it's total in and total out. Another account maybe Electric and it's totals in and out.
Thanks for any help.
Also is it worth carrying on with mvd is there a future
11 2020-06-30 17:41:30
Topic: Web Application (2 replies, posted in Database applications)
Hi folks.
Is it possible to run a My Visual Database online in any server.
Thanks for any pointers.
13 2019-12-29 22:51:58
Re: Editing SQlite with Navicat (4 replies, posted in General)
I added a new table in navicat and tried to add it in mvd but it said table already exists but doesnt show up. Will i need to delete it and add it in mvd?
Thanks
14 2019-12-29 22:12:01
Topic: Editing SQlite with Navicat (4 replies, posted in General)
Hi there
This is probably a very simple solution. If I edit the sqlite database with an external application like navicat it doesnt update the tables etc when I reload mvd. Any pointers would be appreciated.
Thank you.