Method Community

Thanks Chad, that clears things up. I think we are writing an SQL statement though, you've just hidden the ugly bits from the user, made a nice gui to allow the user to build a statement by selecting a few key properties, fields, etc. and then written some code to parse that into whatever SQL language, object oriented, ASP whatever. Do you ...

Hi Andrea, [quote user="andrea"] Scenario 1 -my test payment. company email receives the 15 messages. My personal email (a Gmail account) receives "the email send failure alert" [/quote] This sounds like the scenario I described above. I'm going to explore this one further. [quote user="andrea"] Scenario 2- a ...

James, [quote user="jnoneiliv1"]I think answering this question in terms of typical SQL statement logic might help clear things up.[/quote] While it's helpful to answer in terms of SQL statement logic, we're not writing a SQL statement so I wanted to try and explain what distinct means outside a SQL statement. [quote ...

Rolf, Just wanted to let you know this issue was resolved.  You'll have to log out/in again, make sure you're on the April version of Method and make sure you republish the screen. ~Chad

Hi Bill, Do you mind telling me the steps you're taking in Method to get to that report? It sounds like its a custom report? The only other time I've seen this (I think) is if there is some report object that goes beyond the report margins. In the meantime, I'm going to try this in a couple of my accounts as well.

Hey Mark, Nice tip!

OK, I have a question about using 2 cells as the parameters for a SQL Statement. This code is not working because it is not recognizing STARTDATE and ENDDATE as parameters:       Dim STARTDATE As Date     Dim ENDDATE As Date     STARTDATE = Range("B1").Value     ENDDATE ...

Hey Matt In these situations we've found that starting from the last action and working up allows you keep adding the same position number.  

Matt, We'll take this suggestion into consideration and see if and how it would be best to make this area of Method easier. Thanks for the hijack.

So somehow all a sudden my route list is printing one stop per piece of paper printing on 13 pages now instead of 3 and i cannot for the LIFE of me see what was changed, all my page breaks are set to none i've changed them all around since then but can't figure out why it's creating all this dead space.