Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 51
Search took 0.01 seconds.
Search: Posts Made By: kilroyscarnival
Forum: Excel 10-15-2019, 10:59 AM
Replies: 3
Views: 202
Posted By kilroyscarnival
Re: Update Cells from Another Workbook

Did you ever sort this out?

I'd think that the easiest way to do this is to take your existing Worksheet A and upload it to the database, assuming the columns that both datasets have in common are...
Forum: Excel 08-13-2019, 10:06 AM
Replies: 2
Views: 293
Posted By kilroyscarnival
Re: Getting image in Excel header to center/fit as background letterhead

Ah, I forgot to say -- it's Excel 2010. Yes, I do have those features, but though I did have hope for the check-boxes for "Scale with Document" and "Align with Page Margins," I tried those in every...
Forum: Excel 08-13-2019, 06:04 AM
Replies: 2
Views: 293
Posted By kilroyscarnival
Getting image in Excel header to center/fit as background letterhead

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...
Forum: Excel 07-25-2019, 05:09 AM
Replies: 2
Views: 319
Posted By kilroyscarnival
Re: Top 10 Pivot Table

Did you find a solution? I see Uncle Gizmo gave you some good links but those all seem to be MS Access solutions. If you have Microsoft Access as part of your Office suite, that's probably going to...
Forum: Word 07-23-2019, 09:17 AM
Replies: 5
Views: 4,370
Posted By kilroyscarnival
Re: Generating a series of tables-as-forms

Just wanted to update to say that this setup actually worked really well using Mail Merge to transfer a lot of information in and create as many tables as needed for the full report. The only...
Forum: Word 05-30-2019, 01:40 PM
Replies: 4
Views: 250
Posted By kilroyscarnival
Re: Pictures Default Layout in Word

That's where I'd start - even if the table is just a one-cell one. They'd want to go in and turn off the feature where the table automatically resizes to contents though.

Another possibility, or...
Forum: Word 05-30-2019, 01:31 PM
Replies: 5
Views: 4,370
Posted By kilroyscarnival
Re: Generating a series of tables-as-forms

Oh, sorry, by "report" I meant the series of tables will be added to a Word document we term a report. It's not a report in the sense of MS Access. I actually wish I could use Access for some...
Forum: Word 05-30-2019, 12:47 PM
Replies: 5
Views: 4,370
Posted By kilroyscarnival
Generating a series of tables-as-forms

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...
Forum: Excel 05-21-2019, 09:37 AM
Replies: 4
Views: 343
Posted By kilroyscarnival
Re: auto number with duplicate -first-last bench

To populate the answer to "First Bench in all school" and "last bench in all school",

For School 1
=MIN(D$3:D$10)
should yield the lowest number bench
=MAX(D$3:D$10)
should yield the highest...
Forum: Excel 05-21-2019, 09:33 AM
Replies: 4
Views: 343
Posted By kilroyscarnival
Re: auto number with duplicate -first-last bench

SECOND REQUEST column: You want to copy over the number from "First Request" (you'll want to check your spelling on "first", by the way).

The way I would do this with a formula is put your cursor...
Forum: Word 05-13-2019, 04:29 AM
Replies: 9
Views: 482
Posted By kilroyscarnival
Re: Customizing ribbon and QAT on a shared work computer

I should note that this may differ depending on how the overall system is set up, but as long as people have independent user log-ins and separate folders set up, I'm guessing these changes reside...
Forum: Word 05-10-2019, 11:18 AM
Replies: 9
Views: 482
Posted By kilroyscarnival
Re: Customizing ribbon and QAT on a shared work computer

So the answer seems to be, it's user specific.

I got to stretch my legs AND check on it.

Her QAT doesn't reflect the items I added, and her Insert Header doesn't have our letterhead options in...
Forum: Word 05-10-2019, 11:00 AM
Replies: 9
Views: 482
Posted By kilroyscarnival
Re: Customizing ribbon and QAT on a shared work computer

I know that's true about general Windows settings, but not sure how it works within Office toolbars, etc.

I did make some changes to the Building Blocks (added our letterhead headers and...
Forum: Word 05-10-2019, 04:57 AM
Replies: 9
Views: 482
Posted By kilroyscarnival
Re: Customizing ribbon and QAT on a shared work computer

Hmm, I think I'm going to tread lightly then. I suppose I could just try to work around it, and only temporarily add what I like. Most of the time I'm revising reports someone else has made from a...
Forum: Word 05-09-2019, 10:01 AM
Replies: 9
Views: 482
Posted By kilroyscarnival
Customizing ribbon and QAT on a shared work computer

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...
Forum: Word 05-03-2019, 07:26 AM
Replies: 2
Views: 187
Posted By kilroyscarnival
Re: Identical font, different appearance in table

Update: gave up the idea of text boxed text, replaced with regular text and added a gray highlighter which essentially does all I'd needed for now. I'd ultimately like to protect that text, but will...
Forum: Word 05-03-2019, 05:12 AM
Replies: 2
Views: 187
Posted By kilroyscarnival
Re: Identical font, different appearance in table

Here's what I tried:

Changed whole table to a different font (TNR): the difference in thickness was still apparent.

Unbolded the text box headers (INTERVIEW INFORMATION and PUBLIC RECORDS in...
Forum: Word 05-03-2019, 05:00 AM
Replies: 2
Views: 187
Posted By kilroyscarnival
Identical font, different appearance in table

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...
Forum: General 05-11-2017, 08:47 AM
Replies: 16
Views: 5,402
Posted By kilroyscarnival
Re: Publishing access database on web, how and which way is the best?

This is probably a dumb question, but has Access 2016 changed the game on creating a web-usable app? I ask this because I finally upgraded to Office 2016 recently at home, and they offer, under "New"...
Forum: Excel 12-30-2008, 01:30 PM
Replies: 7
Views: 1,440
Posted By kilroyscarnival
Re: Column width issue

With embarrassment I admit I have forgotten how to do this.
Forum: Excel 12-29-2008, 01:59 PM
Replies: 7
Views: 1,440
Posted By kilroyscarnival
Re: Column width issue

Nice! It was the merging, but I'll keep this in mind for something else. Thanks!
Forum: Excel 12-29-2008, 01:59 PM
Replies: 7
Views: 1,440
Posted By kilroyscarnival
Re: Column width issue

That is exactly IT, thanks. I had received an Email of your earlier post, but was training an intern today and hadn't gotten back to it, but it occurred to me that it MUST be related to the merged...
Forum: Excel 12-26-2008, 06:39 AM
Replies: 7
Views: 1,440
Posted By kilroyscarnival
Column width issue

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...
Forum: The Watercooler 06-24-2008, 11:38 AM
Replies: 8
Views: 1,336
Posted By kilroyscarnival
Thank you all for your thoughts and advice....

Thank you all for your thoughts and advice. There's a lot here to consider. I also asked my IT manager in-house, off the record, when we were discussing the recent job eliminations and so forth. He...
Forum: The Watercooler 06-22-2008, 07:46 PM
Replies: 8
Views: 1,336
Posted By kilroyscarnival
Question Career question

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...
Showing results 1 to 25 of 51

 
Forum Jump



All times are GMT -8. The time now is 12:37 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World