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!

  • 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!

Search results for query: *

  1. markphsd

    SQL to Group based on Commission Rate

    Awesome, I was clear. Yes that's exactly what I"m now doing in vb rather than sql. Mark P. www.cafecartel.com Providing Low Cost Powerful Point of Sale Solutions.
  2. markphsd

    SQL to Group based on Commission Rate

    Multiple scales was the part I was trying to get to. It would basically be a GROUP BY that has a where clause as the field. GROUP BY Range So for every given range there's a row with a total. Your statement would require me to do a statement for each commission scale. which I was trying to...
  3. markphsd

    SQL to Group based on Commission Rate

    I would like to write a sql statement that groups sales based on a range of values of a separate commission tier schedule. So basically there would be two tables, the sales table and the commission rate table. for example the sales person has three tier rates: 5% commission at sales...
  4. markphsd

    Merging Multiple Databases

    I would have to say, never mind this for now. I have a solution. Fortunately i have a SiteID witch would be the ID of each database. I will append this to the PKID's when importing into the main database. I believe this will cover it. Mark P. www.cafecartel.com Providing Low Cost Powerful...
  5. markphsd

    Merging Multiple Databases

    I'm going to be merging multiple databases into a central one. I know that during importing to a merged database, a GUID ID can be added. However, this will only be helpful for the database, not the GUI application I'm using. Is there anyway to make the Standard Primary Key ID's unique as...
  6. markphsd

    Retail POS Software Recommendations Wanted

    I worked with a company called SintelSystems.com they won't focused on the software but did focus on the solution. They know different software applications, security systems and so forth. They were an overall positive company to work with. Mark P. www.cafecartel.com Providing Low Cost...
  7. markphsd

    VB6 & CR10

    Any one have any solution? I continue to have this problem. Mark P. www.cafecartel.com Providing Low Cost Powerful Point of Sale Solutions.
  8. markphsd

    Error in forumla, invalid name

    Also, I have used quotes in the second argument like this: "'My Company Name'" Mark P. www.cafecartel.com Providing Low Cost Powerful Point of Sale Solutions.
  9. markphsd

    Error in forumla, invalid name

    Crystal Reports 10, Visual Basic 6. When assigning the header of the report a company name, not using a database I get a permission error or an invalid name error: I have this field in the header of the report. The code behind the header of the report is this: Receipt.RecordSelectionFormula =...
  10. markphsd

    VB6 & CR10

    The field "CompanyHeader" is in the report header section. The code is is in the ReportHeader section. Me.FormulaFields.GetItemByName("CompanyHeader").Text = "'MyCompany'" I get an invalid name error. This isn't using any dataabase at the moment. I actually had no problem generating records...
  11. markphsd

    VB6 & CR10

    How do I set the text of an unbound formula field with VB6 and CR10? I have tried various methods, done lots of searches. I would post them, but I'll wait for an easy response if it's there first. Mark P. www.cafecartel.com Providing Low Cost Powerful Point of Sale Solutions.
  12. markphsd

    Detect Dropped Network

    While that may be interesting, I couldn't figure out how it could answer my question. But yes this is true: "want to time out and raise a flag or whatever when you can't" thanks Mark P. www.cafecartel.com Providing Low Cost Powerful Point of Sale Solutions.
  13. markphsd

    Detect Dropped Network

    How would i detect if the database connection has been dropped. would i use a network or tcpip connection instead? The time out feature on ADODB connections doesn't seem to work as expected. Basically I would like to know very quickly if the connection is broken. Thank you Mark P...
  14. markphsd

    SQL Delete Help

    Fastest help for me ever. Thank you. Mark P. www.cafecartel.com Providing Low Cost Powerful Point of Sale Solutions.
  15. markphsd

    SQL Delete Help

    What's wrong with this: DELETE From ContactPurchases INNER JOIN OrderDetails ON ContactPurchases.OrderDetailID=OrderDetails.OrderDetailID I get this error: Server: Msg 156, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'INNER'. But it works find when using it as a SELECT...
  16. markphsd

    Does it help to be a jerk in the workplace?

    I'm often considered harsh at work. However, it's usually because of mistakes that were made and me trying to correct them. I'm also often very nice. Which is confusing to me and others. To me this document only expressed "promoted for domineering ways." as the basis for a negative individual...
  17. markphsd

    Printing multiple copy reports

    Do the print out one at a time DoCmd.PrintOut , , , , 1, False 'Run the code here DoCmd.PrintOut , , , , 1, False 'Run the code here Mark P. www.cafecartel.com Providing Low Cost Powerful Point of Sale Solutions.
  18. markphsd

    SQL Statement Appears correct, but doesn't work.

    Thanks Mark P. www.cafecartel.com Providing Low Cost Powerful Point of Sale Solutions.
  19. markphsd

    SQL Statement Appears correct, but doesn't work.

    What is wrong with this: UPDATE tblOrders INNER JOIN tblOrderPayment ON tblOrders.OrderID = tblOrderPayment.OrderID SET tblOrderPayment.OrderDate = tblOrders.ScheduleDate Mark P. www.cafecartel.com Providing Low Cost Powerful Point of Sale Solutions.
  20. markphsd

    Assign builtin Toolbar Button to Custom coded Toolbar

    I programmatically build a toolbar. However, i have been unable to find a function or macro to call a builtin toolbar function. This is the tool bar button for security that sets the security level. (so people don't get the warnings on the application i have them set it to low in 2003)...

Part and Inventory Search

Back
Top