Search results

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

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

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

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

Hi, My code: Private Sub cboAgent_AfterUpdate() Forms("NavPage").Controls("NavigationSubform").Form.Controls("frmTermAgent").Requery Forms("NavPage").Contkrols("NavigationSubform").Form.Controls("rptAgentsTerm").Requery End Sub Is supposed to take the agent from cboAgent and use it...

Hi, Is there any way to code my report to freeze panes like MS Excel? When I scroll right I lose track of the Agent name and when I scroll down I lose the headings. On large reports this creates more confusion than I would like. Is there anything that will assist me with this? VBA / header...

Hi, New to VBA here... Will this code shut down my database at 2AM each night? Private Sub Form_Current() If Time$() = 7200 Then DoCmd.Quit End Sub I have it set to On Current in my navigation page... Thanks, Canadian

Hi, I'm wondering if there's any way to find out who has a database open. I've saved the file as an ACCDE for the users and kept the ACCDB file as my working file. Whenever I make changes to the db I need to save a new ACCDE file on top of the existing one. In order to do that, I need to...

How do I format: First 25% of records - Gold Second 25% of records - Green Third 25% of records - Yellow Fourth 25% of records - Red Please!! :banghead:

VBA for Ranking - Help adjusting code PLEASE Hello, I have a query I need help with. My query has a variety of statistics for each employee. There is a field in my query called KPIMiss which takes each KPI(Statistic) and gives them a percentage that it's worth, then subracts that percentage...

Hello, I've been doing some reading on multivalue fields and it seems to be exactly what I'm looking for. My question: Is there a way to use the multivalue field without making it a lookup? I need the user to be able to put multiple values in a field but can't limit them to a list. The...

I've done this once entirely by accident and can't seem to duplicate it... I have a report. It has the following: Report Header: Logo and title Department Header Supervisor Header Group Header Detail Department Footer: Totals Report Footer: Overall Totals for all departments Here's my...

Hello, I have multiple databases (one for each department). All 4 databases have an Agents table (tblAgents). Now I am creating another database that uses all of the agents on site. What I want to do is link all the agents tables and combine the values in one query. Fields are: UserID...

Hello! I have a form with a sub report. The form has very little on it, just combo boxes that filter the report and the report is below them. The parameters for the filter work great while the form is open and filter the report perfectly. When I open the form it works great and does exactly...

Hello! I'm looking for a bit of code for a module that will return the field name from an expression (that uses an array) instead of returning the value in that field. Example: (Minimum is a working module that finds the smallest number in the array) Field1 = 34 Field2 = 53 Field3 = 21...

Hello, I'm trying to convince Access to find a value and then convert said value into the name of the field it came from. Below is my current code: LowestMark...

How do I go about adjusting the below Minimum() module code to find the 5 lowest marks on the test, not just THE lowest?... it needs to grab the lowest, then look past the lowest for others with the same mark, then for the second lowest and the third lowest etc... Many times an employee will...

I'm getting an error and I'm not sure why... My code is meant to convert seconds into hh:mm:ss format. I've attached screen shots.

Hello! I have a report that shows Agent stats which works great for nearly 100 agents. One agent in particular however, is showing stats that are double what they should be. I've looked in the tables and queries and see no evidence of duplicated data. Is there a reason why one agent would...

Hello! I'm trying to create a report that pulls from two tables [tblTelephony] and [tblSales]. All data in my query is limited to a date range entered through a form. For every record in [tblSales] (showing the agent made a sale) there is a record in [tblTelephony] (showing all the stats for...