Search results

  1. E

    How to create a complicated query with four different keyword fields?

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

    How to create a complicated query with four different keyword fields?

    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...
  3. E

    How to create a complicated query with four different keyword fields?

    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...
  4. E

    How to create a complicated query with four different keyword fields?

    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...
  5. E

    How to zoom out the contents of a long-text field

    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.
  6. E

    How to zoom out the contents of a long-text field

    Hi, Yes, the the field is blank because the text begins on the line 2 accidentally. But the reason was the font size as you mentioned above! I enlarged the font size and now the long text is visible! Thank you very much for your help!
  7. E

    How to zoom out the contents of a long-text field

    Thank you for your reply. I tried to use Shift+F2 on the text control ("My notes ) and a window opened but without any text, although the long-text field ("My notes") contains several text lines. (-> please see the attachment). Why is the window empty without text? Sorry, the database text is...
  8. E

    How to zoom out the contents of a long-text field

    Ok. But is there a zoom-out control for designing a report which has a long-text field? Thank you for your reply.
  9. E

    How to zoom out the contents of a long-text field

    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.
  10. E

    How to create a combined query?

    Hi MajP, Thank you very much for your query and the union query you built:) I created a new table with all the keywords and linked the tables (KFM_Knowledgebase and tblKeywords, see the attched file)) But how could I add the union query code (SQL codes you built) to create a union query...
  11. E

    How to create a combined query?

    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...
  12. E

    Property sheet disappeared

    Hi Isladogs, Sorry for the misspelling. I wish you nice December
  13. E

    Property sheet disappeared

    Hi Islagogs, Thank you very much for you reply! The hiding of Property sheet was complete, but your tip ("or its offscreen to the right") was great! Now Property sheet is visible and available.
  14. E

    Property sheet disappeared

    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...
  15. E

    Parameter Prompt with Multiple Entries

    Hi Thank you for the quick reply. I should use (for example) parameters with two entries/inputs because I need to get data from two projects from the database. So how is it possible to create a parameter prompt that accepts multiple entries (here: 2 entries)? Thank you for your reply:)...
  16. E

    Parameter Prompt with Multiple Entries

    Hi, I mean the situation what the attachment file contains. The attached file contains an example from the book "Access 2013 Bible" pages 396-397. I tried the type the text "InStr ([Enter Periods separated by commas], [Period])", (page 397) but this query did not work. It there some type...
  17. E

    Parameter Prompt with Multiple Entries

    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...
  18. E

    Report : Page Header

    Hi arnelgp, Thank you for your reply. Only the label controls (acting as head lines containing column names of the detail section) should be visible on the Page Header on every page, not other controls. I just noticed the report has now only one page although the report's length was 3...
  19. E

    Report : Page Header

    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!
Top Bottom