Recent content by Tessadear

CODE WORKS LIKE A DREAM!!!!

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

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

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

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

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

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

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

Works like a dream Aceman. Thanks a million

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

What about disconnecting the user from the share

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

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

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

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