Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-25-2012, 10:28 AM
Mrkieth Mrkieth is offline Link word check box to access check box Windows 7 32bit Link word check box to access check box Office 2007
Novice
Link word check box to access check box
 
Join Date: Jan 2012
Location: Toledo, OH
Posts: 5
Mrkieth is on a distinguished road
Default Link word check box to access check box


Afternoon Users,

Is there any way to link a word to access? I'm trying to click on a check box in word and it populates in an access check box.

Can this be done?


Thanks in advance.
Reply With Quote
  #2  
Old 01-26-2012, 06:36 PM
macropod's Avatar
macropod macropod is offline Link word check box to access check box Windows 7 64bit Link word check box to access check box 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

Hi Mrkeith,

Yes, that can be done, but it requires vba code attached to the checkbox in Word that starts Access, opens the database file, selects the required record or whatever, then updates the Access checkbox. This requires considerable code just for error-checking (eg is Access already running, is the database already open), quite apart from the code that actually does the work.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-27-2012, 07:43 AM
Mrkieth Mrkieth is offline Link word check box to access check box Windows 7 32bit Link word check box to access check box Office 2007
Novice
Link word check box to access check box
 
Join Date: Jan 2012
Location: Toledo, OH
Posts: 5
Mrkieth is on a distinguished road
Default

Thanks for answering back. I'm not comfortable with VBA. I'm not a coder. But yes access is running. Is there anything else you could help me with to get this going?
Reply With Quote
  #4  
Old 01-27-2012, 02:39 PM
macropod's Avatar
macropod macropod is offline Link word check box to access check box Windows 7 64bit Link word check box to access check box 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

Hi Mrkeith,

The only thing I can add is that it's far easier to update a Word document from Access than to update a field in a particular Access record from Word.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 01-30-2012, 06:43 AM
Mrkieth Mrkieth is offline Link word check box to access check box Windows 7 32bit Link word check box to access check box Office 2007
Novice
Link word check box to access check box
 
Join Date: Jan 2012
Location: Toledo, OH
Posts: 5
Mrkieth is on a distinguished road
Default

Thanks macropod for all your help. I'll continue to research some for the solution i'm looking for.

Thanks again.
Reply With Quote
Reply

Tags
check box

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link word check box to access check box How do I make a check box in a text box in Word? VSCD Word 2 06-15-2011 10:09 AM
Spell Check issue with Word 2003 cdubya Word 1 11-12-2010 06:48 PM
Link 2 form items (for ex check box and a text box) dzn Word 0 07-19-2010 01:58 AM
Check Box in Word serayam Word 1 11-06-2008 06:45 AM
Spelling check in Word 2007 iskndarbey Word 0 02-25-2008 01:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:38 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