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!

  • Congratulations IamaSherpa 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. cvaccess

    Run-time error 450 in formatting Excel sheet from Access

    Thank you PH. I didn't think I could translate what I did in Excel macros to my Access VBA code. I just had to change it to my object and that worked. So this is what I added: Columns("F:F").Select With xlObj.ReplaceFormat.Font .FontStyle = "Bold" End With Selection.Replace What:="00"...
  2. cvaccess

    Run-time error 450 in formatting Excel sheet from Access

    I fixed the first problem which I can't believe fixed it. I just had to remove range and it bolded the header (to this: xlObj.Rows(1).Font.Bold = True). So now, what I need help doing is figuring how to lookup column f for the value 00 and highlighting that row. If anyone has insight on this...
  3. cvaccess

    Run-time error 450 in formatting Excel sheet from Access

    Hi, Disclaimer:I am novice to Access development. I recently was challenged to making enhancements to a db. I am trying to first get through the first hump of getting the header row bolded. I have gotten far enough of being able to display the sheet after it goes through multi queries that...
  4. cvaccess

    VBA 429 error

    Thank you Steve for the quick response. It is in this line: Set MonarchObj = GetObject("C:\Program Files\Monarch\Program\monarch.tlb") which I have debugged. Thanks.
  5. cvaccess

    VBA 429 error

    Hello, I am trying to export spreadsheets through VBA. I get an ActiveX error. This is the code I have, below. There are no ActiveX references in VBA and Monarch.tlb is referenced. I commented out the previous way of getting and creating the Monarch object to directly find the object with the...
  6. cvaccess

    Compare tables - help please =)

    Both tables, NEW and OLD, have the subsc_num in common. The query displays the differences in last names within the NEW table besides the differences in the two tables. I just want it to show the differences in the two tables and not compare within the NEW table. Hope this is clearer. Thanks.
  7. cvaccess

    Compare tables - help please =)

    I am trying to compare tables and it is comparing within the table in addition to the NEW and the OLD table. For example, a family is listed in the tables like this: NEW table subsc_num last_name 123456789 hubert 123456789 hubert 123456789 smith OLD table subsc_num last_name 123456789...
  8. cvaccess

    form versus query

    They have the same data types but they have different tables. That is the difference. I have tried parsing the query further and still I got the same error? Anything else?
  9. cvaccess

    form versus query

    Here is my thing. Why does the same set of queries for another data type work fine right now for the entire month? It is the same with the exception of referring to different tables. For example: SELECT PendPercentTPSummary1.TP, PendPercentTPSummary1.[Pended Total]...
  10. cvaccess

    form versus query

    Right
  11. cvaccess

    form versus query

    I noticed that it works fine if I do a small span date, such as 01/01/03-01/10/03. If I do the entire month I get that long error message.
  12. cvaccess

    form versus query

    I am thinking of doing a 4th query to take out the where clause on summary2. This might be making it too complex currently.Here it goes: RejectPercentTPSummary SELECT DISTINCTROW rejected_summary.TP_NUM AS TP, Sum(rejected_summary.TOTAL) AS [Rejected Total], Sum(indiv_tp_sub.CLAIM_SUB) AS...
  13. cvaccess

    form versus query

    I didn't even get that far I was trying to run it through the query tab first and got this error. I have 2 subqueries for this "RejectPercentTPSummary2", "RejectPercentTPSummary1" and "RejectPercentTPSummary". I think the "RejectPercentTPSummary2" is too...
  14. cvaccess

    form versus query

    Now I get another error which seems like the main reason ( I think) "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression...
  15. cvaccess

    form versus query

    Just this one.
  16. cvaccess

    form versus query

    This bring up a similar error "Run-time error '2001': You canceled the previous operation." It give me the option to debug, end or help. The debug just highlights the do.cmd line.
  17. cvaccess

    form versus query

    I created another command button pulling the same query and the same error came up. I have not modified the queries at all. I believe I mentioned earlier that the query runs fine when I run it through the Queries tab. Thanks.
  18. cvaccess

    form versus query

    Here it is. Thanks. Private Sub cmdRejectSummary_Click() On Error GoTo Err_cmdRejectSummary_Click Dim stDocName As String stDocName = "RejectPercentTPSummary2" DoCmd.OpenQuery stDocName, acNormal, acEdit Exit_cmdRejectSummary_Click: Exit Sub...
  19. cvaccess

    form versus query

    Hello, Something strange is going on with a query I have. I have a command button on a form that pulls from a query "RejectPercentTPSummary2". When I run the query through the form (command button) it brings up an error box stating "You cancelled the previous operation." But...
  20. cvaccess

    tracking field

    Hello, I have a form which contains fields populated by a query when the form opens. The fields can be modified by a user (change the data in the field or fill in a field). I have been asked if it is possible to track the field changes. For example, if the user changes the date field, stamp a...

Part and Inventory Search

Back
Top