Recent content by bnath001

thank you

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

Thanks Jerry. It works. bvyas

Lightning, I appreciate for taking time in responding my question. But it still says "There is an invalid method in an expression" when it runs Forms![frmTabCustomers]![subItems].Form.SetFocus statement. May be I should let you know exactly what I am trying to do. 1. I have a Main...

thanks. But it doesn't work. frmTabCustomers is the Main form. subItems is the name of the sub form. cboNames is the combo box which is on the sub form (subItems) Forms![frmTabCustomers]![subItems!Form].SetFocus Forms![frmTabCustomers]![subItems!Form].[cboNames].RowSource =...

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

How to use Pass thru query ? (connecting to oracle from Access97). currently I have linked Oracle tables into my access97 application using LInked table manager. thank you 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...

Thank you I will do that. But I am using an access form and with local access tables and few Oracle tables (connected thru a ODBC DSN). I have linked the oracle tables into my access database using linked table manager. When User clicks on the Generate button, it does bunch of calcuations in...

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