101 Topic by dbk

(5 replies, posted in General)

Hello All,

I was just thinking if MVD would have the possibility to change/fill in bookmarks/placeholders in an MS Word template?

For example, i have a lot of the same word templates/boilerplate documents, in these documents i only need to change a few parameters, like the name/address/etc..

I know i could just make a report and save it as a pdf, but sometimes i need to add or change the document some more and a pdf file isn't editable in such a way. Therefore, it would be a real timesaver if i could fill such a 'boilerplate' word template, and save it as a .docx, and if needed i could change or add some things to the document later.

Could this be done? If so, how should i approach this?

Thanks!

Go to forum: General

102 Reply by dbk

(10 replies, posted in SQL queries)

derek wrote:

Hi DBK and EHW,
Also knocked up a quick demo project (see attached) - I clearly have too much time on my hands - LOL! 
I was trying to see how close it could get to the requirement without using any script but in the end I had to give in and add a few lines!!!
Anyway, hope it helps to move things forward for you.
Derek.

EHW - neat way how you toggle between the edit field and the combobox for the stock or non-stock items.  Just one thing - can you explain  what does the Prod_Lookup.TableGrid1.PopupMenu := nil;  line do?  It's not something I've come across before. 
Thanks.

Hello derek,

Wow!! This is amazing!! This is really helping me so much, truly appreciate your time and effort. I'm looking into this example you made and figuring it out. This is actually almost exactly what i wanted to make LOL!

You are all so helpful i am really amazed by it. Thank you so much!

Go to forum: SQL queries

103 Reply by dbk

(10 replies, posted in SQL queries)

ehwagner wrote:

DBK, Derek,

I threw together a quick project to demonstrate a possible solution for you. First and foremost this project is by no means anywhere close to a productional app. My solution is along the same lines as to what Derek mentioned. I used a slightly different approach than the normal combobox methodology in MVD. The combobox for products is still there in order to make the connection to invoice items, but it is hidden. The lookup is done using a tablegrid instead. So on the invoice detail form the user can either type in a freeform text field or do a lookup into the product table. The lookup will fill in the invoice line item text field and price field from the product table. The invoice detail form will let you know whether you have a stock item or a non-stock item. If you have a stock item assigned to the line, you have the ability through a button to remove the stock item and put in a freeform text description in it's place. Hope it helps. If not, it was good practice for me anyway. LOL.

Hello ehwagner,

Wow this is great!! This is actually almost exactly what i was trying to achieve! How did you read my mind? Thank you for your effort, this is really helping me a lot!

Go to forum: SQL queries

104 Reply by dbk

(10 replies, posted in SQL queries)

derek wrote:

Hi DBK,
In its simplest form, I think you only need to add a new field to the invoice_details table to hold the 'non stock item' and create your relationship to the stockitems table as optional.  Then in your input form, simply have a combobox (for stockitems) and an edit field (for nonstocked items).
Obviously, you could do a lot to smarten up your forms and grids (perhaps display both stocked and nonstocked items in the same column etc) but as a basis, I can't see why this sort of approach shouldn't work for you.
Regards,
Derek.

Hello Derek,


Yes, this is exactly what i meant. Thank you! Now that i see your solution it is so obvious.

Thank you for this solution, it would have taken me so much longer since i'll admit that i am not the brightest bulb in the box tongue

Go to forum: SQL queries

105 Reply by dbk

(10 replies, posted in SQL queries)

domebil wrote:

http://myvisualdatabase.com/forum/viewt … 390#p12390

Hello, thanks for your reply, but i think this isn't quite what i am looking for

Go to forum: SQL queries

106 Reply by dbk

(4 replies, posted in General)

This is fixed. I was saving the MVD project files in the same folder as another project file. When i made a new project folder everything worked ok.

Go to forum: General

107 Topic by dbk

(10 replies, posted in SQL queries)

Hello friends,


I am struggling with a table layout for a simple invoice application.


What i basically want to achieve is:


1) When making an invoice (eg in frm_Invoice) the user can select products from a dropdown box, these products were added through a seperate form (eg frm_AddProducts), have fixed names / prices etc > no problem


2) User can also add products directly in the invoice (frm_Invoice) without first adding these products through frm_AddProducts. For example, the user can fill in the text boxes with a description and a price as he chooses and it will be added to the grid. This doesn't get added to the products table for re-use or stock counting later on.

> This is the part i am struggling with. How can i achieve this? Should i add an extra table for this?


https://s17.postimg.org/pbbqir7fz/schema.png

Go to forum: SQL queries

108 Topic by dbk

(4 replies, posted in General)

Hello Dmitry & friends,

After a long time of absence i tried to make a quick database application for my job in MVD but i'm getting these errors as follows:

"No such table"
or
"No such column"

However, these tables DO exist! There are no typing errors.

When i run the example databases that come with MVD everything runs fine. It seems that I can't save anything to database i created within MVD.

Go to forum: General

109 Reply by dbk

(6 replies, posted in General)

DriveSoft wrote:

First you should download beta version 2.6
https://www.dropbox.com/s/pebrvqwqcbluy … a.zip?dl=0

Ofcourse, i forgot to use the new version :-)


It works now, this is an excellent addition to MVD Dmitry!

Go to forum: General

110 Reply by dbk

(6 replies, posted in General)

I get this error when i try to run the project

http://s32.postimg.org/y2ft0mdxd/Naamloos.jpg

Go to forum: General

111 Reply by dbk

(4 replies, posted in General)

DriveSoft wrote:

Yes, I plan to add controls like RichEdit, TreeView, Chart and may be something else.


These would be excellent additions, can't wait!

Go to forum: General

112 Reply by dbk

(4 replies, posted in General)

Hello Dmitry,


That is unfortunate to hear.


Couple more questions:


- do you plan to add more gui controls in the future? Like window splitters/toolbar/ribbon/sidebar components?


- is there a roadmap?


Thank you for responding

Go to forum: General

113 Topic by dbk

(4 replies, posted in General)

Hello friends & Dmitry,


I was wondering if it is possible in any way to make child forms?


I've found an example of what i mean online like this one below:


http://i.stack.imgur.com/Gr8tp.png


The idea is to make a main form which will act as the main window, this main window can hold child windows which are constrained by the main window, e.g. they can not move outside the main window.


If not possible > is this a planned feature?


Thanks!

Go to forum: General