PDA

View Full Version : help in entry in excel access



pachchigar
07-01-2009, 12:33 AM
Please guide me how to connect &
add entry in local network

Bob Phillips
07-01-2009, 12:53 AM
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
07-01-2009, 12:56 AM
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
07-01-2009, 03:50 AM
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
07-10-2009, 04:43 AM
Can u give me Full code ?