Avatar of jaymz69
jaymz69

asked on 

Add a macro to open a form in word

On my Switchboard how can I program a macro or something to click on and it will open a my word templete for a form to fill out and then update my database with the info when I close it.

Microsoft Access

Avatar of undefined
Last Comment
jaymz69
Avatar of Boris Petrovic
Boris Petrovic
Flag of Croatia image

Would you consider making an Access form for getting the data, and then automatically fill the form in Word, or even easier, to create a report just like that form?
Avatar of jaymz69
jaymz69

ASKER

Anything to make the user friendly and easy while still updating the database
ASKER CERTIFIED SOLUTION
Avatar of Boris Petrovic
Boris Petrovic
Flag of Croatia image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of jjafferr
jjafferr
Flag of Oman image

jaymz69 have 2 Qs for the same concept:
https://www.experts-exchange.com/questions/23578207/Add-a-macro-to-open-a-form-in-word.html
https://www.experts-exchange.com/questions/23576588/Start-Access-App-but-use-a-Word-form-to-send-to-database.html

In both, the same recommendations were given,
but the author didn't come back with further questions or ask for details.

I therefore don't think these Qs are eligible for PAQ/Refund OR Delete/Refund.

jaffer
Avatar of jjafferr
jjafferr
Flag of Oman image

Vee_Mod

Thanks for jumping in, much appreciated :)

I propose accepting the solution from:
http:#a22040282

jaffer
Avatar of jaymz69
jaymz69

ASKER

OK, thanks
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo