| Computers Forum Index » Computer - Databases - MS Access » Unresponsive Macro on client's computer... |
|
Page 1 of 1 |
|
| Author |
Message |
| Tomahawk Lady... |
Posted: Tue Oct 27, 2009 11:45 am |
|
|
|
Guest
|
A new user loaded my program onto her computer and began entering
data. A number of macros had already run successfully before she got
to one that was unresponsive. On exiting a field, Category, I run a
macro that does SavesRecord and Requery to make the next field choose
data based on the value chosen in the Category. When she gets to that
new field, a combo box with the list based on the value in Category,
no list appears. That macro fails in the blank version as well as in a
version I sent along that has junk data for clients to see how reports
look.
Does the problem have something to do with outdated Jet versions?
Any suggestions? I'm going to see her Wednesday. Thanks!! |
|
|
| Back to top |
|
|
|
| Tomahawk Lady... |
Posted: Tue Oct 27, 2009 12:24 pm |
|
|
|
Guest
|
On Oct 27, 7:45 am, Tomahawk Lady <nancycmarsh... at (no spam) verizon.net> wrote:
Quote: A new user loaded my program onto her computer and began entering
data. A number of macros had already run successfully before she got
to one that was unresponsive. On exiting a field, Category, I run a
macro that does SavesRecord and Requery to make the next field choose
data based on the value chosen in the Category. When she gets to that
new field, a combo box with the list based on the value in Category,
no list appears. That macro fails in the blank version as well as in a
version I sent along that has junk data for clients to see how reports
look.
Does the problem have something to do with outdated Jet versions?
Any suggestions? I'm going to see her Wednesday. Thanks!!
Years ago I was told to use Refresh rather than Requery. I just
changed the macro from "Requery" to RunCommand/Refresh. That works on
my computer. Will that be a better solution? Nancy (again) |
|
|
| Back to top |
|
|
|
|