Recent content by murphy123

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