Recent content by mdProgrammer

Ok, I found something close, but it's for Oracle. So, just for reference - https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:9531712000346124348 Seems to be almost what I want. For example, row 2 should say 0 for the total, and row 3 should say -300, so offset by the previous...

I have a query that I'm working on which has the requirement that it calculates a netloss carryover (it's an accounting app, so accounting algorithms aren't my strong suit). The current netloss carryover field should add the income and netloss from the previous month. I found a running total...

I found a work-around code to just save the PDF and then send that. 'Behind a comand button save the report as PDF file DoCmd.OutputTo acOutputReport, "Report1", acFormatPDF, "reportname.pdf", False

Unfortunately, where I work, they aren't going to be using Outlook anymore (or exchange server for that matter). What I was trying to get at with the first question was something like I did above (adding the test file does work), but instead of a test file, the report object in MS Access, like...

I have code, found on the Internet, which can send an email to gmail (via an internal relay). How do I add an attachment of a report in the database? I can't use Outlook (I have code for this that has worked for years, but we're no longer using Outlook) due to switching to web-based email, and...

Thanks, I'll keep those links in mind. The above code seems to work in IE10+ (which most of our users have - some still use IE9 for older legacy web applications on outside networks). There's also the work-around of saving the file first, which can then open.

I have a datagrid that creates a dynamic linkbutton control if the column contains an attachment field. This linkbutton should download the file, but doesn't (The popup comes up, but then says unable to download file). I get different results on 3 different browsers. Ok, first, I have a...

To add, I'm not sure if it's the best practice, but it works.

I did manage to find a work-around for what I want, via modifying the gridview after it has been databound. I also found and slightly modified some code I found on the Internet (the original assumed that the column would be found, so I added a boolean to check if that was the case or not. If...

I have an application which was written in .NET 1.1 that used a datagrid that I would dynamically change a cell into a link based on the column and security settings. For example: Column is an ID field and user has access to the record - Show a link. Column is an ID field, and user does not...

Note - I'd ask this on Microsoft's Technet Forums since it's more browser specific, but the firewall at work blocks Microsoft's live.com as a web-email service, so I can't log in... ("Security Wars"!!!) Anyway, Google Chrome recently disabled support for showModalDialog (version 37), and I've...

Just to update, I've did the above query using a crosstab, and then another query to get the required records. That query took 1 1/2 minutes. The second part was where the item was "closed", except for one particular category of items. That query is taking well over 5 minutes to run, but the...

Just to add (there doesn't seem to be a way to edit posts here - unless that section above Homer > Forums > Programmers, etc. is the edit commands and our network decided that it's spam content and blocked it...), that query is only the half of it. There's another where a specific category is...

You're not the only one that finds it confusing. :) It's common to get these types of requests from a few staff members where I work... (fortunately, it's just a few) User_ID and Name_ID are the same thing - just didn't change them. ID#1 - Would show as all 'items' are closed', and at least...

I have a query that I'm trying to create for Access, with limited success (data's not always correct, and can be very slow). Anyway, the query works in a similar way to this (only I was trying to change the Having clause to count if the item didn't say "close", and ignore those IDs)...