You are here:
| Subject | Date Asked | Expert |
| Calculation in MS Access | 7/13/2009 | Scottgem |
| Q: how do I calculate the Diff of Current Date and a date in the field? E.g. 2009(Current ... A: Use the DateDiff function. You can do it in either a form (seting the Controlsource to the DateDiff ... | ||
| MS Access 2007 | 7/9/2009 | Scottgem |
| Q: I just started using Access 2007 a couple of months. My question is: how do I make the blank page ... A: Depends on how you want the app to work. Generally, forms are loaded from a menu system like a ... | ||
| choosing an optimizable domain name | 6/26/2009 | Scottgem |
| Q: Let's say I just designed a website. I want a domain name for my blog or website that really fits ... A: Not a clue. A "best fit" name for a domain is whatever you want. I don't believe any software can ... | ||
| Project Management Software | 6/2/2009 | Scottgem |
| Q: I have been promoted at the company I work at and one of my responsibilities is to manage the ... A: The main difference is that Professional can be integrated with a server and the WEB to allow for ... | ||
| Investor relations management | 4/30/2009 | Scottgem |
| Q: Scott, are you aware of any shareware to manage an investor base? We have just over 300 investors, ... A: I haven't heard (and couldn't find in a brief search) shareware that specialized. There are plenty ... | ||
| Software for certifications / diplomas / invoices | 4/27/2009 | Scottgem |
| Q: Is there a software that helps creating cards (certification cards), diplomas, invoices, etc.? ... A: There are several that do this. Microsoft Publisher can definitely do it and print from a list of ... | ||
| how intelligent a business software can be | 4/20/2009 | Scottgem |
| Q: scottgem, i am munsif ali, commerce graduate from pakistan. i have come across many websites, some ... A: There are dozens. Any accounting software can perform calculations. Any banking software can be set ... | ||
| AutoResponder | 4/13/2009 | Scottgem |
| Q: I bought an Autoresponder a little while ago, the type that runs on your own worktop.Since then I ... A: Um that's not what an A/R is. An A/R resonds to received e-mails. Sophisticated A/Rs can scan the ... | ||
| Using VBA in Access to create code that will run in Adobe | 4/9/2009 | Scottgem |
| Q: I have a report that I have generated in Access. this report is created to disperse information via ... A: Ok, so if I understand you, you are using a PDF to display the information entered for a new ... | ||
| Using VBA in Access to create code that will run in Adobe | 4/9/2009 | Scottgem |
| Q: I have a report that I have generated in Access. this report is created to disperse information via ... A: I don't think you can control a PDF file from within Access. But I'm really not clear what you are ... | ||
| Can the fields in Pivot table be locked -- Ms Access | 3/30/2009 | Scottgem |
| Q: I want to create a Pivot table where users can filter records from the drop down but I don not want ... A: I couldn't find any way of doing this. What I can suggest is that you use the On Close event or your ... | ||
| Can the fields in Pivot table be locked -- Ms Access | 3/30/2009 | Scottgem |
| Q: I want to create a Pivot table where users can filter records from the drop down but I don not want ... A: You can have them apply criteria to a query that will be used as the source of the Pivot. then ... | ||
| Installing Microsoft Office | 3/24/2009 | Scottgem |
| Q: From: I recently installed a larger Hard Disk in my computer and transferred all programs from the ... A: You can't copy programs from one drive to another. The install routines have to be run because they ... | ||
| Access Survey setup | 3/19/2009 | Scottgem |
| Q: Okay, I'm too on the "artistic" side to really get my head around the db structure for surveys. I ... A: OK, Since this is a survey that has no right and wrong answers you don't need tblAnswers. Also, the ... | ||
| Access VBA Code | 3/12/2009 | Scottgem |
| Q: You told me the following yesterday following my question about workgroups: "As for workgroup ... A: Ahh, I assumed you were only entering Title. I'm pretty sure I can come up with a solution, but I ... | ||
| Access VBA Code | 3/12/2009 | Scottgem |
| Q: You told me the following yesterday following my question about workgroups: "As for workgroup ... A: Did you try my code? I don't get that when I use it. The reason for that message is Access isn't ... | ||
| Printing a filtered datasheet | 3/11/2009 | Scottgem |
| Q: In an Access 2007 database, is there a simple way in VBA to determine a (subform) datasheet's data ... A: If there is a filter being applied to a subform, you can use the Filter property in the OpenReport ... | ||
| Access VBA Code | 3/11/2009 | Scottgem |
| Q: You told me the following yesterday following my question about workgroups: "As for workgroup ... A: First, Access is, by default and design, a multi-user application. Workgroups have nothing to do ... | ||
| Javelin | 3/3/2009 | Scottgem |
| Q: Did you say you wanted a copy of Javelin Plus? Email me and we'll get you one. A: No thanks ------------------------------ Excuse me? You made a nice offer, but I really don't have ... | ||
| Video Rental Software (Filmrent) | 2/25/2009 | Scottgem |
| Q: I've got a video rental program which works perfectly except for one thing. When I try to add new ... A: From the look of your screenshot this is an old program probably written original for DOS. If you ... | ||
| converting scanned docs | 2/17/2009 | Scottgem |
| Q: What is a program that will convert scanned documents into wordperfect format? A: Any OCR (Optical Character Reader) software. OmniPro is one, there are a number of others. OCR is ... | ||
| pdf highlighter | 1/29/2009 | Scottgem |
| Q: I am trying to find some inexpensive software that simply allows me to use a yellow highlighter on ... A: I believe Paperport from Nuance has these features. Hope this helps Scott<> First, only Paperport ... | ||
| Modifying Lebans PDF Converter | 1/6/2009 | Scottgem |
| Q: I am trying to use Lebans code for converting a report to PDF format. In his sample database he has ... A: OK, if you don't need to select from a list then just substitute the3 report name for Me.lstRptName ... | ||
| Excel duplicate finder | 1/2/2009 | Arthur Naman |
| Q: I want free software for checking duplicate words in Excel (Deduplication check Software). I have ... A: The key to the answer to your question is in the last sentence of your" ... my database of 50 ... | ||
| Excel duplicate finder | 1/2/2009 | Scottgem |
| Q: I want free software for checking duplicate words in Excel (Deduplication check Software). I have ... A: I do not know of any free software that will check for duplications in an Excel sheet. They may ... | ||
| Modifying Lebans PDF Converter | 12/30/2008 | Scottgem |
| Q: I am trying to use Lebans code for converting a report to PDF format. In his sample database he has ... A: First, you aren't really modifying Stephan's code, all you should be doing is supplying your own ... | ||
| shopping cart | 12/11/2008 | Scottgem |
| Q: how u doing? im now building my own website by myself which if for buying few baby clothes, i wonder ... A: That's not what you asked nor did you tell us what research you had done. But like I said, the ... | ||
| shopping cart | 12/11/2008 | Scottgem |
| Q: how u doing? im now building my own website by myself which if for buying few baby clothes, i wonder ... A: There are loads of shopping cart applets available. Your web host service may have one. Or just ... | ||
| Ms access password | 12/11/2008 | Scottgem |
| Q: I am using ms access 2007 and while I want to open any file or even creating new databases, the ... A: I just double checked and I can't see anything that would require a login when just loading Access. ... | ||
| Ms access password | 12/10/2008 | Scottgem |
| Q: I am using ms access 2007 and while I want to open any file or even creating new databases, the ... A: Are you using MDB or accdb files? Security doesn't work with ACCDB files, so if you are using that ... | ||
| Milage by State | 12/2/2008 | Scottgem |
| Q: I am looking for a program that you can key in the the cities you travel to by car from place to ... A: I don't know of any software that will break it down like that. I do know that Delorme's Street ... | ||
| 11/18/2008 | Scottgem | |
| Q: I just read the Wikipedia article on PDF without learning what it is, how to use it, why anyone ... A: I just took a look at that article and I can see where it might be a little confusing. Think of it ... | ||
| MS- Access - Isolate a record in a report | 11/11/2008 | Scottgem |
| Q: Scott, Please see my attached image. Once I've ran a report in MS Access, is there a way to filter ... A: Again, it depends on how you run the report. I need to know that to advise. Hope this helps, ... | ||
| MS- Access - Isolate a record in a report | 11/10/2008 | Scottgem |
| Q: Scott, Please see my attached image. Once I've ran a report in MS Access, is there a way to filter ... A: You can't do this from the report. But you can go back to how you run the report to apply a filter. ... | ||
| New Program | 11/10/2008 | Scottgem |
| Q: Consider this scenario. My nephew is a programmer for a company that manages large investment ... A: I would go to the software manager's supervisor or the highest level manager he can find, maybe even ... | ||
| Microsoft Access Find Duplicates Query | 10/30/2008 | Scottgem |
| Q: Scott, I send out an eNewsletter for my business and track what links my subscribers are clicking on ... A: Ok, I suspected that. Because generally, you would not include both name and e-mail address in the ... | ||
| Microsoft Access Find Duplicates Query | 10/30/2008 | Scottgem |
| Q: Scott, I send out an eNewsletter for my business and track what links my subscribers are clicking on ... A: First, you can't do this in a query, but you CAN do it in a report as I outlined in my first ... | ||
| Microsoft Access Find Duplicates Query | 10/28/2008 | Scottgem |
| Q: Scott, I send out an eNewsletter for my business and track what links my subscribers are clicking on ... A: I'm not clear on what is duplicated. The links or what? What you have is a classic relational ... | ||
| Email Extractor Programs? | 10/1/2008 | Arthur Naman |
| Q: As no one has created an internet "Yellow Pages" for email addresses, do you know of any good email ... A: There are web sites with mailing lists for purchase. One I have heard of is www.infousa.com, ... | ||
| cafezee | 10/1/2008 | Scottgem |
| Q: How can i find some one who can help me with this software as the site gives no help at all please ? A: I did a search and couldn't find any support sites for the product. They do have a support e-mail ... | ||
Page: Prev | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Next All
Top Expert on this page
I can answer some questions on a wide variety of business applications, including MS Office, Lotus Smartsuite, Visio, Notes and many others.
I have over 16 years of experience as an IT professional, supporting a wide variety of business applications.

©2012 About.com, a part of The New York Times Company. All rights reserved.