ACCESS FEED: Re: [MS

Rabu, 19 November 2014

Re: [MS_AccessPros]

You could make the StepID a plain Integer or Long to use a PKey, but that would allow you to resequence the steps if necessary.

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 Nov 19, 2014, at 4:38 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Duane,

Thank You. I would have missed that. I too have made that mistake with a ranking scenario years ago. It was painful.

Jim Wagner

On Wednesday, November 19, 2014 8:28 AM, "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

I agree with John regarding the table. However, I would add a sequence field so processing steps can be added and reordered. I created something similar for a client that processed loans. The steps and order they originally identified looked nothing like the final processing steps. If I had created the steps a field names, it would have cost my client (or me) a ton of hours to make modifications.

Duane Hookom MVP
MS Access

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 19 Nov 2014 15:48:26 +0100
Subject: Re: [MS_AccessPros]

Jim-

Then you need a table with three columns:

StepID AutoNumber

HiringProcessShortName

HiringProcessDescription

Be sure to load the rows in ascending order from earliest step to last step so that the AutoNumber reflects the correct sequence.

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 Nov 19, 2014, at 2:25 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

At this time the table has not been built. I have the data in a spreadsheet and was not sure how to design the table(s). They have mentioned that the long description will probably be used on reports frequently as well as the short description. Currently there are 6 columns in the spreadsheet. 4 columns are not being used. The first column has a header of Steps on Hiring Process Checklist. The second column has a header of Short Name for Forms. There are 49 rows in the sheet. each of the fields will be dates. Several of the rows consist of

ATH Form to Hiring Official ATH to HO

Approved ATH received from Hiring Official Rec'd ATH from HO

Draft job posting to Manager for Approval Draft posting to Mgr

Jim Wagner

On Wednesday, November 19, 2014 1:22 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Jim-

If this is variable data to display, it doesn't seem to make much sense to put "data" in a field name. Are there multiple rows in this table? What's in the actual field as data?

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 Nov 19, 2014, at 12:33 AM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hello all,

I have just received a strange request from our users. It never ceases to amaze me.

The users request that they have a table that has two columns currently. The first column has a long description of a step below is an example

Final applicant list/screening sheet approved by Manager/ready to interview

The second column has the short description. Below is the equal to the long description above.

AL/SS final

So I thought that I would put the short description in the Caption of the field. Then I would put the long description as field name or vice versa. But the problem is that they have a report that they want as a check list the long description as the label and a form they want the short description to show.

So my question is how do I see both?

Jim Wagner