Search results

  1. C

    Count help

    I have a report that shows: Dlr Count_of_Delinq Min Days Max Days It shows up fine. But what I'm trying to do is only show those with multiple counts.(leaving off the ones that have only 1 count. Thanks for the help.
  2. C

    Could someone review this code?

    I don't know code that well. I'm trying to count for all curGrefund fields in my report. I need to count only those that have a dollar amount. I do not need to count the ones that are $0.00. THis code works but I wanted to make sure there won't be any problems down the line. Thanks for the...
  3. C

    Conditional Formatting

    Thanks, I will try it.
  4. C

    Conditional Formatting

    I am trying to use conditional formatting in my report but I am having trouble. I am trying to get these fields to be bold: txtName curGcost curGrefund curSCcost curSCrefund The condition is: Expression Is [chkDealerVisit] = True When I view my report, it comes up with the appropriate...
  5. C

    Criteria help in query

    That's not possible in my case. One record(or account) has the possibility of having cost in each category(GAP, SC, Life, Other). I'm trying to get totals of each category. I'm trying a crosstab query now. but seem to be having trouble with it.
  6. C

    Criteria help in query

    I am trying to get all records that have been delinquent in any part for 45 days. Each record has these categories: G, SC, CL, O. Not all records have data in these categories. Here's what I have: I have an expression: Total: Sum([dtmGrec] - [dtmSent]) dtmGrec is the received date for...
  7. C

    Dap

    I took out some criteria: Like "121###" and Like "122###" and now it works. But I need the Like parts. Any suggestions? Thanks!
  8. C

    Dap

    I am trying to create a DAP from a query. I did create on from a query that pulls up all records past 45 days. But I tried with another query and it didn't work. I know the query works b/c I run reports off of it. It does the same as the first query but also seperates the information by...
  9. C

    Bound Checkbox

    not sure if this will help, but maybe it might. http://www.tek-tips.com/faqs.cfm?fid=5159
  10. C

    adding to comments for multiple records

    I have a comments on my form. I have contacts with them having from 1 to many customers accts. I am trying to come up with a way to update the comments for a contact that adds those comments to all their customers records...but not to those that have been closed. How would I add these...
  11. C

    Form problem

    ok, Thanks very much for the help!
  12. C

    Form problem

    I changed it to Null and it worked. is "" better than Null?
  13. C

    Form problem

    Here's what I am trying for... If I put $0.00 into the 1st control, then 2nd and 3rd control will display nothing. But 2nd control is showing $0.00 and the 3rd is showing 12:00:00AM I don't have a problem with the 2nd control displaying $0.00 but the date is bothersome. It would be fine if it...
  14. C

    Form problem

    The reason I set the default values is b/c of this problem. But it didn't help. Code for 1st control: After_Update ----------------- Me!curGrefund.Enabled = Nz(Me!curGcost, 0) <> 0 If Me!curGrefund.Enabled = False Then Me!curGrefund = False End If Me!dtmGrec.Enabled = Nz(Me!curGcost, 0) <>...
  15. C

    Form problem

    I am having a problem when I enter data into my form. I have two controls that are currency and 1 that is date/time. If the first currency control is 0 or null, then both the others are disabled. If I enter 0 or delete the default "$0.00" in the first control, the 2nd control will show...
  16. C

    Switchboard/Search problem.

    I created a switchboard and when I click on it to bring up my form, the search functions on the form won't work. I created the search through the combo box wizard. It gives me this error: Run-Time Error '3021': No current Record. Any suggestions? Thanks
  17. C

    Report problem

    How would I go about doing this?
  18. C

    Report problem

    IT's the expression. If i remove it...the comments show. But...now I've seen that it cuts part of the comments off. I guess after 255. I originally changed the memComments from text to memo b/c my comments are sometimes over 255. How can I get around this on a report.
  19. C

    Report problem

    I think its actually the expression I have. SELECT [Dealer Contact Info].intDealerNum, [Dealer Contact Info].txtDealer, [Dealer Contact Info].txtContact, [Warrenty Log].txtName, [Warrenty Log].dtmSent, Sum(Date()-[dtmSent]) AS [Total Days], [Warrenty Log].curGcost, [Warrenty Log].curSCcost...
  20. C

    Report problem

    I think it has to do with my query. I need to split up some info into two queries. I have #'s that start with 121, 122, 123, 124. 121 and 124 needs to be together. 122 and 123 needs to be together. I had this in the criteria field: Like "121###" Like "124###" These were on seperate lines...
Back
Top Bottom