Prompted as though doing a param query on closing form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is odd, and only occurs for one user, no matter what machine he's using...

I have a query that populates a listbox contained in a "Tab Control" on the
main form. In order for this listbox to show the most current information, I
have the form perform a Me.Refresh in the Form_Current event. This seems to
work just fine - re-querying my listbox and all is good.

Now the hook, and this happens so far to only one user, as this fellow exits
this main form (after clicking on the tab containing the listbox) and goes to
close, he's prompted as you might be in a param query, i.e., [Forms]![Main
Form]![Main_ix]. Either entering something in this dialog or not still
results in the form closing.

Is there some event where I might put in a "Me.ListboxA = Null" to clear out
the call for a query? Anyone have a clue why it ought be doing this?

It should also be noted that even if I remove the Me.Refresh as stated
above, it still goes to a dialog requesting the Main_ix value.

Any thoughts here would be great! I find myself cruising this site all the
time finding little gems of knowledge!

Thanks - Gordon
 
Gordon Clark said:
This is odd, and only occurs for one user, no matter what machine he's using...

I have a query that populates a listbox contained in a "Tab Control" on the
main form. In order for this listbox to show the most current information, I
have the form perform a Me.Refresh in the Form_Current event. This seems to
work just fine - re-querying my listbox and all is good.

Now the hook, and this happens so far to only one user, as this fellow exits
this main form (after clicking on the tab containing the listbox) and goes to
close, he's prompted as you might be in a param query, i.e., [Forms]![Main
Form]![Main_ix]. Either entering something in this dialog or not still
results in the form closing.

Is there some event where I might put in a "Me.ListboxA = Null" to clear out
the call for a query? Anyone have a clue why it ought be doing this?

It should also be noted that even if I remove the Me.Refresh as stated
above, it still goes to a dialog requesting the Main_ix value.

Any thoughts here would be great! I find myself cruising this site all the
time finding little gems of knowledge!
Click to expand...


I have not experienced this problem (yet), but I have heard
that it's caused by a bug in a specific(?) version(?) of
Access (might have been fixed in a service pack??).

I think I remember that setting the list box's RowSource to
"" before closing the form can prevent the prompt from
appearing.

Sorry to be so vague, but I thought I'd pass on the rumor
since you haven't had any other replies.
 
Update - now this is just plain old getting weird.... I've determined the
"why" he's getting this behavior - simply because he runs the XP desktop
theme - this error does NOT occur when running the "Classic" theme.

When I load the XP theme up, I can duplicate it... /ponder *on*

Also - the Switchboard and all forms are run in full screen mode, and
perform normally in "Classic" mode, switch to the XP theme and it throws the
forms into a windowed mode, rather than full screen.

?????????????????????????? At a loss, will delve into it further, actually I
Must, as most our users (when this goes live next week) are using the XP
themed desktop.
 
RESOLVED - - -
The fix was odd, had to put focus on a different tab than the one containing
the Listbox, within the Form_Close event:

Me.TabCtl58.Pages(0).SetFocus

It did the trick, not sure how this bug comes up only when using the XP
theme, but at least we're operational (especially before this whole thing
goes live Monday!)

Thanks again for your input Marshall! Gordon

Gordon Clark said:
Update - now this is just plain old getting weird.... I've determined the
"why" he's getting this behavior - simply because he runs the XP desktop
theme - this error does NOT occur when running the "Classic" theme.

When I load the XP theme up, I can duplicate it... /ponder *on*

Also - the Switchboard and all forms are run in full screen mode, and
perform normally in "Classic" mode, switch to the XP theme and it throws the
forms into a windowed mode, rather than full screen.

?????????????????????????? At a loss, will delve into it further, actually I
Must, as most our users (when this goes live next week) are using the XP
themed desktop.

Gordon Clark said:
This is odd, and only occurs for one user, no matter what machine he's using...

I have a query that populates a listbox contained in a "Tab Control" on the
main form. In order for this listbox to show the most current information, I
have the form perform a Me.Refresh in the Form_Current event. This seems to
work just fine - re-querying my listbox and all is good.

Now the hook, and this happens so far to only one user, as this fellow exits
this main form (after clicking on the tab containing the listbox) and goes to
close, he's prompted as you might be in a param query, i.e., [Forms]![Main
Form]![Main_ix]. Either entering something in this dialog or not still
results in the form closing.

Is there some event where I might put in a "Me.ListboxA = Null" to clear out
the call for a query? Anyone have a clue why it ought be doing this?

It should also be noted that even if I remove the Me.Refresh as stated
above, it still goes to a dialog requesting the Main_ix value.

Any thoughts here would be great! I find myself cruising this site all the
time finding little gems of knowledge!

Thanks - Gordon
Click to expand...
Click to expand...
 
Sorry, I couldn't be more specific. I guess I forgot the
part about Themes being involved. Now that you mention it,
I vaguely remember that the form being maximized was part of
the problem too.
--
Marsh
MVP [MS Access]


Gordon said:
RESOLVED - - -
The fix was odd, had to put focus on a different tab than the one containing
the Listbox, within the Form_Close event:

Me.TabCtl58.Pages(0).SetFocus

It did the trick, not sure how this bug comes up only when using the XP
theme, but at least we're operational (especially before this whole thing
goes live Monday!)

Thanks again for your input Marshall! Gordon

Gordon Clark said:
Update - now this is just plain old getting weird.... I've determined the
"why" he's getting this behavior - simply because he runs the XP desktop
theme - this error does NOT occur when running the "Classic" theme.

When I load the XP theme up, I can duplicate it... /ponder *on*

Also - the Switchboard and all forms are run in full screen mode, and
perform normally in "Classic" mode, switch to the XP theme and it throws the
forms into a windowed mode, rather than full screen.

?????????????????????????? At a loss, will delve into it further, actually I
Must, as most our users (when this goes live next week) are using the XP
themed desktop.

Gordon Clark said:
This is odd, and only occurs for one user, no matter what machine he's using...

I have a query that populates a listbox contained in a "Tab Control" on the
main form. In order for this listbox to show the most current information, I
have the form perform a Me.Refresh in the Form_Current event. This seems to
work just fine - re-querying my listbox and all is good.

Now the hook, and this happens so far to only one user, as this fellow exits
this main form (after clicking on the tab containing the listbox) and goes to
close, he's prompted as you might be in a param query, i.e., [Forms]![Main
Form]![Main_ix]. Either entering something in this dialog or not still
results in the form closing.

Is there some event where I might put in a "Me.ListboxA = Null" to clear out
the call for a query? Anyone have a clue why it ought be doing this?

It should also be noted that even if I remove the Me.Refresh as stated
above, it still goes to a dialog requesting the Main_ix value.

Any thoughts here would be great! I find myself cruising this site all the
time finding little gems of knowledge!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top