You are here:
- Home
- Computing/Technology
- Business Software
- Using MS Access
Using MS Access/Questions Answered by Expert Lisa Sims
| Subject | Date Asked |
| Trying to figure out how to count values within a group | 9/12/2007 |
| Q: I am trying to count/find the page count. or more like to find how many pages(blanks) are within ... A: You may want to consider using a crosstab query to produce the result that you are looking for. ... | |
| creating field from multiple sources | 8/15/2007 |
| Q: I am a novice to Access and really need help. I have a table containing the following data: LE ... A: To create the LE-OU/DEPT field, you will need to use the concatenation character (&) within a query ... | |
| Dbase Query | 8/11/2007 |
| Q: I have a dbase database with six million lotto combinations, each one with 6 numbers from 1 to 51. ... A: I would suggest using the count function along with the dbase equivalent of the substring function ... | |
| Access 2007 - How to view records in a form | 8/10/2007 |
| Q: ). I have created a database with 4 separate tables and linked them all together. I have created a ... A: It seems as though you may have a problem with the links between the tables that you have. Have you ... | |
| A Formula to Extract Data | 8/9/2007 |
| Q: I am working in access and have hundreds of thousands of rows of varying length. Basically, the data ... A: There are many ways to accomplish this but the easiest in my opinion is to use the VBA split ... | |
| How to undo some, not all bound controls on a form | 7/31/2007 |
| Q: I'm trying to figure out how to do this. I have an order app with two major forms with bound and ... A: Unfortunately, I do not know of a way to clear bound controls due to the fact that they are bound to ... | |
| Displaying related records in another table | 7/30/2007 |
| Q: I have a form that displays a record from my table, and I also have a subform that displays all ... A: You can use the Dcount function but you just have to specify the matching criteria (matching field ... | |
| Photo uploading | 7/25/2007 |
| Q: I am in the process of developing a database that I hope to market to the general public. However ... A: The best suggestion that I can give is to create a form that has about 5 textboxes (or prompt the ... | |
| Photo uploading | 7/24/2007 |
| Q: I am in the process of developing a database that I hope to market to the general public. However ... A: Have you tried the aspupload component that will allow users to upload images to a web server? This ... | |
| Linking Access to a website | 7/22/2007 |
| Q: I have got an Access database that I would like to share with friends. Ideally I have a tool that ... A: There are many options that you can use but they depend on your skill level. The simplest solution ... | |
| Using a Date field in a form | 7/18/2007 |
| Q: I use a date field in a form that lets my engineers update the tasks that they carry out in a day. ... A: My suggestion would be to add a button beside the date field that users can click to overwrite the ... | |
| Displaying 2 tables in one form | 7/17/2007 |
| Q: I have a database with 2 tables that contain almost exactly the same data structure. I will not go ... A: I would suggest using the subform method. Instead of setting up a parent/child relationship where ... | |
| Drop-Down List Configuration | 7/14/2007 |
| Q: I designed a form to enter employees who are working a shift. The combo box accesses a query with ... A: You are using the BoundColumn property correctly because it tells Access which column in the combo ... | |
| Memo Field question | 7/8/2007 |
| Q: I need to add a note (append) to the memo field in the customer table when clicking on a command ... A: Here's a sample of what the code could look like: Dim strsql Dim strMsg strMsg = "Confirmation sent ... | |
| How to code radio buttons to open a new form | 7/6/2007 |
| Q: I am new to this and I am trying my best to understand the code thing, so go easy on me. I have use ... A: What you will need to do is determine the value of option group radio buttons (yes or no) and save ... | |
| MS Access | 6/28/2007 |
| Q: I have written a database for my office(general contracting) now I want to put it on the office ... A: It depends on how many users you have. Your best option that will grow with the number of users is ... | |
| query | 6/26/2007 |
| Q: I have a product table with wholesale prices by quarter. the fields are Product Name, qtr1Price, ... A: Pat, I wouldn't suggest storing a calculated value in the table because it goes against proper ... | |
| How to update quantity in stock control system | 6/24/2007 |
| Q: I am doing a project on stock control for a shop. I must be able to update my quantity in stock when ... A: Sameer, My suggestion would be to create an update query that executes at the time of a purchase ... | |
| References | 6/23/2007 |
| Q: I would like to know what check box is related to which library for example i can not find the ... A: I'm not sure I understand your question. I would suggest going to Tools/References and verify that ... | |
| Query? | 6/21/2007 |
| Q: I have a client list database. The phone number field is 10 digits. I want to work only a certain ... A: Here's my suggestion: Create a query that includes all the fields in table 1 and create an ... | |
| Query? | 6/20/2007 |
| Q: I have a client list database. The phone number field is 10 digits. I want to work only a certain ... A: Without seeing your tables, you will need to have some way to link these tables based on a common ... | |
| restrictions, limitations, problems? | 6/18/2007 |
| Q: I want to ask the restrictions, limitations, and problems using Microsoft access 2003 and My SQL in ... A: It all depends on how you plan to use Microsoft Access 2003 and MySQL. Microsoft Access is not a ... | |
| Value of a check box to determine action for a Query | 6/17/2007 |
| Q: Hope you can assist me with the following as I am really new to check boxes - I need to add a check ... A: You will need to write SQL that can be used as the basis for a subform (or other form) that displays ... | |
| Several Issues Here (mostly with "Pages") | 6/16/2007 |
| Q: I am new to using Access 2003, and I generally pride myself on an ability to figure out most ... A: My suggestion would be to create queries that the pages are based on with the necessary criteria. ... | |
| Using forms to search different tables at the same time. | 6/15/2007 |
| Q: I'm guessing this is easy to do but I am having a very hard time figuring it out. Basically I need ... A: Depending on the number of fields you have in your tables, this could be difficult. You basically ... | |
| Queries | 6/14/2007 |
| Q: I have created a database. I have formulas on the queries. But how can I get the query to pull out ... A: I would remove the formula for the 'in standards' field because you are basically trying to do the ... | |
| beginning balance in report | 6/13/2007 |
| Q: I'm making a report (group by date, monthly report) containing these fields: date, transaction ... A: Anita, Here's my suggestions. First, I would try using the Dsum function to sum the credits and the ... | |
| Parsing out and formatting as a date field | 6/13/2007 |
| Q: I have a column of data that looks like this: 20070403 20050203 20060103 That string of numbers ... A: To parse this column of data, use the mid function and append the "-" with the code or query as ... | |
| Msgbox | 6/12/2007 |
| Q: How do I incorporate a msgbox function so that when a book is searched for a message is shown to ... A: Ronke, To incorporate a msgbox function you will have to use VBA code. Your code will need to ... | |
Using MS Access
Answers by Expert:
Lisa Sims
Top Expert on this page
Expertise
I can answer Access questions pertaining to database design (proper normalization), query design, VBA coding, macros, forms, and reports. I have worked with clients, big and small, to create and correct problems with their Access databases.
Experience
I have been using Microsoft Access for over 12 years and make a living as a professional database consultant via my company, The IT Mechanic (www.theitmechanic.com). I have worked with various clients (big and small) on creating and correcting their Access databases.
Organizations
I am the founder of The Business Professionals Network (www.bpronetwork.com), an organization created to empower small businesses with the necessary resources for success. I am also a member of the Rockdale Chamber of Commerce in Conyers, Georgia. Likewise, I am a board member with the nonprofit organization Diva Girls in Lithonia, Georgia.
Education/Credentials
I have a BBA from Georgia State University with a major in Computer Information Systems. I also possess a Masters of Science in Computer Information Systems from the University of Phoenix Online.
©2012 About.com, a part of The New York Times Company. All rights reserved.