Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 07-08-2014, 06:07 AM
Sharath_MS_Forums Sharath_MS_Forums is offline Checking Gender Windows 7 32bit Checking Gender Office 2007
Novice
Checking Gender
 
Join Date: Jul 2014
Location: India
Posts: 14
Sharath_MS_Forums is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Your image indicates that neither the birth date nor the date of admission are stored in the document, but in a userform. So how is the macro supposed to access these data? Without them, there is no way of doing anything with the document.
Is there any chance of using the Birth Date with today's date and insert the age in number in the document.



I mean, that any data like Birth date used in userform, can't it be used for calculation in macros?

Thanks in advance.

Sharath
Reply With Quote
  #17  
Old 07-08-2014, 06:11 AM
macropod's Avatar
macropod macropod is offline Checking Gender Windows 7 32bit Checking Gender Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

And how is the macro to get the birth date? If it can get that, why can't it get the admission date too? Unless you can edit the code behind your userform, so that it runs the macro or outputs the data to the document, neither date is available to anything outside the userform.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #18  
Old 07-08-2014, 06:20 AM
Sharath_MS_Forums Sharath_MS_Forums is offline Checking Gender Windows 7 32bit Checking Gender Office 2007
Novice
Checking Gender
 
Join Date: Jul 2014
Location: India
Posts: 14
Sharath_MS_Forums is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
And how is the macro to get the birth date? If it can get that, why can't it get the admission date too? Unless you can edit the code behind your userform, so that it runs the macro or outputs the data to the document, neither date is available to anything outside the userform.

The database from where the data is autopopulated in this user form is not in our hands; user has only chance to modify it. We have no access to code as well. As an end-user/transcriber, to avoid any errors in my document with regards to age, I just wanted to the above task. So, if there is any chance to do this, please go ahead and provide me with the solution.

Your assistance/effort is appreciated.

Thanks in advance.

Sharath
Reply With Quote
  #19  
Old 07-08-2014, 06:23 AM
macropod's Avatar
macropod macropod is offline Checking Gender Windows 7 32bit Checking Gender Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

As I have already said:
Quote:
Unless you can edit the code behind your userform, so that it runs the macro or outputs the data to the document, neither date is available to anything outside the userform.
Since those data are not available, it is not possible to write such a macro.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #20  
Old 07-08-2014, 09:14 AM
Sharath_MS_Forums Sharath_MS_Forums is offline Checking Gender Windows 7 32bit Checking Gender Office 2007
Novice
Checking Gender
 
Join Date: Jul 2014
Location: India
Posts: 14
Sharath_MS_Forums is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
As I have already said:

Since those data are not available, it is not possible to write such a macro.
Ok, Thank you...
Reply With Quote
Reply

Tags
gender check

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Turning On Spell Checking Again SQLUSA Word 9 08-01-2012 05:41 PM
Checking n cells above's content hanvyj Excel 4 03-22-2012 03:58 AM
Checking Gender Grammar checking isssue mahenn45 Word 1 03-01-2012 01:05 AM
Checking Gender Help with checking available times Deepy Excel 1 02-14-2011 05:06 PM
Checking for DOS executions ajetrumpet Excel 0 12-06-2009 02:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft