Senin, 26 September 2011

RE: [MS_AccessPros] ComboBox/Continuous Form question

 

Sally-

What happens in the AfterUpdate event of the combo box? I'm having a hard time
seeing why the combo isn't bound.

But to answer your question, do:

Me.cmbStatusChange = Null

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Sally Vega
Sent: Monday, September 26, 2011 6:36 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] ComboBox/Continuous Form question

Hi John,

The combo box is for the user to switch from one status to another. I want the
user to be able to change the status of each row individually. I tried
Me.cmbStatusChange = "False" and this resets all of the combo boxes to 0, how
can I have them reset themselves to null like when I first open the form?

Thank you.

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Monday, September 26, 2011 9:20 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] ComboBox/Continuous Form question

Sally-

Have you considered putting the combo box in the form header?

If the combo box were bound, I could suggest a solution using an overlay text
box. Also, do you need the combo only when on a new row? Consider
showing/hiding the combo box in the Current event of the form based on the
setting of Me.NewRecord.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From:
MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%40yahoogr
oups.com>
[mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%4
0yahoogroups.com>] On Behalf Of Sally Vega
Sent: Monday, September 26, 2011 6:05 PM
To:
MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%40yahoogr
oups.com>
Subject: [MS_AccessPros] ComboBox/Continuous Form question

Good morning all,

I'm not new to programming but I'm new to Access/VBA. I'm trying to do
something that should have been easy but can't find a way to do it.

I have a combo box in my continuous form and it is not bound. What the combo
box is doing is an update of the status (from 1 to 7) and then a timestamp of
when the status changed. This part is working.

The problem is that when I change the combo box for one row, it changes all of
the them to the same thing. How can I have it change only to the value in that
row? It needs to remain unbound so that I can do the update.

I would also be happy with just having all of the combo boxes reset themselves
to nothing once the update is done.

Thank you.

This email (and all attachments) is for the sole use of the intended
recipient(s) and may contain privileged and/or proprietary information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you are
not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended
recipient(s) and may contain privileged and/or proprietary information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you are
not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar