Dim strCnn As String
(Connection string )
strCnn = "Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=" & App.Path & "\WareHouse_Mai nt.mdb;Persist Security Info=False;Jet OLEDB:Database Password= raju"
(/Connection string )
Set cnn = New ADODB.Connectio n
cnn.Open strCnn
End Sub
rajaaryan44
Last Activity: Apr 8 '07, 09:43 PM
Joined: Mar 20 '07
Location:
-
. i wrote some codes in dao. i created a function : AddTableField
i m writing it in module so that it can be access from anywhere in the program
this is the code
...Code:. Sub AddTableField(ptdfTableDef As DAO.TableDef, pstrFieldName As String, pintDatatype As Integer, Optional pintSize As Integer, Optional pblnFixedLength As Boolean, Optional pblnAutoIncrement As Boolean, Optional pblnAllowZeroLength As Boolean, Optional
Leave a comment:
-
. i wrote some codes in dao. i created a function : AddTableField
i m writing it in module so that it can be access from anywhere in the program
this is the code
Sub AddTableField(p tdfTableDef As DAO.TableDef, pstrFieldName As String, pintDatatype As Integer, Optional pintSize As Integer, Optional pblnFixedLength As Boolean, Optional pblnAutoIncreme nt As Boolean, Optional pblnAllowZeroLe ngth As Boolean, Optional...Leave a comment:
-
Same problem of transfer of some access data to another access database
how can we transfer data from one access database to another databse . the table name is same for both the database . in one table some records are there (rs say e.g.) now another table has say rs+10 records . now i have to pass there 10 values to another table with same name . can anyone help me with this. i m usinf DAO
. i wrote some codes in dao. i created a function : AddTableField
i m writing it in module so that it can... -
Dim cnn As ADODB.Connectio n
Private Sub OpenConnection( )
Dim strCnn As String
strCnn = "Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=" & App.Path & "\WareHouse_Mai nt.mdb;Persist Security Info=False;Jet OLEDB:Database Password= raju"
' connection string
Set cnn = New ADODB.Connectio n
cnn.Open strCnn
End Sub
use this...Leave a comment:
-
i m not using sql statement i m using dao . i m not able to get the required fields in my table . please help me with that. i m able to get the table from other database with same name but the no data....Leave a comment:
-
text1 is the textbox just put this code in the textbox key press event . u will get the result
Private Sub Text1_KeyPress( Index As Integer, KeyAscii As Integer)
If Not ((KeyAscii >= 47 And KeyAscii <= 57) Or KeyAscii = 8) Then
Beep
KeyAscii = 0
Else
KeyAscii = Asc(UCase(Chr(K eyAscii)))
End If
End SubLeave a comment:
-
printing records
in my project i m using data environment to peint the records . but i cannot get the required print as i have to go and manuaaly set the printer settings . its very tiresome . .
i m using these codes to print the record
If Not lrs Is Nothing Then
lrs.Filter = "SrNo = '" & strId & "'"
' Bind the Recordset to the Report
Set Stock_Info.Data Source = lrs.DataSource... -
Data Transfer from one Access database to another
how can we transfer data from one access database to another databse . the table name is same for both the database . in one table some records are there (rs say e.g.) now another table has say rs+10 records . now i have to pass there 10 values to another table with same name . can anyone help me with this . can anyone tell me how to transfer records using codes . please -
Data Transfer from one Access database to another
how can we transfer data from one access database to another databse . the table name is same for both the database . in one table some records are there (rs say e.g.) now another table has say rs+10 records . now i have to pass there 10 values to another table with same name . can anyone help me with this -
Vb Data Import Export
i m using access2003 database for my Project. now i have to import data from another access database with the same table name. can any one please tell me how to import data from another access file using codes.please its urgent
No activity results to display
Leave a comment: