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 Chriss Miller 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 Tessadear

  1. Tessadear

    averaging numbers in linked tables using cal query

    CODE WORKS LIKE A DREAM!!!!
  2. Tessadear

    averaging numbers in linked tables using cal query

    This is the only code I got to work for me. How can I edit it to display the average when an amount value is blank. It works well except that when an amount is missing the average is not displayed...
  3. Tessadear

    averaging numbers in linked tables using cal query

    ([table1].[Amount]+[table2].[Amount]+[table3].[Amount])/(IIf(Nz([tblb].[field1],0)>0,1,0)+IIf(Nz([tblb].[field1],0)>0,1,0)+IIf(Nz([tblc].[field1],0)>0,1,0)) this code works, but if an amount is missing the average is not displayed. I tired using the Nz before each table in the first part of...
  4. Tessadear

    averaging numbers in linked tables using cal query

    I figured I could do it that way but I was trying to get rid of the / by the number of numbers because for example in some instances there might only be 2 numbers instead of 3.....I wonder if I could do a count on the number of values entered for example if there are 2 numbers the count would...
  5. Tessadear

    averaging numbers in linked tables using cal query

    I am not getting the correct answer using this formula Lets say I had 20 in table1, 50 in table2 and 60 in table3 what i need is to find the average of those 3 numbers. when I work it out using the formula above I am getting an incorrect answer fot the average. Percentage...
  6. Tessadear

    averaging numbers in linked tables using cal query

    how can I use the average function to average numbers from various linked tables in a custom calulated query field.Access allows me to add the numbers but if I needed to average those numbers how would I do that. eg.([table1]![number1]([table2]![number2]+[table3]![number3] I need to calculate...
  7. Tessadear

    using a blank value in a custom calulated query field

    I am using a custom calculated field in a query. the calculation adds an amount of money from each linked table. My problem is that the calculation (total) only displays if a value is entered as data in each table, if cell is left blank the calculation does not display. I need to make the...
  8. Tessadear

    code to allow user to select a printer when printing a report

    I need a user to click on a command button and print a report. My code sends the report directly to the default printer without allowing the user to select a printer. I need the user to get the dialog box which will allow him to select a printer, before printing. Here is my code Private Sub...
  9. Tessadear

    using the cursor to move down a row in a form

    Works like a dream Aceman. Thanks a million
  10. Tessadear

    using the cursor to move down a row in a form

    In a database table I can use the cursor to move down from row to row in column lets say to enter amounts but in the form I find I can only move from one field to the other horizontally with the tab which is fine. But I also want to be able to move down a column in the form using the cursor key...
  11. Tessadear

    Making design changes in a shared database

    What about disconnecting the user from the share
  12. Tessadear

    Making design changes in a shared database

    I have database that is shared. Sometimes I need to make design changes to the database but I access tells me that because I do not have exclusive use of the database I can't make design changes. If I try to open the database in exclusive mode it tells me I can't do tha because other users are...
  13. Tessadear

    Make database available on the internet

    I need to make my database available on the net so that users can input data in forms already created in access. Right now I can change the object name in the database to html and upload objects to my website but then the data is only read only. On some of my forms I need to have the users...
  14. Tessadear

    Freezing columns in a form view

    Freezing the columns in the datasheet view of the form did not seem to have any effect on the data in form view only in datasheet view. I need the field to be frozen in form view so that the user can scroll to the right and continuously see the frozen field. Is there a way I can achieve that...
  15. Tessadear

    force playsound code to play the full length of sound

    I used Audacity to record the sound, placed the code into a module and called the code from a command button. My problem is that when I click on the command button the sound plays but stops before the sound is finished. The sound file which is a wav file plays through to the end if I just...
See more

Part and Inventory Search

Back
Top