Prev: Closing Balance figure to be carried as Opening Balance in a new record
Next: Yes/No Field Size
From: Jeff Boyce on 27 Jan 2010 14:49
I always get those mixed up! Thanks, you're correct.

Jeff B.

"Volker Neurath" <neanderix(a)gmx.de> wrote in message
news:28f637-f03.ln1(a)ID-29596.user.individual.de...
> Jeff Boyce wrote:
>
>> Is your form's properties set to Allow Addition? If so, I'll guess that
>> the "record" you see is blank!
>
> Should i've been mistaken?
>
> Up to now I thought that this only occurs when DataEntry is set to True
>
> Volker
> --
> Im �brigen bin ich der Meinung, dass TCPA/TCG verhindert werden muss
>
> Wenn es vom Himmel Zitronen regnet, dann lerne, wie man Limonade macht


From: slh on 28 Jan 2010 10:30
John I'm new at this, on my properties for the form I have Yes for everything
except Data Entry No
Record Locks No locks
Allow filters No




"John W. Vinson" wrote:

> On Wed, 27 Jan 2010 07:35:01 -0800, slh <slh(a)discussions.microsoft.com> wrote:
>
> >I have created a form when I open it, it has 1 of 1 in the record navigator.
> >I want to be able to see 1 of however many records I have so I can use the
> >find key to update a record if needed.
>
> Correct the error in the form's design.
>
> If you would like help doing so, please post some information about the form -
> in particular, its Recordsource and Filter properties.
> --
>
> John W. Vinson [MVP]
> .
>
From: John W. Vinson on 28 Jan 2010 12:15
On Thu, 28 Jan 2010 07:30:16 -0800, slh <slh(a)discussions.microsoft.com> wrote:

>John I'm new at this, on my properties for the form I have Yes for everything
>except Data Entry No
>Record Locks No locks
>Allow filters No

Again:

What is the Recordsource of the form? (First line on the Data tab; if it's a
query or a SQL string please post the SQL).

What's the Filter?

--

John W. Vinson [MVP]
From: slh on 29 Jan 2010 12:40
I open the from from a switchboard that I created. I go to form RECCS it
opens blank 1 of 1 in the navigator, but i have 80 records in the table that
the form was created from. The table is names RECCS

Record Source: RECCS

"John W. Vinson" wrote:

> On Thu, 28 Jan 2010 07:30:16 -0800, slh <slh(a)discussions.microsoft.com> wrote:
>
> >John I'm new at this, on my properties for the form I have Yes for everything
> >except Data Entry No
> >Record Locks No locks
> >Allow filters No
>
> Again:
>
> What is the Recordsource of the form? (First line on the Data tab; if it's a
> query or a SQL string please post the SQL).
>
> What's the Filter?
>
> --
>
> John W. Vinson [MVP]
> .
>
From: Linq Adams via AccessMonster.com on 29 Jan 2010 13:24
Try this:

Private Sub Form_Load()
DoCmd.GoToRecord , , acNext
DoCmd.GoToRecord , , acFirst
End Sub

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201001/1

First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Closing Balance figure to be carried as Opening Balance in a new record
Next: Yes/No Field Size