record sets ??

  • Thread starter Thread starter Srenfro
  • Start date Start date
S

Srenfro

open a Recordset based on the table and loop through its
Fields collection.

I got this answer after i asked a question yesterday. can anyone help me
open a record set bassed on the table and is it possable to open it based on
a query

thanks
 
Yes, a recordset based on a query behaves exactly like a recordset based on a
table - most of the time. The difference would be if your query created an
uneditable recordset, it would be read only.
 
Can you please tell me how to do this though i am a bit confused because i
have an access book infront of me access for dummies and i cant figure out
how to do this

also if i make a recordset as a query then it becomes read only does this do
this to the whole form or can i just choose to have it only do it to the
records in the query because i want to add data to the tabel for half of the
text boxes i have and i want it to read it from query for the other half

is this possable??

and if it is can i get some help thank you
 
i want to add data to the tabel for half of the text boxes i have and i want
it to read it from query for the other half

Not a good plan. A bound form can have only one record source. That would
be either a table or a query. You could do it one of two ways. Use an
unbound form and handle everything yourself or you can use a form/subform for
your data.

Why do you need a table and a query?
 
I need a table to store data after i type data into my form's blank text
boxes and i need the query for my labels and i used unbound boxes for bolth
of them and the reason why is because i linked it to another form so i can
change my labels when ever i need and all at once instead of having to do it
form by form.

So is there a way for me to get this to work?

Thank you

Stephen
 
I need a table to store data after i type data into my form's blank text
boxes and i need the query for my labels and i used unbound boxes for bolth
of them and the reason why is because i linked it to another form so i can
change my labels when ever i need and all at once instead of having to do it
form by form.
Click to expand...

Is there any chance (any chance at all) that you could use TWO TABLES?

One table for labels, and a *different* table for the data?

You could then use two subforms on a main form, one for the labels and one for
the data.

Your insistance on having the entire relational database structure, fieldnames
and all, embedded within every single record of a hideously denormalized
monster wide flat table, is the source of your difficulty. I think you're
trying to be clever and save yourself work, but in reality you're being very
extreme and COSTING yourself a great deal of work!

John W. Vinson [MVP]
 
Can I use 3 tables in a form,?? Because i am already using 2 i have one
subform that add's and subtracts what people owe us after the job is done it
is like a spread sheet subform. so can I use 3 tables because that would be
great


Thank You
Stephen Renfro
 
Can I use 3 tables in a form,?? Because i am already using 2 i have one
subform that add's and subtracts what people owe us after the job is done it
is like a spread sheet subform. so can I use 3 tables because that would be
great
Click to expand...

I think you're limited to 64 subforms. Three is NO problem.

If the users need a spreadsheet.... Excel is a very good spreadsheet, can be
launched from Access, and can get its data from an Access query. Nothing in
what you say here has any evident bearing on your storing labels and data in
the same table!

John W. Vinson [MVP]
 
Well that was exactly what i needed to do thank you very mych but now i have
a lot more work to do since now i have to change so much stuff well thank you

Stephen
 
Back
Top