| Subject | Date Asked | Expert |
|
| can i compare databases in both oracle and sqlserver | 11/18/2009 | Mehmet Orun |
Q: "hi do we have any online tools or there is any mechanism so that i can compare a database schema ...
A: Assuming your data is text only, try the following steps: Reverse engineer physical model in a ...
|
| can i compare databases in both oracle and sqlserver | 11/17/2009 | Mehmet Orun |
Q: "hi do we have any online tools or there is any mechanism so that i can compare a database schema ...
A: Yes, you can definitely compare two different databases, the technique will be different depending ...
|
| file keeping | 11/12/2009 | Mehmet Orun |
Q: "I am starting a new office job on Monday and would like to know if there is some program that I can ...
A: Yes, there are other ways of capturing your notes. I think it is great you are thinking ahead of ...
|
| file keeping | 11/12/2009 | ScottGem |
Q: "I am starting a new office job on Monday and would like to know if there is some program that I can ...
A: Sure its called CRM (Customer Relationship Management). There are several apps that allow this. You ...
|
| combo boxes | 9/14/2009 | ScottGem |
Q: Can you tell me in Acess 2007 how to enable a combo box for multiple selections? We want to be able ...
A: You can't. Comboboxes cannot do multiple selections. However, LIST boxes can by turning on the ...
|
| Database Structure and Source of Info | 8/17/2009 | Mehmet Orun |
Q: What sources of info there are for selecting the best technology for Virtual education purposes? ...
A: Virtual Education software is not an area I am familiar with. However, I can provide pointers ...
|
| Assesment Database | 8/13/2009 | ScottGem |
Q: I hope that you are able to give me some guidance. I work for an org. that produces bespoke B2B ...
A: I was hoping that the last paragraph would be in your next question. You have found someone who can ...
|
| Assesment Database | 8/12/2009 | ScottGem |
Q: I hope that you are able to give me some guidance. I work for an org. that produces bespoke B2B ...
A: If you take the WEB enabled out of the equation, then Access can handle the job. Access can be used ...
|
| Assesment Database | 8/11/2009 | ScottGem |
Q: I hope that you are able to give me some guidance. I work for an org. that produces bespoke B2B ...
A: The WEB enabled piece is a stickler here. You would actually have to create TWO front ends to the ...
|
| structure of db | 7/26/2009 | ScottGem |
Q: I am developing a site with mulitilingual feature.its working fine without any problem.first the ...
A: Use a table like Translation TranslationID (PK) PersonID (FK) LanguageID (FK) You then create a ...
|
| backing up music | 7/7/2009 | Mehmet Orun |
Q: is there a way to save it so that it retains all the song information that was inputted [album art, ...
A: If you use backup software for your files vs. "copying", you should be able to retain this. On the ...
|
| Paperwork to scan to online doc storage | 7/3/2009 | ScottGem |
Q: and thank you for any help. I am a writer drowning in paperwork. Newspaper articles, scraps of ...
A: I would suggest you take a look at Paperport from Nuance. This is a very good document management ...
|
| Clear Oracle Database | 7/3/2009 | Mehmet Orun |
Q: I have a question about clearing Oracle 10.2.0.3 Database (clearing database files, free it) ...
A: You would need to have the privilege to export one schema and import it into the other. THis will ...
|
| Computer issue. | 6/26/2009 | ScottGem |
Q: I have a problem with my computer, and I have no idea who to ask. I'm not very wise with computers ...
A: The first thing to do is what the error instructs you to do. I'm going to assume you have Win XP If ...
|
| Need Advice | 5/27/2009 | Mehmet Orun |
Q: Within the engineering department, we have several different sections. All those sections have their ...
A: It has been several years since I focused on telecom but I recalled a company who appears to have ...
|
| Need Advice | 5/27/2009 | Mehmet Orun |
Q: Within the engineering department, we have several different sections. All those sections have their ...
A: We may need one more follow up but lets see Do you need to consolidate only static data (diagrams) ...
|
| Need Advice | 5/27/2009 | Mehmet Orun |
Q: Within the engineering department, we have several different sections. All those sections have their ...
A: You may need to provide one more round of information for me to provide a clearer answer but lets ...
|
| install new Windows updates | 5/25/2009 | Mehmet Orun |
Q: My PC is a laptop, Acer Intel@ Pentium@ Dual-Core Processor, Window Vista Home Premium 2048MB DDR2 ...
A: One major reason Windows allows you to determine what time you want to run the updates (as you ...
|
| Query - Exporting only selected items | 5/19/2009 | ScottGem |
Q: didn't see this type of request reviewing the site. I want to have the ability to select from a ...
A: If you only want to export certain COLUMNS, then you will need to build your SQL statement in a VBA ...
|
| internet passwords | 5/8/2009 | Krishna Prasad |
Q: I would like to put a password on the internet options of my computer, im having problems with ...
A: Justin, If it is your personal PC or even a shared PC at home, you can create separate accounts ...
|
| cpu usage for idle process | 4/22/2009 | Mehmet Orun |
Q: when i open task manager it says my system idle process is using 80-90% of my memory/ram can this be ...
A: System Idle Process means the capacity your CPU has available to run jobs. So if it is high, that ...
|
| Business Objects | 4/19/2009 | ScottGem |
Q: I am not sure if business objects is your are of expertise. Let me know if you can help me with some ...
A: Crystal Reports is a report writer that is a probuct of Business Objects, which in itself is a ...
|
| project | 4/18/2009 | Mehmet Orun |
Q: i am prafulla doing my engneering 3rd year from india. me doing one problem.the problem is being ...
A: If I understand your question correctly, you are trying to extract data from a graph. I am afraid I ...
|
| To develop a software | 4/9/2009 | ScottGem |
Q: I am working on a project for Pharmaceutical Company. Company exports lots of its product and have ...
A: Just about any software development platform can do what you want. For ease of use and support I ...
|
| SYSTEMS ANALYSIS AND DESIGN | 4/2/2009 | ScottGem |
Q: Please sir, would you suggest me some websites where i can learn ms access free. The purpose of ...
A: Try HpLearning.com they have some Access courses. If you want to send a zipped copy to dafiles @ ...
|
| Data Flow Diagrams | 3/30/2009 | Mehmet Orun |
Q: I would greatly appreciate it if you could look through the following question for me and point out ...
A: Sorry about the delay in getting back to you. Here are some general observations (vs. a ...
|
| Database Management - Relationships | 3/27/2009 | ScottGem |
Q: Consider the following relation: CLIENT (ClientNumber, ClientName, VetID, VetName, ...
A: First I don't see a relation, second I don't see a repeating group. A repeating group is generally ...
|
| Database | 3/20/2009 | ScottGem |
Q: I meant the new dwg # was not going into the table. I will leave that part of the code out for now ...
A: Well this goes back to something I said earlier. How is the Drawing # generated? If its an inputted ...
|
| Database | 3/17/2009 | ScottGem |
Q: I meant the new dwg # was not going into the table. I will leave that part of the code out for now ...
A: Great job. Just a point, when you ask for help like this. We don't know what names you are using for ...
|
| Database | 3/16/2009 | ScottGem |
Q: I meant the new dwg # was not going into the table. I will leave that part of the code out for now ...
A: An autonumber is a Long Integer datatype. So a foreign key field in the related table also has to be ...
|
| Database | 3/14/2009 | ScottGem |
Q: Sorry, about the incorrect name - I was typing an email to my boss to a Geof - guess it was stuck in ...
A: strSQL = "INSERT INTO Drawings ([Drawing Number],Title) VALUES('" & strDrawingNumber & "','" & ...
|
| Database | 3/13/2009 | ScottGem |
Q: I didn't know there was a limit to the number of follow up questions you can as... Here was your ...
A: Think about it. The problem is with the variable strSQL, the generated SQL statement. So you want to ...
|
| Database | 3/13/2009 | ScottGem |
Q: I didn't know there was a limit to the number of follow up questions you can as... Here was your ...
A: Check the generated SQL statement. When you select Debug and the VBE opens, look in the Locals pane ...
|
| Database | 3/12/2009 | ScottGem |
Q: I didn't know there was a limit to the number of follow up questions you can as... Here was your ...
A: Yeah that's one of the things I don't like about this site. OK, but that doesn't quite answer where ...
|
| Storage Area Network (SAN) | 3/10/2009 | Krishna Prasad |
Q: Please what certification exams and courses will i need to do to become a SAN Administrator (or SAN ...
A: Elliot, There are many certifications offered by many institutions, but the most reputed are ...
|
| design of db | 3/5/2009 | Krishna Prasad |
Q: we are developing a site for classfieds.the site will have different categories and different ...
A: Parth, This ia a very general question and involves a design of a whole subsystem. I would like ...
|
| Access Relationships | 3/1/2009 | ScottGem |
Q: I am trying to put together a database of companies. I have three tables - Companies, Contacts and ...
A: First, you need to have a primary key for each table. I recommend using autonumbers for your PKs. So ...
|
| Database Accuracy | 2/18/2009 | Krishna Prasad |
Q: We want to insure that the information stored in our database is accurate. Are there any standard ...
A: Brian, The short answer is - you have to test! When you build the data warehouse, it shoudl be ...
|
| Data management | 2/16/2009 | ScottGem |
Q: My work computer desktop screen was configured differently when turned on yesterday & numerous icons ...
A: Don't you have an IT support group? If you do, I would contact them immediately. They can probably ...
|
| DATA STREAM MANAGEMENT | 2/15/2009 | ScottGem |
Q: I'm an MD. I'm not sure I'm asking the right guy but hopefully you can at least direct me correctly. ...
A: What it sounds like you are referring to is basically a standard database application. You enter ...
|
