Search results for query: *

I have a SQL returing distinct values. I need to know the total rows of the recordset. How is this possible without iterate through the recordset and having a counter? I tried the following code but it keeps giving me recordcoutn of -1 SQLquery="SELECT DISTINCT Elective FROM tblStudents"...

I have a tab control on my Form and a On click event function. The problem i have is the only fires when the user clicks within the content of the tab page but not on the tab's page header. How can i have the module trigger if the tab page header is clicked?

With reference to post thread10-1140443 Instead of going to exchange server and saving info to CSV file, I would like this process automated. Is there any file I can parse or component I can used to access this info or more to create my own management reports on exchange server usage? Please...

I have created a DTS package to 1. Execute a SQL task - which deletes all old data from a SQL database table 2. Import data from CSV file to SQL database Table. Now the DTS package runs Ok and fine from enterprise manager but when I run it from ASP it fails at item/step 2. ASP uses server...

I have a button on a Form which prints a report in acNormal view however I want the user to select the printer they want the report to print to. I don't want to preview the report, but rather just select the printer they want and click print. Any ideas?

How do I get the current path of my access database. I don't want to type an absolute path like below so how do I get the current path of the database? strFile = "provider=microsoft.jet.oledb.4.0;data source=C:\data\database.mdb