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!

Search results for query: *

  1. edsearl

    Chart does not fill in with Vista

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

    Missing queries when merging with Word

    Thanks anyway.
  3. edsearl

    Missing queries when merging with Word

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

    Missing queries when merging with Word

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

    Missing queries when merging with Word

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

    Pass a value from a module to a macro

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

    Run_Time '490' Error Message

    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\" &...
  8. edsearl

    Run_Time '490' Error Message

    Thank you Lewds You put me on the right track.
  9. edsearl

    Run_Time '490' Error Message

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

    Null field shuts down database

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

    Null field shuts down database

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

    Copy record with max value by week

    Thank you. I'll try it.
  13. edsearl

    Copy record with max value by week

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

    Copy record with max value by week

    Or rather, Group By.
  15. edsearl

    Copy record with max value by week

    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];
  16. edsearl

    Copy record with max value 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...
  17. edsearl

    Copy record with max value by week

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

    Copy record with max value by week

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

    Access Equivalent to Excel's Roundup

    Is there a Access equivalent to Excel's Roundup?
  20. edsearl

    Reading an Array from a Recordset

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

Part and Inventory Search

Back
Top