Help with ALOT!

[Grafixx01]

Ok, I'm a little rusty with the Access program. But i'm trying to create a database to track documents with a login screen for users to enter their user name and password, then this would check it against a table but also enter it into the form where the user enters in all the tracking information. **this user name that is entered into the ORIGINAL FORM must not be able to be changed.**

Then I'm trying to make it so that these documents are added into a table but each time they click on "Create a New Tracking Document" it would automatically generate a new document with a number ID one higher than the previous one. Then they click "save" and it would then save all the data back into the original "documetn" table.

Could someone help me with this so I can get started on it. Because I found this forum and hope that I can learn a lot along with asking a bunch of questions, with getting answers.

Thank you,

G

 

[The_Doc_Man]

First, you need to understand that your design is not at all impossible but it is tedious. This place typically gives you short answers. I'll point you in a couple of directions.

Second, the search function on the forum's tool bar works great for specific questions that have already been answer - which by now run into the tens of thousands, pushing into the hundreds of thousands.

OK, now that we have dealt with that...

Login screens: Look at WorkGroup security rather than re-inventing the wheel. Once you let Access do the login, the CurrentUser function tells you who just logged in. You never need to know the password yourself anyway.

Not change username? The CurrentUser function is one-way. Read. No write.

Add document by clicking a button? Use the button wizard. There's a function for "new record".

Separate "save" button? Another button wizard option.

As to table design, you need to decide what you need to keep, based on this rule: No database can give you anything you didn't give it first. I.e. if you want to track the number of left-handed veeblefetzer drawings, you need a field that says "Left Handed Veeblefetzers." (Righties need not apply.)

If you are so rusty as to not already know these things, get yourself a cheapie book like Access for Dummies or one of the myriad other self-help books. Many of them are designed on a case-study basis, which would surely help you think about your problem better. Once you develop some ideas, come back and bounce them off the forum. I don't show up that often right now due to extenuating circumstances, but lots of other folks are here, eager to help give back what they got here when they were also newbies to Access.