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

thanks for the reply. This is what I wanted. -shandoo

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.

Hey, Thanks if anyone was going to help me with the above problem. The problem has been resolved rather very easily. Me.ActiveControl.InputMask="PASSWORD" This masks the password textbox peacefully.

Hi, I did as you told above but there is no change , it is still focussing on the starting row first column as usual. any other way to achieve it ?

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.

yes i have done the above , but my purpose of having an add button is because I dont want that row to be added directly because a few of the total field columns of the table have been bounded, the rest of the values are there in the textboxes in main form. So once the user enters the values in...

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

I am new to access and thus having a lot of doubts. Sorry for being ignorant. Could you guide me as to how to bind a table to a form then without VBA directly pls ? thanks in advance for the help .

Private Sub compare_Click() Dim TOBEEFTMIN As Integer Dim TOBEEFTMAX As Integer Dim ACT_EF_T As Integer Dim EF_REMARK As String Dim EF_DIFF As Integer TOBEEFTMAX = CInt(DLookup("EF_T_MAX", "ADMIN_ACCESS", "FORM_CHOICE='TO_BE' AND PRJT_NAME=FORMS!ACTUALS!PRJT And TLA=FORMS!ACTUALS!SUB_PRJT And...

I tried the above Cint function as u said but still no change. I am facing the same problem . I have posted below the SUb for the button, Could you please check and tell whether i am making some grave blunder or syntax mistake ? thanks in advance for the help .

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

I now understand the difficulties in the above situation. But then it would be kind of you to also tell how to avoid such errors and how to correctly create a new row in the oracle database . Thanks in advance for the help provided .

Yeah thats what i wanted . How do you open a file and write into it using VBA coding . Please enlighten me on this . If you could give a sample code I would be very thankful . Thanks in advance for the help .

Are you sure that a normal sql query will be enough to update a table in Oracle ? Because some people say that modifying link tables don't modify the database in oracle, but then they say we need to set up some server or something ?