input form on sql server

[diegomarino]

hi


i need to create a form just for data input that i want to distribute to the employee of the company.
the form should input values in the sql server, without let employee see tables. How can i do?

[ranman256]

make the form that connects to the linked sql table
hide the table (property)

make a macro called autoexec. this will run code at db open
1.hide the db when it opens,
2. then show the input form.

runcode HideDB()
openform "myForm"

in vbe, insert a module, and add this code.....

Public Function HideDB()
    DoCmd.SelectObject acTable, , True
    DoCmd.RunCommand acCmdWindowHide
End Function

[diegomarino]

whoa, so rapid. thx, when i go to the company i'll try it, it seems easy
your help il precious and appreciated, thx very much

i have a few question:

1) i have first to create the form on a new database, and i have to link the form to the specific sql table, is it right? i'm not sure how to do that, is it through the ODBC database in "external data"?
2) i already made some macro, but how can make this macro?

runcode HideDB()
openform "myForm"

3) how can i insert the vba code? or better, where?

sorry i'm not so advanced...

make the form that connects to the linked sql table
hide the table (property)

make a macro called autoexec. this will run code at db open
1.hide the db when it opens,
2. then how the input form.

in vbe, insert a module, and add this code.....

Public Function HideDB()
    DoCmd.SelectObject acTable, , True
    DoCmd.RunCommand acCmdWindowHide
End Function

[ranman256]

click the External data tab, ODBC databases, pick your server/user/password
it shows as a table,
connect form to the table,
hide everything but the form.

[diegomarino]

click the External data tab, ODBC databases, pick your server/user/password
it shows as a table,
connect form to the table,
hide everything but the form.

thx very much, i do not want to ask too much, i have just few doubts.

1) if i hide a table, employees could see it if they go to the "custom view" on navigation panel, isn't it?
2) may i create a form that do not displays values, but only input?
3) i have then to create a package? or i have just to give the files to the employess?

[ranman256]

if you hide the table, AND hide the db, users cannot see anything.
The avg user wont even want to look at the table, or try to figure out how to see the table.

[diegomarino]

if you hide the table, AND hide the db, users cannot see anything.
The avg user wont even want to look at the table, or try to figure out how to see the table.

great, so this is the procedure.

1) open a new database
2) create a form i want to use
3) connect to the sql server using the ODBC DATABASE, and link the form to the table and hide everything except the form
4) i make the macro you wrote before
5) i give the file to employees... or the package? what is better.

sorry to bother u, but i really need this info