I found the answer: after inserting merged fields; Alt F9 to show the merged fields; in the merged fields, a person needs to use switches. A person could search for help on more information. My example was {MERGEFIELD DATE \@ "dddd, MMMM d, yyyy"}
will display Wednesday, July 6, 2002
I've created a table where a date field is set up as short date and an input mask is entered. I then created a query where I changed the date format to long date (it suited my purpose better). I ran the query and everything is as it should be. However, when I merge this long date into a word...
Originally, I printed the VBA from this site. I tried coping and pasting the VBA into Word. Low and behold, there was one important line that was left out: Next Cell. All is fixed and running perfectly. - Thanks!
euskadi - First, thanks for the instruction - I'm further ahead today than I was yesterday. However, I'm still stuck. I'm getting an "EndIf without Block if" message. I've tried any number of things to figure it out - but can't. Any hints?
I've created an Excel spreadsheet with various data (a checklist of sorts). One column in the spreadsheet will have a date that a contract needs to be returned to our office. I would like to be able to have a message box alert us to the fact that a contract is not back within the specified...
Hi! I'm intrigued by Visual Basic and would like to learn more. Is this something that a book can teach or should I consider attending a class? If a book can do the trick, can someone suggest one. - Thanks!!
I am trying to create alpha buttons on a form that will allow me to click on a letter and will be advanced to the first last name with that corresponding letter. My form consists of two tabs: Company Info and Personal Info (the last name will appear on the first tab only). Nothing I seem to do...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.