Search results

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.

Same DAO.... Hello Dear Tim, Thanx for the code, it works perfectly, except one thing. I put the code from CreateCalenderReference() into Form_Load() procedure, it works fine for the first time, but if I next time load the form, it says Name conflict. that's coz it loads the same file again...

Hi experts, I am using a bit of VB code in my form and that needs to have DAO references loaded first. I needed to run the same code in another database, and it generated error, coz DAO was not loaded there. What I need is to have a VB code to load DAO at run time if i need to run this form...

I hate replication.... Help plz Dear All, I searched through the threads in the forum, but couldn't find a suitable answer to my question. Here is the situation: We have a database which is splitted into front End and Back end parts. This database is recording the customer information. There...

or if you use VB code. write the following DoCmd.SetWarnings False :)

Hi raskew, thanx for ur time and effort. Let me tell u a bit bout the contents of two combo boxes. I have designed a database to record any problems facing our customers. Our customers are of two types. 1. Organizations (with fields - Org_ID, Org_name, Address, Contact Person, Telephone...