Access Noob needs help

[goosegoose35]

Hello. A little BG info: im great with all programs but I am new to access. I do not have much VBA skills either. Other than that I am very computer literate.



so any ways, I have am tasked with creating a database at work. I have the database all set for now, however I have the following issue that I would like to resolve:

the primary input is a form with the following fields:

EIN
SSN
Program 1
Program 2
Entered By
EOR First Name
EOR Last Name
Support Ticket
Issue
Date Received
Date Complete
Participant or Non-Participant
Comment

Now i need the Issue, and Date Complete, and comment to be able to be edited when necessary but every other field I would like to lock after data is entered. How can I go about doing this?

The database is split so I am not worried about changes made to the tables, I just need specific fields on the form to not be editable.

I do not know where to enter VBA codes so if that is a solution I need step by step how to enter everything. Thanks.

[Robeen]

You can have one form for the initial Data Entry - with all the fields included in the Form.

Then you can create a separate Form that only shows the fields that you want to allow editing on.

Or - you can show all the fields on the Editing Form- but disable [in properties set Enabled to 'No'] the fields that you don't want any editing done with.

Hope this helps.

[goosegoose35]

i did not even think of that, i did the two forms. That gets the job done for now. Thanks so much!

[Robeen]

Glad I could help!

[goosegoose35]

One more issue I just came across. The linked tables are hidden, but once they are un-hidden, any user can just edit any of the information via the table. How can i make it so they can view the table but not edit it from the front end file? Thanks again in advance.

[Robeen]

I may not have a good answer for you on this one I'm afraid.

Sorry!!!

I think you should start a new thread so that there are more people looking at your request.

All the best!

[Amicron]

Goose, keeping users from messing around with your tables is not easy. In fact, I teach a whole seminar JUST on security for Access databases: http://599cd.com/XSS8ZA

A simple solution: you can keep the CASUAL user (who doesn't know much Access) out of your tables by HIDING the navigation pane. An EXPERIENCED Access user will know how to get around that, but it's "good enough" for the normal users in your office who don't know a lot about Access.

Go into File > Access Options. In the Current Database section look for "Display Navigation Pane." Turn that off. BEFORE you do that, however, you'll want to make sure you specify a startup form (the Display Form property above that). I like to create a MAIN MENU form that has buttons to open other forms. I cover all of this in my Access tutorials.

Oh, and in case you goof up and accidentally hide the navigation pane without specifying a startup form, just hold down the SHIFT key when you start your database. It will bypass all of the startup options... but don't tell the other people in your office that.