Search results

  1. H

    Update Data from one database in another one

    But don't I then have the problem, that I have lost data staying in the database, whenever I replace the full tables? For example, we have two records in database B. After the replacement, however, we only have one of the two left. So the records in the other "counselling"-tables related to the...
  2. H

    Update Data from one database in another one

    Hey Part Hartman, thanks for your response first of all :) No, the big database is the master-DB (A in my example) from which the updated data is retrieved. The light database (B) has these tables in common with A which cannot be altered within B. These tables and their fields can only be...
  3. H

    Update Data from one database in another one

    Dear all, As I stated already in another post: So now, I am almost done with forms (at least I want to believe that:D). But I ran into an issue I would love to have your comment and different approach on: The Database I create is projected on another, significantly bigger database! The one I...
  4. H

    Search/Filter by multiple (optional) textboxes on form

    Thanks again guys! I first solved it with the SQL approach Brian suggested and it worked very nice. And I have to say, it was not too easy since the code he suggested was very logic and not too complex. You just had to repeat the same kind f string with for the different fields. However, after...
  5. H

    Search/Filter by multiple (optional) textboxes on form

    Thanks a lot @Brianwarnock!!! I tried it out and it seems to work, unbelievable how much time I spent yesterday on this problem with no real results... But now: 1) when the user does not enter any field of the Name Search, how can I tell him with a msgBox, that at least one field is required 2)...
  6. H

    Search/Filter by multiple (optional) textboxes on form

    Dear Community, I'm relatively new to MS Access (using MS Access 2013 but the db should work on 2010, too) and try to develop a database for an NGO I'm working in. I created almost all the tables (all that I need for now) and made the relationships. However now I start to create forms and...
  7. H

    Greetings from Istanbul

    Hi guys! First of all thanks for the forum in advance :) I'm currently living and working in Istanbul and Ankara and are in the process of developing an MS Access database for an NGO...Unfortunately, I've never really worked with Access before. I created a tool in Excel you could call database...
Top Bottom