Search results for query: *

Hi, Its been long now, earlier was using editor for ASP as below. Editplus Visual Studio HTML Editor Is there any better editor, which can be used and develop the site faster. Captain

Hi, Currently using SQL loader on server. Problem is each user logs into the server and loads, requirement is each user from their own PC logs in thru the application and loads. Can't load SQL loader in all the PC as it is chargeable for installing SQL loader in each PC. Captain

For SQLLoader it needs to be on all client's PC. Can only install on Server. Captain

hi, Thanks, I have saved it in Personal.xls with a code in VBA Private Sub Workbook_Open() Call PersonalMenu End Sub Captain

No, not created custom toolbar. Then tried creating custom toolbar and transferred New Menu and in that dragged custom menu item. On restarting Excel neither menu appears i.e. New Menu nor custom menu item. Cap2010

hi, I have created lots of Code and want Menu to display all the buttons whenever Excel is opened. How to do it. Cap

I am trying to do it using Query mode given in MS Access and not through module. Cap2010

Yes this is right, only things is on giving dates for date1 and date2 it displays all records. date1 = 11/1/2004 date2 = 11/10/2004 Captain

Mufasa, File is fixed-length fields, process followed want to follow is 1) Upload all records in Oracle 2) Check whether records id exist with main id 3) .... rest other checking after uploading file. Can we directly ftp to oracle database ? Captain

Hi, Currently using MS Access Query to retreive data from Oracle database thrugh ODBC. The query is retrieves all data for a date range given. Requirement is to retrieve only those data with a date range given. Please help Cap

Hi, How to retrieve data from ascii text file which is having 1,000,000 lines or records and store data at a stretch directly in Oracle using Client to Server. Captain

HI, I currently have 15 users having different PC and acccess one PC having data in a folder. Only 10 are able to access this folder (data is on single Windows XP PC). How do I make the other 5 to access this folder. How to make access a single PC for all 15 to access at a same time Captain

hi, How much time will it take to import 20000 or more records from a text file to Oracle database (Client to server). Want to retrieve fast and than check all the 20000 or more records is correct. How to import such large records in Oracle at a one go. Captain

hi, Through connected Oracle database with Access using ODBC. Using access for queries on oracle through MS Access. Whenever using certain date range query, Access outputs all data of Oracle. How to query through MS Access with date criteria on Oracle Database using ODBC with output of those...

hi, Below are two different code. Doing same task. Which is better to use and effective ? Code 1 rs.Open sql, Adoconn, adOpenDynamic, adLockOptimistic rs.AddNew rs.Fields("ItemCode").Value = "AWI01" rs.Fields("Name").Value = "ABDEOD" rs.Fields("DDATE").Value = Date...

hi, In XP have run error-checking on Hard Disk, USB Sony Giga Vault 40 GB. now it is not accessible. Is there way to correct this and bring all data back. Need help. Cap2010

I can't do this in all PC. Application will run from any PC of respective user authorised and they will send. Is there other way. Cap2010

DanJr, Thank you very much, it worked for the month. Cap2010

PHV, Thanks, it is done. Made two query. Query 1 Has all the criteria with dates. Query 2 used your query it worked. amorous : what is t2.yourdate ? Thanks to all. Cap2010

I have added a field rowid and now it as numbers from 1 to ...... Wanted to delete those records having even numbers how. tried doing proc sql; %let vrowid = 2; delete * from tt4 where rowid = &vrowid + 2; quit; deletes only one record. cap2010