Search results

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, 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...

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 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, The report contains a small text box control (only one-line high) for a long-text field. The long-text field could contains e.g. twenty lines of text. How could I zoom out the contents of the long-text field while reading/watching the text of the long-text field? Thank you for your reply.

Hi, It's about a database/knowledge base (Access database) with 4 keywords in order to search subjects/topics in the knowledge base. My question is how to create a combined query with 4 keywords (each keyword has own field, -> see attachment). With a combined query I mean: I am able to do...

Hi, A strange thing happened when I tried to create a new form in design view: a Property sheet tool had disappeared! The symbol of Property sheet is still in the menu, but clicking does not activate it. How could I find the Property sheet in order to bind e.g. a text box to its data source...

Hi, My question is about how to create a parameter prompt that accepts multiple entries. The table contains data of several projects (project numbers 1,2,3,4 and 5) If the user wants to search data from the project numbers 1 and 2 he/she should enter the project numbers 1 and 2. If I create a...

Page Header is visible only on the first page, although Property Sheet of Report shows: Format: Page Header: All Pages. Why is Page Header not visible on the other pages, only on the first page. Than you for the answer!