Search results for query: *

On my main form I am using text boxes with their control source pointing to their respective queries IE: (=DCount("*","QueHVBServiceOrders"). On my PC this data populates instantly. However as soon as I dump it on the server it takes several minutes to populate. If I open a query on the...

Thank you

I have sub reports based on queries, I am trying to total their values however if a sub report has no records I get an error. I was thinking Nz may help but it doesn’t seam to work. =([RepTimeSheetsQuery]![TotalM].Value)+(Nz([RepHelperTimeQue]![TotalH].Value,0)) How do I get a default of 0 is...

That’s what I thought.. I have tried both. Me.SubVisible.SourceObject = "frm_HVBServiceOrdersBilling" Also Me.sfVisible.SourceObject = "frm_HVBServiceOrdersBilling" And I get a compile error …Method or Data Member not found. On my main page I use this Code to change the subforms value . Dim...

Wow... where's the edit button :(

Is there a way to change my Subforms source object from a command button on my subform. What I am trying to do is have a welcome subform, That when the user clinks on a link it just changes the subforms source object

Is there a way to change my Subforms source object form a command button on my subform. What I an trying to do is have a welcome subform and when the user clinks on a link it just changes the subforms source object

Try this =Nz([table].[count]),0

Thank you

I have a form that I am populating with Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[CustomerID] = " & Str(Me![List1]) Me.Bookmark = rs.Bookmark On this form I would like to populate a subform based on the value from [List2] Being a novice I would think this...

OK why didn't I think of that... LAZY... thanks.. Strange that Summing the field didn;t work. OH well that did.

PHV I tired it… =Nz([List Price]*[Quanity]*(1-[Discount])*(1+[PST])*(1+[Markup]),0) This may help, if I just use =([Total]) It will give me the value on the cell I click on. But as soon as I put =Sum([Total]) I get #Error

I guess I shouldn’t have used the term Subform, right now it’s just a form that will become my parts subform on my orders form. It doesn’t appear to be a name problem Could it be a null value Problem? I know some of the totals are blank.

I have a sub form based on my parts table. The form is a Continuous Form. On this form I have a unbound (Total) text box where I run the calculation =[List Price]*[Quanity]*(1-[Discount])*(1+[PST])*(1+[Markup]). This part works well. In the footer I also have an unbound text box where I am...

Michael, I really wanted to keep a record of the calculated total value on the table as well as I felt it’s was an important number, however I had no success in finding how to store this data and gave in to normalization.

Thank you.. pampers, I know it's against normalization so finding this information has been tough.

Since taxes can and will change I would like to save the tax rate in my orders table. I was thinking of having a table called tax and in that table having a sales tax and GST rate. How can I take the data from this table and have it automatically populate my orders table via my order form?

What code can I use to show the total number of records resulting from a query in my sub forum?

I have put a bit of thought into this and I know it’s bad practice to do this. This value is the total of my invoice to be billed to my clients. I was thinking it would be better to make this hard data so it would never change if a problem occurs. I’m just thinking it would be safer for me to...

How can I take the result of calculated data and apply it to a cell in the table my form is based on. Normally I would not require this, however in this case I need this valve as once the table is populated it will be exported.