form control values

[greg]

Hi,

I don't think my message posted correctly so here it is.

Is there any way to access the individual values of a form text box?
I want to iterate through all of the rows and access the values of a
text box in my form.

thanks.

[Larry Linson]

Except for the Multi-Value Field (aka "Complex Data") a Text Box in a Form
contains only a single value. Could you clarify just what it is that you
have, and what you are trying to accomplish? Are you describing a
continuous forms view Form, and want to look at the data in the bound Field
for every Record in the RecordSource of the Form? And, if so, what is the
purpose. It is possible that someone could suggest a useful alternative to
the way you think it must be done.

Larry Linson
Microsoft Access MVP
"greg" <gr*****@gmail. comwrote in message
news:11******** **************@ u30g2000hsc.goo glegroups.com.. .

Hi,

I don't think my message posted correctly so here it is.

Is there any way to access the individual values of a form text box?
I want to iterate through all of the rows and access the values of a
text box in my form.

thanks.

[greg]

Yes, well actually what I'm trying to do is set the values in the Text
Box to a dynamically generated query (within vba code) which I can
access with a DAO.Recordset object. However, the rest of the fields
are generated from a different query which cannot really be altered
because the file (for work related reasons) is read only. I was hoping
to set only certain fields dynamically because they are generated from
a crosstab query and if you join the rest of the query with it, the
data in the entire form cannot be editted. I need all of this
information to be displayed in the form though and still be editable.

I hope that makes sense.

Thanks,
greg

[Larry Linson]

Yes, I think I understand. But, I am reasonably sure the way to accomplish
what you want is not to work in the Form, but with the tables/query that are
the RecordSource for the Form.

Am I correct in understanding that, to start, there will be no Records, so
you need to create them, populate one Field from a Crosstab Query, and then
populate the other Fields from a different Query? If not, please clarify.

If so, (1) how are the Records identified (what field is the one which
uniquely identifies the Record? What type of Field is it? If Autonumber,
that's an easy thing; otherwise, you have to define how the value is
calculated.) (2) Is there only one user, so that you have assurance that no
one else will be trying to do something with a partially-completed Record?
(3) What is the source of the data for the CrossTab Query? Do you have a
working Crosstab Query?

If the RecordSource of your Form includes a Query on ReadOnly data joined
with a Crosstab Query (the results of which aren't editable), then I am not
surprised that the Form is not editable.

Can you explain what type of data you have, what the crosstab is returning,
what editing you want to do, and what you are going to do with it/how you
are going to use it... in business terms, not Access tech terms?

Larry Linson
Microsoft Access MVP

"greg" <gr*****@gmail. comwrote in message
news:11******** **************@ n76g2000hsh.goo glegroups.com.. .

>
Yes, well actually what I'm trying to do is set the values in the Text
Box to a dynamically generated query (within vba code) which I can
access with a DAO.Recordset object. However, the rest of the fields
are generated from a different query which cannot really be altered
because the file (for work related reasons) is read only. I was hoping
to set only certain fields dynamically because they are generated from
a crosstab query and if you join the rest of the query with it, the
data in the entire form cannot be editted. I need all of this
information to be displayed in the form though and still be editable.

I hope that makes sense.

Thanks,
greg

[greg]

Answers below.

Am I correct in understanding that, to start, there will be no Records, so
you need to create them, populate one Field from a Crosstab Query, and then
populate the other Fields from a different Query? If not, please clarify.

The RecordSource for the form is being dynamically generated. I need
several
fields from a crosstab query and the rest from a standard query.
Everything
needs to be dynamically generated as this form is called from another
form
with a variable Date field. Right now I'm inserting the crosstab info
into a
table but the performance is not great.

If so, (1) how are the Records identified (what field is the one which
uniquely identifies the Record? What type of Field is it? If Autonumber,
that's an easy thing; otherwise, you have to define how the value is
calculated.) (2) Is there only one user, so that you have assurance that no
one else will be trying to do something with a partially-completed Record?
(3) What is the source of the data for the CrossTab Query? Do you have a
working Crosstab Query?

1) There is a reference number that is common to all tables in the
query. It is not an Autonumber.
2) The database is read only (so you can't dynamically change saved
queries) but the tables are linked sybase tables
3) I have a working crosstab query based on one of the tables but i
don't use it directly since the form has to be editable.

If the RecordSource of your Form includes a Query on ReadOnly data joined
with a Crosstab Query (the results of which aren't editable), then I am not
surprised that the Form is not editable.

- well the data is not read only. but crosstabs obviously can't be
edited.

Can you explain what type of data you have, what the crosstab is returning,
what editing you want to do, and what you are going to do with it/how you
are going to use it... in business terms, not Access tech terms?

so i have description table and a data table. the data table has a
timestamp field as well
which is what the crosstab is built on. so i want to display the past
12 months of data for a certain field
but the current month, as well as the description data to be editable.

Thanks for the help,
greg