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.

Thanks anyway.

I'm only seeing SOME of the tables. I tried creating a new query and it still didn't show up. The query has simple syntax...qryAPPLY.

I had previously created the Word document (a letter) to look to the Access database to fill in certain information in the letter by running a query in the database. The query does have criteria set. (e.g., a date field allows the user to enter a time frame.....such as all records entered...

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

I did this If [Supply Voltage] = 36.5 Then strinput = Dir("F:\NR-Scanned-Drawings\Customer Connection CD\Overhead\33kV Customer-OH\" & Me("drawing") & ".tif") If strinput <> "" Then strinput = "F:\NR-Scanned-Drawings\Customer Connection CD\Overhead\33kV Customer-OH\" &...

Thank you Lewds You put me on the right track.

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

Thank You Remou The isnull works fine. I will look up the select case.

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

Thank you. I'll try it.

The first query: SELECT StationDaylyPeaksT.CTI_MTRID, StationDaylyPeaksT.Year, StationDaylyPeaksT.Week, Max(StationDaylyPeaksT.KW) AS KW FROM StationDaylyPeaksT GROUP BY StationDaylyPeaksT.CTI_MTRID, StationDaylyPeaksT.Year, StationDaylyPeaksT.Week; Then, the second: SELECT MV90SubKeys.CM_NAME...

Or rather, Group By.

Do I add By Week to the end of it? Like: SELECT TOP 1 * FROM tblTable WHERE [CTH_KVAH] IN (SELECT Max([CTH_KVAH]) FROM tblTable) By [Week];

Maybe I should have said SQL. What I have done in the past was to creat a query in design mode, group it by week to get the max CTH_KVAH, then link that query back to the table to get the rest of the record. It seemed clumsy. I wanted it to be easier for someone in the future to work on...

CTI_MTRIDX YrMoDaHr CTH_KWH CTH_KVARH CTH_KVAH CTH_PF Week SUB01250 2007061108 8864.099821 -4932.899901 10144.24798 -0.8738 24 SUB01250 2007061109 9185.399815 -4706.099905 10320.80162 -0.89 24 SUB01250 2007061110 9393.299811 -4498.199909 10414.79159 -0.9019 24 From the above data I would want...

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?

Thank you all for your time. The d3y.Fields(i).value worked. What I should have told you in the beginning was that when I created the table I named those fields KVA(1),KVA(2)...KVA(36). I did that so that I could use them in a do loop. Now it seems that the parentheses were a waste of effort...