Search results

Worked beautifully!!! Thanks Paul!!

I'll try it and let you know. I did see that there but wasn't sure....

Hi, I have a database that logs people in and out. Works great unless the user minimizes the navigation page and clicks the X on the main Access Page. I have to keep the minimize button active on my nav page. Is it at all possible to disable the main access page for the user? If not, is it...

Hmmmmmm Now that I'm doing this with multiple queries it's telling me that I cannot open any more databases... this is why I soooo wanted to filter that in the report... I'll keep working at it tho. :)

Thank you! Now I know how to move forward. Your help is appreciated! :)

OH! haha ok The first line: ((([tblTelephony].[TelephonyDate] Between [Forms]![NavPage]![StartDate] And [Forms]![NavPage]![EndDate]))) [tblTelephony].[TelephonyDate] is the date of the info I'm working with (needs to be filtered using a date range so that I can pull one month/week/day of...

Separately, the codes work beautifully. The filter fails because the report properties filter setting can't see tblTelephony or qryTelephony. How do I get the filter property in the report to find tblTelephony when there are multiple query levels between the table and the report? I need this...

SELECT qryActiveAgents.Coach, qryActiveAgents.Agent, qryTotalCalls.SumOfCalls, qryTotalCalls.SumOfTransferredCalls, qryTotalCalls.AvgOfAverageHandlingTime, qryTotalCalls.AvgOfTalkTime, qryTotalCalls.AvgOfAfterCallWork, qryTotalCalls.AvgOfHold_Time, qryTotalCalls.AvgOfBreakAux...

I'm doing research on subqueries... this may be the answer.

qryTelephony is basically a copy of the table with minor criteria in the query. I can't put the date range in the query as I will be using this for multiple date ranges on separate reports and I'm trying to limit my query use in order to avoid the db getting bogged down. tblTelephony has all...

Hi, I'm trying to use the filter in the properties section on my report instead of multiple queries in an attempt to spead my database up. I can reference the query I'm using no problem so most of my reports are working fine. The problem: One report in particular contains sums and averages...

there is code in my FE, but not in my BE file It's the FE that keeps going Read Only Strangely, IT doesn't see anyone in the DB when they kick everyone out of the folder. This still fixes the problem (temporarily).

Hello, I'm sure it's not random, but it doesn't seem to follow any sort of rules. My database has become "Read Only" 3 times now causing all workers using the database to stop work until IT can fix the issue. All IT does is kick everyone out of the folder that my db is in and suddenly it is...

OMG it worked!!! Thanks BluishDan!! :)

Thanks Paul! but how do I do that? I don't see anything that refers to negatives...

I'm already working from a query that has queried queries... lol it is called: qryMetricsDifference-1Month The fields are: Coach - Text Agent - Text Calls AHT - formatted as hh:mm:ss (at the report level) ACW - formatted as hh:mm:ss (at the report level) Hold - formatted as hh:mm:ss (at the...

Would that solution remove the "-" or make it not visible? I would prefer to make it not visible.

Hi, My database tracks statistics for Agents in a call center. I have reports that show the agent stats. The report I have a question about shows the difference in stats from last month to this month. I've conditionally formatted the report so that if the number is negative it is red...

The codes worked perfectly individually, but as soon as I put both actions in one code it would screw up. I ended up figuring out how to do it on one form and it works great. Thanks for the help!

typo corrected: returns same result