Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. murphy123

    Combo box/form not requerying when value " "

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

    Combo box/form not requerying when value " "

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

    Combo box/form not requerying when value " "

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

    Automatically populate field value based on a combo box selection.

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

    Automatically populate field value based on a combo box selection.

    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?
  6. murphy123

    Automatically populate field value based on a combo box selection.

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

    DSum expression help

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

    Issues Updating Access Office 2000 to 2003 Export to Excel

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

    Form footer total not working for all agents from Combo box filter

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

    Form footer total not working for all agents from Combo box filter

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

    Form footer total not working for all agents from Combo box filter

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

    Select different values from the same field dividing them in groups

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

    Select different values from the same field dividing them in groups

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

    Select different values from the same field dividing them in groups

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

    Create one report using VB code from one single table

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

    IIf Question

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

    IIf Question

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

    IIf Question

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

    IIf Question

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

    Create an Audit db with multiple linked tables

    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.

Part and Inventory Search

Back
Top