Actually im using ADO ODBC but im not good in ADO. Can u give the equivalent code of this in ADO...
Set rs = db.OpenRecordset("MyTable", dbOpenDynaset)
With rs
.FindFirst "Field1='" & Text1 & "'"
If Not .NoMatch then
my code goes here ...
Hi!,
Just asking how to edit records using ADO, im really not much of an ADO user. This is my first time practicing ADO i know how to add records but not Edit and Delete. Im using ADO ODBC!!!
Any help!!! Pls.....
[pc]
Set db = Opendatadase("Your Database")
Set rs = db.OpenRecordset("Select * From TableName Where
Field1='" & Datacombo.text & "'")
With rs
combobox.clear
Do
combobox.AddItem !Field2
.movenext
Loop Until .EOF...
Ok. If You're using DAO as your reference then here's the code.
1. Go to Project Reference and then Select Microsoft DAO 3.51
2. Open the Database and the Recordset......
If you are searching use dbOpenDynaset if adding records use dbOpenTable...
Assuming that you have a TextBox where you type...
Add a Data Environment and from there right click on the Connection and select Properties and find the path of your Database. Once connected, add a command and select what table you want to display or just use an SQL.
From your DataReport set the datasource to DataEnvironment1 and then the Data...
There are two types of embedding a sound in your application, the first one is by using API function and the other one is using OLE.
Try this....
Public Declare Function sndPlaySoundA lib "winmm.dll" (ByVal lpszSoundName as String, ByVal uFlags as Long) as Long
Private Sub...
Hi!
MSAccess 2000 is not recognizable when you are using DAO as your reference. Try to use ADO... i guess these will solve your problem.
Try to download some Service Pack. OK[bigsmile]
Are you using DAO?
Try This....
Set rs = db.OpenRecordset("TableName",dbOpenDynaset)
With rs
DTPicker1.Value = !fldBeginDate
End With
rs.Close
Set rs=Nothing
Note:
If you are trying to find a specific Date to load to the DatePicker Control... Try to query before loading...
Hi! [hammer]
Sorry im new in crystal report... anyway i tried to put the summary (total count of PC in every branch) in report footer but its not working. Its a summary of all pc in every branches grouped into department.
How do i do that? HELP! [pc]
Regards,
Arnel
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.