Ask Your Question

Ratslinger's profile - activity

2019-01-18 07:01:17 +0100 commented question Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

In answer to your question about connectors, there are some answers here in the forum. You can also check Chapter 2 - C

2019-01-18 04:20:07 +0100 commented answer Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

@Inkblotr Just looked at the existing macro in your sample. I started with type this of code (from docs if I remember c

2019-01-18 04:19:41 +0100 commented answer Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

@Inkblotr Just looked at the existing macro in your sample. I started with type of code (from docs if I remember correc

2019-01-18 00:24:42 +0100 answered a question How to return table ID and Name from a linked table in a query

Hello, Have actually provided this information before in another sample -> Query previous record for form control in

2019-01-17 23:07:19 +0100 answered a question Automatic Date Input Base

Hello, Please see the answer (and associated links) by Jim K in this post -> Libreoffice Base: Need today's date as

2019-01-17 22:58:19 +0100 commented question Automatic Date Input Base

Please, no need to yell (use of all caps) when asking a question.

2019-01-17 22:57:34 +0100 edited question Automatic Date Input Base

AUTOMATIC DATE INPUT BASE When I add a new record, in ms access with a funtion now() he add the date of today. An Intake

2019-01-17 22:53:02 +0100 edited answer Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

Hello, Notwithstanding the open questions in the comment, have modified your 'Item' form. It is simply adding a sub f

2019-01-17 22:41:10 +0100 commented question Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

Only going by you mention of: ...though it is not the eCommerce site we want it to be. Not to say your entire system

2019-01-17 22:34:05 +0100 commented answer Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

Sorry, should have mentioned in answer. This is how you typically use a sub form (see LO docs for more info if needed).

2019-01-17 22:33:06 +0100 commented answer Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

Sorry, should have mentioned in answer. This is how you typically use a sub form (see LO docs for more info if needed).

2019-01-17 22:32:41 +0100 commented answer Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

Sorry, should have mentioned in answer. This is how you typically use a sub form (see LO docs for more info if needed).

2019-01-17 22:26:51 +0100 commented question Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

Well, first thing is to determine which DB you are to end up with. I believe I mentioned planning before. Consider in

2019-01-17 22:18:03 +0100 commented answer Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

This empty sub form now has the Item ID already filled in. To add an item, select the Color field & use drop down t

2019-01-17 22:14:36 +0100 commented answer Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

Many things to learn yet. When you enter a new item, the record is not in the database until it is saved. Until it is

2019-01-17 22:03:41 +0100 commented answer Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

Maybe I don't see something. On this modified form, if you enter a new item the sub form will be empty. You can add re

2019-01-17 22:03:24 +0100 commented answer Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

Maybe I don't see something. On this modified form, if you enter a new item and then the sub form will be empty. You c

2019-01-17 22:02:11 +0100 commented answer Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

Maybe I don't see something. On this modified form, if you enter a new item the sub form will be empty. You can add re

2019-01-17 21:56:12 +0100 commented question Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

Consider moving to MySQL now (I personally find PostgreSQL and Firebird to be better). You can place MySQL server softw

2019-01-17 21:37:20 +0100 commented question Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

One quick question. I know you've tagged questions with HSQLDB. Are you using the default embedded HSQLDB? IF so, bef

2019-01-17 21:36:37 +0100 commented question Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

One quick question. I know you've tagged questions with HSQLDB. Are you using the default embedded HSQLDB? IF so, bef

2019-01-17 21:15:31 +0100 answered a question Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

Hello, Notwithstanding the open questions in the comment, have modified your 'Item' form. It is simply adding a sub f

2019-01-17 20:32:17 +0100 commented question Calc automation

@billprice0052005 Inserting sheets and inserting HTML files are two different topics. Please restate your comment as a

2019-01-17 19:37:36 +0100 commented question Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

Hello, Have previously looked at your web site & so have a tiny bit of understanding at to your project here. Havi

2019-01-17 19:09:45 +0100 commented answer need help with Query SQL WHERE syntax

@mycle While it may seem logical to continue here, the way the forum is set up, your question would become buried in ano

2019-01-17 00:18:06 +0100 commented question Unable to connect to a DB

Hello @sequimbob, Please do not check post as wiki when asking/answering questions. This question is a complete duplic

2019-01-17 00:09:11 +0100 commented answer Base Handbook example "Media_with_Macros" has Macro errors when executing, please help fix

Actually, it appears, based on documentation and what little I got from the docs, the dialog was meant to repair bad lin

2019-01-16 22:19:01 +0100 answered a question Struggling to work out how I need to design my tables

Hello, What on the surface seems to be a simple project can end up being a very large one. The reason being that it ma

2019-01-16 20:59:31 +0100 commented answer Base Handbook example "Media_with_Macros" has Macro errors when executing, please help fix

Have now found complete routine missing which is attached to combo boxes on the form. If selected there is an unending

2019-01-16 20:05:44 +0100 commented answer Base Handbook example "Media_with_Macros" has Macro errors when executing, please help fix

Have now found complete routine missing which is attached to combo boxes on the form. If selected there is an unending

2019-01-16 19:17:04 +0100 answered a question Base Handbook example "Media_with_Macros" has Macro errors when executing, please help fix

Hello, Well, have spent a bit of time with this and the more I dig into it the more errors pop up. At this point it ap

2019-01-16 18:31:58 +0100 commented answer Base: Entering data in a form, in a field linked to another table, how to add a new record in second table?

Easycoder (I used in 60's & early 70's) is an assembler like language & the Honeywell equivalent of IBM's Autoco

2019-01-16 13:10:22 +0100 commented answer Get the label of the button that was just pressed to call a macro

@jmcsys Looks like third time is a charm. Glad it is what you wanted. Asked: Is the oEvent automatically passed to al

2019-01-16 12:50:46 +0100 answered a question Is it posible to protect a base database? password protect or something similar?

Hello, Forms themselves have properties you can set where you do not allow additions, deletions, or modifications (on i

2019-01-16 12:32:42 +0100 edited answer need help with Query SQL WHERE syntax

Hello, Note: Deleted original answer. Edit 2019-01-16: The problem is in the ON section of the join. Only 'PrevAcc

2019-01-16 06:54:48 +0100 edited answer need help with Query SQL WHERE syntax

Hello, Note: Deleted original answer. Was looking at wrong form. As comment states, waiting for further information

2019-01-16 06:30:55 +0100 commented answer need help with Query SQL WHERE syntax

Nope - still see no problem.

2019-01-16 06:24:17 +0100 commented answer need help with Query SQL WHERE syntax

Sorry, looking at wrong form. Still would like details of where the problem is.

2019-01-16 06:06:56 +0100 commented answer Base: Entering data in a form, in a field linked to another table, how to add a new record in second table?

For the spaces LTRIM() removes spaces on left & RTRIM() removes spaces on right. So you need: SELECT RTRIM("Custome

2019-01-16 05:49:02 +0100 commented answer need help with Query SQL WHERE syntax

Have now looked at the result multiple times and can't see any problem. Need specific information on what you see as th

2019-01-16 05:25:24 +0100 commented answer Base: Entering data in a form, in a field linked to another table, how to add a new record in second table?

Guilty of placing horse in wrong place! Just trying to get you an answer and thinking (or NOT thinking) too fast. You'

2019-01-16 04:53:24 +0100 edited answer Base: Entering data in a form, in a field linked to another table, how to add a new record in second table?

Hello, This is the 'horse-before-the-cart' syndrome. Development before design. Happens much more often than thought.

2019-01-16 04:51:51 +0100 answered a question Base: Entering data in a form, in a field linked to another table, how to add a new record in second table?

Hello, This is the 'horse-before-the-cart' syndrome. Development before design. Happens much more often than thought.

2019-01-16 03:59:00 +0100 answered a question need help with Query SQL WHERE syntax

Hello, Just add to link on sub form:

2019-01-16 03:38:24 +0100 received badge  Nice Answer (source)
2019-01-16 03:36:12 +0100 edited answer Get the label of the button that was just pressed to call a macro

Hello, Seems to me you don't need any buttons at all. The macro can be attached to a toolbar item. The value to be us

2019-01-16 02:27:31 +0100 commented answer Get the label of the button that was just pressed to call a macro

The other suggestion requires each button to be unique in some way - either label or internal name. A button may be anc

2019-01-16 02:12:38 +0100 commented answer Get the label of the button that was just pressed to call a macro

The other suggestion requires each button to be unique in some way - either label or internal name. A button may be anc

2019-01-16 02:11:41 +0100 commented answer Get the label of the button that was just pressed to call a macro

The other suggestion requires each button to be unique in some way label or internal name. A button may be anchored to

2019-01-16 00:59:43 +0100 answered a question Get the label of the button that was just pressed to call a macro

Hello, Seems to me you don't need any buttons at all. The macro can be attached to a toolbar item. The value to be us