Search results for query: *

I have just started learning Access. I want to create a tree structure for my database in MS Access form. I have three fields in my table - category_ID, category_name and parent_category_Id. Tried treeview control recursively (used the code given by Microsoft)- did not work. Can some one...

Thanks a lot mp9 :)

Hi, In excel or word is there a way to anchor a document (that I use all the time) to the "File" menu item at the top or end of the recent documents list? Or can I anchor a document to the "documents" item in the start menu? Thanks, Rao.

Then only the first match is replaced!

Hi, I'm trying to replace all special characters (space, comma, parens) within double quotes in a string with an underscore using: while(<>) { s/"(.*)[ ,:\]\[\(\)](.*)"/"$1_$2"/g; print "$_\n"; } The following text <?xml version="1.0" encoding="UTF-8"?> <root> <cleanup"a string,here...

Dave, Excuse me for my sloppy post earlier. Following is the code I used. Thanks again for your help. --existing table in the database desc tab_raw raw_ID NOT NULL NUMBER raw_data NOT NULL LONG RAW --new table desc long2; ID NUMBER X VARCHAR2(4000) --function create or replace...

Dave, I tried your solution, sections 2 and 3, but get this error while trying to insert into long2 from longthang: ORA-06502: PL/SQL: numeric or value error ORA-06512: at "MYDB.GET_LONG", line 4 What am I doing wrong? TIA for your help. --Rao.

Hi, While using the following statement to do a load: BULK INSERT mydb.dbo.mytable from 'C:\data.txt' with ( fieldterminator = '|' rowterminator = '\n' ) I get an error "Line 6: Incorrect syntax near 'rowterminator'. Help appreciated. --Rao.

Hi, I would like to output all column names for each table in an Access2000 database. This would be similar to the ssql query in oracle, &quot;select column_name from user_tab_columns&quot;. A query or vba code is ok. I have searched around but didn't find any answer. Thanks for the help. --Rao.

Hi, In Windows explorer, I have enabled web view. In the right hand panel, when no folder or file is selected, on the left side there is a picture of the folder, its name underneath and then &quot;See also: My documents, My networkplaces, My computer&quot;. My question is can I add another...

Hi, I have several workbooks (each with just one worksheet) in a directory folder. I want to consolidate them (move them all) into one workbook (can be the first one of the bunch or a new one) each as a separate worksheet. I can do this manually by move/copy each sheet to the main one, but am...

Thanks for the help.

yes, this refers to Excel. Actually I lost the item from the built in menu. My question is how to get it back there!?

While trying to put a command (Format->sheet->rename) on the tool bar, I dragged it some place else and it is lost. Now it is lost from the menu too... How do I get it back? And then how do I assign a keyboard short cut to it (or any other menu item that doesn't have one)?

If any of the tables that are used by this SP is dropped and recreated, you will have to recompile the SP. Is that the case?

use utlfile package to open your text file; then you can loop through each line (record) and compare with your rows in table or parse for unique key fields. the other way is output your rows as text in the same format (csv or fixed width) and use any file compare utility. let us know what worked...

While in code window for modules or controls, I'm not able to scroll using the mouse scroll wheel (I have to use pgdn or down arrows). I can scroll in some other places like in drop down boxes, etc. This MS &quot;feature&quot; is driving me nuts. Does anyone know how I can scroll with the wheel...