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

Senin, 14 Juli 2014

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

Jim

All photos must be approved. I'll do that for you right now.

-Bill

---In MS_Access_Professionals@yahoogroups.com, <luvmymelody@yahoo.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