Access 2000 - Hidden record counter and open to new record

[Kostika]

Basic DB. Nothing fancy. Got two questions.

First, is there a way to automatically have the DB open to a new
record?

Second, is there a way to hide the Records listing that shows at the
bottom left corner of the form?

THanks

~Kostika

 

[Van T. Dinh]

Database is a container so it has Tables, Queries, Forms, Reports, etc ...
and it doesn't have Records. Only Tables do or Forms that are bound to
Tables. If you are talking abound the bound StartUp Form, you can use:

DoCmd.GoToRecord , , acNewRec

in the Form_Open Event to make the NewRecord the current Record.

To remove the Navigation Bar from the Form, set the Navigation Buttons to
No/False in the design of the Form.

 

[Kostika]

I meant Form. And tables don't have records, Forms do. I found a much
easier way to do what you just mentioned below though.

So much for that MVP.

~Kos

 

[Van T. Dinh]

You obviously haven't heard of unbound Forms?

What do you think Tables have? Perhaps, you need to read an *introductory*
Access book.

 

[Stephen Lebans]

Prove it Kostika. What is your much easier method than:

DoCmd.GoToRecord , , acNewRec
and
Turning off the NavigationButtons property.


This I gotta see...
--

Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Kostika]

Easy. Use the macro builder to create a macro that does open new
record. Then put it in the On Open for the form's properties.

Much easier than screwing with VB script.

And I did what you had suggested for the nav buttons. I jsut figured
it out myself before I got a response to my post.

~Kos