Kamis, 12 April 2012

Re: [MS_AccessPros] Sign in sheet report.

 

John

That works great.
Thank You
 I tried to change it to a minus sign but it did not like it before I emailed you back. 
 
Jim Wagner
________________________________

________________________________
From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, April 12, 2012 1:13 PM
Subject: RE: [MS_AccessPros] Sign in sheet report.


 
Jim-

Stupid Outlook autoreplace. I've switched to plain text so it won't happen again.

Employee Name: [First Nm] & " " & [Last Nm] & String(10, " ") & String(100 - Len([First nm] & [Last Nm]), "_")

It turned my minus sign into a hyphen!

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)

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

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Thursday, April 12, 2012 9:52 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Sign in sheet report.

John

I was close. I had the following which was really crazy. I was trying to make the line more justified

Employee Name: [First Nm] & " " & [Last Nm] & [Spaces] & [Bar]

Spaces is Spaces: String(10," ")
Bar is Bar: String(100,"_")

I get a syntax error. at the hyphen when I use your expression.

–Len

Jim Wagner
________________________________

________________________________
From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, April 12, 2012 12:40 PM
Subject: RE: [MS_AccessPros] Sign in sheet report.

Jim-

Use the String function:

Control Source:
=[FirstName] & " " & [LastName] & String(100 – Len([FirstName] & [LastName]),
"_")

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)

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

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
Sent: Thursday, April 12, 2012 8:51 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Sign in sheet report.

Hello All,

I would like to create a report that has the first and last names and a line
like below for a sign in sheet.

Jim Wagner____________________
John Doe ____________________
Frank Smith___________________

Is there a way to do this. or even have it like below

Jim Wagner____________________
John Doe______________________
Frank Smith___________________

Thank You

Jim Wagner

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

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

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar