Search results for query: *

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...

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...

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

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...

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...

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...

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...

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?

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

I'm trying to run a financial report for another database other than the one I am currently in. I already know how to open a session to the other database but I can't quite figure out how to get the financial reporter to pull the information from the open session rather than the current...

I am trying to make a program that will pull up the journal entries in the General Ledger via Excel. The problem is I am not sure which table holds the journal entries. Basically my question comes down to how would you browse the journal entries in the GL? Do you have to hit a series of...