Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

OleCarl (TechnicalUser)
26 Jan 12 16:47
I would like to make a simple MS Word 2007 Template that does the following:
1) Based on a Test data form, I would like to jump sequentially from field to field based on pressing the "enter" key at end of data entry.

2) The data field entry sequence would be as follows:
1st) Product Serial Number (4 numeric only digits).
2nd) Program name (text and numerals).
3rd) Test date (todays date locked to the form being entered).
4th) Check boxes for verifying correct communications received.

If I could see the proper format for doing the data field sequence I believe I could take it from there.

Thank You VERY much for any help provided!
Helpful Member!  SkipVought (Programmer)
26 Jan 12 16:54


hi,

I'm a tad biased, but if it were me, Excel would seem a better tool for doing what you have described.

But have you looked at FormFields in Word Help?

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

OleCarl (TechnicalUser)
26 Jan 12 17:12
The forms I want to automate are all in MS Word 2007.
They have been released to the customers and it wouldn't be easy to make the forms different (many, many hoops to jump thru!!).

I have looked quite a bit but haven't seen anything that does this job.

Thanks for your reply,

OleCarl
SkipVought (Programmer)
26 Jan 12 17:15


Did you check Word Help for FormField as I suggested?

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

OleCarl (TechnicalUser)
26 Jan 12 17:28
Yes, I have checked all the MS Help categories I can think of and Googled them as well.

It seems like it shouldn't be this hard to do a simple form automation!

Thanks for your reply...
OleCarl (TechnicalUser)
1 Mar 12 9:12
Ok, I give up...if Excel is the best way to do it then let's use Excel.

Thanks in advance for any help provided...
SkipVought (Programmer)
1 Mar 12 9:32



You can accomplish the " jump sequentially from field to field based on pressing the "enter" key at end of data entry" in Excel, by

1. SELECT all cells > right-click > select > FORMAT CELLS -- Protection TAB -- Check LOCKED.

2. SELECT each cell OR the RANGE of cells that you will "jump" to, in order to enter data.  On the Protextion TAB -- UNcheck LOCKED.

3. Ribbon Tab REVIEW > Changes > Protect Sheet and choose how you want to protect your sheet.

NOW as you enter data, your selection will "jump" to the next entry cell.
 

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

OleCarl (TechnicalUser)
2 Mar 12 10:03
Thanks Skip, I'll give that a try ASAP...

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close