Normalizating a giant table

[umair434]

hey! so I was just playing with the database and I came across one thing.
(i'm attaching the database here)
In frmemployees - when I click "Add record" the first name and last name disappears. how do I prevent that?


the employees will be entering multiple data in a day - Currently if an employee logs on to the computer today, he will be able to see the his activities and other information for yesterday as well.. how do I hide that?

so basically, an ideal situation would be that whenever the user presses the "Add record" button, the record is saved in Query1 - and it disappears from the datasheet view - Sorry for confusing you =/

thank youu!! you have been of great support. Live Long and Prosper

 

[jzwp22]

You placed the add new record on the main form, so you are creating a record for a new employee, so Access moves to a new blank record. If you want to add a new activity, you can do that through the * button in the lower part of the frame of the SUBFORM. To place a button on the subform you will have to switch the subform from datasheet view (that shows each record in a row) to form view (1 record at a time).

 

[umair434]

Yeah that's what I thought, but in my database the "form view" is not clickable for the subform!!

I right clicked on the subform and it's only showing "datasheet" view only :S

 

[jzwp22]

You can change the property to single form view (go to the property sheet of the form-->Format tab-->Allow form view (change to yes) and then change Allow Datasheet View to No)

 

[umair434]

Yeah that works for the main form but not for the subform! those properties don't even show up in the format tab

You can see this problem in the database i attached as well - i don't know what it is

 

[jzwp22]

If you are accessing the subform from the main form while in design view, you have to click the upper left hand corner of the subform (not just the frame of the subform). A black square within the lighter colored square should show up if you have done it properly. Then you should be able to access the form property sheet.

 

[umair434]

I think I didn't word my problem properly. sorry about that.

i can access the property sheet (for both the form and the subform). but I don't see an option of "-->Allow form view (change to yes) and then change Allow Datasheet View to No) " in the subform.

I only see this option in the main form.

An other option: right click on the form -> subform > Datasheet view only (Other views are not clickable).

hope I'm making some sense.

 

[jzwp22]

Can you open the subform directly in design view (not through the main form)?

What version of Access are you using?

It should be on the format tab of the property sheet. Look also for the Default View property as well and change that to Single Form.

 

[umair434]

I cannot open it directly. I can open it through the main form.

Using Access 2007 - And I changed the property to "Single form", but still nothing works. Is it possible for you to look at the attached database (which I attached before) and see what could be the issue?

can't thank you enough!

 

[jzwp22]

The modified DB is attached. I had to change the default view as well.

 

[umair434]

oh i figured what i was doing wrong.. I was changing default view by going through the main form .. It works when I access the main form via the subform - if that makes any sense..

appreciate the patience!

 

[jzwp22]

I'm glad you got it worked out. Good luck with your project.