Search results for query: *

Pls help. I am trying to refer to a table which is in another sql server database (on the same machine) . What is the syntax ? thanks

I have an MS Access database (Access 97). It is on a Network drive and the idea is multiple users (atleast 10) will be using it parallelly. I mean to input data/edit data. When I am a user and other users in my department use, there is no error. But downstream department users use the...

HI, In the detail section of my form, and I have a subform in that detail section. I have a combo box in the subform and I would like to change the control source/row source properties dynamically. How can I access those properties of the combo box which is in the subform. could someone give...

HI, In the detail section of my form, and I have a subform in that detail section. I have a combo box in the subform and I would like to change the control source/row source properties dynamically. How can I access those properties of the combo box which is in the subform. could someone give...

Hi, I need to FTP using VB5.0. can someone give me some directions on this please. thank ou nath

Hi, I have been using Access97 tables and I used to use set dbtemp = currentdb() set rst_table = dbtemp.openrecordset("tbl_test") to connect to the tables. But now I have moved the table to oracle. I have created a DSN using ODBC administrator. How to connect to oracle using the...

I have declard some global Array variables in the Module files and after finishing the processing how can I intialize the global array variables to nothing? Public gltest(1 To 4, 1 To 10) If I don't initialize the global array variable to nothing does it hog the memory? thank you nath

Hi, This is an MS Access 97 question. I have developed an Access application with Oracle tables as back-end. I have linked Oracle tables using a DSN. (created DSN using ODBC administrator) There is only 1 form in this application. When I run the form it runs fine and does updates, inserts...

Hi, This is an MS Access 97 question. I have developed an Access application with Oracle tables as back-end. I have linked Oracle tables using a DSN. (created DSN using ODBC administrator) There is only 1 form in this application. When I run the form it runs fine and does updates, inserts...

Hi, I am using DBGrid (data bound grid control) on a VB5.0 form. When the user double clicks on a row, I am populating the data into text boxes and the user can modify the data and hit save button. But as soon as the data is saved into the database, I would like to change the color of the row...

Hi, I have an MDI form. When the user logs into my application by typing UID and PWD (which is a small popup form), depending on the access rights to the user I need to disable some menu items of my MDI form . I have created some menu items on MDI form. How can I disable/enable the menu...

HI, I have a VB project and it has an MDI form. How do I know what are the forms that are loaded currently. could some one give me some suggestions please. thanks nath

Hi, I need some urgent help.. I am trying to use DDEInitiate command to invoke Excel from VB5.0. I am able to use this successfully from Access97 but I do not know if I can use in VB5.0 could some suggest me please nath

Hi, I need some urgent help.. I am trying to use DDEInitiate command to invoke Excel from VB5.0. I am able to use this successfully from Access97 but I do not know if I can use in VB5.0 could some suggest me please nath

Hi, I have an MDI form and muliple child forms. There is a Menu item called "Print sCreen". When the user chooses this menu item it has to implement the "Print Screen" functionality. Basically it has to print the screen . Can someone suggest me how this can be done...

Hi, I have an MDI form and muliple child forms. There is a Menu item called "Print sCreen". When the user chooses this menu item it has to implement the "Print Screen" functionality. Basically it has to print the screen . Can someone suggest me how this can be done...

Hi, I have an MS access report and in the detail section of the report, I need to have a check box control. and it should be checked. How can I do that. thank you nath

Hi, I am using VB5. I am using DateAdd(interval, number, date) function. In the interval parameter I need to use half year (6 months). But in the help I don't find that interval. The intervals has quarter, month, seconds, hours, days but not Half year . Can some one give me some idea how to...

Hello, I am trying to write into a table the contents of a excel file using the following code. DoCmd.TransferText acImportDelim, , "tblGR_CallableDNIndexStage", nfile But I keep getting "Cannot update. Database or object is read only.". I checked the database and it not...

Hi, I am studying an old database application and trying to re-engineer it. In the old database application, they are using 2 tables.Both the tables have same table definition. one is a staging table and second one is production table. They import data from an ascii file into the staging table...