Recent content by everblue

Dear All, I searched a lot, but was unable to find a downloadable Tutorial on MS Access 2000, preferbly "Teach Urself MS Access in 21 days" Help....

Dear All, Please read the situation first and help me if possible.... I am using a form, it uses two combo boxes and one text box. In the underlying table, i have a field called (prob_id). I want to extract some values for (prob_id) from those text boxes and I place them in another control on...

Dear All, Please read the situation first and help me if possible.... I am using a form, it uses two combo boxes and one text box. In the underlying table, i have a field called (prob_id). I want to extract some values for (prob_id) from those text boxes and I place them in another control on...

Dear Experts, I have a form having many text boxes and combos. Among them are two text box (Date, Reference_No). I want to retain the previous entered values of these two boxes when I go to a new record. Can Anyone tell me how to do it. Thanx

Thanx Thanx RichMorrison, It is working just fine.

Hi friend, place a button called "add" and a text box and a list box with the names u have suggested. View the properties of List box and on the second tab (Data), select "Value List" from the "Row Source Type". in the click event of the button, write the following code. Private Sub...

Export To Excel If u r exporting ur tables manually to excel format, there is an option in the EXPORT dialogue box... that is (Save Formatted) check box which is located between "Export All button" and FileName combo box. Check the "Save Formatted" Check box and it will save it the way it...

Dear All, Is it possible to execute a standalone executable file (.exe) from within access VB Code. I want to execute the 'Net Send' command to send an alert message to another PC if a new record is inserted in the database. Thanx

Check this..... the click event of the button must have a code like this... docmd.openQuery "QueryName" right? open ur query in design mode and goto its SQL editor. copy the code and come to the click event of ur button.... before the docmd.open..... command, write this set...

Try using this.... Place a list box onto your form, go to its properties, on the DATA tab, Select <Value List> from the <Row Source Type>. I assume ur listbox name is list1, so you can add new items to the list using this techniqu... list1.rowsource=list1.rowsource & NewText & ";" NewText...

It is not the last event of the form. When u start typing on a text box, Before_Update() is triggered. Didn't work :(

try using this ... at the start of the code, use DoCmd.Hourglass True and at the end of the function calls, use DoCmd.Hourglass False It will keep the hourglass till the end of the process. Thanx

Use a little VB code in the Form_load() Ice Rhino, Put three lables naming A, B, C in front of the Today's Text Boxes and write the following Code in the Form_load() event. Private Sub Form_Load() dim db as DAO.Database dim rs as DAO.recordset set db=currentdb() set...

I have a form containing three text boxes. 1. ID - Autonumber 2. Item_Name - Text 3. Item_Num - Text Some of the Items have Item_Num, while some of them not. I have designed a form containg all these three controls on it. Now What I want is: If the user leaves the Item_Num field blank, it...

Try me.Parent.ControlName.value in the default value of the subform text box. replace 'ControlName' with the text box name which uses the date.