| Subject | Date Asked | Expert |
|
| filling orders and maintaining inventory | 10/12/2009 | Scottgem |
Q: Do web businesses like Office Max have an inventory management tool in their software? Where can I ...
A: I believe both Office Max and Staples have modules that will enable you to manage inventory, at ...
|
| Consignment Business Software | 9/15/2009 | Scottgem |
Q: I have a consignment shop and right now, as it has been for the past few years, everything from ...
A: I'm not that familiar with Quickbooks, but you may be able to tweak it to do what you want. I would ...
|
| Sending mass email with personalized information from Microsoft Access | 9/14/2009 | Scottgem |
Q: I am looking for a software program, or method within Access and Outlook, that will help in sending ...
A: You caught me at a good moment. I just set this up for one of my clients. There are two modules to ...
|
| Publisher - Brochure | 9/11/2009 | Scottgem |
Q: I want to make an A4 (or letter size) brochure that has 4 pages. How would I set it up so that it ...
A: I do a newsletter for my bike club. I lay the pges out on letter size. When I go to print I set it ...
|
| Calendar maker software | 9/10/2009 | Scottgem |
Q: Which calendar maker program would be compatible to Dell Windows Vista.. I have Calendar Creator ...
A: Check for a new version of Calendar Creator. Should be a Vista supported version. Try ...
|
| using Word 2007 and Word 2003 on the same hard drive | 7/23/2009 | Scottgem |
Q: nice to meet you? I have Windows XP and MS Word 2003 and Excel 2003 on my computer. Can I install ...
A: I had Ofice 97, Office 2k, Office XP, Office 2003 and Office 2007 all on the same XP machine at one ...
|
| PDF program | 7/23/2009 | Scottgem |
Q: I want to buy a PDF program. The report I want to convert to PDF has text and about 20 high ...
A: You don't need to buy anything if you just want to convert a report to PDF. There are several free ...
|
| QueryDef | 7/20/2009 | Scottgem |
Q: the code works up to the point of queryDef creation. attyName = rs.Fields("Name") MsgBox ...
A: What you should do is STEP through the code seeing what actually happens. To do this you set a ...
|
| office automation and group collaboration software | 7/18/2009 | Scottgem |
Q: what are the advantages and disadvantages of office auto mation?
A: Office Automation allows you to control other programs in the Microsoft Office suite from one ...
|
| QueryDef | 7/17/2009 | Scottgem |
Q: the code works up to the point of queryDef creation. attyName = rs.Fields("Name") MsgBox ...
A: Ok, you changed to using SendObject instead of Outlook automation. Its not an issue. But this is ...
|
| QueryDef | 7/17/2009 | Scottgem |
Q: the code works up to the point of queryDef creation. attyName = rs.Fields("Name") MsgBox ...
A: Ahh I think I see the problem, Try changing this line to: "' ORDER BY [Name];") Since AttyName is ...
|
| Export/append records | 7/16/2009 | Scottgem |
Q: Hey Scott, I have table with records that look like this Smith, Jim Business Lunch ...
A: Well your first problem is you are naming a variable with a reserved word. naming a QueryDef type as ...
|
| Export/append records | 7/16/2009 | Scottgem |
Q: Hey Scott, I have table with records that look like this Smith, Jim Business Lunch ...
A: Well, of course you have to specify criteria. What you are going to need to do is loop through a ...
|
| Export/append records | 7/14/2009 | Scottgem |
Q: Hey Scott, I have table with records that look like this Smith, Jim Business Lunch ...
A: What you need to do is create a query that filters for each person. You then export that query ...
|
| Linking Tables | 7/14/2009 | Scottgem |
Q: I have not been successful. I think you helped me before. I am trying to create a relationship (in ...
A: I name my primnary keys using the convention: tablename % ID example CallerID, QuestionID, etc. My ...
|
| 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 ...
|
