Search results for query: *

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

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

cdukes, I am using VB5 and what library should I include in my project file inorder to make use of DDEInitiate call.. thank u nath

I tried using your code For i = 0 To Forms.Count - 1 'do something with Forms(I).<property> MsgBox &quot;hello this is &quot; & Forms(i) Next i I would like to know the name of the form which is opened. when the control reaches the Msgbox statement, there is no property...

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