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.
Method 1: you didn't tell what operationg system you use. ok Move the "Temporary Internet Files" folder back to its original location To complete Method 1 on a Windows Vista-based computer, follow these steps:
1. Click Start type Internet Options in the Start Search box, and then click Internet Options in the Programs list. 2. On the General tab, click Settings in the Browsing History area. 3. Click Move Folder. 4. In the Please select a folder to which you can add items navigation pane, locate the following folder: C:\Users\User_Account_Name\AppData\Local\Microsoft\Windows 5. Click OK two times. 6. When you are receive the following message, click Yes: Windows will now log you off to finish moving Temporary Internet Files. Do you want to continue? 7. Log on to Windows Vista again.
To complete Method 1 on a Windows XP-based computer or on a Windows Server 2003-based computer, follow these steps:
1. Click Start, click Run, type inetcpl.cpl, and then click OK. 2. On the General tab, click Settings in the Browsing History area. 3. Click Move Folder. 4. In the Please select a folder to which you can add items navigation pane, locate the following folder: C:\Documents and Settings\username\Local Settings 5. Click OK, click Apply, and then click OK.
Method 2: Grant permissions to the "Temporary Internet Files" folder To complete Method 2 on a Windows Vista-based computer, follow these steps:
hello can you help me, i make exe file on my project but the problem is that when i separate the exe file in my folder where my project is stored. it will not run..but i want only my exe file and put it to my flashdrive without the folder of my project..can you help me with this..thank you in advance hoping for your positive responds.
is this a database project and confirm the database file with it in the same folder. what kind of problem you face? if you not use pdw then some .dll file or some .ocx file what u use in your project are need with exe.
in ms word the save button is a toolbar. if you want to do like it then you need to use toolbar. if don't want to use toolbar then you can do it many ways. like: image or picture box. or like debasis.
I am not clear. inserting picture in a button..........again you said "i want to put beauty on my form i want my button to change to picture just like saving a document" what you want. I think you want to change your background picture of form.
you didn't say what your problem. try this to check whether given number is a Prime Number
Option Explicit
Public Function IsPrime(ByVal n As Long) As Boolean
Dim I As Long
IsPrime = False
If n <> 2 And (n And 1) = 0 Then Exit Function 'test if div 2
If n <> 3 And n Mod 3 = 0 Then Exit Function 'test if div 3
For I = 6 To Sqr(n) Step 6
If n Mod (I - 1) = 0 Then Exit Function
If n Mod (I + 1) = 0 Then Exit Function
Next I
IsPrime = True
End Function
