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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mdProgrammer

    Running Total with a reset

    ...'Rome', 90); insert into #t values ('3/1/2017', 'Rome', 30); insert into #t values ('4/1/2017', 'Rome', 1320); with rws as ( select #t.*, row_number() over (partition by destination order by Destination, flight_date) rn from #t ), tots (rn, flight_date, dest, DateDiffMin...
  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)...
  16. mdProgrammer

    Trying to run an application from a SQL Job

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

    Using the same recordset from the report in VBA

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

    Using the same recordset from the report in VBA

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

    Using the same recordset from the report in VBA

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

    Using the same recordset from the report in VBA

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

Part and Inventory Search

Back
Top