ACCESS FEED: Re: [MS_AccessPros] Auto Populate from a drop down box

Selasa, 15 Juli 2014

Re: [MS_AccessPros] Auto Populate from a drop down box

John,

I am adding one record at a time into the entry form. After I select the status combo box value for the record, the after update refreshes the new dashboard form with the current data and opens the new form leaving the entry form. So when I return to the entry form I am back to not knowing what the last value in the color combo box was selected.

Jim Wagner

On Monday, July 14, 2014 2:41 PM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Jim-

I made the rash assumption that you're adding records one at a time. After you select a color, the code sets the Default Value for the *next* new record.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Jul 14, 2014, at 5:37 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

So I added the code to the after update event. But I am confused. the next color will not go to the next color because it will not be null because the after update would have to select a value? I am wrong?

Private Sub ColorOfRecord_AfterUpdate()

Dim varNextColor As Variant

varNextColor = DLookup("ColorOfRecord", "tblColorOfRecord", "ColorOfRecord > '" & Me.ColorOfRecord & "'")

If IsNull(varNextColor) Then varNextColor = "vbBlack"

Me.ColorOfRecord.DefaultValue = """ & varNextColor & " '"

End Sub

Jim Wagner

On Monday, July 14, 2014 2:23 PM, "Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

now that I have a visual. Make it go away!!!

Jim Wagner

On Monday, July 14, 2014 1:55 PM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Aw, you just didn't like showing your hairy belly button!

😃

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Jul 14, 2014, at 4:13 PM, wrmosca@comcast.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John

Photos need to be approved. I set that property after you posted that photo of me in a bikini.

-Bill

---In MS_Access_Professionals@yahoogroups.com, <JohnV@msn.com> wrote :

Jim-

We don't allow photos. Put the photos in the 2_Assistance Needed files folder.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Jul 14, 2014, at 4:04 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I tried adding a photo into the group but nothing happened. I created the album Tasks and Projects and it would not add the photo.

Jim Wagner

On Monday, July 14, 2014 12:57 PM, "Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Duane
I was hoping to cycle through to the next one over and over. The database is my personal project and task database. I enter in the tasks and projects and I was just choosing from the drop down the value. The issue I was having is that I could not remember the last color I chose. Because the tasks can last for an hour I never chose a color because it was somethings that happen each day and would not show on the other form with the tasks and projects that are still open.

I have 12 subforms on a main form that show each of the open tasks I am working on. If there are more than that I do not want to see them. The main form does a count of the open tasks and only shows the amount of subforms that are needed.

Jim Wagner

On Monday, July 14, 2014 12:50 PM, "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

What happens if there are 8 records when there are only 7 options? Are these populated over a group of records based on another field in the table? Can you share some table and field names?

Duane Hookom MVP
MS Access

To: MS_Access_Professionals@yahoogroups.com; MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 14 Jul 2014 12:45:28 -0700
Subject: Re: [MS_AccessPros] Auto Populate from a drop down box

vbBlack
vbBlue
vbCyan
vbGreen
vbMagenta
vbRed
vbYellow

Sent from Yahoo! Mail for Windows 8

From: John Viescas JohnV@msn.com [MS_Access_Professionals]<MS_Access_Professionals@yahoogroups.com>
Sent: ‎Mon, ‎Jul‎ ‎14‎, ‎2014 at ‎12‎:‎11‎ ‎PM
To: <MS_Access_Professionals@yahoogroups.com>
Subject: Re: [MS_AccessPros] Auto Populate from a drop down box

Jim-

OK, and what are the values in the column in the sequence you want them selected?

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

On Jul 14, 2014, at 2:56 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

The combo box is based on a table named tblColorOfRecord. There is only one column in the table so the bound column is 1
Jim Wagner

On Monday, July 14, 2014 11:10 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Jim-

What is the bound value of the combo box? If it's a consecutive number, should be easy to set the Default Value of the control to current value + 1. If not, then I would need to know the Row Source and the Bound Column.

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

On Jul 14, 2014, at 2:02 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hello,

I have a question that is a little off the beaten path but here it goes.

I have form that as I do the data entry on the form I have a drop down that I would like to use to always use the next value for the each record. There are seven choices in the drop down. So as I enter the values in the form the next value will only be available almost like an autopopulate. Is there a way of filtering out the values in the drop down to only see the next value or to just autopopulate the field?
Jim Wagner