Accessing the fields of a datasheet.

[Sofo]

How do i access the fields in a datasheet? The fieldnames refer to a complete column in datasheet mode.

 

[qdogfball]

Are you in a Form?

Are you looking to find out where these fields are located?

You can goto design view, which is right above File and then View, Field List to get which fields you can put on a form.

To find out the underlying table to these fields you can goto View, Properties and then Data on the property sheet and see the Record Source, which is your table.

 

[missinglinq]

The fieldnames refer to a complete column (in the underlying table) in any mode! Exactly what are you trying to accomplish?

 

[Sofo]

The fieldnames refer to a complete column (in the underlying table) in any mode! Exactly what are you trying to accomplish?

I would like to be able to process a datasheet as if it was a recordset produced by an ordinary tablequery, thus gaining access to its fields.

 

[boblarson]

I would like to be able to process a datasheet as if it was a recordset produced by an ordinary tablequery, thus gaining access to its fields.

What does that mean, exactly?

A datasheet is a form that looks like a table and it has, as its recordsource, a TABLE or QUERY. So, as long as your underlying query(or table) is updatable, you have access to the data in the fields from within the datasheet, just the same as you had if in the table or query.

 

[Sofo]

What does that mean, exactly?

A datasheet is a form that looks like a table and it has, as its recordsource, a TABLE or QUERY. So, as long as your underlying query(or table) is updatable, you have access to the data in the fields from within the datasheet, just the same as you had if in the table or query.

I want to modify some of the fields in the datasheet after Access has populated it with data. It would be possible if i could process the datasheet as if it was a recordset, but i don't know how to do it.

 

[boblarson]

I think we're going round and round on this. A data sheet HAS a recordset. You can access this recordset. Example:

Dim rs As DAO.Recordset

Set rs = Me.Recordset

and there you have it, a recordset object that is the data sheet's recordset.

Does that help, or are we still not talking about the same thing?

 

[Sofo]

I think we're going round and round on this. A data sheet HAS a recordset. You can access this recordset. Example:

Dim rs As DAO.Recordset

Set rs = Me.Recordset

and there you have it, a recordset object that is the data sheet's recordset.

Does that help, or are we still not talking about the same thing?

Thanks! - that was exactly the info i was missing.

 

[boblarson]

Thanks! - that was exactly the info i was missing.

Whew! Sometimes it is hard to get to the same page

Glad we got that worked out.