Thanks, actually i will only be using access. I will have to pass a variable & based on that i will be executing a sql ... something like this ..
Private Sub TXTnameMASTER_Click()
Dim nn As String
Dim iAffected As Integer
nn = TXTnameMASTER
MsgBox (" selected " & nn)
CurrentDb.Execute...
Thanks, but I need a bit more clarification. If I create an mde file does & if I store the database on a shared drive then will a user be able to modify the tables directly?
Hi ,
I am developing an application for a friend. I can only use ACCESS 2000. Please note that the entire application will have to be built in access. Now I need to embed sql in the vb code window how I am unable to do so.
Please help