Recent content by nightjam

<RESOLVED> Thanks. I understand. ALl ok. I need to closed this thread as resolved.

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

Use the Tab ON change event instead of the page click events. I found the problem on my own.

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?

I read something on Microsoft Webpage on using CDO or ADO or WEBDAV to acquire. Trying to decipher and see how this can help. http://support.microsoft.com/default.aspx?scid=kb;en-us;320071 There must be someway without me acquring third party. When I find it I'll be sure to post it or make it...

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 resolved problem. On IIS server I had to enable read permission for Scripting from web based application for the folder that contained the CSV files.

If I seperate the task i recognised the SQL task to delete records from the table runs ok. the second dsk task fails on dts data pump 1 transformation 1 which import column 1 of csv file to sql database table. it works fine when ran from enterprise manager but from asp it fails.

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

thread705-679694 tREAD HAD it resolved

Nice code. It works well, but I choose to let my form window have Modal & popup ON & I've disable the minimize & close buttons in an effort to prevent the user from gaining access to the DB tables & queries (security). any advise how to minimize with popup/modal on?

****RESOLVED**** I had a combo box which row source queried as a criteria a textbox value on my Form. This somehow prevented the use of ADO access to the table. The corrective action i did was delete the row source at ADO access and after ado closure changed the row source back.

I am using ADO to open an access 2000 table and do updates but keep getting "database in a state by user which prevents from being open or lock". How can I unlock this state using VB coding? No one is using the db as im the only user, and the form does not have a control source so table should...

I had browse and found this same code late yesterday before your post. Thanks. it worked like a charm. Great stuff.

Interesting thread. I have inserted a picture box or bound OLE object. I want when the user double click the object they can browse for the pic and update the picture. How do u do this? I have disabled the shortcut menu in access so user can't right click to insert object. ANy help?