I give you a very simple way. at 1st click on project menu_Add Data Environment. Double click on Data Environment1. click right mouse on connection1 & then click properties. In Provider tab click on Microsoft Jet 4.0 OLE DB Provider. Click next. select the database. you can test connection in below. click ok. click right mouse on connection1 & click add command. again click right mouse on command1. go properties. in database object_select table. In object name_ select table name. click ok. 2. click on project menu_Add Data Report. select the data report. go properties. In Data source select Data Environment1. In Data member select Command1. 3. put a text box (Rpt textbox, in Data report) in detail (Section1) in data report. select the text box. go properties. in data member select command1. in data field_select any. 4. in form1 put a command button and then write
Private Sub Command1_Click()
DataReport1.Show
End Sub
An invalid variable is being referenced. To create an object variable, declare the object variable and then assign a valid reference to the object variable using the Set statement. Similarly, a With...End With block must be initialized by executing the With statement entry point.
1.Make sure the object variable references a valid object, and specify or respecify a reference for the object. 2.Make sure you did not use an object variable set to Nothing. 3.Make sure the object library in which the object has been described has been selected in the Add References dialog box. 4.Make sure your With block is initialized by executing the With statement entry point.
don't use private email. its not fair. by the way, when enter data by code and you write code for enter its automatically update data. like: With rs .CursorLocation = adUseClient .Open "SELECT * FROM table1", cn, adOpenStatic, adLockOptimistic ' cn is connection
This behavior occurs if a program's DisplayName or uninstall key name is longer than 63 characters. Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry. To resolve this issue:
1. Click Start, click Run, type regedit, and then click OK. 2. Locate the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall 3. Click the folder of the program that has more than 63 characters in the title, right-click DisplayName, and then click Modify. 4. In the Value data box, type a name with less than 63 characters, and then click OK. 5. If the program's uninstall key name is longer than 63 characters, shorten it also. For example, the following key name is too long: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\ 1234567890123456789012345678901234567890123456789012345678901234 6. Quit Registry Editor.
