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.
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...
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...
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...
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...
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...
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.
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 =...
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...
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.
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.
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...
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...
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...
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.
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.
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)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.