Adding, or changing a record with an Input Form.

[boblarson]

While in design view, I followed Bob Lawson's

That is LaRson, not LaWson.

Hope someone can help.

See my last post as I suggested uploading the database instead of screenshots.

 

[jcraw42]

Bob Larson (Sorry for the mix up):

If I up load my DB (which is 93mb), it may contain certain sensitive data on students that I cannot or do not want to get out.

So I may have to get some type of OK from the Administrators. I need to safegard myself. I am an outside Consultant, specializing in Network Administration, and Help Desk Support, and Web Site Development. I am just getting into MS Access.

In fact, I brought the Book, Access 2007, Step-By-Step. Is that any good, Bob?

And my boss is out on Jury duty. So, it will have to be next week.

Thanks for the option.

 

[boblarson]

I have a tool that I can upload for you (next Monday when I'm in the office) that will scramble the data so it isn't personally identifiable. I would suggest making a copy of your database and then running that tool on the fields that have identifiable information in it (addresses, names) and then you should be okay.

 

[jcraw42]

I split the data base with the Front End residing on my Desktop, and the Back End on my Server. So there will be two parts.

I may have a copy of the total data base before I made the split.

How should me do this?

 

[boblarson]

How should me do this?

You can upload (or send) both parts.

The scrambler is actually here:

http://www.access-programmers.co.uk/forums/showpost.php?p=899338&postcount=19

And I can PM you an email to send it to if you want (if it winds up being too large).

 

[jcraw42]

Good Morning Good People:

I am happy to inform you that I have solved my Access Database problems - for the time being.

I was able to add a new record (Teacher) via the "All Data Objects" and clicking on the record or Form pertaining to what I wanted to accomplish.

Thanks for your help Bob Larson.

I am sure I will run into other problems, so just the thought process and communications between an expert and a novice, spurrs the creative process.

Please feel free to close out this POST.

jcraw42

 

[boblarson]

Glad to hear you got things working the way you wanted.