You are here:
- Home
- Computing/Technology
- Business Software
- Using MS Access
Using MS Access/Questions Answered by Expert Don Darracq
| Subject | Date Asked |
| Report Calculation | 5/21/2009 |
| Q: I have a report that calculates two fields in the header. Field 1 Name InvMax, Control Source ... A: There are still too many variables for me to take and "educated guess". If you are willing, I can ... | |
| combo box question MS Access 97 | 1/9/2008 |
| Q: Bob, I have a table Orientation with a one to many relationship with the table Client. I have a ... A: To upload the database, follow these steps; 1)Go to "WWW.Dropboks.com" 2)The sign in should ... | |
| data access thru a pc on network | 1/9/2008 |
| Q: can i use a variable as "adodb.connection" and then open the connection using the "open" method to ... A: The following code is an example of an ADO to a SQL Server: Private Sub Form_Open(Cancel As ... | |
| Form question | 12/28/2007 |
| Q: Can I have a form to input data for a master table and also have a repeating group on the same form ... A: The scenario of entering multiple records, in your case children, for one master record, in your ... | |
| Form question | 12/28/2007 |
| Q: Can I have a form to input data for a master table and also have a repeating group on the same form ... A: I think what you are asking is; Can you use a "continuous form" as a container for additional ... | |
| MS Access Date question | 12/27/2007 |
| Q: I need a series of date fields (each separte in the table) that are generated from a start date. For ... A: Hey Chris - we seem to be missing somewhere. Let's do this. I'll build you a small sample database ... | |
| MS Access Date question | 12/27/2007 |
| Q: I need a series of date fields (each separte in the table) that are generated from a start date. For ... A: This is what I want you to do; 1)Erase everything you wrote in the field to the right of ... | |
| MS Access Date question | 12/27/2007 |
| Q: I need a series of date fields (each separte in the table) that are generated from a start date. For ... A: First make sure that your table has the following fields: Start_date Date_17 Date_30 Date_45 ... | |
| Calculations on Forms | 12/27/2007 |
| Q: I created a main table with several drop down list based on values in other smaller tables. I then ... A: To get the sample database, follow these steps; 1)Go to "WWW.Dropboks.com" 2)The sign in should ... | |
| Access 2003 | 12/26/2007 |
| Q: I have 3 tables within my database: 1. VARSales 2. VARProfile 3. SalesType Some of the queries I ... A: I think that an easier syntax would be as follows; SELECT VARSales.Date, VARSales.VAR, ... | |
| Setting default value | 12/26/2007 |
| Q: I have a form that includes a Date field. I need the date field to be blank when opened. After the ... A: There are several ways to accomplish what you are trying to do. I believe that the best way is to ... | |
| division by zero If statement | 12/21/2007 |
| Q: I would really appriciate ur concern on this matter.please check out why this code still giving me ... A: changing up your code a little bit and got the correct response. Here is what I did: Private Sub ... | |
| Multiple users pulling data | 12/20/2007 |
| Q: Good afternoon! I have a database set up that I am basically going to be using as a workflow tool ... A: Joshua - before I begin looking at this, let me make sure I fully understand the process. For ... | |
| Deletes records in both tables when it shouldn't | 12/20/2007 |
| Q: I have three tables: People (PersonID, Name, etc), ClusterAssignments (PersonID, ClusterID) and ... A: The reason that your records are being unexpectedly deleted is because your query is bound to two ... | |
| Sorting records by date entered | 12/19/2007 |
| Q: when I enter the records into my Access database, will they sort out by the dates I enter or will ... A: The only sorting order for records in an Access Table is the order in which they are entered. If you ... | |
| query | 12/19/2007 |
| Q: I emailed the question below several weeks and got a great answer. However, I am having difficulty ... A: 12AM: IIf([StartTime]<#12:00:00 AM# And [EndTime]>=#12:00:00 AM#,1,0) The "<" after the [StartTime] ... | |
| Comparison Calculation in Queries | 12/18/2007 |
| Q: I'm building this query to do some calculations. Basically I need to compare the current information ... A: Fields added to your table 1) previousRate - datatype NUMBER 2) previousDateRate - datatype ... | |
| Photo's in reports | 12/18/2007 |
| Q: I have probably a very simple question, but I cant find the answer. I have a pretty extensive ... A: do they exist in the access database? Are they Links or Paths to the image ie ... | |
| MS Access - Reports/SendObject Help | 12/11/2007 |
| Q: I have a little problem that I’m not sure on how to approach it: I am trying to send a Report ... A: Good Morning George - In essence, A VBA String continues on one linear line. For the purpose of ... | |
| Data from Subform to Subform | 12/10/2007 |
| Q: . This is gonna be a long story... I'm programming a database to store students exam scrores and ... A: Before I begin, I want to make absolute sure that I am understanding your database structure. You ... | |
| find data | 11/12/2007 |
| Q: i made one small db of training of 20 employee in service company.i made 2 tables, one employee ... A: To get the sample database, follow these steps; 1)Go to "WWW.Dropboks.com" 2)The sign in should ... | |
| How to update records automatically | 11/11/2007 |
| Q: I am making a database for my school project regarding a book shop. I have all the basic knowledge. ... A: To get the sample database, follow these steps; 1)Go to "WWW.Dropboks.com" 2)The sign in should ... | |
| Revision Date/Time fields | 11/9/2007 |
| Q: Please feel free to take another crack at the issue! I'm always appreciate of any help you can ... A: Ok Jeremiah - I believe I have the definitive answer and unfortunately, you will not like it. You ... | |
| COST / BENEFIT ANALYSIS TOOL | 11/8/2007 |
| Q: I have been assigned a project to develop a Cost/Benefit Analysis solution to compare current ... A: What we need is a place to start from. Previously I designed an Access database (ver 2003) that is ... | |
| duplication in reports | 11/8/2007 |
| Q: here is my problem: resources: funder: award: jane doe state ... A: Man I hate to just give up on you like that! The issue is - if Adam Mucci has two entries as the ... | |
| Re: Add Record | 11/8/2007 |
| Q: I would really like your help! I have just created a database with Access 2003. However, when I go ... A: In reference to your question; 1)Open the form in design view and go to its properties and then ... | |
| Revision Date/Time/ID | 11/7/2007 |
| Q: In my db I have a Revision Date/Time & ID fields for each record. For some reason - and this didn't ... A: Jeremiah - this is in response to the active / inactive situation but I don't know if this is ... | |
| Synchronizing two subforms | 11/7/2007 |
| Q: first I want to explain that the db that I'm building is for our Career Services dept (I work at a ... A: very nice work on your Database!! OK - I looked at the SQL string for 'Query Class term 2' and I ... | |
| Making a report based off a query | 11/6/2007 |
| Q: I have 3 tables. One main table populated by a form that contains to combo boxe's. one for ... A: Lets start here. If you have a combo box that contains multiple columns, one being a Primary Key, MS ... | |
| Synchronizing two subforms | 11/6/2007 |
| Q: first I want to explain that the db that I'm building is for our Career Services dept (I work at a ... A: YIKES!!! This was a good one! Ok Jeremiah, my solution is predicated on the fact that what ever ... | |
| dividing a string in a cell | 11/6/2007 |
| Q: .. thanks for your time! I am trying to match up two columns from 2 tables to verify consistency. ... A: The best way to do this is to create a query based on table two. Then type the following code into ... | |
| Lookup Tables | 11/5/2007 |
| Q: I have Lookup Tables and for each table I have a PK and name. In my Lookup combo boxes I have the ... A: Jeremiah - I don't use look-ups that much but I believe I see what you are trying to do. I have ... | |
| Checkbox | 11/2/2007 |
| Q: Don, I need your help with this: I run a parameter query which selects data from a table based on ... A: I designed a small database based on your question to demonstrate what you are wanting to do. To get ... | |
| redundancy in my reports | 11/2/2007 |
| Q: I'm having a problem with my reports. I'm trying to show all the people associated with a single ... A: I think we can separate your data to display properly on a report. it may not be exactly what you ... | |
| Check box | 11/2/2007 |
| Q: You recently wrote a small database for me similar to the code below. Based on what you did for me ... A: in reference to the second issue about the missing reference, there are far too many variables for ... | |
| Access | 11/2/2007 |
| Q: If I have two fields-a Year field for someone's birth year, and an Age field with the person's age, ... A: For this solution I am assuming the following; 1) Your table contains at least 1 field named "Year" ... | |
| redundancy in my reports | 11/1/2007 |
| Q: I'm having a problem with my reports. I'm trying to show all the people associated with a single ... A: is your database already fully populated with hard data records or are you in the design stage. If ... | |
| Opening PDF File from access | 11/1/2007 |
| Q: I have a subform that is linked to a table. there are 5 fields in the table call them 1, 2, 3, 4, ... A: I am just taking a guess. From your question I can ascertain that some action is done to produce ... | |
| query in access | 11/1/2007 |
| Q: I nedd to design a query that shows amount of employyes that took specific training given a date.For ... A: Is this the general manner in which your database works; An employee is chosen from the employee ... | |
| Special Chracter | 10/30/2007 |
| Q: In our Database some names are recorded in parenthesis. For example the Last Name field may have ... A: what you are trying to do is actually very difficult. My solution requires some very long SQL ... | |
| truncate | 10/29/2007 |
| Q: How can I truncate a drop down list so that it only shows 100 characters. If string < 100 it will ... A: The best way I found to do this was as follows; 1) Design a query based on all the fields that are ... | |
| IIF function in a query | 10/29/2007 |
| Q: Don, I need this query to work and I have tried various ways using the below statement. I am getting ... A: The below string does what I think you need. One issue is that you were attempting to name the query ... | |
| Need additional help with Access VB & Nested If Statements | 10/26/2007 |
| Q: This is a followup question to Richard Ross (now maxed out on taking questions)...... Question ... A: Two things 1) Richard is correct, when using multiple if/else/then statements, it is best to use ... | |
| background color change after update | 10/25/2007 |
| Q: I'm trying to change the background color of a text box (called status display) on a form based on ... A: Way to go Rick - About code, if it works then it works - the only time there are flaws is if you ... | |
| background color change after update | 10/23/2007 |
| Q: I'm trying to change the background color of a text box (called status display) on a form based on ... A: HHHHMMMM - interesting idea!! What we would have to do is to somehow distinguish between actions. ... | |
| background color change after update | 10/23/2007 |
| Q: I'm trying to change the background color of a text box (called status display) on a form based on ... A: Hey Rick - open the frm_main in design view. Then go to view on the top tool bar then choose code. ... | |
| background color change after update | 10/22/2007 |
| Q: I'm trying to change the background color of a text box (called status display) on a form based on ... A: Your question is totally clear and helping is no trouble at all! What I have done is to create an ... | |
| How to start with a new record | 10/22/2007 |
| Q: I am new to Access. I need to know how I can modify my forms so that when I open them they always ... A: DoCmd.GoToRecord acDataForm, "frmMyForm", acNewRec Where "frmMyForm" is the name of your form. Don ... | |
| 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: In reference to the first part of your question. You mentioned that there is a formula that ... | |
| OnClick Open specific record | 6/13/2007 |
| Q: I have a database that I want to click in a field (ActivityID)in a subform and have a form open up ... A: Dim stDocName As String Dim stLinkCriteria As String stDocName = '"name of form to open"' ... | |
| delete | 6/13/2007 |
| Q: I have an image database. I use the following coding to delete an record in my database. But it ... A: Ok Rad - next suggestion - Make the code look like this DoCmd.SetWarnings off If MSGBOX("some ... | |
| dsum error | 6/12/2007 |
| Q: I have a small problem. I used the template for fundraising database that I believe I got online ... A: Expr2: (DSum("onetimeamount","Contributors"))+(DSum("AmountPledged","Pledges")) And to get the ... | |
| delete | 6/12/2007 |
| Q: I have an image database. I use the following coding to delete an record in my database. But it ... A: You can try something like this If MSGBOX("some wording",vbYesNo,"Some Title") = vbyes then ... | |
| rank (vba) | 6/10/2007 |
| Q: I would like to create a database that will contain a rank field on the form which allows me to rank ... A: I have given this some thought and have come up with this - Add a 'ranking field to your table and ... | |
| Access Calculations | 6/9/2007 |
| Q: I have the following problem: Three fields in a table, Hourly Rate, GST amount and Total Amount. ... A: I am assuming that you already have a field in your table named 'Total_amount'. First place an ... | |
| Populating one combo box from another | 6/8/2007 |
| Q: I am using Access 2003 and I am very much a beginner. I do have coding & SQL experience but with ... A: ! Text can be very difficult to work with. As matter of fact, instead of attempting enumerate the ... | |
| check boxes | 6/8/2007 |
| Q: I am using access 2000 and need help with my checkboxes. In my form, I have a list of reports and ... A: Forget the macros and lets use some Visual Basic Each of your check boxes are capable of having ... | |
| Query parameters | 6/7/2007 |
| Q: I read you already answered my question/problem to Sue on 5/21/2007. I read the answer thoroughly ... A: There could be several issues at work here. If your combo box is being populated by values in ... | |
| Form Design | 5/31/2007 |
| Q: I have 2 issues. First my form is so large that I had to break it into 7 seperate forms, otherwise ... A: There is no such thing as a dumb question Tana - Open your first form in design view. Now at the ... | |
| How to show parentheses around text | 5/31/2007 |
| Q: I'm a relative newbie, so this may be a dumb question, but... I've designed a "Contacts" table, ... A: Certainly not a dumb question but no question is dumb when you are taking the time to learn. Any way ... | |
| conditional format for report | 5/31/2007 |
| Q: I want to set up conditional formatting for my accounts receivable report. I want to be able to see ... A: Good morning Dave - Well to be honest I don't use conditional formatting that much but it certainly ... | |
| unique user logins to autopop data | 5/30/2007 |
| Q: my team at work uses an Access 2003 database to track results of customer interactions. There are ... A: Secondly, is the database on a network share that each users work station maps to? I ask these ... | |
| Query two date fields | 5/30/2007 |
| Q: basically I have a table with 3 fields - Project name, start date and finish date. I want to create ... A: What you need is a multi-parameterized - select - query which sounds allot worse than it really is. ... | |
| MS Access | 5/30/2007 |
| Q: I want to design a Questionnaire in Access. A user should be able to create a customized ... A: What you are trying to do requires quite a bit of advanced programming and would take far too long ... | |
| Subreport | 5/24/2007 |
| Q: I am having trouble with a subreport that has to do with vendors and their invoice totals. My goal ... A: Open the main report (Vendors) in design view. Then click on the sub report and bring up its ... | |
| to get the data from the db into form | 5/24/2007 |
| Q: i have one table with eno,name,amt fields. i have one form with combo box and 2 text boxes.If i ... A: What I have done is to create a small Access db (Ver. 2003) for you to look at. to get this example, ... | |
| Table Relationships | 5/23/2007 |
| Q: I am creating a database that is intended to track appointments by patient name, time and date. ... A: lets give you something to look at. Go to www.dropboks.com. Log into the website using ... | |
| Order by usage | 5/22/2007 |
| Q: I have a subform that creates a table including two things; Specialty Area and Competency Level. ... A: Ok Jery - lets try this - put the datasource for your subform back to its original table. Now this ... | |
| Lookup list prompt in parameter query - Possible? | 5/22/2007 |
| Q: Me again. I've been tasked with creating a look up list for a parameter query. I have a report ... A: OH - OK I SEE THE PROBLEM!! you run your reports from a switch board switchboard_rpt...Gotcha! Go to ... | |
| Emailing reports from access | 5/22/2007 |
| Q: Expert: Don Darracq Date: 5/17/2007 Subject: email report you have answered this question before - ... A: What you are looking for, at least in a pure Access environment is far to "wordy" for this forum. I ... | |
| Lookup list prompt in parameter query - Possible? | 5/21/2007 |
| Q: Me again. I've been tasked with creating a look up list for a parameter query. I have a report ... A: Good morning Sue - just shaking off the morning fuzz with my first cup of coffee. Anyway yes this ... | |
| Order by usage | 5/21/2007 |
| Q: I have a subform that creates a table including two things; Specialty Area and Competency Level. ... A: Then in the sort criteria for the Competency field choose 'ascending'. Then change the data source ... | |
| MS Access Subform Update | 5/21/2007 |
| Q: Don!!! YIPPEE, your code finally is working for me. If you recall I had an MS Access form with 5 ... A: Well congrats!!! As far as your follow - up question - the best I can do is tell the cursor to go ... | |
| Expressions | 5/21/2007 |
| Q: In my previous question, I read your response and I see I wasn't too clear. This is my delimma. I ... A: . Lets assume that your form has a table bound field called txt_total date and you want this filed ... | |
| Access question | 5/18/2007 |
| Q: I have multiple queries that running from the code and I would like to monitor execution process. My ... A: Let me tell you how I do it. I have a Huge db that executes over 300 various queries via ... | |
| email report | 5/17/2007 |
| Q: I want to send each person only their section of the report (The grouping that conatins their ... A: OH how I love talking with people who know computer language. Your response was perfectly concise. ... | |
| Forms ComboBox | 5/17/2007 |
| Q: Access 2003. I need to capture 3 fields that I display in the ComboBox list and put them on an ... A: Me.test_number.Value = Me.Combo0.Value Me.fee.Value = Me.Combo0.Column(1) Me.turn_around_days.Value ... | |
| email report | 5/16/2007 |
| Q: I want to send each person only their section of the report (The grouping that conatins their ... A: 1) What is your default email handling program. for example do you use MS outlook, outlook express, ... | |
| error on code | 5/16/2007 |
| Q: I am gettin an error "object variable or block variable not set" when running the code below Dim ... A: AddNew" line. From that point above I see a problem. It would appear that you are mixing ADO and DAO ... | |
| Field Value | 5/16/2007 |
| Q: I am using Ms Access'2000. I have one Rate_Table which contains all the rate for my consignments., ... A: Govind - I am really trying to understand what you are trying to do here but it is not clear. Are ... | |
| Reports in Access | 5/15/2007 |
| Q: I'm trying to create a report with a few things and need a little direction. 1. I need the report ... A: Dan - have you ever created a query before?? I am not being a smart @@s I promise. If you have not ... | |
| Form Calculations/Formulas | 5/14/2007 |
| Q: I have a database with a table (tblAgentLedger)containing three fields (SalesPrice, SPPercentAdjust, ... A: Steve - it is hard for me write an exact solution for you with out knowing exactly what you are ... | |
| Find on Form | 5/14/2007 |
| Q: Don, Have an existing form that is used to edit information. Would like to put a "Find Box" at the ... A: Richard this can be done but its explanation is too long for this forum. If you would like I can ... | |
| Access Query | 5/14/2007 |
| Q: I want to create a query that connects to a table and translated data in a specific column. An ... A: This code will go in the very top of the QBE grid, in the first available blank column to the right ... | |
| Ms Access 03 Question | 5/13/2007 |
| Q: I have a database and it measures stock levels, in form view i have a field which says is the "stock ... A: Sebastian - if I am understanding your question, try this- Add an unbound text box to your form ... | |
| Open hypertextlink based on fields in table | 5/13/2007 |
| Q: Using Access 2007, I need to add code to a button on a form to open a web page based on content ... A: Richard - I am not sure if this is what you are looking for but maybe it will steer you in the right ... | |
| Field Value | 5/11/2007 |
| Q: I am using Ms Access'2000. I have one Rate_Table which contains all the rate for my consignments., ... A: Govind - because you are using version 2000 I can not create a sample db for you so I will do my ... | |
| Access calculation in subform | 5/11/2007 |
| Q: Sorry to ask twice in a row.... Still working with subforms and need help updating entry in one ... A: Go to www.dropboks.com - Use DonaldDarracq@yahoo.com as the username and 123456 as the password. ... | |
| Access -2003 | 5/11/2007 |
| Q: I have a table with a field that I enter various answers. I would like to put in a report the count ... A: Delores - I don't think that this is possible as you have set up. There is not a way (that I am ... | |
| MS Access Database | 5/10/2007 |
| Q: I was hoping you could answer a question for me. We have a database of 14,000,000 leads for ... A: Hey Chris - Currently it will pull all SIC CODEs. If you want a specific SIC CODE only, refer back ... | |
| Access calculation in subform | 5/10/2007 |
| Q: Sorry to ask twice in a row.... Still working with subforms and need help updating entry in one ... A: OK but dont laugh.... PLace this code in the on_click event of tab 1 DoCmd.GoToRecord acDataForm, ... | |
| Access calculation in subform | 5/10/2007 |
| Q: Sorry to ask twice in a row.... Still working with subforms and need help updating entry in one ... A: There is always some way to get things done. Access handles macro and 'docmd' commands differently ... | |
| MS Access Database | 5/10/2007 |
| Q: I was hoping you could answer a question for me. We have a database of 14,000,000 leads for ... A: What you are trying to do is actually not very difficult. We will take it step by step. In the ... | |
| date function.. | 5/9/2007 |
| Q: Im working on bond agreement project using ms access.. In my form I’ll have start and end bond ... A: No problem Lana - Go to www.dropboks.com and use donalddarracq@yahoo.com as the username and 123456 ... | |
| Newbie question about table relationships | 5/9/2007 |
| Q: We have a "Contacts" table that includes all our clients. Many of our new clients are referred to us ... A: all you have done is added a field named 'referrer' to to your 'contacts' table? if this is true ... | |
| date function.. | 5/9/2007 |
| Q: Im working on bond agreement project using ms access.. In my form I’ll have start and end bond ... A: In order to automatically update from "Ongoing bond" to "Completed bond" with out daily database ... | |
| Access Query Question | 5/8/2007 |
| Q: I have two tables: Table 1 Field names: Date Name Score June 1 Tom 100 ... A: Hey Bill - I have figured out your issue but the solution is too long for this forum so I have ... | |
| Find Record Button | 5/8/2007 |
| Q: I have build many forms and I find the Find Record Button very useful. What I do not like is that it ... A: GABE - The only way I know of doing this is to set up a query based on your record set. In the ... | |
| Second Page Report | 5/7/2007 |
| Q: I have constructed a report which is in the format of a letter, this report gets some of its ... A: The first is a "page header" which affects all pages with in the report. The second is a "report ... | |
| Form Validation | 5/7/2007 |
| Q: Greetings! I want to require data entry into a text box (non-numeric) when the quantity in another ... A: I have created a sample data base in Access 2003. Would you like me to put this on the net and give ... | |
| Coding | 5/7/2007 |
| Q: Can you please help me. I want to program one command button on my form to do the following: on ... A: This is important so if your main table does not have such a field, you will need to add one to it. ... | |
| Access macro to print a report | 5/4/2007 |
| Q: I have a report that is fed frmo a form. When I go to print the report, it has about 5300 pages on ... A: When you say each page shows the same thing over and over again, do you mean the "EXACT" same record ... | |
| Access macro to print a report | 5/4/2007 |
| Q: I have a report that is fed frmo a form. When I go to print the report, it has about 5300 pages on ... A: You seem to have two issues, if I understand. 1) The single report displays more info than what you ... | |
| Create Lock Button with MS Access | 5/3/2007 |
| Q: My question was: "I have created a form which consist from several other forms. I would like to ... A: Jeva - the way I would do this is as follows 1)Use a togglebutton not a command button name the ... | |
| Hyperlink to Excel form | 5/3/2007 |
| Q: I'm trying to insert a hyperlink into an access form to open an excel file. it has to be dynamic, ... A: Hey Kerry I don't know if this is what your looking for but try this code in the "on_click" event of ... | |
| MS. Access inventory design question | 4/30/2007 |
| Q: I have a question regarding inventory stock. For example invoice 0001 has items of a001 quantity of ... A: Harry - sorry that this took me awhile, allot going on-- Design a query based on your table like ... | |
| Form Design | 4/28/2007 |
| Q: I have Access 2003 on my desktop. I am trying to create a form. There are 61 fields that need to ... A: Tana - If you would like, go to www.dropboks.com use the Username donalddarracq @yahoo.com and the ... | |
| Scan into Access | 4/27/2007 |
| Q: Is it possible for me to scan a list of names and addresses into Access? I am using Office 2000 with ... A: Now the entire document may be saved as an image type document in a ole object field. Now as far as ... | |
| Access 2003 Requiring field to be completed | 4/26/2007 |
| Q: Don, Using Access 2003. Want to create a control(check box or...)on a form that will require the ... A: No problem Richard go to www.dropboks.com and use donalddarracq@yahoo.com as the UserName and 123456 ... | |
| Access Queries | 4/26/2007 |
| Q: How do I add a new field to an existing query while doing calculation from a table ANSWER: I'm sorry ... A: you must add it. In the query design grid (BOTH) go to the very next blank grid and in the very ... | |
| Access 2003 Requiring field to be completed | 4/25/2007 |
| Q: Don, Using Access 2003. Want to create a control(check box or...)on a form that will require the ... A: using a standard yes/no type data field and corresponding check box will not work in this instance. ... | |
| Access 2007 forms | 4/25/2007 |
| Q: I have alot of similar data (67500+ items)of which 9 variables/filters will give me one answer. I ... A: Hey Adie - as I stated before, my solution is quite complex. It involves dynamically customizing an ... | |
| Reports | 4/24/2007 |
| Q: the tabs are Customer and Products. Now I would like to construct a report in the form of letter, ... A: Well that's odd I've never seen that before. I'll tell you what, I have designed a "very" simplified ... | |
| db design basics | 4/24/2007 |
| Q: I really new to access design. I have a really large "client" table containing fields on a variety ... A: There are many schools of thought as to whether "linear" table design is more or less effective then ... | |
| Access 2007 forms | 4/24/2007 |
| Q: I have alot of similar data (67500+ items)of which 9 variables/filters will give me one answer. I ... A: By the way, what version of Access are you using? Follow up Adie - of the 9 fields you wish to ... | |
| add spaces at the end of a line | 4/23/2007 |
| Q: "I have set up a query that lists certain information from my database. The lines are different ... A: If you would, take sometime and send me a detailed explanation of the global thought process of your ... | |
| add spaces at the end of a line | 4/23/2007 |
| Q: "I have set up a query that lists certain information from my database. The lines are different ... A: I was however able to create a form that checks entry lengths and if not 83 characters, adds blank ... | |
| Reports | 4/21/2007 |
| Q: the tabs are Customer and Products. Now I would like to construct a report in the form of letter, ... A: Weekends are bad for me. Anyway to do what you want you will need some sort of unique identifier for ... | |
| Follow up: MS Access Reports | 4/20/2007 |
| Q: If I have report in following format, part Status 1 yes 2 no 3 yes How can I ... A: Dhaval - Ahhhh - I was under the impression that your status field was "text" data type (literal ... | |
| MS Access Reports | 4/20/2007 |
| Q: If I have report in following format, part Status 1 yes 2 no 3 yes How can I ... A: I was able to get the report to do what you want but it’s kind of a sloppy way off doing it. Well ... | |
| Calcualations in a report | 4/19/2007 |
| Q: I have an access database that is used as our companies monthly reporting tool. In a report I have ... A: Sarah - what you might do is create a separate query to include all the fields you want to calculate ... | |
| Menu Creation in Ms Access'2000 | 4/17/2007 |
| Q: I would like to create my own menu wherein i need to my own commands like ... A: Govind - the best way to do this, in my opinion, is to add command buttons to your forms that carry ... | |
| Generating additional tabs on a form ... | 4/16/2007 |
| Q: .. Tina here again .. hope this is okay I continue to ask you my access questions (it was because ... A: Tina - that is actually an interesting thought??? Give me a little time to see what I can come up ... | |
| FORMS AND TABLES | 4/16/2007 |
| Q: i need a combo box to be able to lookup a list of names and the text boxes to equal the address of ... A: James - I am sorry that it took me awhile to respond to your question. What you are trying to do is ... | |
| icon | 4/13/2007 |
| Q: i want to put our company icon to every access form i created, but i want it on the uppermost left ... A: Enrico - Yes this can be done but only through code. The form must also have "pop-up" enabled. First ... | |
| How to write MS-Access script to change the database login password for MS-Access | 4/12/2007 |
| Q: Currently i am working on a support project. It is in VB and used MS-Access2 as a backend. I want ... A: Ok Kishore, lets try this - I am using ver.2003 so it may be different but here it goes. This will ... | |
| How to write MS-Access script to change the database login password for MS-Access | 4/12/2007 |
| Q: Currently i am working on a support project. It is in VB and used MS-Access2 as a backend. I want ... A: I will need quite a bit more info. Please re-post this question to me with very specific details on ... | |
| Display a logo via a command button on access form | 4/10/2007 |
| Q: .. I'm designing a form where I want to be able to click a command button "Insert new logo" and have ... A: For this solution, I am making the following assumption about your Db - 1) Your table has an "OLE" ... | |
| order by clause | 4/6/2007 |
| Q: I created a table as below: Region District Territory Customer_Name 60 42 ... A: I duplicated your table and SQL clause and, no big surprise, got the same result as you did. When I ... | |
| Matching 2 sources | 4/5/2007 |
| Q: In query design mode, (2 sources used) I need to take one field containing 6 characters, and match ... A: I'm not sure exactly what your trying to do but a query based on the table that holds source 2 with ... | |
| Adding for specific records | 4/4/2007 |
| Q: The database I designed is used for shipping purposes so all the information is input into the form ... A: Kerri - sounds like your reports are bound to your table and not through a query. you need to design ... | |
| Ms-access to oracle migration | 4/4/2007 |
| Q: SELECT [FDDS-Customers].REGION, [FDDS-Customers].DISTRICT, [FDDS-Customers].TERRITORY, ... A: Access places records in order as they are entered. Your SQL looks correct and, as you say, you are ... | |
| Starting and Ending date | 4/3/2007 |
| Q: I have two text boxes in a form that shows the starting Date and ending Date for query criteria. How ... A: You will have to alter the my code to fit the naming rules of your text boxes Private Sub ... | |
| saving data into table | 4/2/2007 |
| Q: i have two tables one is a temp table i use on my form for data entry purpose, and the other one ... A: Raw SQL has its place but in your situation I would simply; 1) make sure that your "temp" table is ... | |
| Re: Check marks to Autofill | 3/30/2007 |
| Q: I need help on the following: I have a form where the user has to enter information on hospitals and ... A: Carla - you can pass values to fields from other fields Create a check box and in it's "on_click" ... | |
| Need last activity date | 3/27/2007 |
| Q: I have a table with transaction records for each person. I would like, if possible, to get the last ... A: At a first glance I'm sure this can be done. I'm more concerned with the "tens of thousands of ... | |
| Updating forms and/or content. | 3/26/2007 |
| Q: I helped a non-profit start a database where they keep track of customer contact information as well ... A: As far as executing some sort of deployment package to install your changes - IT IS JUST NOT ... | |
| Data Correction | 11/22/2006 |
| Q: I have an Access data base in which I am trying to migrate to SQL Server. Now when I tried to inport ... A: The first thing I would do is to determine what the oldest correctly formatted date is in your data ... | |
| Triggering an event in a subform from new record | 11/21/2006 |
| Q: I'm game... I'm ready to get this working! I don't feel so bad now that even the experts find this ... A: Will - Access has always handled triggers differently then expected on nested sub-forms. It is not ... | |
| Triggering an event in a subform from new record | 11/21/2006 |
| Q: I have an Access database that transfers service calls from one group to another. Basically, I have ... A: Will - I am very sorry - I have literally been working on your question for two hours and can't come ... | |
| Output to MS Dos Text | 11/21/2006 |
| Q: I have been using Access 2000 version for our school database. I have created a number of reports ... A: This is an inherent issue with Microsoft access. Access 97 does not like Access 2000 and Access 2000 ... | |
| Documentation | 11/20/2006 |
| Q: I am in the process of taking several Identical(in structure not data) access databases and ... A: Hey MO - Progress documentation is as diverse a creature as is possible. In lieu of any existing ... | |
| login | 11/20/2006 |
| Q: Pls i have not heard from you over the mail i sent to you.I have a database in which i want the ... A: Sorry my friend - very busy- Place a button on one of your forms and type the following code into ... | |
| unsafe expressions | 11/19/2006 |
| Q: I have made this database for a workgroup.I split the database,stored the backend in a shared folder ... A: This should clear up the issue | |
| using a form to retrieve information to be edited | 11/16/2006 |
| Q: Don, Thank you for your help and your generosity!!! In looking at the code that you wrote you ... A: Actually Spencer that is an excellent question- frmMain and or tblMain are nothing but general ... | |
| 1 Table, 2 Lookups | 11/16/2006 |
| Q: Don, I am running Access 2002 on a network at work. I shouldn't have used the word virtual at all. ... A: It is sometimes very difficult to give the proper advice when you are not sure exactly how one’s ... | |
| 1 Table, 2 Lookups | 11/16/2006 |
| Q: Don, I am really struggling with how to use one table to be the source for two different lookup ... A: Secondly, exactly how are your results restricted. Thirdly, Exactly what do you mean by "virtual ... | |
| using a form to retrieve information to be edited | 11/15/2006 |
| Q: I have been working on a project that involves entering demographics and test scores using a form. ... A: I will give you one of the many ways that I currently employ in many of my databases. Before we ... | |
| programming combo box | 11/14/2006 |
| Q: My question is about combo box on a form.I want the values shown in my combo box being narrowed down ... A: Yes this can be done – 1) Establish a control Combobox (this is the one from which the user will ... | |
| New Database: financial numbers | 11/10/2006 |
| Q: I am about to begin starting a new database. It will be based on entering client financial ... A: The text of the questions to be asked do not need to reside in your table. Tables should only have ... | |
| Decimals | 11/9/2006 |
| Q: I'm working on a database to keep track of volunteer hours for each month and I want a total at the ... A: Terisa - I think I can "half-way" help. In your table, for all the fields that contain numbers of ... | |
| IIF IsNULL | 11/9/2006 |
| Q: What exactly does this statement do in a query feild. I am restructering someone elses database and ... A: in ACCESS, "0" is not considered null) anyway if it sees that the [it2DispoDate] has a value (in ... | |
| creating a report from logic "yes/no" check boxes | 11/8/2006 |
| Q: Can you help me create a report in Access? Here is the deal. I just sent out a company-wide survey ... A: James – This is an excellent concept! We can make this work but it will take some careful work. I ... | |
| Print in Access | 11/7/2006 |
| Q: Hey, I have a table with following fields: Date,Category,Status,Person and I would like to have a ... A: It’s difficult to answer these types of questions with total accuracy due to me not knowing exactly ... | |
| Pictures in MS Access | 11/3/2006 |
| Q: Yes. All computers are using the same version of Access. As far as I know, there was a complete ... A: Carla - I don't use images very much but I do know that there is a small check box that tells ACCESS ... | |
| Carrying over from one form to another. | 11/1/2006 |
| Q: Once again so near and yet so far! I did everything you suggested but , once again the result looked ... A: Tony, never give up - lets just move outside of this forum. My personal email address is ... | |
| Access | 11/1/2006 |
| Q: I had a look and this is not really what I had in mind. I am still at the design stage, and the ... A: Make sure that your tables are linked in such a fashion as to pass the "Product ID". In other words, ... | |
| Sharing Access Program | 10/31/2006 |
| Q: I am going to be sharing the database I have been working on creating with several people over a ... A: First, if this drive is a shared networkwork drive, have the sysadmin limit access via permissions. ... | |
| Reports - selecting information | 10/31/2006 |
| Q: I just keep coming up with add-on questiions. I have the report set up to have a "Id" selected then ... A: Hey Robert - Open each report in design view and in the properties - event tab - on_no_data ... | |
| Access | 10/31/2006 |
| Q: I am linking a product table stock and sales table with rows for each end og month. I want to be ... A: the only way I know how to do this is to insert a sub data sheet. Open your main table, click the ... | |
| Reports - selecting information | 10/30/2006 |
| Q: I have a report that will print several pages of information. Each page is represents a different ... A: In the critera grid of the ClientID number field type this with out the quotation "[type clientID ... | |
| Using a list to drive query parameters | 10/30/2006 |
| Q: I have a query that looks up a department name and then will export it to Excel. How can I make the ... A: I need some more Info. Tell me if I am correct in this assumption; You have a list of departments ... | |
| converting a databse to a program | 10/29/2006 |
| Q: i just finished my database and i want to convert it and the forms to a program so it can't be ... A: Open your db in design view and close all objects so you are looking at the design tabs only. Choose ... | |
| Carrying over from one form to another. | 10/28/2006 |
| Q: I am going to try and answer your question as compactly as possible. If there is any information ... A: Add another Currency field to tblTRANSACTIONS and name it CarryOver. Propagate this new field to ... | |
| Report Generator, selecting records | 10/27/2006 |
| Q: I am trying to create a report for the first time. It is based off of 1 of my queries, which ... A: Hey Robert - There are several ways to do this, some more advanced than others. Let's start with ... | |
| Carrying over from one form to another. | 10/27/2006 |
| Q: Almost then tragedy struck! I followed your instructions to the 'T'. I am not a keen supporter of a ... A: there is always a way! What I would like you to do for me is to send me some info on how your db is ... | |
| Carrying over from one form to another. | 10/26/2006 |
| Q: I hope you can help me. I have created a budget Using access 2003. It works wonderfully well except ... A: The good news is that what you’re attempting can be done! The bad news is that the solution depends ... | |
| Check Box - split in 2 | 10/24/2006 |
| Q: I have a yes/no checkbox in one of my tables and forms. I want to have the answer shown in a report ... A: Yes it is possible - create another "yes/no" field in your table and title it NO. Change the title ... | |
| forms - technical question | 10/23/2006 |
| Q: I am actually working on creating a new DB. So when completed, people will have to enter the new ... A: Hey Robert - The linked tables may be combined in a query using your primary key as the common ... | |
| forms - technical question | 10/23/2006 |
| Q: I have several tables and several forms. One of the tables has a primary field which is used in all ... A: If so try this; I am assuming the following for this demonstration; 1) Your main form with the ... | |
| combo box issues | 10/23/2006 |
| Q: The following issue deals with collecting tons of data on individuals over time in order to provide ... A: Although I don’t currently use this concept in my databases, I understand what you are trying to ... | |
| Record Counting( long) | 10/20/2006 |
| Q: I'm, Altering a database that I didn't create, just Thought I would let you know that. Well I have ... A: Hey MO - first and foremost I take my hat off to you for trying to work with an existing DB ... | |
| Record Counting( long) | 10/20/2006 |
| Q: Hey My friend its me again. I tried that and it did not work. I did notice that the count thats ... A: Hey MO - The answer to the second part of your question is "Most Likely yes" It would depend on from ... | |
| open word files within access | 10/20/2006 |
| Q: I have a form (Access 2003) which brings up a clients details on screen (name, phone number, etc ... A: Before we begin it is important to understand that for my solution to work there needs to be very ... | |
| Microsoft Access forms | 10/19/2006 |
| Q: I am setting up an access database for a hair/tanning salon. I was wondering how to set up a form ... A: Carla - the question is not can this be done but how to go about it. This would take far too much ... | |
| Access Search Form | 10/19/2006 |
| Q: Here is what I'm trying to do.. I want to create a form that will have a series of textboxes on it ... A: I will lay out the way I do it. 1) First step is to have a query, based on the table that stores ... | |
| Record Counting( long) | 10/19/2006 |
| Q: any other ways of counting the records, because I got it to work on two of my forms but when I tried ... A: Hey MO - Before we go any farther I want you to try this- On every form, sub form, where you have a ... | |
| SubReport Problems | 10/19/2006 |
| Q: It did not work ƒ¼ So here goes with more details: 1) The main table (the report is generated from ... A: WOW – this one took me awhile… The best solution I can come up with for you is as follows… First, ... | |
| Record Counting( long) | 10/18/2006 |
| Q: is there a way I can Display a zero or a message if zero records show upHey you gave me your email ... A: Hey - Just though of another possibility..In design view go to the properties of the text box ... | |
| Record Counting( long) | 10/18/2006 |
| Q: Hey you gave me your email the other day but I didn't get a chance to get back to but here is my ... A: Wow – good question… Ok for the purpose of clarity, let’s make some assumptions 1) your main form ... | |
| SubReport Problems | 10/18/2006 |
| Q: I am currently trying to make a report (for an invoice) in this I am using to tables the first is ... A: I am assuming the main report is bound to a query that reflects all the info from both tables? if so ... | |
| Combo Box in Access. | 10/18/2006 |
| Q: I have made an Access DB with one table a form(About vessels and characteristics of them)and a ... A: Hey SPYRO - good question.. Try this - Create two forms; the first will be "unbound" that is choose ... | |
| IIF Statement Issue | 10/17/2006 |
| Q: Hey, I am having problems creating an IIF STMT. I have 4 fields, I am trying to merge into a 5th ... A: . If by "merge" you mean add them up try this. Expr1: IIf([corporation total sales]>0,[corporation ... | |
| Fiscal year reporting | 10/16/2006 |
| Q: how would you summarize in one query: number of cany bars sold between 7-1-04 and 6-30-05 as well as ... A: Well sorry owen it would appear that you have stumped me... My best solution would be to design two ... | |
| Record Counting | 10/16/2006 |
| Q: This wont work for me because I have the form dynamically pulling certain sets of records from the ... A: Rocknd@hotmail.com Email me and we'll try to work this one out. I think I'm seeing that the main ... | |
| Fiscal year reporting | 10/16/2006 |
| Q: Is there a way to perform a crosstab query or a regular query for that matter that can report ... A: I don't use cross-tabs in my line of work so I am not really sure about them. In a standard query, ... | |
| Record Counting | 10/16/2006 |
| Q: I have a form that has a sub form. The record source for both forms is created dynamically in vb. ... A: .. Here is how I do it – I always add an “auto number” field to my table, name it “trans” and use ... | |
Using MS Access
Answers by Expert:
Don Darracq
Top Expert on this page
Expertise
I am able to answer most questions regarding the design of Access databases. I also have a solid knowledge of VBA and SQL. PLEASE - NO QUESTIONS REGARDING ACCESS 2007.
Experience
I have been designing Access databases, for large to moderate size industries, for the better part of 15 years. I have extensive experience using SQL ODBC connections for front end – back end applications, I also have experience in using both DAO for local tables and ADO for remote access to SQL sever tables.
©2012 About.com, a part of The New York Times Company. All rights reserved.