Ask Your Question

Inkblotr's profile - activity

2019-02-12 02:04:15 +0100 commented answer Base How to set row height in a sub-form table?

After hours of trying to find a way to adjust the row height, I feel almost silly. Thank you very much!

2019-02-12 02:03:19 +0100 marked best answer Base How to set row height in a sub-form table?

I have a list box in a sub-form table and need to make the row height larger so I can read the cell value being displayed.

Any suggestions on how to make all row heights taller in a sub-form table?

Thanks in advance!

2019-02-11 23:34:41 +0100 edited question Base How to set row height in a sub-form table?

Base How to set row height in a sub-form table? I have a list box in a sub-form table and need to make the row height la

2019-02-11 23:02:17 +0100 received badge  Organizer (source)
2019-02-11 23:01:42 +0100 edited question Base How to set row height in a sub-form table?

Base How to set row height in a sub-form table? I have a list box in a sub-form table and need to make the row height la

2019-02-11 23:01:41 +0100 received badge  Associate Editor (source)
2019-02-11 23:01:41 +0100 edited question Base How to set row height in a sub-form table?

Base How to set row height in a sub-form table? I have a list box in a sub-form table and need to make the row height la

2019-02-11 22:57:29 +0100 asked a question Base How to set row height in a sub-form table?

Base How to set row height in a sub-form table? I have a list box in a sub-form table and need to make the row height la

2019-01-31 22:28:02 +0100 commented answer Base Which is best when setting a Date column default, the GUI or query? If query, how do I construct it?

@Ratslinger - I guess I wasn't way out in La La Land after all. Thank you for the feedback and the additional reading m

2019-01-31 22:26:44 +0100 marked best answer Base Which is best when setting a Date column default, the GUI or query? If query, how do I construct it?

I'm trying to set two Date columns in one table with Default values. When using the Table Design View GUI, I enter the default values I want and save the changes then save the database. When I edit the table and click on the DATE "Field Types" I do not see the values I previously set. If I click back and forth between the two fields, the DEFAULT values change on each click. I have no confidence they are being set to the values I want.

I tried the query: SELECT * FROM "INFORMATION_SCHEMA"."SYSTEM_COLUMNS" WHERE "TABLE_SCHEM" = 'PUBLIC'

To try and see what the two column DEFAULT Date values were and I don't see a column that I interpret as to what would be the DEFAULT.

Am I way out in left field? Is this something I shouldn't worry about but just trust the GUI?

If there is a way to set then view what the DEFAULT Date values are with queries, would someone offer suggestion(s) on what query to use, please?

I'm using default HSQLDB.

Thank you in advance!

2019-01-31 22:26:42 +0100 commented answer Base Which is best when setting a Date column default, the GUI or query? If query, how do I construct it?

@Ratslinger - I guess I wasn't way out in La La Land after all. Thank you for the feedback and the additional reading m

2019-01-31 21:57:15 +0100 received badge  Popular Question (source)
2019-01-31 18:46:29 +0100 edited question Base Which is best when setting a Date column default, the GUI or query? If query, how do I construct it?

Base Which is best when setting a Date column default, the GUI or query? If query, how do I construct it? I'm trying to

2019-01-31 18:33:16 +0100 edited question Base Which is best when setting a Date column default, the GUI or query? If query, how do I construct it?

Base Which is best when setting a Date column default, the GUI or query? If query, how do I construct it? I'm trying to

2019-01-31 18:24:03 +0100 asked a question Base Which is best when setting a Date column default, the GUI or query? If query, how do I construct it?

Base Which is best when setting a Date column default, the GUI or query? If query, how do I construct it? I'm trying to

2019-01-31 04:58:01 +0100 commented answer Base - How to display a calculated result from an input value to a form using formulas from table record?

Okay, Thanks.

2019-01-31 04:27:24 +0100 received badge  Famous Question (source)
2019-01-31 04:20:38 +0100 edited question Base - How to display a calculated result from an input value to a form using formulas from table record?

Base - How to display a calculated result from an input value to a form using formulas from table record? Hello - I'm st

2019-01-30 18:19:17 +0100 commented answer Base - How to display a calculated result from an input value to a form using formulas from table record?

In the FinalJoin query, I also do not understand in the last LEFT JOIN, the significance of no commas between the field

2019-01-30 18:17:34 +0100 commented answer Base - How to display a calculated result from an input value to a form using formulas from table record?

In the FinalJoin query, I also do not understand in the last LEFT JOIN, the significance of no commas between the field

2019-01-30 17:15:08 +0100 commented answer Base - How to display a calculated result from an input value to a form using formulas from table record?

In your FinalJoin query, I do not understand the use of "Sale_ID2". Would you please explain?

2019-01-30 04:45:23 +0100 commented answer Base - How to display a calculated result from an input value to a form using formulas from table record?

@Ratslinger I'm trying to wrap my head around what date information the tblVenueFees records need to contain that woul

2019-01-30 04:43:24 +0100 commented answer Base - How to display a calculated result from an input value to a form using formulas from table record?

@Ratslinger I'm trying to wrap my head around what date information the tblVenueFees records need to contain that woul

2019-01-30 04:20:23 +0100 edited question Base - How to display a calculated result from an input value to a form using formulas from table record?

Base - How to display a calculated result from an input value to a form using formulas from table record? Hello - I'm st

2019-01-29 20:49:24 +0100 commented answer Base - How to display a calculated result from an input value to a form using formulas from table record?

Using the simple example file, I've gotten the Joins working (cool!) and I've also gotten a calculated field "Profit" to

2019-01-29 20:44:05 +0100 commented answer Base - How to display a calculated result from an input value to a form using formulas from table record?

@Ratslinger - Wow, you've given me even more information to assimilate. Thank you! I'm trying to provide all the infor

2019-01-29 19:43:39 +0100 marked best answer Base - How to display a calculated result from an input value to a form using formulas from table record?

Hello - I'm struggling to explain, but trying my best.

My wife and I own a business, we sell art online through sites including Etsy, eBay, Amazon, etc. Each company charges us fees they subtract from the customer payment for each transaction. The formula is known and different for each company. The formulas have an effective date and do change, though rarely.

During data entry of a sale (using a form) we want to see what our profit is for each sale. I have part of the system working now but since the fees change, I need to incorporate a way of using different formulas based on the effective date compared to sale date.

I'm no expert at database design/programming but I think I'm correct to have a table of "Venues" (our term for the sites we use to sell our art) that would be linked to a secondary table where the fee formulas and effective dates would be values in records. An example of that linked table might be: "Venue_ID", "Effective_Date" and "Fee_Formula".

Data entry of a sale would include, date of sale, the item sold, amount of the sale (think customer only buys ONE item), and the Venue where the sale occurred. Before the sale record is saved (and fields cleared for the next sale to be entered) I need to provide on screen the profit of that sale. The calculated profit would not need to be written to the table. I have the cost to produce each piece in another linked table.

I know how to link tables to a form and I'm beginning to understand creating SQL queries. Help with how to use a formula in a linked table record to calculate and display on screen,is what I'm asking. An example of a formula would be "0.035 + 0.50" and would be used like this: "Total_Sale" x "0.035 + 0.50" - "Cost_to_Produce" = "Profit". The "Profit" value would be displayed in a field on the form.

If I have not written a clear enough explanation, please post a comment of what is confusing and I will edit or reply to clear any confusion.

Thank you in advance!

[Edit 1/28/19 15:20 CST]
I realized last night I was asking for help with a complex problem.

I suspected Macros might be necessary to achieve my goal. I'm not averse to using Macros, I have a learning curve to negotiate in this respect.

I appreciate the answer @Ratslinger provided below. There is more information in the answer than I can assimilate and utilize quickly. So I've started by creating an example file where I am attempting to link the tables to display the relevant Venue_Fee record for each sample sale. It isn't working and I'm not sure what I'm doing wrong.

Step 1 - I'm trying to simply display the first Venue_Fee record (ignoring date evaluation).
Step 2 - I will try to incorporate selecting the ... (more)

2019-01-29 11:36:15 +0100 received badge  Notable Question (source)
2019-01-28 22:24:43 +0100 edited question Base - How to display a calculated result from an input value to a form using formulas from table record?

Base - How to display a calculated result from an input value to a form using formulas from table record? Hello - I'm st

2019-01-28 22:23:34 +0100 edited question Base - How to display a calculated result from an input value to a form using formulas from table record?

Base - How to display a calculated result from an input value to a form using formulas from table record? Hello - I'm st

2019-01-28 15:52:15 +0100 received badge  Popular Question (source)