| Subject | Date Asked | Expert |
|
| memory wipe | 6/30/2008 | ScottGem |
Q: I recently purchesed a used desktop,how do I wipe the old memory so,there's only whatever I put on ...
A: All your files have an extension after the dot. Usually three characters they define the type of ...
|
| Converting old data in dbase or Lotus 123 format! | 6/27/2008 | Krishna Prasad |
Q: Krishna Prasad I am hoping you could assist me with some ideas/solutions - I have an old computer ...
A: Carl, I have heard that sometimes it does not work perfectly but in most cases it should be OK. ...
|
| Automaticall saving back-up | 6/1/2008 | Krishna Prasad |
Q: Is there a way to have Microsoft Office software to save two copies of a file when you click save? ...
A: Unfortunately, what you ask for is not possible through Word itself. Now, from Word 2003 ...
|
| making a filing system electronic | 5/27/2008 | ScottGem |
Q: Scott- I hope you are the right man to ask, if not please steer me in the right direction. This ...
A: There are loads of document management applications out there that will do it. If you are looking ...
|
| backup | 5/11/2008 | Krishna Prasad |
Q: I have two dell servers ,one dell power edge 2950 and one power edge 1950,I want to use the 2950 as ...
A: Hussein, Depending on the sophistication you want and the money that you are willing to spend, ...
|
| data transfer | 4/28/2008 | ScottGem |
Q: I have a 3 1/2" floppy disk full of documents formatted for my old Brother WP-1500D Word Processor. ...
A: Frankly, I don't know. You have two problems, first is whether the floppy can be read by a Windows ...
|
| Discoverer Report | 4/18/2008 | ScottGem |
Q: Scott: Andrew Zima here - the one with all the MS Access bug-a-boos. I did not know you were an ...
A: Where did you get the idea I'm an Oracle expert? I'm not in any way. However, Oracle does use SQL. ...
|
| cloning | 3/31/2008 | Krishna Prasad |
Q: What I want to accomplish ti to clone my entire hardrive on my desktop to an external USB harddrive ...
A: Jim, I simply meant that in the target system, you need to have the drive recognized.... (If a ...
|
| cloning | 3/29/2008 | Krishna Prasad |
Q: What I want to accomplish ti to clone my entire hardrive on my desktop to an external USB harddrive ...
A: Generally, the hardware layer is hidden underneath what you are trying to do. If you can define your ...
|
| Transferring old computer printouts to CD | 1/24/2008 | ScottGem |
Q: We are using Windows XP. We have a database of original owners of our RV resort which we refer to ...
A: What I suggest you do is get a copy of Omnifile (nuance.com). OmniFile is one of the top OCR ...
|
| mirrored databases and tailored databases | 12/28/2007 | Krishna Prasad |
Q: I'm studying the difference between distributed databases and localized databases, my question is ...
A: Fiorita, In the time and space available I can give only an overview. A mirrored database is ...
|
| Primary Key - Autonumber | 12/27/2007 | ScottGem |
Q: I am a new user of Access 2007, and am trying to set up a small database to hold company details. I ...
A: First, the purpose of an autonumber is SOLELY to provide a unique identifier for a record. Many ...
|
| easiest way to parse instrument data | 11/27/2007 | ScottGem |
Q: Can you please point me in the right direction for importing the following data into MS Access? ...
A: There is actually no easy way to do this. You would need to use the OPEN command to open the text ...
|
| Copying Data from a Query to a Form | 11/20/2007 | ScottGem |
Q: I would like to know how to automatically populate a form field with a value retrieved from a query. ...
A: Correct, so you don't need to use the Alias (As Fullname) either. But if the format is last, first ...
|
| Copying Data from a Query to a Form | 11/19/2007 | ScottGem |
Q: I would like to know how to automatically populate a form field with a value retrieved from a query. ...
A: Have you tried using a RowSource for the combo like: SELECT EmployeeID, LastName & ", " & Firstname ...
|
| migrate to oracle | 11/14/2007 | Krishna Prasad |
Q: resp. sir, I have a fair knowledge of FoxPro system of database mgmt. and programming related to ...
A: DDY, I can answer your questions but please bear this in mind. 1. I only give my perspective in ...
|
| DB Standards | 11/13/2007 | ScottGem |
Q: I recently began overseeing a MS Access database of HVAC repair parts and repairs. I'm looking for ...
A: I'm still not clear what you are asking. Are you asking whether Cond motor 1/2hp 115volts cw ...
|
| DB Standards | 11/13/2007 | ScottGem |
Q: I recently began overseeing a MS Access database of HVAC repair parts and repairs. I'm looking for ...
A: I'm not clear what you are asking here. To ensure standardization of data entry, you should make ...
|
| need for a solution | 11/10/2007 | Krishna Prasad |
Q: respected sir my question is that ,how i create a database,what are the steps are thers for create a ...
A: Anirban, 1. You have control over access to the database. (You can set up who can see, update, ...
|
| What database handles the largest files? | 11/7/2007 | Krishna Prasad |
Q: I know that certain database system (e.g. ACCESS) defaults at 2 gigabytes. I need a database ...
A: Unfortunately, with power comes complexity. All these systems are complex and require knowledge to ...
|
| need for a solution | 11/4/2007 | Krishna Prasad |
Q: respected sir my question is that ,how i create a database,what are the steps are thers for create a ...
A: Aniban, If you are looking for the absolute basic material, you can find some here ...
|
| What database handles the largest files? | 11/1/2007 | Krishna Prasad |
Q: I know that certain database system (e.g. ACCESS) defaults at 2 gigabytes. I need a database ...
A: For that large a database, you need an industrial strength database. I have used Oracle, Sybase and ...
|
| backup | 10/18/2007 | ScottGem |
Q: Windows XP What is the best / easiest way to back up my computer (60 GB HD)(periodically) so in the ...
A: It depends on whether you are looking to protect yourself ONLY against a hard drive failure or ...
|
| Data storage | 10/14/2007 | ScottGem |
Q: We often hear how hackers can retrive lots of data from hard drives even when they've been ...
A: First, let me explain how data is stored on a regular hard drive. A hard drive is a thin plastic ...
|
| Append Query | 10/10/2007 | ScottGem |
Q: I have data gathered from others that I am trying to put into a database. The imported table has a ...
A: So you want all the data from your table of weights inported, byt to that the record type relect ...
|
| knowledge mgt | 9/13/2007 | Krishna Prasad |
Q: I have a question and I'm not too sure if it's related to database but i'm just wondering what is ...
A: Sue, In my view, designing all your systems and processes around knowledge means that you keep ...
|
| Archived files | 9/12/2007 | ScottGem |
Q: Not sure if you are the right person for this question or not, but you probably still know alot more ...
A: Outlook will automatically Archive e-mails and other files you associate with Outlook after a period ...
|
| knowledge mgt | 9/12/2007 | ScottGem |
Q: I have a question and I'm not too sure if it's related to database but i'm just wondering what is ...
A: Knowledge mgmt is a fairly new term used to describe the total administration of what a company ...
|
| knowledge mgt | 9/12/2007 | Krishna Prasad |
Q: I have a question and I'm not too sure if it's related to database but i'm just wondering what is ...
A: Sue, You are right in that Knowledge Management does not have anything directly to do with ...
|
| Help with Sql query | 8/21/2007 | Krishna Prasad |
Q: i m steve, i actually need a sql query, i am not able to get it can you please help i got two table ...
A: Steve, That should be easy. In any SQL, you determine the link field. Here it is PATIENTID. ...
|
| Automatic renumbering in Excel | 8/5/2007 | ScottGem |
Q: Our small newspaper needs to create a database of subscribers from which we can print labels in what ...
A: Assuming your first data row starts in Row 2, the formula in F2 should be =F1+1. When you copy that ...
|
| Automatic renumbering in Excel | 8/5/2007 | ScottGem |
Q: Our small newspaper needs to create a database of subscribers from which we can print labels in what ...
A: If you are going to do a database you should do it in Access. But you can do what you want with a ...
|
| Ms Access/ Excel | 7/17/2007 | ScottGem |
Q: I'm doing a project that receives SMS messages to a computer. I'm extracting the data and it's being ...
A: Nothing visible will happen but records should be added to the subtable. Did you enter this code ...
|
| certificate | 7/16/2007 | ScottGem |
Q: Can people with a microsoft certificates such as MCSD or the like find jobs without having a ...
A: Salary varies widely on job requirements, geographic area and industry. So there is no way I can ...
|
| Ms Access/ Excel | 7/10/2007 | ScottGem |
Q: I'm doing a project that receives SMS messages to a computer. I'm extracting the data and it's being ...
A: Ahh so there IS a pattern. The pattern is Category Amount; What you would need to do here is store ...
|
| Where can I find a flexible Visual Query Reporting Tool with text export (for end-users using Win) ? | 7/5/2007 | ScottGem |
Q: Nice and neat if you could advise me a good tool ? I have found a few but they are not really ...
A: You want pie in the sky don't you? Sorry, but I don't know of any that meet that criteria, ...
|
| Ms Access/ Excel | 7/4/2007 | ScottGem |
Q: I'm doing a project that receives SMS messages to a computer. I'm extracting the data and it's being ...
A: Extracting data from a text string into individual fields has to be based on a pattern. For example ...
|
| request for help! | 7/3/2007 | ScottGem |
Q: sir, i have a secnario, i want 2 do normalization and er diagram what i do for that? can u help for ...
A: As far as normalization is concerned, there are many good books and articles on the WEB that explain ...
|
| Data entry to database | 6/19/2007 | ScottGem |
Q: I'm looking for a solution to this problem: We receive data, mostly by email in either Word, Excel ...
A: There are things like Cardscan that scan a business card and store the data in a Contacts database. ...
|
| Data entry to database | 6/14/2007 | ScottGem |
Q: I'm looking for a solution to this problem: We receive data, mostly by email in either Word, Excel ...
A: The key here is patterns. As long as the input files follow a consistent pattern you can automate ...
|
