Search results

I tend to work on other people's documents, and some are made using old templates or editing old reports. I use Styles a lot, whereas in the past they weren't always used. I've been using headings 1-5 regularly, but in order to get them into the Styles pane, I have to go into Manage Styles and...

Recently we upgraded to Office 365 and I'm slowly exploring what's new in it. (Excited about the XLOOKUP and FILTER options!) I've been tasked with creating some dynamic (interactive) charts with bulk amounts of Excel data (upwards of 1,000, perhaps sometimes 10,000 rows, and multiple columns...

I'm using Word 2010, though I'm pretty sure there are others in my office using a newer version of Office. I'm trying to streamline some old document templates to eliminate mistakes, formatting issues, etc. One thing is that some items get placed several places within the document: 1) title...

Yesterday we got hit with a virus at work. Our IT provider took care of everything and most of our files are just fine. However, one item that won't open is a shared Excel workbook with our shared input on our reports and tasks for this week. It would be a pain to have to have everyone...

Hello all, At the office we have Acrobat X/XI (varies by desk) and Reader. I don't think anyone has Pro or DC. I'm looking for a relatively easy way to take an old (literal) rubber stamp and make it fillable as a form to be stamped into an existing document. I've watched some tutorials on...

I was sent a problem sheet to try to fix it. It's a simple spreadsheet used as a rundown of fees, and apparently the user wanted our "second sheet" letterhead as a background. I'm attaching a snip of how it looks in Print Preview - with the letterhead image starting about .7 inch to the right...

Me again. I've been asked to try to sort a way to get a lot of complex information into a report, where previously a table was on one page and a photo on the following. After a series of back-and-forth drafts, I've come up with each record going into a 1 x 3 table format, where the first...

At lunchtime, I cover the front desk in my office and log in as myself on the receptionist's computer, taking whatever desk work I can with me. If I want to replicate some of my custom ribbon features, and Quick Access Toolbar, on her computer, those are user-specific, aren't they? When she...

Hello all! I'm hoping someone can explain or commiserate. I'm roughing out some tables to be used for a rather busy set of data, so I made a table and added some controls to help automate it (autonumbering, some combo boxes, etc.) Because I have a lot of data to try to get onto each...

Happy holidays, everyone! I've written a simple macro to do some autoformatting of an Excel spreadsheet. When I reduce to 100% zoom, I want to widen every third column so the contents display fully. Range("D:D,G:G,J:J,M:M,P:P,S:S,V:V,Y:Y").Select Selection.ColumnWidth = 2.1 When I run...

Hello! I've visited the forums in the past to find information to help me out of a jam in Access or Excel, and have always found it very helpful. I'm a research director for local television stations in the U.S. When I started doing this work over 10 years ago, it seemed like there were always...

This is probably something so obvious I'm hitting myself on the head in advance. Any idea why the button to "send worksheet as attachment" is not available in all workbooks lately? It always worked before. I checked Tools/Options but didn't see a setting for it. Thanks! -- Ann

I have tried just adding the *&* to the query or or filter criteria, but it seems to parse it to "*" & "*". I have a list of television programs and wanted to be able to filter out the sports events, most of which are listed as "METS&CUBS" and so forth. I suppose I could do this manually in...

I'm hoping to replace a manual text-add process in Excel to an update query in Access. I have one table of data (tracking ratings of TV programmes) with a date field. I have another table of data with the start dates and stop dates of TV ratings "sweep" periods (U.S.). In the past, I would...

This has been driving me crazy! I'm trying to add data to an existing table. First I tried my usual, importing data from Excel and adding to the existing table. The field names are identical. But I got an error that they couldn't be added due to violation of the validation rules. So I imported...

Does this happen to anyone else here? I've pulled some data into Excel from other software. The column headers are made the same as in my existing Access table. I set my print area, save the Excel workbook, close, and then try to import in Access. And the import dialogue won't recognize my...

When I enter Access either by opening a database file or by opening the program by its desktop icon, I continue to get an error message saying: Microsoft Access can't change the working directory to Y:\database. Verify that the drive is valid and the path is 260 characters or less in length."...

I built the darn switchboard to simplify for a coworker's use! And though it appears fine on my PC, on hers it not only won't auto-open, it won't open at all. The piece of code highlighted as the problem is triple-bracketed below {{{ }}}: ' Open the table of Switchboard Items, and find '...

I have a message box popping up before my macro runs. I would like to modify that to give the user a choice to cancel. In other words, two option buttons, one saying "OK" and the other "CANCEL". I'm enough of a beginner to be clueless as to how to do this. Can I do it in a Macro or will I have...

I hope I can explain this properly. I'm trying to come up with a way to take a list of items with exact times and match them up with another list of items containing a start and stop time. Specifically, a TV ad is broadcast 1/1/2002 at 17:57, and I want Access to assign the record from another...