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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mdProgrammer

  1. mdProgrammer

    Running Total with a reset

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

    Running Total with a reset

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

    Attaching an Access report for gmail

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

    Attaching an Access report for gmail

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

    Attaching an Access report for gmail

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

    Having trouble downloading a file from a server with a dynamic link button

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

    Having trouble downloading a file from a server with a dynamic link button

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

    Putting links into a gridview dynamically (.net 4.5.1)

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

    Putting links into a gridview dynamically (.net 4.5.1)

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

    Putting links into a gridview dynamically (.net 4.5.1)

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

    showModalDialog and future IE browsers

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

    Help on Grouping Query to find all rows that only have the same value

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

    Help on Grouping Query to find all rows that only have the same value

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

    Help on Grouping Query to find all rows that only have the same value

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

    Help on Grouping Query to find all rows that only have the same value

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

Part and Inventory Search

Back
Top