Search results

by cellpointer are you referring to the active/selected cell? assuming the above is accurate, you want your selected cell to simply be formatted differently only while it is selected (go back to 'normal' formatting when another cell is selected) ??? I'm not versed well enough in VBA to...

which version of MS Word are you using? Utilizing the Form Controls may be helpful... it wont pop-up and ask for particular data (perhaps it could..?) but if you have lets say only 5 things in the entire document that will change (name, address, price, etc...) you can use a Form Control -Text...

Form Controls: Have to enable the Developer Ribbon first for this ribbon to show up. Once that Ribbon is available, find the "Control" group; there you will see all kinds of form controls (check boxes, drop down lists, text boxes, etc...). Hope this helps!

are you trying to use the records from your Access table (like an receipent address list?) for the word document? what options are you given when the 'error' occurs?

MS Word 2007 saves their files in a different format than MS Word 2003. So much so that if you take a 2007 version document and try to open it on a computer that does not have 2007 (or 2010), the computer will not even recognize the file as a Word document (unless that patch is installed as John...

HOLY COW, I THINK THAT WORKS!!!!!!!!!!! I'll have to run a few tests to make sure, but first glance looks perfect!!! 1000000 THANKS TO YOU!!!

A "job" can have lets say 8 Activities. One of those Activities will contain the Cat #'s needed. The current Query just pulls out those steps that have the Cat#. so if Step 2 is a Gather Material step with the Cat # and Step 3 is the next step, step 3 doesnt get included because it doesnt have...

Ok, so im not sure if this is the best place to put this... so if its not, mods can move as they see fit. I have this (and many many others) report that I use several times a day depending and need some help. DISCLAIMERS: 1) I'm no SQL expert (more of a newb) 2) this was created by someone...

You lost me with the code...sorry, not familiar with vba.

are you useing the MailMerge Feature in Word? im not sure i follow what you mean by "After I enter template, signature etc. in Access I can save them, Word opens but the file does not open" ? I assume you have a list of addressed stored in a Access tbl, yes? and you want to generate a...

what steps do you go through to insert the pictures into the spreadsheet now?

if youre not familiar with VBA, start this in MS word with the MailMerge tool. here is a post i made a little bit ago explaining to someone else how to setup the word mailmerge doc for thier needs, should be fairly similar for you. ei: rather than selecting recepients from an excel spreadsheet...

Im going to echo what has been said in regards to row labels............... i havent come across any other 'solution'. but you've got my wheels spinning, so if i dig something up, i'll let you know.

Im not sure what version of word/excel you have, but if its 07 or 10 you can use more than 3 conditional formats. (just make sure that when you are inserting the Excel spreadsheet (Insert-Object) you select the 07/10 option and not the 03 format spreadsheet option (this will limit you to the...

Re: Problem with Multiple IF Condiction im not sure im understanding exactly what you're going for: are you wanting a user to select a name from Column A and a model from B and that given total to be displayed? or the total for all occurances of that combination? can you give more details?

Funny Story: I created something similar for my HR department for the Onboarding of new associates... then found out that we are changing our (brand new) Onboarding process. (bye=bye days (if not weeks) of time I'll never get back! hahaha on the bright side, I did learn things about Excel...

...what are you trying to accomplish with this Pop-up Box?

Im not sure if this is what you're looking for.... but here's what i did ~~~All of this "MATH" can technically be skipped if you're just after a chart: if so, just skip down.~~~ Not sure if this will make sense but from 8/6/12 to 8/16/12 10 days had passed and a total of 8k units were used...

Thank you, Bob, for the link!

....:eek:.....wha...what was that!? HAHAHAHAHA I tried to send you a private message but couldnt find the option. can you further explain the front end and back end, and the how-to's?