Search results for query: *

Ok. After reading more postings I tried combo box code to say isNull rather than ="" and I placed the code under the Current event procedure of the Form, and it's working now. Private Sub Form_Current() '**NULL TRUE STATEMENTS If IsNull(Me.CSC_Audit_Type) Then Me.UserID.Visible = True...

I attached a link to a copy of the database. http://www.mediafire.com/?dkfgt6vv106e8eh http://www.mediafire.com/?dkfgt6vv106e8eh

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

Hi Randy, Is your form bound to the table? YES Which table? Field names, please. The table where the User detail is: LAN_IDs Fields: UserName, UserID Table where I need the data to be stored: tblCredit fields: CSC_ID, CSC_Name (there are several other fields) The fields that I need to...

Thanks Randy. I tried the code, but I'm getting an error msg. "The expression you entered as a query parameter produced this error:" ...then it gives me the userID that I selected. The Name values are Null. Any other suggestions?

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

Sorry, I forgot to give you the code I tried: Private Sub Form_Load() Me.FilterOn = False End Sub I also tried... Private Sub Form_Load() Me.FilterOn = False Me.ComboAgent= " " End Sub

I tried that and I still get the same error message in the textboxes if there is no agent name selected from the combo box. Any other suggestions? Thanks.

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

The code VRoscioli provided was right on the money. Thanks everyone. For total adjustments audited: qryAdjAuditedByCat SELECT Sum(IIf([Amount]<=-50,1,0)) AS AuditCat1, Sum(IIf([Amount]>-50 And [Amount]<-15,1,0)) AS AuditCat2, Sum(IIf([Amount] In (-3.99,-4.99,-10.99),1,0)) AS AuditCat3...

Hi guys, Thanks so much for the quick replies. I have a sample of the data ready to be posted. But after I read VRoscioli's reply, it looks like it is exactly what I am looking for. I am going to test it, and if I have any problems I'll get back to you and post my data sample. Again...

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

Hi, Sorry I am just responding back now. I was on vacation and I just came back. I was able to work a little more on the issue I had. I decided to work in the query itself and I created an expression to count the "No" and "Yes". On the report the AGENT gave me the grouping totals I was...

Here is a small sample of my data: Call# Agent Call Necessary 1 Smith Yes 2 Smith No 3 Smith Yes 4 Davis No 5 Davis No 6 Davis Yes 7 Jones Yes 8 Jones Yes Here is what I need on my report output on the Agent Header...

Hi, [Call Necessary] is a text field with "Yes" and "No" list values. Thanks

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

Hi lotharious, thanks for the information. So far I tested the db with 2 tables and the queries worked. I'll add more tables to the query and if I come across a problem I'll send the question out. Thanks again.