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: *

  • Users: markphsd
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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 =...
  4. 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.
  5. 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...
  6. 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...
  7. 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.
  8. 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)...
  9. markphsd

    ADO handling disconnections

    Hi, I would like to know how to determine if the connection object is valid, before using it. Invalid wouldn't necessarily mean, adStateClosed, because i can turn off my wireless device on my computer and ado won't recognize this. Then when i try to open a recordset i get an error. I...
  10. markphsd

    Distributing Schema Updates

    Hello, I have a number of distributions of a database for a Sales application. We want to version each group of changes to the schema by the development team, then package those changes for distribution along with our application distribution updates. Currently we have to connect to each...
  11. markphsd

    ADO Field Name problem

    Hello, I have a field name of "1s" on a SQL Server Database. When using ADO to edit the field i get a 3265 error, that the field can't be found. I try to use an Alias, but it doesn't work. What can i do without changing the Fieldname? Mark P. www.cafecartel.com Providing Low Cost Powerful...
  12. markphsd

    Attach only MDF, was not dettached.(system crashed)

    I have a mdf only that I need to attach. The back up is several weeks old. The system crashed so the database couldn't be detached. The ldf could not be copied because it is corrupt. I'm trying to attach the mdf to a new server, but i can't use the sp_attach_single_file_db because from what i...
  13. markphsd

    System Crash, can i detach from sql server?

    A customer had an operating system crash on their system running SQL Server. Can the database be detached or copied and attached by just accessing the hard drive. (The folder is not secured). If not, what could be done with that database? Thanks. Mark P. www.cafecartel.com Providing Low...
  14. markphsd

    Tab Index Property

    I've been trying to figure this out for a while. I have to set the tab index of about 60 or 70 controls on a form. I have a sub that runs when the form loads, i've also tried it after the form is open: It goes like this: option explicit private mlTabInit as integer Private Sub...
  15. markphsd

    Autogenerated SQL Script to Add Column, Deletes Tables Data

    I have been using the SQL Script Generated to update multiple databases after changing one. It seems one or more of the are deleting all of the data from two or three tables in the datbase. How would I identify which script causes the deletion? Mark P. www.cafecartel.com Providing Low Cost...
  16. markphsd

    Trouble Debugging (Class does not support automation....

    I'm i'm trying to debug my dll. I Run the DLL, start the application. Some functions run, but I get an error only in debug mode on a Enumeration in the one class. Any ideas? Mark P. www.cafecartel.com Providing Low Cost Powerful Point of Sale Solutions.
  17. markphsd

    Question about What happens during Making a DLL

    I have a related post on here, about binary compatability. My DLL compiles fine, however when using Binary Compatability, i have been getting a couple of messages, and it seems they are consisistent. THe messages say i'm using an Obj type rather than the explict type. There are two object types...
  18. markphsd

    Updating DLL Breaks references in word

    I use a dll with word and Access, when I make any changes to the dll, i have to re-reference it in the WORD And access file. Is there any way to get around re-referencing? Mark P. www.cafecartel.com Providing Low Cost Powerful Point of Sale Solutions.
  19. markphsd

    Open Word Template, create new document

    How do i open a word template and create a new document from it? There's like 20 parameters when opening a word.application .documents.open(,,,,,,...... Mark P. www.cafecartel.com Providing Low Cost Powerful Point of Sale Solutions.
  20. markphsd

    Packaging and distributing saved scripts

    Earlier this month i had asked how to script changes to a SQL Server 2000 database. I was told to set the changes to be saved to a text file. Now i have all these script files from the changes. I thought I could run the SQL in the scripts using ADO with VB, but I get an error. For the...

Part and Inventory Search

Back
Top