Sabtu, 30 April 2016

[MS_AccessPros] Re: MS ACCESS 2010 AND FINGERPRINT ENROLLMENT CONTROL

 

I had to change the %2F 's in the link to forward slashes, but it just went
to a forum where someone had asked a question, which got one reply giving a
defunct link. I then tried the root of the link, but it got redirected
somewhere unhelpful. Here is something about it from Dell:
http://www.dell.com/support/article/us/en/19/SLN146739

--

----- Original Message -----
From: wrmosca@comcast.net [MS_Access_Professionals]
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, April 29, 2016 4:44 PM
Subject: [MS_AccessPros] Re: MS ACCESS 2010 AND FINGERPRINT ENROLLMENT
CONTROL

I don't know if that can be done or not. What kind of data does the control
gather? An image? Or is it a binary?

I found this link
www.excelforum.com%2Fexcel-programming-vba-macros%2F902562-how-to-use-digitalpersona-active-x-control-in-excel.html
Maybe that will help you. It's blocked at my work so I can't see the page.

---In MS_Access_Professionals@yahoogroups.com, <gocigbeti@yahoo.com> wrote :

I just stumble on Digita Person Fingerprint Enrollment ActiveX Control but I
have been having trouble working through it.
Any one with the idea of how to integrate fingerprint enrollment and
verification with ms access 2010.

Help will be highly appreciated.

__._,_.___

Posted by: "Dave Williams" <davewillgmale@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!


.

__,_._,___

Jumat, 29 April 2016

[MS_AccessPros] Re: MS ACCESS 2010 AND FINGERPRINT ENROLLMENT CONTROL

 

I don't know if that can be done or not. What kind of data does the control gather? An image? Or is it a binary?


I found this link www.excelforum.com%2Fexcel-programming-vba-macros%2F902562-how-to-use-digitalpersona-active-x-control-in-excel.html Maybe that will help you. It's blocked at my work so I can't see the page.


---In MS_Access_Professionals@yahoogroups.com, <gocigbeti@yahoo.com> wrote :

I just stumble on Digita Person Fingerprint Enrollment ActiveX Control but I have been having trouble working through it.
Any one with the idea of how to integrate fingerprint enrollment and verification with ms access 2010.

Help will be highly appreciated.


__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!


.

__,_._,___

Re: [MS_AccessPros] Access Report Format event question

 

Jim, adding on ... you can set the DefaultView property of the report (FORMAT tab of Property Sheet) to Print Preview

warm regards,
crystal

~ have an awesome day ~

On 4/29/2016 8:26 AM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] wrote:
That was it.

Thank You


 
Jim Wagner


On Thursday, April 28, 2016 8:10 PM, "Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Duane,

I think that was it. I will check with my boss and see if that is it.

Thank You
 
Jim Wagner


On Thursday, April 28, 2016 12:04 PM, "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Are you viewing in Report View or Print Preview? Code doesn't run in Report View.

Duane


To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 28 Apr 2016 11:20:48 -0700
Subject: [MS_AccessPros] Access Report Format event question



Hello all,


I have a report that have several headers named
GroupHeader1
GroupHeader2


I want to hide the headers if there is no data for them. I have the following code in both OnFormat events, below. It works great and then it does not. But if we just open the VBA window to the events. and then close the VBA window it works.
When it does not work it shows the headers. When it works the headers are NOT visible.


Is there something missing from the code or something else?


Thank You
Jim Wagner




Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
Cancel = IsNull(Me!Subdept)

End Sub


Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer)
Cancel = IsNull(Me!Subdept2)
End Sub








__._,_.___

Posted by: crystal 8 <strive4peace2008@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!


.

__,_._,___

Re: [MS_AccessPros] Access Report Format event question

 

That was it.

Thank You


 
Jim Wagner


On Thursday, April 28, 2016 8:10 PM, "Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Duane,

I think that was it. I will check with my boss and see if that is it.

Thank You
 
Jim Wagner


On Thursday, April 28, 2016 12:04 PM, "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Are you viewing in Report View or Print Preview? Code doesn't run in Report View.

Duane


To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 28 Apr 2016 11:20:48 -0700
Subject: [MS_AccessPros] Access Report Format event question



Hello all,


I have a report that have several headers named
GroupHeader1
GroupHeader2


I want to hide the headers if there is no data for them. I have the following code in both OnFormat events, below. It works great and then it does not. But if we just open the VBA window to the events. and then close the VBA window it works.
When it does not work it shows the headers. When it works the headers are NOT visible.


Is there something missing from the code or something else?


Thank You
Jim Wagner




Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
Cancel = IsNull(Me!Subdept)

End Sub


Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer)
Cancel = IsNull(Me!Subdept2)
End Sub







__._,_.___

Posted by: Jim Wagner <luvmymelody@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!


.

__,_._,___

[MS_AccessPros] MS ACCESS 2010 AND FINGERPRINT ENROLLMENT CONTROL

 

I just stumble on Digita Person Fingerprint Enrollment ActiveX Control but I have been having trouble working through it.
Any one with the idea of how to integrate fingerprint enrollment and verification with ms access 2010.

Help will be highly appreciated.


__._,_.___

Posted by: gocigbeti@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!


.

__,_._,___

Kamis, 28 April 2016

RE: [MS_AccessPros] Access Report Format event question

 

Is it one of those things where the code knows you’re watching so it doesn’t misbehave?

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, April 28, 2016 12:04 PM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] Access Report Format event question

 




Are you viewing in Report View or Print Preview? Code doesn't run in Report View.

 

Duane


To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 28 Apr 2016 11:20:48 -0700
Subject: [MS_AccessPros] Access Report Format event question



Hello all,


I have a report that have several headers named
GroupHeader1
GroupHeader2


I want to hide the headers if there is no data for them. I have the following code in both OnFormat events, below. It works great and then it does not. But if we just open the VBA window to the events. and then close the VBA window it works.
When it does not work it shows the headers. When it works the headers are NOT visible.


Is there something missing from the code or something else?


Thank You
Jim Wagner




Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
Cancel = IsNull(Me!Subdept)
End Sub


Private Sub GroupHeader2_Format(Cance! l As Integer, FormatCount As Integer)
Cancel = IsNull(Me!Subdept2)
End Sub







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.

__._,_.___

Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!


.

__,_._,___

Re: [MS_AccessPros] Access Report Format event question

 

Duane,

I think that was it. I will check with my boss and see if that is it.

Thank You
 
Jim Wagner


On Thursday, April 28, 2016 12:04 PM, "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Are you viewing in Report View or Print Preview? Code doesn't run in Report View.

Duane


To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 28 Apr 2016 11:20:48 -0700
Subject: [MS_AccessPros] Access Report Format event question



Hello all,


I have a report that have several headers named
GroupHeader1
GroupHeader2


I want to hide the headers if there is no data for them. I have the following code in both OnFormat events, below. It works great and then it does not. But if we just open the VBA window to the events. and then close the VBA window it works.
When it does not work it shows the headers. When it works the headers are NOT visible.


Is there something missing from the code or something else?


Thank You
Jim Wagner




Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
Cancel = IsNull(Me!Subdept)

End Sub


Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer)
Cancel = IsNull(Me!Subdept2)
End Sub





__._,_.___

Posted by: Jim Wagner <luvmymelody@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!


.

__,_._,___

RE: [MS_AccessPros] Access Report Format event question

 

Are you viewing in Report View or Print Preview? Code doesn't run in Report View.

Duane


To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 28 Apr 2016 11:20:48 -0700
Subject: [MS_AccessPros] Access Report Format event question



Hello all,


I have a report that have several headers named
GroupHeader1
GroupHeader2


I want to hide the headers if there is no data for them. I have the following code in both OnFormat events, below. It works great and then it does not. But if we just open the VBA window to the events. and then close the VBA window it works.
When it does not work it shows the headers. When it works the headers are NOT visible.


Is there something missing from the code or something else?


Thank You
Jim Wagner




Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
Cancel = IsNull(Me!Subdept)

End Sub


Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer)
Cancel = IsNull(Me!Subdept2)
End Sub



__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!


.

__,_._,___

[MS_AccessPros] Access Report Format event question

 

Hello all,


I have a report that have several headers named

GroupHeader1

GroupHeader2


I want to hide the headers if there is no data for them. I have the following code in both OnFormat events, below. It works great and then it does not. But if we just open the VBA window to the events. and then close the VBA window it works.

When it does not work it shows the headers. When it works the headers are NOT visible.


Is there something missing from the code or something else?


Thank You

Jim Wagner



Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
Cancel = IsNull(Me!Subdept)

End Sub


Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer)
Cancel = IsNull(Me!Subdept2)
End Sub

__._,_.___

Posted by: luvmymelody@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!


.

__,_._,___

Re: [MS_AccessPros] Pulling two different names in one query

 

John,

Thank you. This is the final code:

SELECT tbl_mediation_log.MediationLog_ID, tbl_mediation_log.Case_Number, IIf(IsNull([tbl_People].[MiddleName]),[tbl_People].[LastName] & ", " & [tbl_People].[FirstName],[tbl_People].[LastName] & ", " & [tbl_People].[FirstName] & " " & [tbl_People].[MiddleName]) AS cClaimantName, IIf(IsNull([Respondent].[MiddleName]),[Respondent].[LastName] & ", " & [Respondent].[FirstName],[Respondent].[LastName] & ", " & [Respondent].[FirstName] & " " & [Respondent].[MiddleName]) AS cRespondentName, tbl_people.Salutation, tbl_people.FirstName, tbl_people.MiddleName, tbl_people.LastName, tbl_people.Suffix, tbl_mediation_log.Claimant_Petitioner_Name_ID, tbl_mediation_log.Respondent_Name_ID, tbl_mediation_log.Case_Summary, tbl_mediation_log.Facts, tbl_mediation_log.Claimant_Case, tbl_mediation_log.Respondent_Case, tbl_mediation_log.TERO_Ordinance, tbl_mediation_log.Applicable_TERO_Ordinance, tbl_mediation_log.Remarks, tbl_mediation_log.Decision, tbl_mediation_log.Stipulated_Res_Claimant_flag, tbl_mediation_log.Stipulated_Res_Respondent_flag, tbl_mediation_log.CaseDate
FROM tbl_people AS Respondent INNER JOIN (tbl_people INNER JOIN tbl_mediation_log ON tbl_people.PeopleID = tbl_mediation_log.Claimant_Petitioner_Name_ID) ON Respondent.PeopleID = tbl_mediation_log.Respondent_Name_ID;
 
The actual name is Respondent_Name_ID

With Warm Regards,
 
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."  







From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, April 28, 2016 1:44 AM
Subject: Re: [MS_AccessPros] Pulling two different names in one query

 
Add a second copy of tbl_People:

FROM (tbl_people As Claimant INNER JOIN tbl_mediation_log 
  ON Claimaint.PeopleID = tbl_mediation_log.Claimant_Petitioner_Name_ID)
INNER JOIN tbl_People AS Respondent
  ON Respondent.PeopleID = tbl_mediation_log.RespondentID

Note that I gave each copy of tbl_people an alias name so that you can tell which is which.

BTW, in your list of fields below, you say it's ClaimantID, but you use Claimant_Petitioner_Name_ID in your SQL.  Have no clue what is the actual name for "RespondentID" in tbl_Mediation_log.

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 
(Paris, France)



On Apr 28, 2016, at 7:42 AM, dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



I have the following tables:
tbl_People
peopleID   PK
FirstName
LastName
MiddleInitial
PeopleType = Claimant or Respondent

tbl_mediation_log
MediationLogID  PK
CaseNumber'
ClaimantID - Should link to tbl_People with PeopleType of Claimant
RespondentID- Should link to tbl_People with PeopleType of Responent
Facts
Case Note

I started on a query to try and pull it out:
SELECT tbl_mediation_log.MediationLog_ID, tbl_mediation_log.Case_Number, IIf(IsNull([tbl_People].[MiddleName]),[tbl_People].[LastName] & ", " & [tbl_People].[FirstName],[tbl_People].[LastName] & ", " & [tbl_People].[FirstName] & " " & [tbl_People].[MiddleName]) AS cClaimantName, tbl_people.Salutation, tbl_people.FirstName, tbl_people.MiddleName, tbl_people.LastName, tbl_people.Suffix, tbl_mediation_log.Claimant_Petitioner_Name_ID, tbl_mediation_log.Respondent_Name_ID, tbl_mediation_log.Case_Summary, tbl_mediation_log.Facts, tbl_mediation_log.Claimant_Case, tbl_mediation_log.Respondent_Case, tbl_mediation_log.TERO_Ordinance, tbl_mediation_log.Applicable_TERO_Ordinance, tbl_mediation_log.Remarks, tbl_mediation_log.Decision, tbl_mediation_log.Stipulated_Res_Claimant_flag, tbl_mediation_log.Stipulated_Res_Respondent_flag, tbl_mediation_log.CaseDate
FROM tbl_people INNER JOIN tbl_mediation_log ON tbl_people.PeopleID = tbl_mediation_log.Claimant_Petitioner_Name_ID;

I need to add this in:

]),[tbl_People].[LastName] & ", " & [tbl_People].[FirstName],[tbl_People].[LastName] & ", " & [tbl_People].[FirstName] & " " & [tbl_People].[MiddleName]) AS cRespondentName

But I need to pull the correct person out of the tbl_people.

Any ideas or even doable.

Thank you, 

Art Lorenzini
Sioux Falls, SD





__._,_.___

Posted by: Art Lorenzini <dbalorenzini@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!


.

__,_._,___