help in entry in excel access

[pachchigar]

Please guide me how to connect &
add entry in local network

[Bob Phillips]

I think that you need more detail, a lot more detail, as to what your app is supposed to do, what it does,a nd what problems that you have.

[pachchigar]

i have two & more computer in use this application
i don't any entry in other computer
i want to use database in only one computer & use application in many computers

[slamet Harto]

Hi Pachigar,

I think you need to setting up or create a table for user log and create password your master database for security reason.

I've tested your code and working fine.
Just look at your query for :
sSQL = "SELECT QtyReceived.KapanNo, QtyReceived.date, QtyReceived.time, QtyReceived.User " & _
"FROM QtyReceived " & _
"ORDER BY QtyReceived.Date, QtyReceived.Time;"

this is a moodest way if you want to show all database in your table

sSQL = "SELECT * FROM QtyReceived " & _
"ORDER BY QtyReceived.Date, QtyReceived.Time;"

Hope its help,
Rgds, Harto

[pachchigar]

Can u give me Full code ?