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 derfloh 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: *

  • Users: CluelessRink
  • Order by date
  1. CluelessRink

    Suppress #Error

    If I enter a value into the appropriate field then the DSum works great. What I am looking to accomplish is to loose or hide the #Error that shows up before a value is entered.
  2. CluelessRink

    Suppress #Error

    Ok, I put the following into the beforeupdate event... Private Sub runningsum_BeforeUpdate(Cancel As Integer) Sub CheckValue() Dim frm As Form, ctl As Control Dim varResult As Variant ' Return Form object variable pointing to frm_main_tip_form form. Set frm =...
  3. CluelessRink

    Suppress #Error

    Yikes! That looks pretty complicated. I'll try to break it down. 1. Where or for what event do I put the function? 2. Does it go into the text box where I have the DSum? Or into the text box it pulls the data from?
  4. CluelessRink

    Suppress #Error

    Actually the only error I have is that the field is looking for data that isn't there. Not a problem, it'll be entered eventually. I just don't like the #Error that shows up and was wondering if there was a way to suppress it.
  5. CluelessRink

    Suppress #Error

    Is there a way to suppress the #Error message that normally occures when you don't have any data for a DSum function?
  6. CluelessRink

    Query Quandary

    Ah, I do wish all my troubles were so simple. Thanks. Rink
  7. CluelessRink

    Query Quandary

    I have a text box set up on my form using the following DSum statement to get data via a query... =DLookUp("SumOftotalSales","qry_sales_by_dept_es","transdate=#" & [transdate] & "#'") It isn't working correctly though, I am getting #Error. What do I have wrong?
  8. CluelessRink

    DSum Question

    Oh, they aren't joined at all
  9. CluelessRink

    DSum Question

    What the!!?? Here's an odd one! When I run the query, it pull up a bunch of data that isn't even in the table(s). I've done a compress and repair, but it's still there. What would cause that?
  10. CluelessRink

    DSum Question

    Got it! The problem was in the query, I had the wrong table in there. It sure helps to have a second mind in the mix to assist.
  11. CluelessRink

    DSum Question

    You know, I never though of trying the query, and no, there is no data. So that's where the problem is. Eh?
  12. CluelessRink

    DSum Question

    By [Name of Total control] do you mean the main table where my form gets the data?
  13. CluelessRink

    DSum Question

    I also put dept in [ ], still no-go.
  14. CluelessRink

    DSum Question

    PH, same thing... I've tried manipulating my data, adding new records and then going back and forth. Same thing, box remains empty.
  15. CluelessRink

    DSum Question

    Hey gol, your not out of line (at least I don't think you are), but I don't mind the dlookups, especially since I am learning while I am putting this thing together. I took on the project being a "kind of" access user and didn't really know what I was getting into. But I sure am learning a lot!
  16. CluelessRink

    DSum Question

    Hmm, sure looks like it should work to me. But now I am just getting an empty box.
  17. CluelessRink

    DSum Question

    Yes all are true except for [es], it is not a control but the name of a dept (which is a control). es is the name of the dept that I want the sumoftotalsales for.
  18. CluelessRink

    DSum Question

    Ok, I understood your post and I put in The es is the department code I would like to look up. With it the way I have it right now I get #NAME
  19. CluelessRink

    DSum Question

    gol4, I see what your saying, it *is* a weakness. PHV, it that a SQL specific query? I'm a bit confused.
  20. CluelessRink

    DSum Question

    I have a DSum that goes And it works wonderfully. I would like to add another variable to it though, one that will pull the data from another field called dept from the table named tbl_employees. I've tried but that didn't work. How would I phrase it? What I am trying to do is get the...

Part and Inventory Search

Back
Top