Recent content by AccessNub

I actually did, it failed without it. I even had to alias the pivot and the table even though I wasn't referencing it anywhere else.

Ok, I got it, I sat down and really focused on how to build this damn thing..Turns out in SQL you have to name all the possible values. SELECT RptDate,[PR] as PR, [TR] as TR,[TY] as TY FROM (SELECT RptDate,PlanType, PaymentAmt from TABLE) ps PIVOT (Sum (PaymentAmt) for PlanType IN ([PR]...

Ah, I wasn't clear. I want this query to work in Sql Management Studio. It doesn't like the word Pivot.

I am normally able to figure this stuff out on my own, but I can't seem to get the logic for a SQL pivot. Here is what I have in Access: TRANSFORM Sum(Table.PaymentAmt) AS Amt SELECT RptDate FROM Table GROUP BY Table.RptDate ORDER BY Table.RptDate DESC PIVOT Table.PlanType; Which outputs...

That sounds like a good place to start. I will give it a whirl on Sunday. Thanks for the idea.

A little more info: I am using excel to open a recordset, the recordsource is 2 tables in 2 different databases with an Inner Join. I do this by specifying the whole path of the database in the table selection, ex: String = "SELECT * FROM [;DATABASE=Path\Database.accdb].tablename INNER JOIN...

Hey All, I have an Excel file that has been working just fine for the past 2 years. Yesterday it started to debug saying Item Not Found. I was able to determine the exact line of code that was causing the error, but I haven't been able to find the cure. Dim DB as DAO.Database set DB =...

If the front end with no tables was 1.5GB I would delete the whole thing and start over. =)

Hey all, I have adopted someone elses database. It is a front end with about 100 linked tables/forms/reports/modules. The problem is that the database is really large. I would think by looking at the objects that it should be around 5mb tops, however after compacting it is still 63mb. Is...

No sooner than I ask, I figured it out.... Here is what is needed to make the body your HTML Dim stream As Object Set stream = MBSession.CreateStream Set body = MailDoc.CreateMIMEEntity Call stream.WriteText("Place HMTL Code Here") Call body.SetContentFromText(stream...

Hi All, I have been sending plain text emails for a while, but now I have a project where the formatting of the text needs to be specific and I need to send as rich text. I can use the rich text from a table, excel, or word, but I am at a loss on how to get the data to Lotus Notes. Any...

It's been a while since I have been stumped, but I can't seem to get VBA IE to wait for the page. Here is the issue: Page loads, transaction is submitted, everything works fine 99% of the time, however, on occasion, the page loads a mini error page where you have to click a blue link for it to...

Unfortunately, this is a government report and I cannot change how it looks.

Hi Guys, I have recently started using acOutputReport to print my report to PDF. Previously I was clicking the Print button and chosing Adobe (distller). Everything is working fine, however, I noticed that the acOutputReport files are HUGE in comparison to the Distiller prints (859KB vs...

Hi all, I have a database that runs a macro/report every 2 hours, however our network has been up and down lately. This causes the macro to fail when trying to log into the system because the table that is storing your username is no longer in the database. When I check, all tables, linked...