You are here:
- Home
- Computing/Technology
- Oracle
- Data Management & Storage
Data Management & Storage/Questions Answered by Expert ScottGem
| Subject | Date Asked |
| POS and Accounting | 1/27/2012 |
| Q: I have an idea from creating a cloud based accounting software, Very similar to the intuit ... A: The cost to create such software depends on whether you will write it yourself or not. If you can, ... | |
| query cost | 1/12/2012 |
| Q: I want to calculate the cost of the query without its execution from the information like how many ... A: First, what platform are you working in? Some database management platforms have tools to determine ... | |
| Re:database | 1/7/2012 |
| Q: I would be very pleased if you could give me some suggestion as I am a student and I am very ... A: You could run your own server locally that is accessible from the Internet, but I don't recommend ... | |
| POS software | 1/7/2012 |
| Q: I am not a computer egineer or any programmer. recently i was looking at some POS for my business ... A: POS software is basically a database application. You are recording your sales as transactions in ... | |
| recover data due to system error | 12/12/2011 |
| Q: My friend set his computer to restore at an earlier date due to some problems he was experiencing. ... A: It does not sound like your friend did a system restore but a system recovery. A System Recovery ... | |
| Entity Relationship Diagram question | 11/2/2011 |
| Q: I just want to ask you a question about the ER diagram. I am not sure if the part of sub type ... A: Doesn't look right to me. The Entity is crew, attributes of crew are job title or function (ex: ... | |
| How to collate data from multiple to sources and where to locate this data? | 9/26/2011 |
| Q: I like to look at market statistic for a variety of things, from salaries to house markets, from one ... A: I gave you some tools you can use to combine multiple sources. I don't know of any free ones that ... | |
| How to collate data from multiple to sources and where to locate this data? | 9/25/2011 |
| Q: I like to look at market statistic for a variety of things, from salaries to house markets, from one ... A: There are firms that sell lists of data. There are also web sites that have feeds that you can ... | |
| Creating a small database for a charity | 8/2/2011 |
| Q: but are a small charity with just 4 part time staff. We're looking for the best/easiest database ... A: If its a simple matter of organizing contacts, then Outlook would be the tool of choice. But if you ... | |
| work with more than two databases | 7/8/2011 |
| Q: I want to know how can i work with more than one databases at same time. Is it possible and if its ... A: You need to define this more fully. It is certainly possible to work with two databases at the same ... | |
| MS Access VBA Programming | 6/21/2011 |
| Q: Hopefully you can help me. I do a lot of VBA programming in both Excel and Access but wouldn't ... A: "As for the dialog form issue, I am convinced that there is some way to make code pause until values ... | |
| MS Access VBA Programming | 6/18/2011 |
| Q: Hopefully you can help me. I do a lot of VBA programming in both Excel and Access but wouldn't ... A: Well part of the answer is you have to stop thinking spreadsheet when dealing with Access. Access is ... | |
| Data base integration | 6/16/2011 |
| Q: I work for a company that use a few data bases management programs. Vtiger for salesperson, Quick ... A: I know of no application that specifically works with all those. A lot depends on what engines they ... | |
| Concatenate rows | 5/25/2011 |
| Q: This is a follow up question. I put a Debug.Print SQL before the line throwing the error. I'm ... A: you have to replace Conc with the name of the new function, and Jerry's code doesn't take as many ... | |
| Concatenate rows | 5/24/2011 |
| Q: This is a follow up question. I put a Debug.Print SQL before the line throwing the error. I'm ... A: Hmm, First if you copied and pasted that there is a problem because there are no spaces. However, ... | |
| Concatenate rows | 5/23/2011 |
| Q: This is a follow up question. I put a Debug.Print SQL before the line throwing the error. I'm ... A: Dalia, You didn't provide what I needed. Again, the Format expression in the function call converts ... | |
| Access VBA issue | 5/23/2011 |
| Q: I am running vba that updates a large amount of records in Access '07 but in '03 format. Been a ... A: Is the database split?. I think what may be happening is you need to do a Compact and Repair between ... | |
| Change in code for 'Date' field | 5/20/2011 |
| Q: Scott, you always helped me with my access questions. Thank you. I'm using the following code which ... A: Are you using the Format function within the function call? The Format function is converting the ... | |
| Change in code for 'Date' field | 5/18/2011 |
| Q: Scott, you always helped me with my access questions. Thank you. I'm using the following code which ... A: No, you don't want to change the function, you want to change the data that goes into the function. ... | |
| Change in code for 'Date' field | 5/17/2011 |
| Q: Scott, you always helped me with my access questions. Thank you. I'm using the following code which ... A: First, DATE is a reserved word in Access so should not be used as an object name. So you should ... | |
| I am a caseworker for a contract company. I have a supervisor and then it is just me. I create my own way of doing things and as long as I'm doing my job, that's all that matters. Whatever works for me, I do. So, what I want to do is create my own website | 5/3/2011 |
| Q: I am a caseworker for a contract company. I have a supervisor and then it is just me. I create my ... A: First, since you are the only one accessing this, there is no need for a website. The major purpose ... | |
| Data Mining | 3/23/2011 |
| Q: Scott, I work for a small company that collects a lot of data for certain manufactured goods, from ... A: The value of data has become more and more recognized in recent years. Even less than 20 years ago ... | |
| Normalizing data | 2/17/2011 |
| Q: I need to normalize vehicle maintenance data from 1 large table and break it up into multiple ... A: What database platform will you be using? Once you have setup the database, you will be using list ... | |
| Normalizing data | 2/17/2011 |
| Q: I need to normalize vehicle maintenance data from 1 large table and break it up into multiple ... A: Definitely normalize your data! But instead of trying to convert the existing data into a normalized ... | |
| Lost Files | 1/12/2011 |
| Q: (I do not know much about computers, so excuse me if I use weird phrases and words) The other day, I ... A: You need to log in as an Administrator to first see if the files are there. Your new user account is ... | |
| BKP Files | 12/20/2010 |
| Q: I have a folder In C:\ titled "C:\File Cache." The files are all .BKP files. There are 5,836 of ... A: Do you have a backup program running that is making automatic backups? Most likely that is what's ... | |
| Data Architecture | 12/2/2010 |
| Q: My father worked with an insurance company for 25 years as a data analyst and architect before he ... A: I'm afraid I'm not that familiar with resources on those tools. Books from Que and Worx are ... | |
| Data Architecture | 12/2/2010 |
| Q: My father worked with an insurance company for 25 years as a data analyst and architect before he ... A: Not too much has changed in architecture. Oracle and SQL Server have become even more dominant. But ... | |
| Beyond MS Access | 9/19/2010 |
| Q: I have been a MS Access developer for several years. Many organizations seem to be using ... A: It all depends on needs. Access has always been looked down on by IT departments because of its lack ... | |
| data transfer | 9/12/2010 |
| Q: I want to copy Word and Excel files from my old Dell Dimension 4700 computer that has a CD R/W ... A: CDs come in two types CD/R and CD/RW. CD/Rs are write once, CD/EWs are rewriteable. They work ... | |
| Transferring files from computer to computer | 6/7/2010 |
| Q: I'm finishing up my home schooling online program, and my school computer I need to return has about ... A: There are several ways to do this. You could burn to CD, copy them to a Flash Drive, copy to an ... | |
| Have a btn that opens a form using a query filter, if the query filter returns no records then i do not want to display the form | 4/18/2010 |
| Q: I have a button on a Client form that opens a form with a query as filter. If the query filters no ... A: Sorry, but you are off the mark here. Yes, a -1 does indicate a True value. But you aren't using a ... | |
| Normalization | 4/5/2010 |
| Q: I'm trying to normalize a group of tables to 3NF, but I'm having trouble figuring out the functional ... A: If you were not given a specific prupose for the database, then you had to select one of your own. ... | |
| Normalization | 4/4/2010 |
| Q: I'm trying to normalize a group of tables to 3NF, but I'm having trouble figuring out the functional ... A: You still haven't explained what the tables are used for. pID is not a foreign key in either ... | |
| Normalization | 4/4/2010 |
| Q: I'm trying to normalize a group of tables to 3NF, but I'm having trouble figuring out the functional ... A: Well your first problem is that you have no foreign keys. There is no relationships between tables. ... | |
| opening transfered files | 3/21/2010 |
| Q: i have transfered all my files from my old windowsxp computer to my new hp touchsmart windows 7 ,my ... A: Probably. Data files from a proprietary program cannot be opened in another program. You need to ... | |
| access replacement | 3/5/2010 |
| Q: we currently use access. the data that we store used to be stored in excell but was too large to ... A: You can use SQL Express or MYSQL as your backend, but there is no freeware database where you can ... | |
| 3NF relations | 2/26/2010 |
| Q: I'll start by saying I've read the text, read some of your previous posts regarding this subject and ... A: Appreciate your showing me what the text says. But that's ridiculous. However, what they are calling ... | |
| 3NF relations | 2/26/2010 |
| Q: I'll start by saying I've read the text, read some of your previous posts regarding this subject and ... A: I have been designing relational databases for over 20 years. I have a certificate as a Microsoft ... | |
| 3NF relations | 2/26/2010 |
| Q: I'll start by saying I've read the text, read some of your previous posts regarding this subject and ... A: Your close, but you need more tables. First, I don't know what the Object table is. No need for ... | |
| ORACLE | 12/29/2009 |
| Q: Sir, I am new to this site. Recently I have started learning ORACLE. I can't understand Functional ... A: This article does a good job of explaining the rules of normalization. ... | |
| ORACLE | 12/28/2009 |
| Q: Sir, I am new to this site. Recently I have started learning ORACLE. I can't understand Functional ... A: Normalization is not something I can explain in a few paragraphs. There are whole books written on ... | |
| file keeping | 11/12/2009 |
| 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 |
| 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 ... | |
| Assesment Database | 8/13/2009 |
| 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 |
| 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 |
| 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 |
| 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 ... | |
| Paperwork to scan to online doc storage | 7/3/2009 |
| 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 ... | |
| Computer issue. | 6/26/2009 |
| 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 ... | |
| Query - Exporting only selected items | 5/19/2009 |
| 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 ... | |
| Business Objects | 4/19/2009 |
| 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 ... | |
| To develop a software | 4/9/2009 |
| 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 |
| 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 @ ... | |
| Database Management - Relationships | 3/27/2009 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 ... | |
| Access Relationships | 3/1/2009 |
| 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 ... | |
| Data management | 2/16/2009 |
| 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 |
| 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 ... | |
| query question | 2/11/2009 |
| Q: I have a simple dB with 2 tables. In table 1 the primary key is "customer id". It is linked in a ... A: There are a couple of ways to do this, the way I would do it is to create a query that returns the ... | |
| access query | 1/30/2009 |
| Q: how can i make a question in a query that only retrieve the data that we want in the answer we give ... A: This goes to the essence of queries. For you to ask this question means you need to try to ... | |
| School Library Catalog System | 1/16/2009 |
| Q: I am a teacher in Philadelphia. Some other teachers and myself are working to organize or library so ... A: The first thing I would do is talk to librarians in other schools and your local library. They may ... | |
| Evaluate Calculated Field on Close | 12/23/2008 |
| Q: I have a set of yes/no boxes in a form and its necessary that at least one box be checked before the ... A: Try this in the On Close event. If Me.txtChecksum = 0 then Me.Undo End if If that doesn't work, ... | |
| ACT! 5.0 won't open on Windows XP | 12/11/2008 |
| Q: Scott- Thanks for your time. I'm a fellow expert with recruiting and jobhunting. I use a Dell ... A: Have you tried using System Restore to go back to a point in time where it worked? Also are you sure ... | |
| Appending a Table in MS Access | 12/10/2008 |
| Q: Howdy Scott, I've got a question. I'm a new Access user(much like it seems everyone else with ... A: The INSERT INTO statement has two forms. One with a SELECT clause, the other with a VALUES clause. ... | |
| Student, confused on database and SQL | 11/27/2008 |
| Q: I have started a module called advanced rich media, and as a part of the module we have to learn ... A: You are asking very broad questions that are really unsuited for this medium. These are questions ... | |
| Database possibilities... | 11/17/2008 |
| Q: I'm new to databases. I have Office 07/Access. Would I be able to do the following using Access: ... A: Yes, this is just the type of thing that a database was meant to do. Access can do this fairly ... | |
| Linking Forms | 11/13/2008 |
| Q: I may have asked this question before, I am not sure. I know nothing that i have tried has worked ... A: You are close, but not there yet. Since you are trying to open an EXISTING record Then all you need ... | |
| split database | 10/31/2008 |
| Q: I have split an Access database in our shared folder, then send a copy of the front end to each ... A: Not necessarily. If the file was on a network share, then it would indicate they might have had the ... | |
| split database | 10/31/2008 |
| Q: I have split an Access database in our shared folder, then send a copy of the front end to each ... A: Probably because they aren't mapped to the same drive. When you split the database you should use ... | |
| Table, query, and relationship design with membership and attendance | 10/20/2008 |
| Q: Scott, I could not find a link for a follow-up, so I had to start a new one. The attached image ... A: Ahh OK, that does make a difference. If you need to include whether a person is a leader of the ... | |
| Table, query, and relationship design with membership and attendance | 10/20/2008 |
| Q: Scott, I could not find a link for a follow-up, so I had to start a new one. The attached image ... A: You lost me. First, if Leader is the leader of the group, then LeaderID should be in tbl_Groups as a ... | |
| database warehousing | 10/15/2008 |
| Q: I am having a databse with pretty large amounts of data. some of the data entered have mistakes ... A: Assuming the database is a SQL compatible one, you would need to run queries with selection criteria ... | |
| Table, query, and relationship design with membership and attendance | 10/14/2008 |
| Q: Re:http://en.allexperts.com/q/Database-Programming-1041/2008/10/Table-query-relationship-design.htm ... A: I did get both. But I think you are answering my question here. So, if I follow, the relationship ... | |
| Table, query, and relationship design with membership and attendance | 10/14/2008 |
| Q: Re:http://en.allexperts.com/q/Database-Programming-1041/2008/10/Table-query-relationship-design.htm ... A: Ok, You have your people table and your groups table with a junction table that shows what people ... | |
| MS Access 2007 Autonumber Problem | 10/13/2008 |
| Q: Scott: After compacting & repairing a simple but large (approx 22000 records, about 1G) Access 2007 ... A: Ok, a couple of things to check. One make sure the Autonumber type is set to Sequential and not ... | |
| The Error is | 9/29/2008 |
| Q: Run Time error : 3464 ( Data Type Missmatch in criteria expression) Private Sub Command20_Click() ... A: You keep missing the point here. Again, both sides of the comparison have to be the same datatype. ... | |
| The Error is | 9/29/2008 |
| Q: Run Time error : 3464 ( Data Type Missmatch in criteria expression) Private Sub Command20_Click() ... A: Yes that's part of it. The Format function returns a text string, yet you are comparing that to a ... | |
| The Error is | 9/29/2008 |
| Q: Run Time error : 3464 ( Data Type Missmatch in criteria expression) Private Sub Command20_Click() ... A: OK, That tells me the problem and it should tell you as well. That means that you are mixing your ... | |
| Access Error | 9/29/2008 |
| Q: The expert can't answer your question. Your Question was: Hello, i have this problem , i have a ... A: I've asked you a couple of times now, what is the error message? If I know what the error is, I may ... | |
| Access Error | 9/26/2008 |
| Q: The expert can't answer your question. Your Question was: Hello, i have this problem , i have a ... A: But what IS the error? Also I would di like this Private Sub Command20_Click() Dim sFilter As ... | |
| Access Error | 9/26/2008 |
| Q: The expert can't answer your question. Your Question was: Hello, i have this problem , i have a ... A: First, what error? Second, do you want the user to be able to select only one criteria or more ... | |
| Linking criteria | 9/23/2008 |
| Q: I have a form that has a subform, in the subform is a check box titled Closed. I want the user to ... A: Try this: stLinkCriteria = "[VikingInqNo]=" & Me![VikingInqNo] & " AND [InquiryNo] = " & ... | |
| Help | 9/9/2008 |
| Q: My computer was stolen this weekend, is it possible to locate it to a physical address, here is the ... A: Sorry, but its not possible. It might be possible to find it online via its MAC address, but that ... | |
| access vba | 9/1/2008 |
| Q: im working on an access db and using vba for functionalty. I have 2 combo boxes and a text box. In ... A: Use a SELECT CASE then. You can put the code in the On Current event of your form as well as the ... | |
| access vba | 8/29/2008 |
| Q: im working on an access db and using vba for functionalty. I have 2 combo boxes and a text box. In ... A: In the After Update event of the first combo use code like: If Not IsNull(Me.cboFirst) then ... | |
| subform | 8/26/2008 |
| Q: I have a subform that tracks individual part numbers on a Quote (MainForm). I placed code in the ... A: Set up a WHERE cluase in your OpenForm method: doCmd.Openform "formname",,,"[Partnum] = " & ... | |
| Hard drive | 8/21/2008 |
| Q: Scott, I have a question in regards of the hard drive, for some reason my computer has to partition ... A: How big is the D? Some machines create a small recovery partition. As far as using the space, if ... | |
| DB acess lockout | 8/19/2008 |
| Q: What is the quickest or easiest way to apply a lock to a DB to prevent users from entering while I ... A: The best method is to split your database between backend (tables) and frontend (everything else). ... | |
| Dates in Access | 8/14/2008 |
| Q: I'm trying to get either a query or report in Access 2000 to show date ranges...Items between 0 to ... A: If there is a term you don't understand, I suggest using the Help screens to look it up. Access's ... | |
| subform control/focus | 8/13/2008 |
| Q: I have a form that has a subform, this form has a textbox named quotenum. The subform is linked by ... A: If you just entered that code that would be the response. As I said, you need to enter it as part of ... | |
| subform control/focus | 8/13/2008 |
| Q: I have a form that has a subform, this form has a textbox named quotenum. The subform is linked by ... A: I would use the OpenArgs argument for this: In the OpenForm method behind the button add an ... | |
| Dates in Access | 8/8/2008 |
| Q: I'm trying to get either a query or report in Access 2000 to show date ranges...Items between 0 to ... A: You need to use a Custom function to assing the ranges. something like this: PUBLIC FUNCTION ... | |
| Evaluating multipule records | 8/8/2008 |
| Q: The subform displays from 1 to many records depending on the link to the main form. The code below ... A: If I understand what you want I would base the subform on a query. In that query I would add a ... | |
| file duplication issue in db | 7/9/2008 |
| Q: I need to have a database which save the details of files stored on a file server- there would be ... A: Read up on indexes in Access Help. You can create an index on a field that won't allow duplicate ... | |
| memory wipe | 6/30/2008 |
| 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 ... | |
| making a filing system electronic | 5/27/2008 |
| 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 ... | |
| data transfer | 4/28/2008 |
| 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 |
| 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. ... | |
| Transferring old computer printouts to CD | 1/24/2008 |
| 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 ... | |
| Primary Key - Autonumber | 12/27/2007 |
| 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 |
| 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 |
| 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 |
| 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 ... | |
| DB Standards | 11/13/2007 |
| 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 |
| 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 ... | |
| backup | 10/18/2007 |
| 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 |
| 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 |
| 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 ... | |
| Archived files | 9/12/2007 |
| 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 |
| 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 ... | |
| Automatic renumbering in Excel | 8/5/2007 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 ... | |
| rank (vba) | 5/31/2007 |
| Q: I would like to create a database that will contain a rank field on the form which allows me to rank ... A: For renumbering the records, you need to use an UPDATE query. Something like: UPDATE table SET rank ... | |
| rank (vba) | 5/30/2007 |
| Q: I would like to create a database that will contain a rank field on the form which allows me to rank ... A: First, if you want to provide a ranking for records you need to store the value in a field in your ... | |
| DB2 | 5/25/2007 |
| Q: I mostly program in Java and need to do a query on multiple tables that have the same column names. ... A: I'm not sure of the exact SQL for DB2. But it should look something like this: SELECT C_Class, ... | |
| Backup data | 5/19/2007 |
| Q: It is about one year that I am working in a company and I have entered alot of datas on it. Now for ... A: You can backup to a hard disk, but what good will that do if the disk crashes? Backups should be ... | |
| Surveyor's database | 5/13/2007 |
| Q: Here is what I am attempting to do. My father in law is the oldest working surveyor in Vermont. He ... A: I would not do this in Excel. Excel does not have the robust search tools that Access does. I would ... | |
| Is there any way to copy these cells to excel? | 5/1/2007 |
| Q: I want to copy all these data in excel cells as text. It is picture format but there are only ... A: Does the site offer a way to download the data as a csv or Excel file? That would be the best way to ... | |
| Help please | 4/15/2007 |
| Q: Which of these degrees have the best future, as far as employment, career advancements, and are the ... A: Its really hard to say. part of the problem is the hardware vs software tracks require different ... | |
| Sorting question | 3/18/2007 |
| Q: I am running a MySQL query using product ids like this: SELECT * FROM products WHERE product_id=510 ... A: No, you aren't getting what I'm saying. The SQL I gave you: SELECT * INNER JOIN Products.ProductID ... | |
| Sorting question | 3/18/2007 |
| Q: I am running a MySQL query using product ids like this: SELECT * FROM products WHERE product_id=510 ... A: You need the resultset to display the selected Products in a specific order. But the resultset is ... | |
| Sorting question | 3/18/2007 |
| Q: I am running a MySQL query using product ids like this: SELECT * FROM products WHERE product_id=510 ... A: I'm glad it works but why are you creating a temp table form the FINAL query? There is no need for ... | |
| Sorting question | 3/17/2007 |
| Q: I am running a MySQL query using product ids like this: SELECT * FROM products WHERE product_id=510 ... A: The only way I can see doing this is to use a temp table to supply the IDs. This table (call it ... | |
| internet explorer | 1/31/2007 |
| Q: When i open an internet page i get this message: a runtime error has occurred. do you with to debug? ... A: Is it on all pages or just one? The error usally means there is somne code on the page that is ... | |
| inquary | 1/27/2007 |
| Q: The text above is a follow-up to ... -----Question-----The text above is a follow-up to ... ... A: Pho, I have tried to help you. What you are asking for is for me to teach you what is already in ... | |
| formatting | 1/23/2007 |
| Q: i am aashish , i had win 98 on my c drive , than i removed win 98 by formatting c partition and ... A: First, you can't format a drive from that drive. You would have to boot to a Win 98 bootable floppy ... | |
| inquary | 1/20/2007 |
| Q: The text above is a follow-up to ... -----Question----- My name is Pholone. I'm from Myanmar.I have ... A: A Disk Image is an exact sector by sector copy of what's on your hard drive. The other type of ... | |
| inquary | 1/19/2007 |
| Q: My name is Pholone. I'm from Myanmar.I have a problem about my PC.I want to backup my system ... A: There are different types of Recovery Disks. Some recovery Disks, run a program that reformats your ... | |
| Searching in database | 1/13/2007 |
| Q: I am an enthusiastic amateur cook and want to organize my hundredes of recipes, scan them to my PC ... A: There are any number of recipe databases out there. You can probably find some freeware at places ... | |
| a ques. | 11/9/2006 |
| Q: in excel, can u plz suggest a way by which i may put a formula in one cell and based on the result ... A: You would have to use VBA code for that. Which would then have to be triggered by some action. Why ... | |
| starting a business | 10/5/2006 |
| Q: I am on the process of starting an online company. I was wondering if you could tell me how to ... A: If you are setting up an online store, without much technical knowlefdge, I would either go with an ... | |
| Excel/Spreadsheet formula | 9/28/2006 |
| Q: Yes I know that, but how would you get it to, say, look at z10 thru z20 and put the info from a10 ... A: First is the concept of relative addressing. Lets say you have columns of numbers in Cols AB & B. ... | |
| Migrateing All Data | 9/20/2006 |
| Q: I Have recently brought a brand new 150gig sata hard drive and need to transfer everything from my ... A: Partition Magic and Norton Ghost First install PM and partition the SATA drive. I would suggest, ... | |
| Virus attack | 9/16/2006 |
| Q: 1.my computer was infected with W32.Rontokbro virus.the virus has changed few of my drive names and ... A: WinRar is a wellknown program and Download.com is a respected shareware site. I've downloaded from ... | |
| Leadership in community of practice | 9/16/2006 |
| Q: I need to find some informations about the role of the leader in the communities of practice on ... A: I don't know of anything specific, but a WEB search of "Virtual community leadership" might find ... | |
| Partitions | 9/13/2006 |
| Q: I have an old gateway P3 (1999) for some reason "C" drive has a total of approx.8GB and "D" has ... A: No, actually C should have the smaller space and should be used only for the OS, Other partitions ... | |
| data flow chart | 9/8/2006 |
| Q: sir, i want the data flow diagram for the topic "customer service". please send me the reply by ... A: First, the people who answer questions here volunteer their time and expertise. They do not take ... | |
| Retrieving lost input data | 9/8/2006 |
| Q: I have no idea if it's even physically possible to do this but I was up late typing up an CD review ... A: You can try looking in your cache (Temp Internet Files), but I doubt if its there. Generally when ... | |
| Cleaning Up Computer? | 9/4/2006 |
| Q: I have used 58.3 GB of my 74.4 GB hard drive and would like to do some serious organizing and ... A: I would not use online storage. I would get another Hard drive, either external or internal to ... | |
| Backup | 8/21/2006 |
| Q: I have 2 internal hard drives 40g master and 80g slave.Through a class action suite against Western ... A: I don't know what retrospect calls their backup files. But there are a few things you can do. First, ... | |
| formatting/cleaning hard drive | 8/20/2006 |
| Q: I run XP. I have an 85gig hd. I have bought a 250g removable drive to allow me to get rid of the ... A: First, the only thing you want to copy are DATA files. If you are reinstalling a clean version of XP ... | |
| Software transfer | 8/18/2006 |
| Q: I've bought a new PC. Now I would like to transfer software like Microsoft Office, Photoshop, Adobe ... A: What I recommend is to install each program from the original disk or file. What you might try is ... | |
| Access 2000 table/query design function | 8/15/2006 |
| Q: Followup To Question -Hi Scott, working with access2000 SP3 on XP SP2. database: worktime and ... A: Ok, DutyDays and Flight Assignments looks good now with one change. While I am normally against ... | |
| Access 2000 table/query design function | 8/15/2006 |
| Q: Followup To Question - Hi Scott, working with access2000 SP3 on XP SP2. database: worktime and ... A: OK, I follow this so far. Just the mention that the industry is aviation helped a great deal. I ... | |
| Access 2000 table/query design function | 8/15/2006 |
| Q: working with access2000 SP3 on XP SP2. database: worktime and production; scheduling discription of ... A: Ok, that helps a great deal, but it does suggest that you need to change your structure. The fact ... | |
| Access 2000 table/query design function | 8/15/2006 |
| Q: working with access2000 SP3 on XP SP2. database: worktime and production; scheduling discription of ... A: Well the first thing is you DON'T store the calculated values. As a general rule, we do not do store ... | |
| Complete system backup | 8/8/2006 |
| Q: I have just started to restore my system after a hard drive crash. My data is reasonably intact as ... A: Yes, but I would recommend that you make a change to your backup process. I would suggest that you ... | |
| Program backup | 8/6/2006 |
| Q: While this question isn't in your direct field it will probably be simple for you. I have several ... A: If there is I haven't heard of one. The reason why there probably isn't is because when a Windows ... | |
| USB Travel Key | 8/3/2006 |
| Q: I have a USB Travel Key, already formatted and do not no how to use it. Please direct me to a site ... A: I'm not sure what you mean by a Travel Key. Didn't it come with instructions? If you are talking ... | |
| USB Flash Drive is write protected | 7/31/2006 |
| Q: I have a 2gb USB flash drive. Somehow the drive became write protected. I can't even reformat the ... A: Some Flash drives have a slide switch that makes them write protected. You might want to check for ... | |
| Offsite backups | 6/22/2006 |
| Q: I want to backup offsite daily to a computer at my residence. I have a mirrored server in my office ... A: You could, but not sure exactly how. You would have to establish a connection to the home PC using a ... | |
| Nero Backitup | 4/29/2006 |
| Q: I tried Ghost but all I remember is that it said something about maybe making an image but it would ... A: An image will take up a lot of CDs. That's why I partition my drives. My C partition only holds the ... | |
| Nero Backitup | 4/29/2006 |
| Q: I want to be serious about backing up my data. I want a backup system where I copy folders and files ... A: I'm not familiar with Nero's product. But there are many backup utilities that work as you describe. ... | |
| Locator System Technology | 4/4/2006 |
| Q: I am exploring the feasibility of installing & maintaining an object locator system in a heat ... A: I would suggest doing research on RFID. This is a fairly new technology. An RFID tag is a small ... | |
| External hard drive for backups | 2/21/2006 |
| Q: Scott I wondered if you know of reliable, easy-to-use external hard drives to use for backup of ... A: Sure, the partitions do not have to be on the same drive. Not sure if it would help anything ... | |
| External hard drive for backups | 2/21/2006 |
| Q: Scott I wondered if you know of reliable, easy-to-use external hard drives to use for backup of ... A: Let me tell you what my backup strategy is, I think it will help you because we have a similar ... | |
| Personal PC backup | 1/23/2006 |
| Q: Scott, I am a web developer, recent grad. I use my personal laptop for work and need to find a data ... A: There are several companies selling external hard drives that come with backup utilities. Such ... | |
| company info | 10/27/2005 |
| Q: Who and when founded Reebok International Ltd.? A: Questions like this are a lot more quickly answered by going to a search engine like Google and ... | |
| Excell Spreadsheet Application | 9/26/2005 |
| Q: I'm sure this is easy but for whatever reason I am having a "brain pause" and can't figure it out. ... A: MS Query can be used to query a table within Excel, even with 97. The thing is you need to put the ... | |
| Company & Personal Database Research | 8/22/2005 |
| Q: I am a database researcher. I have spent 35 years of my Life to develop a blue print (The Test-tube ... A: The best suggestion I can make is to approach Google with it. Google has been very encouraging of ... | |
| Storage Area Networks | 5/23/2005 |
| Q: What kind of person(job title etc) would be an expert(or the person to go to) for Diaster Recovery ... A: There may be many titles to cover that. Disaster Recovery Specialist, Business Continuity Planner ... | |
| paperless design | 4/11/2005 |
| Q: how can i performe a paperless design? thank u Answer - You need to explain this in much greater ... A: Go to aiim.org. This site is a trade organization that specializes in document management, imaging ... | |
| Deleting data | 1/19/2005 |
| Q: I wonder if you know how to permanently delete Internet-related data and files that can tell you ... A: First, let me say that the likelihood of someone spying on your surfing is not great. Second, I ... | |
| IT | 10/22/2004 |
| Q: http://www.cioinsight.com/article2/0,1397,1456958,00.asp Thank you so much! by the way do you also ... A: The last time you asked me a similar question you did it both here and on Answerway as well. Just ... | |
| Should a public library teach Access? | 9/25/2004 |
| Q: At a large public library, I teach everything from mousing and internet to all the Office software. ... A: Depends on what level you want to teach it too. I don't think 4 hours would cover much. I would ... | |
| large data files | 9/17/2004 |
| Q: wonder if you can help me please? I have a text data file with over 2M lines that I can only fully ... A: By "not too hot on" do you mean not knowledgeable or not fond of? If the latter, why not? I'm not ... | |
| data warehouse | 7/15/2004 |
| Q: I am putting a proposal togther and need your advice. I need to know the pros & cons of the ... A: The purpose of a data warehouse is to group disparate tables of corporate information together for ... | |
| automating chart generation from a statistical application | 6/14/2004 |
| Q: I am relatively familiar with Excel, but new to automation and need to accomplish the following: I ... A: This is not an area where I'm strongest, but I may be able to give you some hints. The first point ... | |
| round | 4/6/2004 |
| Q: Fine! Hello I am Fanju. I need to backup my computer, what you recompense? I have window95 with ... A: I think the word you are looking for is recommend. As for backing up your PC, the main issues are ... | |
| WinXP System vol. incorrect | 7/16/2003 |
| Q: After updating WINXP I could no longer read cds in either of my cd drives. I restored a factory ... A: Did you check the cables and such to see if the Cd is connected properly? Did you check CMOS ... | |
| DVD STORAGE | 3/24/2003 |
| Q: WHAT IS THE DIFFRENCE BETWEEN DVD+ AND DVD- DISKS I HAVE SEE 2 SIDED - BUT NOT 2 SIDED + AND CAN ... A: The differences are technical but the issue is they are different formats so are not compatible when ... | |
| DVD+R STORAGE | 3/24/2003 |
| Q: IS THEIR A DVD+R OR DVD+RW STORAGE DISK THAT IS BIGGER THAN 4.7GB. IF SO WERE DO YOU FIND THEM A: Not currently. Professionally mastered DVDs can be 2-sided and store 9.4G. But DVD burners are only ... | |
ScottGem
Top Expert on this page
Expertise
I have been an IT professional for over 16 years. During that time I have accumulated a large store of knowledge and experience. This allows me to assist with a large variety of technology issues. My specialty is Database design primarily with MS Access. However, I can answer questions on many different IT related topics.
Experience
I have worked in IT support for over 16 years. I have also helped people in cyberspace for a good portion of that time. I have been a volunteer staffer on Prodigy and AOL. I was the #2 ranked expert at AskMe.com (#1 in Technology) and am currently ranked at or near the top at Answerway.com and PointAsk.com.
©2012 About.com, a part of The New York Times Company. All rights reserved.