Search results for query: *

The data points in a scatter chart do not show when it's form is opened on our Vista machine. If you double click on the chart they appear. The form works fine on an XP. Any help. Thank you.

Why are queries missing when I try to mail merge a word document to my access database?

The following coding checks an ODBC table to see if the connection is OK. How do I get it to tell the macro that runs it to stop if the connection is bad? Public Function IsTableThere() On Error GoTo Err_IsTableThere DoCmd.OpenTable "PS$O_Table" DoCmd.Close acTable, "PS$O_Table", acSaveNo...

This coding looks for a drawing in one folder. If it can't find it there it produces an error which sends it to err_drawing to look in the other folder. If it can't find it in the second folder it produces a Run-time '490' message box. In place of the Run-time message box I would like it to...

Microsoft shuts down the application when the voltage field is empty. I tried "if [voltage] is null goto exit_Drawing_DblClick",but it didn't work. Private Sub Drawing_Click() Dim strinput As String Dim Name As String Dim symbol As String On Error GoTo err_drawing If [Voltage] = 4.34 Then...

I would like to see an example of coding that would copy the entire record that contains the maximum value in a field by week or month to another table.

Is there a Access equivalent to Excel's Roundup?

I get a "Run time error 3265 Item not found in this collection." message at If xmax < d3y!KVA(i) Then when running this code. Any help? Private Sub Command0_Click() Dim db As DAO.Database Dim d3y As Recordset Dim KVA(36) As Integer Dim MAX As Single Dim MIN As Single Dim xmax As Single Dim...

I have a form in which the vertical location of text boxes are determined by a values in a query. When the form is open I want to be able to move a text box to a new location and change it's value in the query by putting the curser over it, clicking and moving the mouse. How would that be done...