Yesdazedandconfused wrote:Am I having this because the customer is a "varchar" and FK_ID_customer is an "integer?
dazedandconfused wrote:Also I noticed that under column ID it says "auto." How do you do that and is that what allows an infinite number of rows?
dazedandconfused wrote:... since I can't seem to figure out how to change anything to a combo box or list box...
Villeroy wrote:Some form, subform, list box or combo box is bound to a table named "PO Invoice" which does not exist.
ALTER TABLE "PO_Items" ALTER COLUMN "Type" set default 3
F3K Total wrote: when you don't select a Type and jump direct to Quantity or save the new row
F3K Total wrote:Hi,
the default D will be insertedF3K Total wrote: when you don't select a Type and jump direct to Quantity or save the new row
R
1. Is there a way to hide the others and only show the selected invoice?
2. Is there anyway to make the rows taller? I see I can change the column width and even hide them, but I can't figure out how to do the same thing w/ rows.
3.Lastly (I hope) is there a way to make the buttons bigger, that is the buttons on the bottom of the main form that allow the user to move from one record to the next.
Arineckaig wrote:1. Is there a way to hide the others and only show the selected invoice?
There are several ways. One route makes use of the relationship between a data form and its sub-form, another route would be to use a filter from a navigation form control or the form navigation toolbar. You may get some pointers from a fairly extensive tutorial that can be downloaded from http://dl.dropbox.com/u/10552709/FilterExamples.zip2. Is there anyway to make the rows taller? I see I can change the column width and even hide them, but I can't figure out how to do the same thing w/ rows.
It is not possible to change just the height of rows in a table form control, but it is possible to change the zoom level of the whole form document which will increase the displayed height of the rows: right click the bottom right hand corner of the status bar of the form document. The size and format of controls other than the table control can then be adjusted as desired.3.Lastly (I hope) is there a way to make the buttons bigger, that is the buttons on the bottom of the main form that allow the user to move from one record to the next.
The form navigation toolbar tends to be inflexible. On the other hand a navigation form control included in any data form or sub-form and the navigation bar at the bottom of a table form control are more flexible and can also be varied with the zoom of the form document.
dazedandconfused wrote:Is there a way to set the default date as "today's date?" that is the date it is when I create the entry?
ALTER TABLE "MyTable" ALTER COLUMN "MyDate" SET DEFAULT CURRENT_DATE
F3K Total wrote:Hi,
you can do it, as you showed it, single or additional, or a mixture, e.g a table control for the items and single controls for the invoices.
Find the mixed version attached in Form Form_PO_invoice2.
In my point of view, the overview is worse.dazedandconfused wrote:... since I can't seem to figure out how to change anything to a combo box or list box...
Right-click the control or within a table control the column header an choose Replace with > and select the control Type you like.
Learn, how to use the Form Navigator in Forms-Edit-Mode.
R
F3K Total wrote:Hi,
you can do it, as you showed it, single or additional, or a mixture, e.g a table control for the items and single controls for the invoices.
Find the mixed version attached in Form Form_PO_invoice2.
In my point of view, the overview is worse.dazedandconfused wrote:... since I can't seem to figure out how to change anything to a combo box or list box...
Right-click the control or within a table control the column header an choose Replace with > and select the control Type you like.
Learn, how to use the Form Navigator in Forms-Edit-Mode.
R
F3K Total wrote:Hi,
controls created by the wizzard have grouped label- and controlfields. Rightclick -> ungroup or rightclick -> enter group helps.
R
Users browsing this forum: No registered users and 3 guests