Freeze Form

EL-g · Jul 14, 2006

Hey Guys,

Well i have a table with 39 observations. I made a form that updates the data of thid table. So the next values would be the observation number 40. What i wanted to do i that my form only showed the field that is not filled up, in this case would be the 40. Its like the form shows the 40 observation in blank and lets me fill up. After i fill it up it should only show me the 41 and so forth. And also block all the previous form editing.

Can anyone help

Thanks a lot

Kind regards

RuralGuy · Jul 14, 2006

Have you tried turning on the DataEntry property?

EL-g · Jul 14, 2006

Hey RuralGuy, well the data is fine. The thing is that to fill up the last row, which is number 40 i have to go through all the previous 39. So the idea was that all the 39 before were frozen

Thanks

EL-g · Jul 17, 2006

Can anyone please help me out here.

Thanks for all the help guys

RuralGuy · Jul 17, 2006

Again.

Have you tried turning on the DataEntry property?

It is on the Data tab of the properties sheet for the form.

EL-g · Jul 17, 2006

RuralGuy said:
Again.
It is on the Data tab of the properties sheet for the form.

Oh cool. In the Locked part right. Is there anyway i can lock all my sheets at once?

Thanks a lot for all the help Rural guy

RuralGuy · Jul 17, 2006

It is *not* "in the Locked part" but set Allow Edits to No and see what happens.

EL-g · Jul 17, 2006

RuralGuy said:
It is *not* "in the Locked part" but set Allow Edits to No and see what happens.

WOW!!!!!!!!!!!!!! Damn Ruralguy.........you ROCK!!!!!!!!!!!!!!!!!!!!!! Thanks a lot

Just one more thing. How can i make my form apear on the after the last data i have, in the new additions screen, and also how to make it accept my changes with a pop up screen asking accept addition "yes" or "no". And another thing, after i putted no to edit i cannot access the properties anymore. Do u know why?

Thanks a lot again

RuralGuy · Jul 17, 2006

Maybe if you post your zipped up db, it would be easier to offer suggestions.

EL-g · Jul 17, 2006

RuralGuy said:
Maybe if you post your zipped up db, it would be easier to offer suggestions.

OK. I upped the zip. Please take a look. I also have a few query questions that have been killing me for the past few weeks. MAybe you can help me out. Please check those links:
http://www.access-programmers.co.uk/forums/showthread.php?t=111002
http://www.access-programmers.co.uk/forums/showthread.php?t=111105
http://www.access-programmers.co.uk/forums/showthread.php?t=100019

Thanks in advance for all the help........you rock!!!!!!!!!!

And inside the zip there is the excel i have to do¨In Access!!!!!!!!!!

RuralGuy · Jul 17, 2006

And another thing, after i putted no to edit i cannot access the properties anymore. Do u know why?

By this do you mean that you can no longer *edit* any of the controls on the form? That is expected behavior for that property setting.

Just one more thing. How can i make my form apear on the after the last data i have, in the new additions screen,

Does the attachment function as you suggest in this quote?

EL-g · Jul 17, 2006

RuralGuy said:
By this do you mean that you can no longer *edit* any of the controls on the form? That is expected behavior for that property setting.
Does the attachment function as you suggest in this quote?

Hey Rural guy. the attachment does not work like that. It starts at the 1st of 39. SO when i want to add another valeu i vale to go one by one or press the>*. What i wanted was instead of it that the form would appear already in the 40th observation

Kind Regards

Banana · Jul 17, 2006

Is an observation a record? If so, in the Open Event of the form, run this code

Code:

DoCmd.RunCommand acCmdRecordsGoToNew

EL-g · Jul 18, 2006

EL-g said:
Hey Rural guy. the attachment does not work like that. It starts at the 1st of 39. SO when i want to add another valeu i vale to go one by one or press the>*. What i wanted was instead of it that the form would appear already in the 40th observation

Kind Regards

Oh Sorry rural guy. Just saw your attachment now. It works perfect!!!!!!!!!!! Many thanks!!!!!!!! By the way, what did you do to make it like that?

Thanks a lot for all the help guys

RuralGuy · Jul 18, 2006

I probably just set the DataEntry property to Yes.

EL-g · Jul 18, 2006

RuralGuy said:
I probably just set the DataEntry property to Yes.

Man im so noob. Can you tell me please the step by step way to make it?

Thanks again!!!!!!!!!

Banana · Jul 18, 2006

In form's design view, get properties window open (by right clicking on the form), click on the data tab. Data Entry is just under the four "Allow ..." lines

HTH.

EL-g · Jul 18, 2006

Banana said:
In form's design view, get properties window open (by right clicking on the form), click on the data tab. Data Entry is just under the four "Allow ..." lines

HTH.

That was awesome. Thanks for the tip. It is all i needed. Btw, if you could help me out one the queries i'd be more than gratefull to you. My brain is almost stopping now. Ive tried so hard to find out this things and havent came to any conclusions.

Thanks 4 all the help Banana. You really ROCK!!!!!!!!!!

Freeze Form

Registered User.

AWF VIP

Registered User.

Registered User.

AWF VIP

Registered User.

AWF VIP

Registered User.

AWF VIP

Registered User.

Attachments

AWF VIP

Attachments

Registered User.

split with a cherry atop.

Registered User.

AWF VIP

Registered User.

split with a cherry atop.

Registered User.

Similar threads

Users who are viewing this thread