Search results for query: *

I have a long document in Word 2010 with various footers that need to change based on a name put in one of the headers in the document. So I inserted a bookmark for the text in the header and then inserted cross reference to the bookmark in all the various footers(different sections). Anyway, I...

Help! I am copying/pasting formatted text from one document to another and it doesn't keep the exact formatting. (it keeps some but things like the bullets change.) I have tried everything. I use paste special of course and I have checked all the copy/paste settings under word options. I've...

I feel like I should know this but I can't figure out what I am doing wrong. I ran this query asking for only records where the name field contains the word in the keywords1 field. But when I view the results, there are many records that do not have the keyword anywhere in the name. I have...

Not sure what I did wrong, but I created a fillable form in Word 2010 with just some text fields. But when I protect the form, the fields only allow one character to be typed in. I cannot find a property anywhere that tells me how to set the character length. Can you help me? Thank You, Dawn

Hi there, I really need help on this asap. I created a report in Access 2010. It's a listing of contact information, name, address, phone, email, etc. Since everyone doesn't have every piece of info, I have the fields shrink if the field is blank. Some cases it shrinks and some it does not. So I...

I often have trouble with totals queries. So I start with just one field at a time to make sure I am doing it right. I have a data field (say company name) I am grouping by, and then a date field. I want to see the records with the most recent date. So I group by company and sort descending by...

I am trying to merge multiple cells/ranges from multiple worksheets into one spreadsheet. This is the code I found and used, and even though I specified all the cells in the set source range code (about 1/2 way down), it only brought in the first cell C4. Here is the code. Can anyone guide me on...

With the help of google I created this module to merge multiple Excel files into one file. Only problem is, it creates a new sheet for each file. Can someone tell me how to edit this code so that it merges into one single spreadsheet? (all files are same number of columns with same headings). I...

I am using Outlook 2010 and cannot seem to get the grouping feature to work properly. In previous versions if I grouped by category, I could see ALL contacts in a particular category. What it is doing now is grouping together contacts that have the same set of categories. Like if 10 people are...

So, I have 3 fields, Zip Code, State, and Age. I want to show the top 1/3 records for EACH State based on age. In other words, if there are 99 CA records, I want the results to show the top 33 oldest according to the age field. I know how to set the properties of the query to show the top 1/3...

Has anyone seen any kind of dupe removal program for Access (2010)? I was trying out some code someone wrote for me for a 2003 database that would find all the dupes in one table and update the child table with the ID of the dupe records that were replacing the records being deleted. But it...

Hi All, I was trying to append some records to a table and got the Key Violations error message. Upon investigating, I discovered that a new record added to the table creates a duplicate number in the autonumber field (which is set as the primary key, not to allow duplicates.) I have never seen...

Hi All, I know how to set it up to open a form from a button on another form and to either have it open to all records or a specific record. What I can't figure out is how to tell it to open to a NEW record. I have Access 2010 where it defaults to the macro when setting up a button. Thanks!!!

Hi all, I have a combo box that is used as the criteria to open a form.(form is filtered based on what event the user picks in the combo box before clicking open.) How do I put the TEXT from the combo box into a label in the form header??? (I want to be able to see clearly what even it is while...

Hi All, I have a repeated task in Excel 2010 that I would like to automate. I often have to change the columns around to the same order as another spreadsheet so that I can merge the lists together into one worksheet. For instance, "Company" is always in column A, "Name" is always in Column B...

Hi everyone, I have a crazy issue that I can't find answers for on the internet and customer service is closed today. My client has ACT!Premium 2010 and Word 2003. When I edit ACT! templates for them (using Word) occasionally I am not able to merge them, instead getting a message "The Variable...

Please refresh my memory. When I am searching/filtering for blanks in Access and there are still blanks showing what other type of blank can I search for besides NULL and "" (empty string)? (and I am certain they don't have a space in them, I checked for those too.) Thanks Dawn

Hi All, I am having trouble with finding and replacing numbers in a query. I need to remove all numbers from a particular field. I can do it manually in the table by finding # and replacing with "" but when I do it in the query it throws up an error about an invalid date value. This is what I...

hi All, I need to write a query that counts the characters in a field. Really I need to be able to say what I need it to do if there is just one character. So, IIF([FieldName]=1 character, then...and so on. Thanks for any help, Dawn

hi Everyone, Ok, I recently installed Access 2010 and am trying to run a process that was created in Access 2003 and am getting an error now. The process is this: Basically, I click a button, and the data in one of the tables is uploaded to a local copy and then to another copy on someone's...