Who is So familiar with MS Access

[Lich]

hey anyone can help me

who is familiar with access.. need a urgent help

 

[nabil]

somewhat. did an olevel project

 

[nEoN_wHitE]

sorry dot come

 

[Lich]

somewhat. did an olevel project

ehema bae. poddak hodata danna ekek one. mata kela wela inne.. he he

 

[sriflipflop]

db ekak hadanna dha

 

[nabil]

ehema bae. poddak hodata danna ekek one. mata kela wela inne.. he he

machan oyage prashna tika demmanam danna kattiya thread ekema answer karai

 

[Tissaka]

samanayayen DB ekak hadanna dannawa.. :S not prof.

 

[Lich]

database eka hari. eka nemei me ewata link karagena podi case ekak hadaganna one.

 

[GTRZ]

conenct Access db from Visual Basic or from what?

If its from Visual Basic

Option Explicit
'declare global variable
Public cnnDb As New ADODB.Connection

Public varInvNo As Long

Sub Main()
'change into the project directory
ChDrive Left(App.Path, 2)
ChDir Mid(App.Path, 3)

'open the database
cnnDb.Open "Provider = Microsoft.Jet.OLEDB.3.51;" _
& "Data source = dbname.mdb"
MsgBox ("Connection is now open")

'load the main form
frmInvoicesView.Show 1

'close the database
cnnDb.Close
MsgBox ("Connection is now closed")

End Sub

 

[farshad]

know little
sorry bro

 

[Lich]

conenct Access db from Visual Basic or from what?

If its from Visual Basic

Option Explicit
'declare global variable
Public cnnDb As New ADODB.Connection

Public varInvNo As Long

Sub Main()
'change into the project directory
ChDrive Left(App.Path, 2)
ChDir Mid(App.Path, 3)

'open the database
cnnDb.Open "Provider = Microsoft.Jet.OLEDB.3.51;" _
& "Data source = dbname.mdb"
MsgBox ("Connection is now open")

'load the main form
frmInvoicesView.Show 1

'close the database
cnnDb.Close
MsgBox ("Connection is now closed")

End Sub

its not that link machan.. karanna one a whole system doing only using access. they ask some functions as well

 

[x-pert]

its not that link machan.. karanna one a whole system doing only using access. they ask some functions as well

Ithin SQL statesment tikak liyala daapan machang functions walata.

select <Field name> from <table name> etc. machang.

Try this site: http://www.w3schools.com/sql/sql_intro.asp

If you can tell what you want to do in simple english (I mean the functions) I can convert them into SQL.

But will take some time machang. Im in the office.

 

[romero2005]

wht do u want to do???

 

[Lich]

Ithin SQL statesment tikak liyala daapan machang functions walata.

select <Field name> from <table name> etc. machang.

Try this site: http://www.w3schools.com/sql/sql_intro.asp

If you can tell what you want to do in simple english (I mean the functions) I can convert them into SQL.

But will take some time machang. Im in the office.

k.. i think im stuck in this switchboard thing.. others are ok.. tawa case ekak date eken hadagannath one.. ekath karaganna one

 

[x-pert]

k.. i think im stuck in this switchboard thing.. others are ok.. tawa case ekak date eken hadagannath one.. ekath karaganna one

Check these out machang

http://www.eggheadcafe.com/software/aspnet/31469752/sql-server.aspx

http://www.tizag.com/sqlTutorial/sqldate.php

 

[Lich]

Check these out machang

http://www.eggheadcafe.com/software/aspnet/31469752/sql-server.aspx

http://www.tizag.com/sqlTutorial/sqldate.php

ela thanks macha

 

[Kalindugayan]

hmm

 

[Malinga]

k.. i think im stuck in this switchboard thing.. others are ok.. tawa case ekak date eken hadagannath one.. ekath karaganna one

switchboard eka gana honda vataheemak laba ganna puluvan oyata access vala thiyana example Project eka baluvahama.

 

[GTRZ]

its not that link machan.. karanna one a whole system doing only using access. they ask some functions as well

ehenam access eke help balapan oka ehemmama thiyanawa.
Umba help eke kali install kalla naththan install kara ganin.

 

[ereshthush]

no ideas