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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Xenos132

  1. Xenos132

    Query population slow on main form.

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

    How to handle a calculation if the subform has no value?

    Thank you
  3. Xenos132

    How to handle a calculation if the subform has no value?

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

    Subform Source Object?

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

    Subform Source Object?

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

    Subform Source Object?

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

    Subform 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
  8. Xenos132

    how to display a count of "0" in report

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

    Populating a subform based on the value from a list box help.

    Thank you
  10. Xenos132

    Populating a subform based on the value from a list box help.

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

    Sub form totaling help?

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

    Sub form totaling help?

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

    Sub form totaling help?

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

    Sub form totaling help?

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

    Dealing with Sales Tax and GST.

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

Part and Inventory Search

Back
Top