Search results for query: *

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

I created a simple test application that automatically sends an email (it's eventual use will be sending secure email based on what's in a table - yes, I know about SQL Server 2008's email capabilities, but it's not set up, and I'm not the one that sets the servers up). This application works on...

Your code was referencing a table, but I wanted to use the recordset found in the report (which I found on another site, and was faster than what I was usiong). Also, not every answer in this survey database has percentages. Some answers have a list of counts, and a top 3 list of counts. At any...

Duane's suggestion sort of helped. It wasn't 100% what I was looking for, but it did point me in the right direction. Not 100% cleaned up yet, but this is what worked - Private Function findField(fieldName As String) As Boolean On Error GoTo FieldError Dim rs As Recordset, db As Database...

Also, why is it that reports can only run functions within the report code behind itself and not the 'global' module? I have 9 sub reports that are all going to have the same function.

Maybe I'm asking or wording this wrong, but how do I loop through the fields that the report uses without running the query again? I have a report that gets data from a crosstab report for a survey(thus, the fields are dynamic). So, the results might look like this: Run1: Question1...