Predifined text and starting from the last record(in a form)

M

marko

I don't know how to form my question but this is my problem:
I would like to fill out a form containing let's say 3 fields and then
when i go to the next record. Now the next record would be blank except
the last field wich would have the value of that same field from the
last record. How can i do that?
And when i start a form i would like to start if from the last
record(>* not the last but from a new,that would be the one after the
last which has values) not the first. How?
Thanks,

Marko
 
T

Tom Wickerath

Hi Marko,

For the answer to your first question, see the following KB article:

How to fill record with data from previous record automatically in Access 2000
http://support.microsoft.com/?id=210236

Note: The directions in this article should work equally well for Access
2002 or 2003.

I do not understand what you are asking in the second part of your question.
Can you try re-phrasing it?


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I don't know how to form my question but this is my problem:
I would like to fill out a form containing let's say 3 fields and then
when i go to the next record. Now the next record would be blank except
the last field wich would have the value of that same field from the
last record. How can i do that?
And when i start a form i would like to start if from the last
record(>* not the last but from a new,that would be the one after the
last which has values) not the first. How?
Thanks,

Marko
 
M

marko

Thanks for the first answer.
I'll try rephrasing but my english is bad so... :((
When i open a form it always starts at the first record. In my database
i have 100 records and when i open my form i would like it to start at
the 101. record. That would be a new one. Can you help me now?
Thanks again!

Marko
 
M

marko

Hey! I can see that you are familliar with access so I'll ask you one
more easy question(but for me a mistery) and i would be very happy i
you could help me!
So here it goes: I have two tables, one main containing ID(primary
key),brand,model,colour,price and one containing
AutoNum(autonumber),ID(linked with the ID in the main table) and
Quantity.
So I have a Main andI I/O (input output) table.
I have a form in wich i write ID and quantity. So my question to you is
how can i see the Brand,Model and Colour when i write the ID? I would
like to write the ID in a form and i would like the Brand,Model... to
be displayed automaticly somewhere on the form.Just so i can now what
is ID:0001.
Thanks,

Marko
 
T

Tom Wickerath

Hi Marko,

Much easier to understand this time. Open the form in design view. Click on
View > Properties to display the properties dialog, if it is not already
displayed. (In Access 2002 and later, you can use the F4 key as well). Make
sure that the word "Form" is displayed in the blue title bar of the
properties dialog. Select the Data tab. Set the Data Entry option to Yes.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Thanks for the first answer.
I'll try rephrasing but my english is bad so... :((
When i open a form it always starts at the first record. In my database
i have 100 records and when i open my form i would like it to start at
the 101. record. That would be a new one. Can you help me now?
Thanks again!

Marko
 
T

Tom Wickerath

Hi Marko,

You really *should* post a new question. This one is not even remotely
related to your original question. It's almost 3:00 AM where I live, and hey,
I need to get to sleep. But there are plenty of other experts out there who
are likely to take notice of your question if you repost it.

That being said, do you really want to design a form where you have to enter
a known ID number? How are you going to keep track of potentially hundreds
of ID numbers? Try searching your hard drive for a file named "Northwind.mdb"
(without the quotes, of course). Open the Orders form. Navigate to a new
record. When you select a customer by name (not by ID number), note that
several fields fill in automatically. Also, when you select product in the
subform, the unitprice field is automatically populated. (Other fields are
automatically populated as well). Is this the type of functionality that you
are trying to achieve?

My recommendation is to make a copy of Northwind, and then pick it apart
with reverse-engineering to see how it works.

I'm going off-line now.....Zzzzzzzzz

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Hey! I can see that you are familliar with access so I'll ask you one
more easy question(but for me a mistery) and i would be very happy i
you could help me!
So here it goes: I have two tables, one main containing ID(primary
key),brand,model,colour,price and one containing
AutoNum(autonumber),ID(linked with the ID in the main table) and
Quantity.
So I have a Main andI I/O (input output) table.
I have a form in wich i write ID and quantity. So my question to you is
how can i see the Brand,Model and Colour when i write the ID? I would
like to write the ID in a form and i would like the Brand,Model... to
be displayed automaticly somewhere on the form.Just so i can now what
is ID:0001.
Thanks,

Marko
 
Top