Search results for 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...

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

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

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

I am using a calculated query field from access as a datasource field in a mail merge doc in ms word. the field shows up in datasheet query view in access as 0 decimal places ( I used fixed and O decimal places in the format property. But when the merge is done in ms word the field displays...

How can I attach a wav file (sound) to a command button on a form so that when the user click the button the sound plays.

I want to place a command button on a form and have the user click the button to play a wave file. Can anyone help me with code I would place in the click event to play a wav file

I am trying to record using accessories sound recorder in XP...but it seems there is a preset lenth of 60 minutes because it records for 60 minutes and then stops. How can I get my recording to go on for as long as I would like it to.

I have just installed ISA server 2004 on windows 2003 server. I previously used proxy server. Now all the internet connections are very slow, much slower that when I used the proxy. I am operating on a partial T1 line. Any ideas what the prob might be.

I am connecting remotely to an xp client from server 2003. I am able to connect to the xp client and view everything else except disk management. when I try to use view disk management remotely from the server I am getting the message "unable to connect to the logical diskmanager service"...

When trying to startup my Nt Server I am getting an error message saying that the file Winnt/systems32/Drivers/ntfs.sys is missing or corrupt Press R to repair from the original setup CD. I renamed the ntfs.sys file to ntfsold.sys, got a copy of the ntfs.sys file from a next server and copied...