| Subject | Date Asked | Expert |
|
| MS Access AutoNumber feature | 11/20/2009 | Scottgem |
Q: I have a database that contains two tables (Activate %26 Wirelist) with a "auto-number" column (WID) ... A: If I follow you, you have two tables in one to many relationship. What's not clear is which is the ...
|
| How to connect a text field to combo box | 11/20/2009 | Scottgem |
Q: "Yes", "No". There's a text box underneath it "Incident number". If user selects "Yes" I want the ... A: I would not use a combo in this case. I would use either an Option Group or a Check box. But the ...
|
| To calculate gross,Net salary for an employee in Access | 11/20/2009 | Scottgem |
Q: I need to calculate the net and gross salary for an employe in Ms Access..that to by writing the ... A: Depends on the structure of your database. The proper structure would be using three tables like ...
|
| ACCESS - modify date | 11/19/2009 | Scottgem |
Q: I've implemented the suggestion to add the date modified to a table that is changed via a form. But ... A: Users should NEVER interact directly with tables. All interaction with the data should be done ...
|
| Search mode?? | 11/19/2009 | Scottgem |
Q: I'm new to Access 2007 and have a problem. I've created some tables, queries and reports. I was ... A: Well first you really shouldn't be entering data directly into tables. You should be using forms. ...
|
| Donations Database | 11/19/2009 | Scottgem |
Q: So what i did was create a couple of databases and made sure that nothing overlaps. Here are my ... A: Good start, but room for improvement. First, I recommend naming your PKs using the convention ...
|
| Problems getting forms to work. | 11/19/2009 | Scottgem |
Q: I am not totaly good with access. The problem is: I have many tables setup and working like I need ... A: First, you don't need another table. Vistors should be entered in your People table. You should have ...
|
| Searching for a string in my access form that is made up of text and numbers. | 11/19/2009 | Scottgem |
Q: e. "COMM-125" and other simple text strings? Here is my coding for it thus far: Option Compare ... A: The problem here is the value returned by cboSearchfield. As a rule its is not a good idea to put ...
|
| coding vba | 11/19/2009 | Scottgem |
Q: Please advice on this code What i am trying to do is i have a todo list, and promt me when there is ... A: So what you are trying to do is check periodically if a new task has been added and pop up a ...
|
| Coding in VBA | 11/19/2009 | Bob Heifler |
Q: Please advice on this code What i am trying to do is i have a todo list, and promt me when there is ... A: Shermund, The form probably shows new records without the me.requery since it's probably bound to a ...
|
| Problems getting forms to work. | 11/19/2009 | Scottgem |
Q: I am not totaly good with access. The problem is: I have many tables setup and working like I need ... A: I have one word for you: Subforms! You should find this blog of mine useful: ...
|
| MS Access 2003, Filtering Data Using Forms | 11/19/2009 | Scottgem |
Q: MS Access 2003, I have one table like this with 4 fields, AdmissionDate: AdmissionTime: Discharge ... A: Use the Filter By Form feature. Create a form in Tabular format using the Form Wizard. Then use the ...
|
| Query for different records for identical data | 11/19/2009 | Scottgem |
Q: I have a multi-record table of plant species canopy cover data for 1/10 acre plots/sample areas. ... A: I'm not clear what you want as a result. You can use the Query wizard to create a duplicates query. ...
|
| how do i perform a Count(Distinct) query for 2 different column values using GROUP BY | 11/18/2009 | Scottgem |
Q: I have this "source" table like this.... |------------------------------------| |ROLLUP_ID | ... A: Actually I don't see two columns using DISTINCT. You are Grouping By Rollup_ID. You are counting ...
|
| Dollar per mile problem | 11/18/2009 | Scottgem |
Q: I have two tables: Table: Petty Cash Register Fields: PCVDate, Vehicle (This is a lookup with ... A: Actually your problem is more on the back end. Since you are recording mileage BEFORE pumping gas, ...
|
| Searching for a string in my access form that is made up of text and numbers. | 11/18/2009 | Scottgem |
Q: e. "COMM-125" and other simple text strings? Here is my coding for it thus far: Option Compare ... A: You have the right idea, just the wrong execution. I don't understand why you are using the Replace ...
|
| Form Parameter for Multiple Values | 11/18/2009 | Scottgem |
Q: I have a form that has 1 list box to select multiple facilities name. That form is based on 1 query ... A: Yes it does work if done correctly. So the question is what about it doesn't work? Did you use the ...
|
| Medical Research Study Database | 11/18/2009 | Scottgem |
Q: I have searched google on trying to create a questionnaire type database. I have knowledge of Access ... A: First, no, you have one Answer field. What the QuestionType does is allow you to modify the form ...
|
| Code for a botton | 11/18/2009 | Scottgem |
Q: I have 2 tables; a table for student information and another one for their reports. 2 tables are ... A: Of course you can. A subform is just a form embedded onto a main form. You can do just about ...
|
| No selectable user. Auto pull-up. | 11/18/2009 | Scottgem |
Q: I am new to access. This might be the simplest question you might answer but for me it hasn't worked ... A: First, while I'm perfectly capable of writing VBA code (I wrote a book on it after all) I don't use ...
|
| Entering Dates in a Form | 11/18/2009 | Scottgem |
Q: MS Access 97 (company won't spring for upgrade). I have a date field that I would like users to be ... A: I'm not sure if this works in Access 97u (I believe it does), but if you have no input mask at all ...
|
| Conversion of date stored as text to usable date format | 11/18/2009 | Scottgem |
Q: This is my response to your answer of my first question. Both my first question and your answer are ... A: I gave you the answer, but you didn't answer an important part of my followup, namely how does the ...
|
| Dollar per mile problem | 11/18/2009 | Scottgem |
Q: I have two tables: Table: Petty Cash Register Fields: PCVDate, Vehicle (This is a lookup with ... A: Try doing this: Create a query that returns all records for the period but groups by vehicle and ...
|
| Looking up a value in a table | 11/18/2009 | Scottgem |
Q: I have a table, which I would like to add a column to and populate with data. This data would be ... A: You may have to do this in several passes. What you need to do is first create a SELECT query that ...
|
| locking records in table/datasheet view | 11/18/2009 | Scottgem |
Q: Multi users are entering data in a single table(datasheet view) which has many fields ... A: Users should NEVER interact directly with tables. By letting your users do so, you have created a ...
|
| Access output to word table | 11/18/2009 | Scottgem |
Q: I am using MS access database to store some employee information. Few employee's information are ... A: You can't. What you CAN do is copy and paste the table to an Excel spreadsheet. If the Word doc is ...
|
| Databases | 11/18/2009 | Scottgem |
Q: Mr. Gem, I am attempting to create a model for a student database... The details I'm concerned ... A: For the first issue you need a Curriculum table So BSC Software Engineering would be a curriculum. ...
|
| Databases | 11/18/2009 | Scottgem |
Q: Mr. Gem, I am attempting to create a model for a student database... The details I'm concerned ... A: You have a many to many relationship. That means you need a Join or Junction table to handle it. ...
|
| lookup equation for foreign exchange DB | 11/17/2009 | Richard Rost |
Q: Vlookup the currency table (name: CCY) for the text, e.g. AUD, or USD. Then return the value of the ... A: You can use the DLOOKUP function to look up a specific value from a table or query. Please see the ...
|
| Autopoulate with Value | 11/17/2009 | Scottgem |
Q: I have a database whereas I track new building permits issued. In this database I have several ... A: I'm assuming that the Owner info is in the Permits table where there is also a Foreign Key for the ...
|
| Form Parameter for Multiple Values | 11/17/2009 | Scottgem |
Q: I have a form that has 1 list box to select multiple facilities name. That form is based on 1 query ... A: If you are selecting multiple items, you need to build a WHERE clause in code by looping through the ...
|
| Adding a record to a subform when it's based on a query | 11/17/2009 | Scottgem |
Q: Help... I wrote an Access 2003 app 2 years ago and all of a sudden, on October 29th, 2009, it ... A: Lets dissect this. "I have to calculate a percentage using the ACTUAL ATTENDED hours vs. EXPECTED ...
|
| database reports | 11/17/2009 | Richard Rost |
Q: I am having trobule linking information that is added in a form to show up in the report. Any ... A: Forms don't hold data. TABLES hold data. If your form was designed properly, it saves its data in a ...
|
| Code for a botton | 11/17/2009 | Scottgem |
Q: I have 2 tables; a table for student information and another one for their reports. 2 tables are ... A: I wouldn't do it that way. Instead create a main form with a subform. The subform is bound to the ...
|
| Sum Field in Reports | 11/17/2009 | Scottgem |
Q: I have a report from a query, in which I have fields which are scores from 0-5. I need to be able ... A: Well, this first indicates that your database may not be designed properly. If you have multiple ...
|
| display a MS word DOC on my form | 11/17/2009 | Scottgem |
Q: I am using office 2007 My application have an employee table %26 each employee has a word document ... A: You can use an Unbound Object frame control. You would then add code in the On Current event of your ...
|
| Access Autonumber reset every month or every year | 11/17/2009 | Scottgem |
Q: I work in a admin office. And I need records from all the paper work that come and go. But to find ... A: An easy way to find this is to count up all the left brackets and all the right ones to make sure ...
|
| query for access 2007 | 11/16/2009 | Scottgem |
Q: I am supposed to write a query which involves figuring out a rental rate with a 15% discount and I ... A: Yes this does make sense, but in another way it doesn't. First, let me explain that I generally do ...
|
| Adding a record to a subform when it's based on a query | 11/16/2009 | Scottgem |
Q: Help... I wrote an Access 2003 app 2 years ago and all of a sudden, on October 29th, 2009, it ... A: First I wouldn't laugh at you code. There are a lot of people who get thrown into a position and ...
|
| Please help me | 11/16/2009 | Sayedaziz |
Q: I have to design a simple super market data base where in i had two tables,one is Store_goods where ... A: is it homework or work asiignment. If it is work assignment then you should condsider for POS ...
|