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

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.

--
HTH
Van T. Dinh
MVP (Access)



"Kostika" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message news:<(E-Mail Removed)>...
> 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.
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "Kostika" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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

You obviously haven't heard of unbound Forms?

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

--
HTH
Van T. Dinh
MVP (Access)



"Kostika" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in
message news:<(E-Mail Removed)>...
> > 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.
> >
> > --
> > HTH
> > Van T. Dinh
> > MVP (Access)
> >
> >
> >
> > "Kostika" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > 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

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

"Stephen Lebans" <ForEmailGotoMy.WebSite.-(E-Mail Removed)> wrote in message news:<uXw$s#(E-Mail Removed)>...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in
> message news:<(E-Mail Removed)>...
> > > 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.
> > >
> > > --
> > > HTH
> > > Van T. Dinh
> > > MVP (Access)
> > >
> > >
> > >
> > > "Kostika" <(E-Mail Removed)> wrote in message
> > > news:(E-Mail Removed)...
> > > > 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