record name

S

Srenfro

Is there a way to get a record to repeat itself through out the data base?

Example Records that change

Field Names l
to stay the same l
l \/
\/
Contract # 1526826
Customer type walk in

they are unbound boxes that i have bounded to a table and i have several
records that i need to repeat themselves do you have any ideas

Thank you

Stephen
 
J

John W. Vinson

Is there a way to get a record to repeat itself through out the data base?

Example Records that change

Field Names l
to stay the same l
l \/
\/
Contract # 1526826
Customer type walk in

they are unbound boxes that i have bounded to a table and i have several
records that i need to repeat themselves do you have any ideas
Click to expand...

Sorry... "unbound boxes that I have bounded to a table" makes no sense. It's
bound, or it's unbound!

What is the structure of your table?
What are the current contents of your table?
What do you want those contents changed to?

John W. Vinson [MVP]
 
S

Srenfro

Ok the two collumns i have are titles and the other is records, but they are
bolth on the same table and i want the titles on my data base to stay the
same and the records to change. when i go to add a new contract\record bolth
the titles and the records disapear is there a way to keep the collumns from
doing this and still have the ability to change and add records?

is there a way for me send a picture through this screen to show you if you
do not understand what i am asking

Thank you

Stephen
 
J

John W. Vinson

Ok the two collumns i have are titles and the other is records, but they are
bolth on the same table and i want the titles on my data base to stay the
same and the records to change. when i go to add a new contract\record bolth
the titles and the records disapear is there a way to keep the collumns from
doing this and still have the ability to change and add records?

is there a way for me send a picture through this screen to show you if you
do not understand what i am asking
Click to expand...

I'm totally and completely baffled. You want some fields in your table to stay
the same (normally all fields stay the same unless you intentionally edit
them) and other fields to change value as you move from record to record?

I'd prefer not to get binaries over the net except from consulting customers.
Could you instead post a field description of your table? Open the table in
design view and post the table name; the name and datatype of each field in
the table; a brief description of the real-world significance of that field;
and describe how you're looking at the table data and what you want to see.

John W. Vinson [MVP]
 
S

Srenfro

I'm totally and completely baffled. You want some fields in your table to stay
the same (normally all fields stay the same unless you intentionally edit
them) and other fields to change value as you move from record to record?
Click to expand...

Ok i have a form just for adding contracts this is the one i am working on
ok and i have two rows of information

row one row two
Titles for form Contract information

I want row one to stay the same i dont want to add anything to to it

I want row two to take the information i put in it and add it as a contract

row two works great but row one wants to be row two it changes to a blank
box and this only happens when i want to add a new contract and i dont want
that to happen i want row one to stay the same

bolth row one and row two are in my table but i want to make row two freeze
or just not except any information and if it does get information i want it
to go over the information that was there before i changed it

does this help u understand

still baffled because i am

Thank you

Stephen
 
J

John W. Vinson

I'm totally and completely baffled. You want some fields in your table to stay

Ok i have a form just for adding contracts this is the one i am working on
ok and i have two rows of information

row one row two
Titles for form Contract information

I want row one to stay the same i dont want to add anything to to it

I want row two to take the information i put in it and add it as a contract

row two works great but row one wants to be row two it changes to a blank
box and this only happens when i want to add a new contract and i dont want
that to happen i want row one to stay the same

bolth row one and row two are in my table but i want to make row two freeze
or just not except any information and if it does get information i want it
to go over the information that was there before i changed it

does this help u understand

still baffled because i am
Click to expand...

It appears that you are misunderstanding how relational database tables work.
What you're describing might make sense in a Spreadsheet, but Access is NOT a
spreadsheet!

Each Record or Row consists of Fields. Each field should contain a specific
kind of information - an "attribute" of the "entity" represented by the table.
Every row should have the same "shape" - the first field of every row should
be (say) a unique identifier for that row, the second field of every row
should be the title of the contract, etc. If you're using two different kinds
of information in two rows of the same table, you're making a mistake!

If you want titles or labels, don't store them in your table; instead put
Label controls on the Form (use a Continuous Form rather than a Datasheet for
flexibility; you can put labels in the form Header).

John W. Vinson [MVP]
 
S

Srenfro

then is it possable to just make the record repeat itself over and over again
instead of being blank because i dont give the option to change the titles i
locked that option but they still go blank so even if i could just repeat
record over and over again then i would be solving my problem also because i
have a total of 76 fields i guess you call them fields because fields are the
titles of the records right well i want 38 of these fields to not change at
all i want them locked or what ever looped repeated which ever is more
correct but i want 38 of them to always have the same records.

Now the other 38 of the 76 i want them to change but only when i want to add
a new contract and this option works great:)

I also thought can you use more than one record source because if i can use
more than one than i could use a table for 38 of the fields and a queary for
the other 38 does this sound right and is there a way to do it

Stephen
 
J

John W. Vinson

then is it possable to just make the record repeat itself over and over again
instead of being blank because i dont give the option to change the titles i
locked that option but they still go blank so even if i could just repeat
record over and over again then i would be solving my problem also because i
have a total of 76 fields i guess you call them fields because fields are the
titles of the records right well i want 38 of these fields to not change at
all i want them locked or what ever looped repeated which ever is more
correct but i want 38 of them to always have the same records.

Now the other 38 of the 76 i want them to change but only when i want to add
a new contract and this option works great:)

I also thought can you use more than one record source because if i can use
more than one than i could use a table for 38 of the fields and a queary for
the other 38 does this sound right and is there a way to do it
Click to expand...

I'm sorry, srenfro, you've got me totally baffled. I simply cannot make sense
of what you're doing, other than that it appears to be an absolute misuse of
Access! A 76 field table is EXTREMELY wide; 30 is about the maximum number of
fields you would find in a properly normalized table. Having even one field -
not to mention 38 - repeating so that it occurs in every record in a table is
VERY bad design and should never be necessary.

What do you mean by "title"? Again: please do what I asked:

Open the table in
design view and post the table name; the name and datatype of each field in
the table; a brief description of the real-world significance of that field;
and describe how you're looking at the table data and what you want to see.


John W. Vinson [MVP]
 
S

Srenfro

ok john i might be using terminology wrong here and that might be whats wrong
ok

i will explain what the data base is about and what every thing is

first the data base is made so it can be universal amoung this companey
because they think they are going to switch from construction to like a
public storage or mabey even a towtruck yard, but anyways i made the titles
that tell you what the blank box next to them are about i made them unbound
boxes and there controle source or record source is the main table i have 76
collumns in my table going left to right on the top of my table and i have
one row at the moment going down.

When you enter a record in the data base i want only 38 of the records to
change because they have the option to and the other 38 to stay the same or
repeat or just make it a one row accross but only for the 38 collumns i have
.. now this is the problem because when i want to add a new contract i get
everything blank instead of it leaving the titles


------->collumns
l
l
l
\/
rows

I hope me changing my terms will help out a lil

the 38 that i dont want to change i have a seperate menu to change them.
This form is not for changing those 38 only the 38 that hold customer info
not the 38 that hold the names of the titles for the form

Stephen Renfro
 
J

John W. Vinson

ok john i might be using terminology wrong here and that might be whats wrong
ok

i will explain what the data base is about and what every thing is

first the data base is made so it can be universal amoung this companey
because they think they are going to switch from construction to like a
public storage or mabey even a towtruck yard, but anyways i made the titles
that tell you what the blank box next to them are about i made them unbound
boxes and there controle source or record source is the main table i have 76
collumns in my table going left to right on the top of my table and i have
one row at the moment going down.

When you enter a record in the data base i want only 38 of the records to
change because they have the option to and the other 38 to stay the same or
repeat or just make it a one row accross but only for the 38 collumns i have
. now this is the problem because when i want to add a new contract i get
everything blank instead of it leaving the titles


------->collumns
l
l
l
\/
rows

I hope me changing my terms will help out a lil

the 38 that i dont want to change i have a seperate menu to change them.
This form is not for changing those 38 only the 38 that hold customer info
not the 38 that hold the names of the titles for the form
Click to expand...

I'm sorry, but I'm unable to help with this.

This is simply NOT how Access is designed to work. It's like trying to use a
table saw to drive nails.

If you want a multifunctional database - design a properly normalized,
multifunctional database.

I don't see how you can create a table that functions as you describe.


John W. Vinson [MVP]
 
Top