Search results for query: *

I'm not a pro with Access VBA. Any help is greatly appreciated. I have one Unbound Audit main form with 55 controls in it. Under the Change Event I have one combo box named(CSC_Audit_type) that has 6 different values ("", Cash, Deduction, Credit, Journaling and CFR), depending on the value...

Hello, I've been trying to automatically populate the field value based on a combo box selection. I've looked for help in many postings and everything that I try simply doesn't work for me. I have a couple of fields in a table that has ID numbers and all I need is their descriptions to...

I am trying to create a Dsum calculation using a text box on a form just to display to the user what the Current Balance Owed of an employee is. I want to sum the total amount of checks that are showing on the subform received by an employee and deduct this sum of all checks from the employee's...

Hello, My IT dept is upgrading PCs from Windows 2000/Office 2000 to Windows XP/Office 2003. All my Access databases were created in Access 2000. I'll PCs will be upgraded to 2003 as soon as I get this issue resolved. I read thread181-1395263, and got some great information in one of the link...

Hello, I am trying to fix a problem on a database that I didn't create. I need help with some code on a combo box filter. I have form "frmEstimatedPayment". On this form a have an Unbound combo box that filters the "Agents" to give me a total of estimated payments by each quarter. I have 5...

Hello, I am having a problem trying to figure out a way to get a query result that breaks up one field into 4 different Amount groups. I had the same question last week, and I believe I didn't post it in the right forum. I am sorry. It was 703-1388918. I am pulling the data from...

Hello, I am a begginer user with VBA in Access 2000. I created an Adjustment audit db that contain batches to be posted. There is only one table involved (tblAdjustment) The batches have several different amounts. I need to create a report that show the percentage amounts audited. The batches...

Hello, I am working on a report result that gives me a total for the Agent header with the amount of calls answered by an agent. The header section needs to display the amount of necessary calls "Yes" and the amount of not necessary calls "No" as well. I used an IIf function in the control...

I am creating an Audit db in Access 2000 to monitor several different "reports" that agents work, which in fact are(tables)linked into the Audit db. The purpose of the database is to track the type of work the agents have completed. A group of people will auditor the work done. What I am...

Hello, I've read dozens of postings but I didn't find what I was looking for. I have a form with a field named TIME STAMP and the default value is =Time() formatted as Medium Date. I only need hour/min. However, in the table the TIME STAMP field also stores the seconds. This form tracks...

Hi, I created a split database that has a ContactID# set up as autonumber, however, I have about 20+ users (leaders) taking calls from agents logging in calls. I sent the users a copy of the front end database and it worked for about 1 hour. Then error message started to pop up stating...

Hello, I am trying to build a query to pull a total of completed "truck roll saved" coming from 2 different tables on a daily basis. However, I keep getting the incorrect data. I am not a pro with SQL. The common fields in the tables are the User, Date, and a check box for Saved Truck Roll. I...

Hi, I have two fields on my form where I am trying to set values depending if field [Answer] is "Yes" or "No". Field one [Answer] contaings a drop down box "Yes" and "No". Set up on my table as text and a combo box w/Yes and No. Field two [Points] should contain the set value. Set up on my...

Hi, Is there a way to track when users make changes/or try to make changes to the design of an Access database? If yes, what are the steps? Do I have to code it into VB? How can I can get a database sample that can guide me through it? Any help is appreciated. Thanks.

I have to copy information from a in house website. When I copy the information from the web into an excel spreasheet I copy along with it the data I need its hyperlink. I can't find a way to remove the hyperlink from several records at the time. I have to right click and remove the hyperlink...

How can I create one report that would select/pull data from several other forms, that would include drop down boxes, check boxes, etc., to come with one report result using just one query?