Search results for query: *

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.

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

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?

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.

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

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

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?

Oh, they aren't joined at all

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?

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.

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

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

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

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

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!

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

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.

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

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

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