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

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.

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

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

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)?

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