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 Rhinorhino 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: ctrox
  • Order by date
  1. ctrox

    Not printing the data visible in Print Preview

    I have a report with a detail header, and multiple rows of data below the header. When viewed in Print Preview, the detail is shown correctly. When printed, the first row of data in the detail section is printed repeatedly instead of the correct data. What is going on? Can someone please help me?
  2. ctrox

    Division by zero errors

    I have a SQL statement that is dynamically built in VBA through an Access form. I have a calculation that is performed within the SQL statement that takes two fields from a table and divides them by each other. It is very possible that either one or both of the fields in the calculation could be...
  3. ctrox

    Dcount or Count or maybe something else?

    That still doesn't give me what I need. It is filtering with the additional parameters within the Dcount function, but gives me the same number through all the rows. I need this for example (Field5 being the Dcount result, and parameters of Field1=a and Field2=b): Field1 Field2 Field3...
  4. ctrox

    Dcount or Count or maybe something else?

    I have the following query run through VB: SELECT Field1, Field2, Field3, Dcount(Field1,tableName,Field5<7) As Field4 WHERE Field1=a, Field2=b GROUP BY Field1 The Dcount is working correctly, except that it is ignoring the WHERE and GROUP BY in the SQL statement. It is counting all of the...
  5. ctrox

    Dcount or Count or maybe something else?

    nickske80, I tried that, but all it does is return that number of records in the grouping, like it is ignoring the criteria of <7. I hadn't tried your method before, but it gave me the same results that I was getting with Count(Field5<7), that is why I went to Dcount.
  6. ctrox

    Dcount or Count or maybe something else?

    I have the following query run through VB: SELECT Field1, Field2, Field3, Dcount(Field1,tableName,Field5<7) As Field4 WHERE Field1=a, Field2=b GROUP BY Field1 The Dcount is working correctly, except that it is ignoring the WHERE and GROUP BY in the SQL statement. It is counting all of the...
  7. ctrox

    On Add New Row in Excel w/VB

    I am trying to set up an Excel template for which I have a fixed number of columns, but no idea how many rows there will be. I am looking for a way to automatically insert formulas into a row once information has been entered into that row. Please help me, and thank you in advance.
  8. ctrox

    Printing Forms

    They are bound.
  9. ctrox

    Printing Forms

    I have form within a database that brings up info about individual business units with their corresponding image, each unit on its own page. When I view the form in form view, the images match up perfectly with their related information, but when I view the form in print preview or actually...

Part and Inventory Search

Back
Top