| Subject | Date Asked | Expert |
|
| Access Command button | 7/11/2009 | Scottgem |
Q: Please I needs help on Access.I have a Form with this field DATE,QUANTITY,BOOKS,ISBN & AVAILABLE ... A: First, you do not have fields on a form, you have controls that may or may not be bound to fields in ...
|
| Relationships & forms | 7/10/2009 | Scottgem |
Q: Please help me connect the tables so i can use the forms to enter data to run queries and reports. ... A: Sorry that is not much clearer, but your additional info helps. The three tables that are at issue ...
|
| Relationships & forms | 7/10/2009 | Scottgem |
Q: Please help me connect the tables so i can use the forms to enter data to run queries and reports. ... A: First, the screen shot shows your tables have relationships set. Unfortunately the screen shot is ...
|
| Relationships & forms | 7/10/2009 | Scottgem |
Q: Please help me connect the tables so i can use the forms to enter data to run queries and reports. ... A: First, you do NOT need to connect the tables (using the Relationships Windows) to use forms, queries ...
|
| report layout shows 2 pages, print preview shows 1 | 7/10/2009 | Scottgem |
Q: I have a very simple database, keeps track of addresses by category. Example: Photography - Yuen ... A: hmmm, that does sound wierd. You can send a zipped copy of the database to: dafiles at ...
|
| Form / Combo box issues | 7/10/2009 | Scottgem |
Q: So I think i'm getting closer, but still having some problems with my form. Perhaps it is best to ... A: 1) No, that is the way to do it. 2) If its showing a blank record, then your query is returning a ...
|
| Displaying name of who is in the database | 7/10/2009 | Scottgem |
Q: Scott, Is it possible for me to find out the IP or Computer name or the current person in a ... A: Yopu can use the sample found here: http://www.mvps.org/access/modules/mdl0055.htm Another tool I ...
|
| Checkbox/textbox pairing | 7/10/2009 | Scottgem |
Q: I have a database that I have imported data into from an excel spreadhseet. Part of the spread sheet ... A: I don't think you need to do this. So before I provide a solution, I'd like to know more about your ...
|
| Expiry date | 7/10/2009 | Scottgem |
Q: some of the courses dont expire but some do. i have entered an expiry field on the course form, ... A: You do this in a query. In your query add a column like so: Expiration: ...
|
| POP Up in MS access | 7/10/2009 | Scottgem |
Q: I have created a database where there is a follow up, i want to put up a pop up window such that ... A: Without knowing how one determines if a followup is necessary its hard to advise. But you can use ...
|
| Parameter Query | 7/9/2009 | Scottgem |
Q: I need a Parameter Query to accept more than one entry so i can have it return the resuls for ... A: I rarely use Parameter queries because they are so limiting. The way around this is to use a form to ...
|
| Query | 7/9/2009 | Richard Rost |
Q: I need a Parameter Query to accept more than one entry so i can have it return the resuls for ... A: I would do this as a form. Make a form with the most number of text boxes that you think you would ...
|
| Filtering subreport to a record that is using the same table as the parent report | 7/9/2009 | Richard Rost |
Q: I have a pretty complex problem and I hope it possible to even achieve. Basically I have a form set ... A: I wouldn't use a filter. Just set up two queries - one based on each of those combo boxes - then use ...
|
| Calculating Age in Access 2007 | 7/9/2009 | Richard Rost |
Q: I am trying to calculate age in Access 2007. I need the exact age, not just the datediff age. I have ... A: How exact? To the day? DateDiff is pretty exacting, but you could also just use regular old date ...
|
| ID column | 7/9/2009 | Scottgem |
Q: I'm working on a database. I want to include a field named "ID" that is NOT the primary key and want ... A: Again, I can't answer a lot of your questions because it deals with YOUR workflow. I can tell you ...
|
| Replicating in MS Access 2007 | 7/9/2009 | Scottgem |
Q: I was using the replication feature in earlier versions of MS Access, to be able to work on my ... A: Replication exists in Access 2007. If you look up Replication in Access 2007 you will find ...
|
| Updateing table field when a macro is run | 7/9/2009 | Richard Rost |
Q: I am new to Access (but ok at vba in excel) and have being trying to find the answer to what must be ... A: If all you care about is the LAST date that a macro was run (and you don't need to store a complete ...
|
| Formatting | 7/9/2009 | Bob Heifler |
Q: I am trying to get a field to read top to bottom instead of left to right as to create a list to ... A: Michelle, Access version 2000 and later has as a report control property on the 'Other' tab in the ...
|
| Auto populate fields | 7/9/2009 | Scottgem |
Q: I have a multi-column combobox in a form that I want to have autoupdate 3 text fields. i have ... A: What is the bound column, 1? If you set the controlsource to read the appropriate column, you can ...
|
| Auto populate fields | 7/9/2009 | Scottgem |
Q: I have a multi-column combobox in a form that I want to have autoupdate 3 text fields. i have ... A: I think the problem here is that you are using unbound controls. When you set the value of an ...
|
| Covert number of days to date | 7/9/2009 | Scottgem |
Q: i have this issue of converting days to date. eg 18809 which is: 188 are days starting from first ... A: This is assuming, the value is a text field, if not it need to be connverted to one. This would be ...
|
| Running a Query Based on Checkbox Results | 7/9/2009 | Scottgem |
Q: ! I'm sorry I keep coming back to you, I tried to find this answer, and couldn't. Could be there, ... A: No problem in coming back to me when you need help and can't find a similar question. I need to ...
|
| ID column | 7/9/2009 | Scottgem |
Q: I'm working on a database. I want to include a field named "ID" that is NOT the primary key and want ... A: I've answered several questions that were essentially the same as yours. The first issue is that you ...
|
| Form Design | 7/8/2009 | Scottgem |
Q: I asked a question earlier about using unbounded controls and realize that there is probably a much ... A: First, I don't see the need for the Report dates table. I would just have two tables: tblReview ...
|
| Ms Access | 7/8/2009 | Richard Rost |
Q: I have 5 forms in Ms Access 2003 and want to embed them into one main form and use back and fort ... A: Yeah, you'd probably need a little VBA for this. I would suggest making 5 subforms and then make a ...
|
| Form Design | 7/8/2009 | Scottgem |
Q: I asked a question earlier about using unbounded controls and realize that there is probably a much ... A: First, I would add an autonumber primary key to your table. Second, I would set the table as the ...
|
| Event on form closure? | 7/8/2009 | Richard Rost |
Q: First and foremost I want to thank you for all of your help with this database I must say this would ... A: You can prevent the form from closing by going into the form properties and turning off the CLOSE ...
|
| setting up a complex query in Access | 7/8/2009 | Scottgem |
Q: I am using Microsoft Access 2002-2003 and am having problems setting up a complicated query using ... A: When faced with complex queries, I try to build the queries using interim queries. I define an ...
|
| Repeating details | 7/8/2009 | Richard Rost |
Q: I am creating a report based on 1 table (RTL). The fields being used from the table in the report ... A: What does your TABLE DATA look like (show me a few records)? What do you want the REPORT to look ...
|
| Form layout | 7/8/2009 | Scottgem |
Q: I have created a form with the Access 2007 forms wizard. The form has the fields laid out in 2 ... A: First, you don't have fields on a form. You have controls that may or may not be bound to a field in ...
|
| List Box altering equations | 7/8/2009 | Richard Rost |
Q: I am attempting to create a formula that will alter itself according to a list box the users choose ... A: You can use an AfterUpdate or BeforeUpdate event to set values, change properties, run macros, and ...
|
| Auto populate fields | 7/8/2009 | Scottgem |
Q: I have a multi-column combobox in a form that I want to have autoupdate 3 text fields. i have ... A: I wrote an article on this issue which can be found here: ...
|
| Setfocus | 7/8/2009 | Richard Rost |
Q: I have a subform with the emplid as the first feild. when they tab it does the Dlookup. If it can't ... A: If you want to refer to a value on a Form, you can use the notation: Forms!FormName!FieldName You ...
|
| Combo Box | 7/8/2009 | Richard Rost |
Q: I currently trying to make two combo boxes synchonize where one updates based on the selection from ... A: I get asked this question all the time. You've got two or more combo boxes and you want the first ...
|
| Filters | 7/8/2009 | Richard Rost |
Q: Earlier you were asked this: Question Hi, Creating the report of the access from which contain ... A: Sure, you can either use a parameter query to ask for the user ID: ...
|
| MS Access Maximum Users | 7/8/2009 | Scottgem |
Q: I have a shared Access application where all users should log in & then they have to use the same ... A: Generally, I've found Access tends to bog down when the number of concurrent users exceeds 20. ...
|
| IIF Statment | 7/8/2009 | Scottgem |
Q: I am working on a query that has mutliple dates. This is the table structure RequiredStart ... A: Try IIF(([Signature1] > [RequiredStart] AND [Signature1] < [RequiredEnd]) AND (Signature2] > ...
|
| forgot to attach the image.. | 7/8/2009 | Richard Rost |
Q: i send you a question earlier today, but i forgot to attach the image. Here it is. A: I see your relationships now. I think you might be confusing Access with too many related fields. ...
|
| information is not copied into next tabel | 7/8/2009 | Richard Rost |
Q: First of all, I am a complete newbie with using Access, and i do not know anything about ... A: Funny, I didn't know Europe was a country. :) It sounds to me like you know what you're doing. If ...
|
| Min Price as a Comparison / SQL | 7/8/2009 | Bob Heifler |
Q: I am working on an access database system to store product/price information and wanted to write a ... A: Andrew, Yes a group by on product ID and use the visual query grid. Once you do that you can just ...
|