Refresh Table

A

alex

Refresh Table

Hello,

I have a table with a Boolean/checkbox field.

Users can check this field when they want to include particular
records in a subsequent query that’s run from a popup form.

It works fine, but the query does not recognize the last check that’s
made by the user.

I need to somehow refresh (I’ve tried to repaint the table object) the
table so that the last check is recognized by Access.

The user can obviously move his/her cursor off the checked field, but
I’d like to add code so that’s not required.

Some suggestions might be to use a form instead of table, but I’d like
to avoid creating another object and my table only holds temp data.

Thanks,
alex
 
J

Jeff Boyce

Alex

If you're working directly in the table, stop now! Access tables may
resemble Excel spreadsheets, but they are only data containers.

To do the kind of thing you're describing, use the tool designed to do that
.... an Access form.

What's your objection to "creating another object"?

If your table only holds "temporary data", why use a table at all? Could
you use the query that generates the data?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Refresh Table

Hello,

I have a table with a Boolean/checkbox field.

Users can check this field when they want to include particular
records in a subsequent query that’s run from a popup form.

It works fine, but the query does not recognize the last check that’s
made by the user.

I need to somehow refresh (I’ve tried to repaint the table object) the
table so that the last check is recognized by Access.

The user can obviously move his/her cursor off the checked field, but
I’d like to add code so that’s not required.

Some suggestions might be to use a form instead of table, but I’d like
to avoid creating another object and my table only holds temp data.

Thanks,
alex
 
A

alex

Alex

If you're working directly in the table, stop now!  Access tables may
resemble Excel spreadsheets, but they are only data containers.

To do the kind of thing you're describing, use the tool designed to do that
... an Access form.

What's your objection to "creating another object"?

If your table only holds "temporary data", why use a table at all?  Could
you use the query that generates the data?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


Refresh Table

Hello,

I have a table with a Boolean/checkbox field.

Users can check this field when they want to include particular
records in a subsequent query that’s run from a popup form.

It works fine, but the query does not recognize the last check that’s
made by the user.

I need to somehow refresh (I’ve tried to repaint the table object) the
table so that the last check is recognized by Access.

The user can obviously move his/her cursor off the checked field, but
I’d like to add code so that’s not required.

Some suggestions might be to use a form instead of table, but I’d like
to avoid creating another object and my table only holds temp data.

Thanks,
alex

Thanks for helping Jeff…

I have a form that helps users write queries to ORACLE tables.

When a query finishes, a table will open under the popup form and the
user can look at the table and decide what records he/she might want
to include for the next query (multi-step process).

I’ve been using this method for over a year and it works great…I just
added a field, however, to exclude/include certain records (as I
described in my original post). Users simply click a record (first
field) to include it in the next query. The only problem is that if
the user does not click-off the last field, the table does not
recognize the value as true/false.

I don’t want to create another object because I need my one form to be
a nimble as possible (I have to send it to multiple users).

I don’t have your expertise, but I really think a table will suffice
in this situation (rather than a form bound to a table).

Maybe I don’t have a choice; maybe I cannot programmatically get the
table to recognize the last check without forcing some kind of after
update event.

Thanks again,
 
J

Jeff Boyce

Tables in Access don't have triggers, which it sounds like you're trying to
get (i.e., have the table recognize that something has happened).

.... but that's exactly what a Form would be able to do. Forms have a rich
'event environment', where Tables are merely "buckets o' data".

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Alex

If you're working directly in the table, stop now! Access tables may
resemble Excel spreadsheets, but they are only data containers.

To do the kind of thing you're describing, use the tool designed to do
that
... an Access form.

What's your objection to "creating another object"?

If your table only holds "temporary data", why use a table at all? Could
you use the query that generates the data?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


Refresh Table

Hello,

I have a table with a Boolean/checkbox field.

Users can check this field when they want to include particular
records in a subsequent query that’s run from a popup form.

It works fine, but the query does not recognize the last check that’s
made by the user.

I need to somehow refresh (I’ve tried to repaint the table object) the
table so that the last check is recognized by Access.

The user can obviously move his/her cursor off the checked field, but
I’d like to add code so that’s not required.

Some suggestions might be to use a form instead of table, but I’d like
to avoid creating another object and my table only holds temp data.

Thanks,
alex

Thanks for helping Jeff…

I have a form that helps users write queries to ORACLE tables.

When a query finishes, a table will open under the popup form and the
user can look at the table and decide what records he/she might want
to include for the next query (multi-step process).

I’ve been using this method for over a year and it works great…I just
added a field, however, to exclude/include certain records (as I
described in my original post). Users simply click a record (first
field) to include it in the next query. The only problem is that if
the user does not click-off the last field, the table does not
recognize the value as true/false.

I don’t want to create another object because I need my one form to be
a nimble as possible (I have to send it to multiple users).

I don’t have your expertise, but I really think a table will suffice
in this situation (rather than a form bound to a table).

Maybe I don’t have a choice; maybe I cannot programmatically get the
table to recognize the last check without forcing some kind of after
update event.

Thanks again,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top