Recent content by shandoo27

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 .