Search results for query: *

Skip, Thanks for pointing me to the FAQ. That would have worked as well and I may end up going that direction. Maintaining the named ranges could become cumbersome. Yes, it was bad table design. I inherited this project from someone else who said - "Here's the journal entry repository...

Thanks for the suggestion ck. I ended up using some code that copied and pasted the entire range where I wanted it, but your answer got me thinking in the right direction.

I've been at this all day and could really use some fresh eyes. I'm trying to create an automated journal entry form for our accounting department. I have a sheet populated with 20 different standard journal entries. All are identified by a number and include 2 columns: 1-description...

I'm not sure if this would work, but maybe you could set up the page footer with the note you want and set the report properties to Page Footer - Not with Report Footer. Then you could have a Report Footer that's blank. That way your Page Footer wouldn't show up on the last page.

Awesome-star for you! Thank you so much - I'm really going to win some points with my boss for this one. I'm assuming if I want the e-mail to be sent when the worksheet is closed, I can just change auto_open to auto_close.

Does anyone know if it's possible to send an e-mail alert when a number on an Excel spreadsheet reaches a certain amount? It would be used in the following type of example: the bookkeeper keeps track of daily cash balances. If the balance in a cell is less than 100,000, I would want an e-mail...

Tom, Thanks for the input. I'm going to try it. I never thought about turning it temporarily back on, but I imagine that would work. Meghan

Hello, For a long time now I've been dealing with problem of Access 2000 reports reverting back to the default print settings when I've set them to print on Legal Paper, Landscape view. I've read about the bug in Access that causes this with one of the suggested solutions being to uncheck all...

FancyPrairie - thanks for all of your efforts. One quirk to this database is that everytime our export runs from the other software program, it deletes all existing tables and replaces them, even ones that have been created in Access and not by the export. So I don't think any additional...

Fancy Prairie - I've already created the shortcut. My problem is being able to hide the database window from being viewed once the user clicks on their shortcut (since this will not be the default switchboard upon opening the database) bergers - seems a little complicated for me (I learned...

I forgot to mention that I'd rather not use Access security if I can get away with it. This database is an export (that I did not design) from a Microsoft Outlook based CRM program that we have implemented. The built-in reporting that is part of the software program is not very robust, so they...

Hello, This seems like it should be simple, but maybe I'm not looking in the right place. I have an Access 2000 database located on a shared drive that everyone in the company can use. Users only need to run reports that I have already created. I currently have a Main Switchboard that runs on...

Thanks - this gave me just the name I needed in that field.

There are 2 tables with the following fields: Table 1-Company, Industry, Description Table 2-Company, Contact Name, Contact Role The Contact Role field contains many criteria, separated by semi-colons. For example, one person could be all of the following: (co-investor;attorney;referred by)...

I gave this a try. It's only giving me the companies that have an attorney rather than listing all companies. I'm not sure this is possible.

I can assume that each company only has one attorney. How would I go about consolidating down? I'm pretty new at all this stuff, so bear with me! Thanks

I'm trying to develop a report using data imported from Outlook based software. The report will have a list of companies down the page with various related data (# of employees, description, industry, etc.) across. In the last column for each company I want to include the name of the company's...

I'm trying to develop a report using data imported from Outlook based software. The report will have a list of companies down the page with various related data (# of employees, description, industry, etc.) across. In the last column for each company I want to include the name of the company's...