Deltavictor
New Member
- Joined
- Aug 24, 2005
- Messages
- 2
Hi.
I am working on an Access database. One of the functions provides an inventory of 24 connections, include if they are active or not based on a status field.
One particular table has 24 entries (always will, no more, no less) This is the table with the definition of the 24 connections.
One of the fields in this table is a yes/no field which basically is a status field for whether that record is currently 'on' or 'off'
On the main form that I'm using I would like to display the status of the 24 connections, based only on the 'active' field.
It would help me if I could find a way to retrieve the 24 values via VBA.
Is there, for an example a way to take.
testValue1 = table.Connections(record(1), field(active)).value
or better yet
for counter = 1 to 24
testValue.counter = table.Connections(record(counter), field(active).value
{code that does other stuff}
next counter
I know that having a database with 24 records isn't exactly harnessing the full power of Access, but it gives me a project to play around with.
Thanks for any help!
I am working on an Access database. One of the functions provides an inventory of 24 connections, include if they are active or not based on a status field.
One particular table has 24 entries (always will, no more, no less) This is the table with the definition of the 24 connections.
One of the fields in this table is a yes/no field which basically is a status field for whether that record is currently 'on' or 'off'
On the main form that I'm using I would like to display the status of the 24 connections, based only on the 'active' field.
It would help me if I could find a way to retrieve the 24 values via VBA.
Is there, for an example a way to take.
testValue1 = table.Connections(record(1), field(active)).value
or better yet
for counter = 1 to 24
testValue.counter = table.Connections(record(counter), field(active).value
{code that does other stuff}
next counter
I know that having a database with 24 records isn't exactly harnessing the full power of Access, but it gives me a project to play around with.
Thanks for any help!