Search results

  1. Sarameier

    Is MS access the unknown magic bullet of our time?

    Maybe I did not put my point correctly. I know the difference between Access and Excel What I mean is that there is actually (nowadays) NO way to survive without a small relational database. 10 years ago, this was still possible, but in the meantime it is NOT anymore. And I dont think...
  2. Sarameier

    Is MS access the unknown magic bullet of our time?

    Dear all, I wish you a happy new year and thank you again for your previous support for myself. Thanks to all of you, I have managed to get an Access based system running which works efficiently and highly effectively. Following this, I would like to raise a general point. I hope that you...
  3. Sarameier

    copy macros to another access DB

    I tried to import the macro, but there would only the form be available. The thing is that I want to use this macro for other forms other than the inherent one... I thought there might be a way to just copy paste it to other forms
  4. Sarameier

    copy macros to another access DB

    but applying this function: The embedded macro from "on dbl click" would not appear to be copied
  5. Sarameier

    copy macros to another access DB

    Dear all... There is this great macro "for opening a form by click" https://support.microsoft.com/en-us/office/link-forms-together-4d5e8143-1859-4521-bbba-215f5ec8bb39 My question: Apart from copy & pasting the XML block, is there a way to bringing this macro from one Access DB to another?
  6. Sarameier

    Solved General search box for a table

    Hi all, Would a conversion of a (running) system be feasible? And: "lookup data yourself through joins" is basically this: https://support.microsoft.com/en-us/office/join-tables-and-queries-3f5838bd-24a0-4832-9bc1-07061a1478f6 right? @ smart mike: Thanks for this template. I admit that I...
  7. Sarameier

    Solved General search box for a table

    ok.. As said, this code works '------------------------------------------------------------ ' Search ' '------------------------------------------------------------ Function Search() On Error GoTo Search_Err With CodeContextObject If (Eval("[Form]![SearchBox] Is Null Or...
  8. Sarameier

    Solved General search box for a table

    hello again... I got one last little question for you on the source code above. Shall I open another thread or reactivate this one?
  9. Sarameier

    Solved General search box for a table

    Hi all, updating you on this. I have just tried it: Using the macro above, and just amending the field/table names works pretty well. So thanks again!! I think we can mark this thread as "solved".
  10. Sarameier

    Solved General search box for a table

    ...I now found it to, converted it to VBA. It is the following: '------------------------------------------------------------ ' Search ' '------------------------------------------------------------ Function Search() On Error GoTo Search_Err With CodeContextObject If...
  11. Sarameier

    Solved General search box for a table

    and a follow up to Gizmo and all others: I am happy to pay you for your product and support. Since I am still not (yet) able to contribute to this forum by posting technical comments, it should be just fine for me to contribute moneywise. no free lunch intended on my part :cool:
  12. Sarameier

    Solved General search box for a table

    Hi all...:coffee: @ DBguy: I am planning to use a (continuous) datasheet (table) view (i.e. no single or continuous form) Yes. I actually would need such a "filter function" as in the MS template, that is: - only filter applying to record sets - no modification of records - having the option...
  13. Sarameier

    Solved General search box for a table

    The search button should perform a search in which all fields (of one table A) are included. 1. After a string is entered in the search box, 2. and the search function is executed, 3. all records of the table A which include the string entered in the search box before should be displayed I...
  14. Sarameier

    Solved General search box for a table

    I guess, this link could be a simple solution. right?
  15. Sarameier

    Solved General search box for a table

    Hi all, I have been trying to find out how this great search box which MS has in its templates works. Did not manage to understand its logic. Does anybody knows how to implement this? https://omextemplates.content.office.net/support/templates/en-us/tf01225343.accdt
  16. Sarameier

    Solved Combo box filter in 1 table

    HI all, Appreciating all your answers. My system is now running quite well. Thanks for your support although I am just a newcomer...
  17. Sarameier

    Solved Combo box filter in 1 table

    I mean: filtering within one table is somehow also provided by the inherent Access function "filter by form". But is is not as comfortable as using a large "combo box" in a form
  18. Sarameier

    Solved Combo box filter in 1 table

    Hi, @ jdraw in my present case, it is indeed just a table for users (members) of travel groups. And I just wanted to be able to list all people coming from a certain country. An other example could be the table books which all relate to exactly one genre. I thought, there might be a...
  19. Sarameier

    Solved Combo box filter in 1 table

    For me, it makes no difference where the results (list of related users) would be displayed. Therefore, it should probably be displayed on the same form. I am actually just searching for a comfortable way the get search results for attributes within only one table. Of course, I could also...
  20. Sarameier

    Solved Combo box filter in 1 table

    Dear Forum, I am trying to set up a filter function for only one table, the tbl User. It is about listing all users following their country of origin. In my case, it is either 1- FR 2- UK 3- GE How could I do this getting in the combo box - only these 3 countries displayed - and NOT all...
Top Bottom