Search results

My requirement: I want to extract a particular value from the link table ( given between Oracle and MS access 2007) and print it onto a text box. For example , suppose the user gives the company name and employee id i have to look up the table and print the employee name. this employee name...

Thanks for the help . Can I use transfertext on to transfer data from tables to text files or Can data also be directly trasnferred from text boxes ?

Hi, Yes , I wan't to save the results got from the query as I want to print them in the corresponding textboxes in the form . Is there any way by which I can achieve it . One general Doubt: Suppose I did the SQl select operation , where would the output be shown ?? Regarding Oracle ...

One of my doubts is once u write the query, where will the queried output values be stored. Can i define variables and then assign them to it ? Because i want to print the row in the corresponding text boxes . Thanks in advance for the help.

Hi, I have created a MS access 2007 database with a set of forms and tables. Now I need to give the user the application to use . I don't want the user to be able to modify the forms or change the tables . It should no longer be a MS access file but just an application for use . Could...

Hi, I would like to run a C++ program which is called using a macro when a command button is clicked in the form . But the C++ program requires data which is available in the link tables in MS access . Is there anyway i can extract these data seperately and give it as input to my C++...

Hi, I have a few doubts regarding how to make SQL queries to link tables from MS access buttons using VBA coding. Given: I have a list of link tables connecting Oracle and MS access with info stored in these tables.I also have a list of text boxes and drop down lists also to get information...

Yeah I agree. But sorry, since I am new to VBA programming in MS access , could you tell me where this code should be written. I am only used to writing VBA codes for click function of command button. I dunno how to make something happen when the form is opened. Please guide me with this issue...

how to make a command button in a form visible automatically when the form is opened if he is in admin mode ?

Hi, I have a set of forms in my MS access database and have linked it to oracle database with ODBC. With the link tables now available , could someone help me out as to how to write VBA code for the buttons so as to retrieve info from the oracle database ? I would be happy if you could provide...