Search results

I would like to export the bounded data in a subform ( this subform is only bounded to a particular set of fields in the table) to a text file on the click of a button . Could someone help me with a suitable VBA code pls ?

hi, I have successfully bound the sub forms in MS access to the tables present in the database and run the application . Now i wish to have a bigger database and thus shifted to oracle for database.Thus i created tables in oracle database and linked them to MS access using ODBC . But now my...

Hi, I have till now used MS access tables for database and thus peacefully used Dlookup for selecting a particular column value and insert and delete and update for row modifications. Now I am going to destroy these tables and link my MS access forms to oracle database. I would like to make...

Hi, I have till now used MS access tables for database and thus peacefully used Dlookup for selecting a particular column value and insert and delete and update for row modifications. Now I am going to destroy these tables and link my MS access forms to oracle database. I would like to...

I have a text box which is validated to store date. I want to automatically store the current date when the textbox is unlocked. Is it possible ? If so please help me with the VBA code.

Hi, Is there a way to mask the password as the user types in the text box in MS access2007 using a suitable VBA code?? I want to print * for each character entered. Is it possible? If so please guide me as to how it can be achieved. Thanks for the help in advance.

I have a main form with a button add and a subform which is bounded to a given table. I want the add button to work like this: When add button is clicked, It has to set focus on the first column of the new record in the subform and then after the user enters data into all the columns in the...

I wish to modify a row in the table on the click of the modify button . I tried to use UPdate SQL command and run the SQL command using DoCmd.RunSQL. It is not showing any error but it is not modifying the row . the Code for the above requirement i wrote was : Dim SQLC As String SQLC =...

Is it possible to bind a table and a form in MS access 2007 ?? i.e. I want the form to have mutliple rows which are bound to a particular access table . Once I enter values into a particular row and move onto the next row the previous row must be updated automatically into the table . Is it...

hi, I wish to retrieve a particular value from the table and use it for comparison and calculation purposes . In the VBA code i tried using Dlookup function , but it returns a variant and i can't compare with an integer. Is there any possible way where i can extract tht value as an integer...

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

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

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