Hide database from form entry users 5

[frog40]

I would like to hide the database from the users who enter data into the form. The form updates the table, and I do not want the user to be able to see records. I use GoTo next record, but before any entry is made, the user has the option of looking at the database. How do I hide this option?

 

[TheAceMan1]

How are ya frog40 . . .

Be more specific! . . .

See Ya! . . . . . .

 

[PHV]

Set the DataEntry property to True.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[frog40]

I am trying to set up a "sign-in" system on a pc screen. I do not want any new signers to see any part of the table. When I use a "form", the records automatically show at the bottom so that anybody can go from record to record to view them. I am a novice at VBA. Will hiding the tool bars and scroll bars eliminate this part of the "Forms" screen? When I used "tabs", I could still see the access to the records.

 

[IGPCS]

if you meant that you dont want the users to get access to the acctual tables so here is what i do

i create a MS ACCESS files that have all the tables i then link them to a different Access file and hide them + in the startup properties i uncheck the box where it says show database window

with the table where i have all the data i change the extension of the file after i linked them to my own made up extensio for example *.pcs then i goto to database mangement and i relink them to file with this extension

hope you understand what i wrote here

and if you need help with the workgroups and user permission please reply here so i will try to help you with that too

have a great day

 

[IGPCS]

i am sorry you dont need to create to databases thats only if you want i do it usually because when i update a form for 1 of my customers i dont need he should email me the whole database so i ask him to send me only the forms file

but you can still hide the database window by going into the menu tools, startup... and in the popup you will see the show database window

 

[TheAceMan1]

To All! . . .

[purple]Someone gave a pinky to the wrong person! . . .[/purple]

See Ya! . . . . . .

 

[abaldwin]

Dadgumm.....got a star for asking for more info. WAY TO GO!!!!!!!!

LOL


Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[missinglinq]

Sometimes the question's more important than the answer!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[JoeAtWork]

So I just gave ICGPS a star. Makes me feel useful around here.

 

[IGPCS]

thanks joeatwork but why is that so?

 

[frog40]

Thank you PHV. Your tip worked perfectly (set the Data Entry property to True).

I also went to Tools>StartUp and unchecked the Show Database Window, but this did not work. Don't know if I did something wrong or not.

I also need to hide the Command Bars and the ToolBars. I went to Code>Form>Delete, then entered the command to delete the CommandBars. This did not work. Am I in the wrong place to begin with? (Code>Form>Delete). I took the command to delete from the text book, but it does not tell me exactly where to start. I am making some progress using VBA, but unfortunately for me it is slow. Thanks for any help.

 

[snayjay]

After reading your second post I think I know what you are talking about (If I missed someone else answering your question I'm sorry.) Try this:

While in Design View of the Form... view form properties and ensure the Navigation Buttons value is set to 'No'. You can change this value on the Format tab and the All tab. That gets rid of those buttons on the bottom of your form, which is what I thought you were asking from your second post.

 

[fneily]

I also went to Tools>StartUp and unchecked the Show Database Window, but this did not work. Don't know if I did something wrong or not." It will not take effect until you totally close the database and reopen.

 

[IGPCS]

if you uncheck that you will need to close the database and reopen it but once you reopen it, it will only show you the form that you chose the database to open with and to reshow the databae window just press F11 and it wont disapear untill the next time you reopen the database but it shouldnt show it the next time

 

[frog40]

Thanks snayjay. It works great. How about a back door so I can get to the codes without disturbing the form?

 

[snayjay]

Well I'm not sure why you would want to do that... I'm assuming you aren't going to make this project into an .MDE but keep it as an .MDB. If that's the case, it's near impossible to keep people from the code... there's almost always a way to it. The only way I know of to keep users from the code is to make the file an .MDE. But then you can't get to the code either and therefore must make a way to make changable options prior to making an .MDE.

I have a sign-in program I made that allows the users to create 'visit' options on the fly, it also has reports and a custom coloring option. You are more than welcome to have it. It's an .MDB, feel free to change anything you want about it. Email me at snayjay@yahoo.com if you want it.