Search results

Hi Minty, Thank you for these two solutions!

Hi Mike, Thank you for your reply. The design plan for the database is still in progress.I hope you to answer the question below. I set the Link Master Field and Link Child Fields on the subform (-> the attachment). I set the edit properties in the main form (Allow editions, etc, tblProjects)...

Hi Tom, I set the Link Master Field and Link Child Fields on the subform (-> the attachment). I set the edit properties i the main form (Allow editions, etc, tblProjects) NO. But then I couldn't edit records in the subform. I clicked the OK button in Subform Field Linker. What is the solution...

Hi Tom! Thank you for your reply:) Now I can add records in the subform! Adding records in the subform (tblProjectPayments) the data properties Allow additions/Allow Deletions/Allow Edits are YES (-> attachment) The main form (-> upper form (tblProjects) in the attachment: Data properties Allow...

Hi, It's about how to add/edit records in a subform. The first attachment contains the subform which is inside the main form (-> the second attachment). There are two tables, tblProjects and tbl ProjectPayments in one-to-many relationship (-> the third attachment). The projects will last about...

Hi, Thank you for your information about how to create a primary key.

Hi, Thank you for your reply. Yes, your are right about the table names and autonumber fields.

Hi, Thank you for your reply! The agreement number is created by European Union authorities. The projects are funded by EU. Private businesses are implementing these projects in practise. Just a check question: while all the primary keys in these tables should be Autonumbers, I must change the...

Hi, Than you very much for you reply. The field "Agreement Number" must be a text type because agreement numbers contain numbers, letters and hyphens. The agreement number is unique and is at the same time the unique project number/ID. Why Agreement Number could not be used as Primary Key? By...

Hi, It's about the error message after using the Lookup Wizard (-> third attachment). The idea was to make the field "Agreement_Number" in the table "tblProjects_payments_from_2022-10-01" (-> second attachment) a field which gets the value (Agreement Number) from the table...

Thank you for your reply!

Hi, Usually a data source for a text box control is a field of a table. If it is appropriate that the data source for a calculated field is actually the result of a query: how could the result of a query be transferred as a data source for the calculated field? Thank you for the answer!

Hi, How to add a currency symbol (€) after the currency amount (120,00€) in the calculated field in the report? Please reply to me as soon as possible! Thank you for your answer:)

Hi, What is the latest version of Microsoft Access? How could I get it? Can I get it as a part of my Microsoft Office 365? My MS Office 365 version is Microsoft 365 Business Premium (CSP) Microsoft Online. Thank you for your answer!

Hi, I have developed small Access applications for a long time. But today cloud-based databases are becoming more common and useful. One alternative is to begin to develop Azure SQL Database applications. The current Access applications would be front-ends. What is the best way to study how to...

Hi, My email is ensio.ekonen@kfmaccounting.fi Best regards

Hi arnelgp, Just a correction to the last line of my email I sent today: the preposition should be FROM, not for!:) I suppose the function udfIsKeyWord() is able to execute these complicated queries. Please email me your comments By the way, is it possible to purchase programming services...

Hi arnelgp, Thank you for your good and quick reply! Attached is the structure of the table "KFM_Knowledgebase". This table contains information about business accounting and taxation I enter. The following example shows what I mean. If there are only two keywords I would enter then the...

Hi, My question is about a complicated Access query. The knowledge base table has four different keyword fields and other fields. When entering a new knowledge item, I usually enter 2-4 keywords, one keyword in each keyword field. If I do a query with four keywords, the structure should be...

Hi, Yes, I use the Report View. And using Shift+F2 the small text control is zoomed out and the long text is visible. Thank you for your reply.