2 tables many forms

[Srenfro]

hello i have a question i have figured out what i did wrong the last time i
asked i was using labels instead of textboxes but now this isnt the problem
any more my problem is that i want to be able to use these two tables i have
in most of my forms i want one table to be the descripteve and the other to
be informative like this


descriptive informative
Contract # 2045
Customer type Commercial\residiential

The informative works on my data base but the descriptive doesnt
I want to be able to use bolth tables in the form but the only way i have
seen it even a little close to working is when i try expression builder and
it comes up with #name? all i tell the expression builder to get the
information for the descriptive here =[Forms]![Text Box Names Query]![Job ID]
and that is when i get #name? on my form and solutions

 

[Jeff Boyce]

I don't understand what you are storing in the two tables, nor how you've
related them.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Srenfro]

and that is when i get #name? on my form and solutions *any solutions

 

[Jeff Boyce]

Unless you provide more specific descriptions, it will be difficult to offer
more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

and that is when i get #name? on my form and solutions *any solutions

hello i have a question i have figured out what i did wrong the last time
i
asked i was using labels instead of textboxes but now this isnt the
problem
any more my problem is that i want to be able to use these two tables i
have
in most of my forms i want one table to be the descripteve and the other
to
be informative like this


descriptive informative
Contract # 2045
Customer type Commercial\residiential

The informative works on my data base but the descriptive doesnt
I want to be able to use bolth tables in the form but the only way i have
seen it even a little close to working is when i try expression builder
and
it comes up with #name? all i tell the expression builder to get the
information for the descriptive here =[Forms]![Text Box Names Query]![Job
ID]
and that is when i get #name? on my form and solutions

 

[Srenfro]

Jeff Can I send you a picture of my data base and mabey could you understand
what it is i need they say a picture is worth a thousand words you know and i
am trying ro not relate the tabels except for them bolth exsiting in the form
runing two seperate things

what i am trying to get done is i am trying to at the end of everything when
all is done with my data base i want to be able to change my names of the
descriptive colome's text box's and on all my forms like 8 or 9 forms and i
want to be able to change the descriptive form in a form my modify form which
you can only access if you have user rights to do so

i have created the form for the modify screen and it works except for
changing all other textboxes in my other form

 

[George Nicholson]

"#Name?" is Access-speak for one of 2 things:
1) "I can't find anything with that name"
or
2) "Which one do you mean? I'm confused." (i.e., there are 2 things,
probably a control and field, with the same name

So, either:
- you don't have a form (not subform) named [Text Box Names Query] (or it
isn't open)

- or you don't have a control or field called JobID on that form

- and/or you have both a Field and control named JobID on the form. (rename
the control)

Punctuation was invented for a purpose. Please use it. It helps.

 

[Jeff Boyce]

These newsgroups do not allow attaching pictures. Besides, a database has
multiple parts, and a picture of only one part probably wouldn't help a
great deal.

If I'm understanding, you want to have a change in the name of a text box
"ripple through" all the places (i.e., forms) where it shows up. Why?

There are commercial (and free) tools that can help you perform a global
search & replace ... this might be the search terms you could use to find
some, if that's what you are trying to do. But still, why? How will
changing the names of your columns (and the forms in which they appear) make
your users' lives easier?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff Can I send you a picture of my data base and mabey could you
understand
what it is i need they say a picture is worth a thousand words you know
and i
am trying ro not relate the tabels except for them bolth exsiting in the
form
runing two seperate things

what i am trying to get done is i am trying to at the end of everything
when
all is done with my data base i want to be able to change my names of the
descriptive colome's text box's and on all my forms like 8 or 9 forms and
i
want to be able to change the descriptive form in a form my modify form
which
you can only access if you have user rights to do so

i have created the form for the modify screen and it works except for
changing all other textboxes in my other form

hello i have a question i have figured out what i did wrong the last time
i
asked i was using labels instead of textboxes but now this isnt the
problem
any more my problem is that i want to be able to use these two tables i
have
in most of my forms i want one table to be the descripteve and the other
to
be informative like this


descriptive informative
Contract # 2045
Customer type Commercial\residiential

The informative works on my data base but the descriptive doesnt
I want to be able to use bolth tables in the form but the only way i have
seen it even a little close to working is when i try expression builder
and
it comes up with #name? all i tell the expression builder to get the
information for the descriptive here =[Forms]![Text Box Names Query]![Job
ID]
and that is when i get #name? on my form and solutions

 

[Srenfro]

I got it thanks though i cant use two tables at once so i just put the info
from the second table into the first table and used the unbound text box to
get my info from the table.

But thanks guys for your help

Stephen

"#Name?" is Access-speak for one of 2 things:
1) "I can't find anything with that name"
or
2) "Which one do you mean? I'm confused." (i.e., there are 2 things,
probably a control and field, with the same name

So, either:
- you don't have a form (not subform) named [Text Box Names Query] (or it
isn't open)

- or you don't have a control or field called JobID on that form

- and/or you have both a Field and control named JobID on the form. (rename
the control)

Punctuation was invented for a purpose. Please use it. It helps.
--
HTH,
George

hello i have a question i have figured out what i did wrong the last time
i
asked i was using labels instead of textboxes but now this isnt the
problem
any more my problem is that i want to be able to use these two tables i
have
in most of my forms i want one table to be the descripteve and the other
to
be informative like this


descriptive informative
Contract # 2045
Customer type Commercial\residiential

The informative works on my data base but the descriptive doesnt
I want to be able to use bolth tables in the form but the only way i have
seen it even a little close to working is when i try expression builder
and
it comes up with #name? all i tell the expression builder to get the
information for the descriptive here =[Forms]![Text Box Names Query]![Job
ID]
and that is when i get #name? on my form and solutions