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

  • Users: XJ900
  • Order by date
  1. XJ900

    Convert Access SQL code to usable ADO SQL?

    I am trying to convert this code from an MS Access table to code that will be usable with an ADO connection. But I've had problems trying to figure out how to select multiple tables, inner join relationships and summing up fields from the RS.Open statement. SELECT Sites.SiteID, [To Date] AS...
  2. XJ900

    session login with windows authentication?

    This is all in VB6 by the way.
  3. XJ900

    session login with windows authentication?

    Is there a way to have the session use windows authentication rather than session.open "ADMIN", "ADMIN", "THEDB", DATE, 0? I am also using the xapi method to access accpac from outside the program. I thought I could go in with the normal string, get the user id that matches the current user...
  4. XJ900

    Detect user of application?

    Exactly what I needed. Thanks.
  5. XJ900

    Detect user of application?

    Is there a way to have an application detect the user that is using the app? e.g. Their windows login?
  6. XJ900

    Error in prog when it hits rs([field name]).value: Write Violation

    Looking at it again, I think it crashes every time it tries to look up a field in the record source.
  7. XJ900

    Error in prog when it hits rs([field name]).value: Write Violation

    I have a program that is supposed to access a ms access database, pull the information, and then post it to a MSOWC spreadsheet. If I run the code from VB6 it works fine, but when I compile it it crashes with an "unhandled exception...Access violation writing location..." When I debug the...
  8. XJ900

    DAO ODBC Connection

    Well who knew. That worked perfectly. ArtieChoke you are the man. I appreciate your help! Thanks
  9. XJ900

    DAO ODBC Connection

    Can anyone tell me how to create a DAO ODBC connection to a MS SQL server? I can do an ADO connection like so: Dim conn As adodb.Connection conn.ConnectionString = "driver={SQL SERVER};Server=Williamtell;DATABASE=" & sqldb & ";uid=accpac;pwd=accpac;" conn.Open I'm wondering what the DAO...
  10. XJ900

    View Crystal Report through ODBC in VB

    Thanks, I will check it out. Appreciate the help.
  11. XJ900

    View Crystal Report through ODBC in VB

    Can you tell me what the connect string is supposed to look like? I think that is where I am getting junked up the most, I'm not sure the format.
  12. XJ900

    View Crystal Report through ODBC in VB

    I suppose this is probably a basic question but this is what I am trying to do, keep in mind I am brand new to crystal reports and not the best VB programmer in the world. I am trying to bring up a report designed to pull information from any one of about 20 databases. The db's are located...
  13. XJ900

    Way to get a list of accpac dbs and MS SQL dbs?

    OK thanks.
  14. XJ900

    Way to get a list of accpac dbs and MS SQL dbs?

    On another note, I am wondering if anyone can tell me how to use the AccpacOrganizations object? Along the above lines I'd like some way to return the SQL database name of the company I'm in. Thanks
  15. XJ900

    How to pause a function?

    I have a function that executes until it runs into an inconsistency, then another form loads to supply the correct variable. The problem I am running into is that although the other form loads the primary form where the function is running continues to run. How can I pause the current function...
  16. XJ900

    Way to get a list of accpac dbs and MS SQL dbs?

    Thanks, that is exactly what I am looking for!
  17. XJ900

    Way to get a list of accpac dbs and MS SQL dbs?

    Is there a way to get a list of all the company databases and their MS SQL names using VB or is there a file accpac saves this information to?
  18. XJ900

    Way to return a list of all databases on MS SQL server?

    Thanks I'll give it a whirl.
  19. XJ900

    Way to return a list of all databases on MS SQL server?

    Thank you, one more question: Is there a way to do this with a DSN-less connection from a VB app?
  20. XJ900

    Way to return a list of all databases on MS SQL server?

    Is there a way to return a list/names of every database that is on the MS SQL server?

Part and Inventory Search

Back
Top