Search results

  1. N

    Dynamic List Turns to Static List

    Hello, We're using a new database version and so we set a new data source location for my report templates. For some reasons, CR is asking for username and password after refreshing the report unlike before. So I created a read-only username and password. Everything works fine but one...
  2. N

    With new Souce Database, It Asks Username & Password

    Hi, After using the new source database location due to using a new database version, the report template that I'm using is now asking for username and password before it generates a report. Please see attached. This was not the case during the time that it was using the old database location...
  3. N

    Buttons Unclickable

    Hi, I am using Access 2007. Just last week, my database is working fine. Now, I'm trying to click any buttons on my main menu, it highlights the button but does not do anything after that. I can still open any tables, queries, and reports but for some reason buttons are not working properly...
  4. N

    Query: Update Field Formula

    Hi, I have a formula for my query: Expr2: iif((not isnull([StartDate]) AND isnull([EndDate])) OR(not isnull([startdate]) AND [EndDate] >= date()), 1, 0) So it says count 1 if: StartDate: with date EndDate: blank OR StartDate: with date EndDate: today - future date How can I update...
  5. N

    Formula to Count Dates (with conditions)

    Hi, I am new here and so desperate to ask anybody here to help me fix my database. I need to create a report to count my Subjects if they only have the following date conditions: #1 StartDate: with date EndDate: blank and any Subjects with #2 StartDate: with date EndDate: today's date...
Back
Top Bottom