Manipulating Forms in Access 2000

[matethreat]

Hello All,

I am new to this forum and relatively new to Access as a programmer. SO, bare with me if my questions seem quite simple to begin with.

What I want my form to do:

1. When I open a form I want the record on that form to be a new record. Whenever I open it currently it displays pasts records, which I don't want it to do.

2. If it's possible I also want to eliminate the ability to scroll through past records gone. So, if I can eliminate the Record scroll bar at the bottom of the screen, that would solve my problems.

If anyone has any solutions they would be greatly appreciated.

Thank You

 

[kev747]

Welcome to the forum.
Hopefully you will be able to pass on hints and tips to other newcomers in the near future.

To open a form at a new record, enter this code into the OnOpen event for the form.

DoCmd.GoToRecord , , acNewRec


To remove the record navigation buttons, open the properties window for the form (View,Properties), then in the All tab, select NO for the Navigation Buttons.

Hope this helps.

Kev.

 

[striker83716]

Here is another method you can use. This method does not require you to write any code.
On the properties of the form set the following

Navigation Buttons = NO
Data Entry = YES

 

[matethreat]

I'm Sorry Guys, but I didn't clarify what version of Access I was using. Both your solutions look nice and simple but I don't have those options in Access 2000, so I am still lost.

 

[gusbrunston]

[tt]
Dear Matethreat(?)

Maybe I can help you locate those options in Access 2000.

Everything that was suggested by Kev and Stryker is available in A2K in the "property sheets".

To use Kev's suggestion:
Right click on the box in the upper left
hand corner of the form in design view.
Select "Properties"
Select "Events"
Click on the elipsis (...) of "On Open"
Enter "DoCmd.GoToRecord , , acNewRec"
Save and close the VBA code window(s).

To use Stryker's first suggestion:
As before, open the form property sheet.
Select "Format"
Set "Navigation Buttons" to "No"
Close the property sheet and save the form.

To use Stryker's second suggestion:
In the form property sheet
Select "Data"
Set "Data Entry" to "Yes"
Close the property sheet and save the form.

Once you locate the right box in the upper left hand corner to click on, you'll have no trouble.

Cheers,








[tt]Gus Brunston - Access2000(DAO Intermediate skills.
Webmaster: www.rentdex.com[/tt]

 

[ZmrAbdulla]

Hi,
Open your form in the design view.
Click on the small square box at the left hand upper corner wher the rulers join.(normally selected when open in the design view)
Open View Menu > Properties. This will bring property box of the form.
Slect the Data tab and change
Data Entry = YES

Regards


Zameer Abdulla

http://www.geocities.com/zameerabd/

http://www.mtkhoory.com