Search results

Thanks for reply kevlray. I did that but it's still giving me the same problem. When I used a system admin account, it works fine but if I used the read-only username, it's the dynamic list becamse just a regular field to fill out.

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

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

Nope; I didn't move it. It is still in correct location. I also just noticed that two buttons are clickable except the rest.

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

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

pbaldy once again, thank you :). I am using: Start Date: Is not null End Date: >=Date() If I have new questions I will just create a new topic and hope you'll not get tired of checking and helping me, if ever. Thanks again to you and to all who took time checking and fixing my Access...

Honestly no, I really thought of that - to sum the first condition, sum the second condition, and then total them up :) By the way, you're super duper ROCK!!! It worked!! :) P.S. I will take advantage of your "smartness"; the report that I have is showing all data even those that don't...

Still not working. I have another option where I created a report and shows only 3 fields (Subjects, StartDate, and EndDate). So I'm thinking of having a total below the report but as always I'm not good in creating formulas. What I'm thinking is to put: Total A: Total of Subjects with...

Wow! You guys are the best taking care of a newbie *blush* :) So anyways, as long as the StudyStart (with dates) and StudyEnd (blank or "todays" and future dates) are showing and with total. Thanks, netchie

Hi, pbaldy, I think I am giving you a wrong info. It does not need to enter what Start Date I need to capture before I can get the total. As long as the Start Date is not blank and End Date is blank and/or with future dates then it should be counted automatically. it says I can't attach or...

Hi pbaldy, Thanks so much for your quick reply. You gave me a big smile as soon as I learned you posted. It seems that it's giving me wrong total (820). StartDate (with date) and EndDate (blank) should have a total of 136 StartDate (with date) and EndDate (recent dates to future dates)...

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