Recent content by cvaccess

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

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

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

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.

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

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.

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

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?

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

Right

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.

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

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

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

Just this one.