You are here:
- Home
- Computing/Technology
- Business Software
- Using MS Access
Using MS Access/Questions
| Subject | Date Asked | Expert |
| Forms | 2/7/2012 | Scottgem |
| Q: I am using Access 2010. In my database I have the following tables, among others, to provide me with ... A: I think something went wrong in posting because your table structure is not clear. But if Class and ... | ||
| Microsoft Access Queries for Travel Agency | 2/7/2012 | Scottgem |
| Q: I'm creating a microsoft access database for a travel agency. And i'm not very familiar with access ... A: A query is used to pull information from a table or tables and/or filter information to meet ... | ||
| Creating an invoice in Access 97 | 2/6/2012 | Scottgem |
| Q: I need to create an invoice form that automatically fills in customer name, address and phone number ... A: Do you already have a database setup? If not, you might try starting from a template. Any Order ... | ||
| open 2 forms instead of only 1 | 2/6/2012 | Scottgem |
| Q: I changed my code for the login form from: Private Sub ButtonLogin_Click() 'Check that User is ... A: Sorry, you have to make sure your IFs have matching End Ifs Try it this way: Private Sub ... | ||
| open 2 forms instead of only 1 | 2/5/2012 | Scottgem |
| Q: I changed my code for the login form from: Private Sub ButtonLogin_Click() 'Check that User is ... A: If Me.txtWachtwoord0 = Me.cboUser.Column(2) Then DoCmd.OpenForm "frmHoofdmenu" ... | ||
| Database runtime error | 2/5/2012 | Scottgem |
| Q: i tried the Dlookup in the immediate window, your right there is no number that comes up but the ... A: tblUser should have a Foreign key that links to the Access Level ID from your Access Level table. ... | ||
| Multi User Login Access 2010 | 2/5/2012 | Scottgem |
| Q: I struggle on the user login of our database. (access 2010 Database) We use the database to log the ... A: Actually that doesn't follow. An autonumber is generally used as a PK, but its not cause and effect ... | ||
| Multi User Login Access 2010 | 2/5/2012 | Scottgem |
| Q: I struggle on the user login of our database. (access 2010 Database) We use the database to log the ... A: I suspect UserID is text so it should be: intUserLevel = DLookup("ToegangsLevel", "tblUser", ... | ||
| Access / Infopath | 2/4/2012 | Scottgem |
| Q: I need to create an invoice form that will pull info that I currently have in an Excel spreadsheet. ... A: Yes I meant the Access Form Wizard. And Yes I'm not recommending InfoPath for this. As I sais, ... | ||
| Multi User Login Access 2010 | 2/4/2012 | Scottgem |
| Q: I struggle on the user login of our database. (access 2010 Database) We use the database to log the ... A: You may have seen my blog on Login Security since your description is very similar to what I've ... | ||
| Access 2007 Table Number Field | 2/4/2012 | Andy Dominguez |
| Q: I have a table with data already in it. The ID field is a number field. I have been requested to ... A: How are you? You will not be able to add any alpha characters in a number field. If you need to do ... | ||
| MS Access Date Expiry Alert | 2/3/2012 | Julie Misson |
| Q: I'm a complete novice with Access. I can't do any programming, I have just learned the absolute ... A: Many thanks for the question. Probably easiest to do this in a query. It will not be an alert as ... | ||
| To get totals ordered by date and type | 2/3/2012 | Julie Misson |
| Q: I have a BD(acces 2010)about Clients(only one table) with the following fields: Cod, Name, Date, ... A: Many thanks for the question. I hope I have understood it correctly, if not, then let me know. You ... | ||
| Limit number of records for each id in a query | 2/2/2012 | Scottgem |
| Q: I have a complex query that returns large numbers of records (each record is a date) for each id. ... A: What you need is a top N of group query. This article explains how to create one: ... | ||
| Access / Infopath | 2/2/2012 | Scottgem |
| Q: I need to create an invoice form that will pull info that I currently have in an Excel spreadsheet. ... A: Infopath is useful for distributing forms for collecting data. So what you want to do is link your ... | ||
| code ranking | 2/2/2012 | Julie Misson |
| Q: i have one question to ask u. can u show me a code of ranking the student use in VBA.i have 3 ... A: Many thanks for the question. I am not sure I have understood it fully, but try the following. ... | ||
| Access reports to append to Word document | 1/31/2012 | Richard Rost |
| Q: Greetings, I am using Office Pro 2007 on a WinXP sp3 machine... I am developing an app for a ... A: I wouldn't mess with Word documents. I would store the layouts as graphics in your database - either ... | ||
| Auto-date fill in form | 1/31/2012 | Scottgem |
| Q: I have a field in a form where you enter the "Opening Date", and the next field is "Due Date". I ... A: First, you don't have "fields" on a form. You have controls that may or may not be bound to a field ... | ||
| Add Diameter Range Column | 1/31/2012 | Scottgem |
| Q: I have the following problem. I have a table containing articles [bearings] and one column contains ... A: What you do is create a table that has fields for the Article and the Diameter Range. Then create ... | ||
| Subject: Synchronizing Combo Boxes Based on a Many-to-Many Relationship | 1/30/2012 | Scottgem |
| Q: Scott - If I interpreted your last suggestion correctly, this is where we're at now for the first ... A: I'm not sure why setting it to Null is not working. For the time being, I would just comment out the ... | ||
| Enhancing report print in MS Access Data base | 1/30/2012 | Scottgem |
| Q: Printing reports from the data base rather takes a very long time when more than one user is logged ... A: How are your databases setup? Are they split? If not, they should be. That will help the issue. ... | ||
| NESTED SUBFORMS | 1/30/2012 | Scottgem |
| Q: Good Morning and thank you for any help you may be able to offer in the following area. NESTED ... A: First, you can't nest a continuous form or datasheet view within another continuous form or ... | ||
| NESTED SUBFORMS | 1/30/2012 | Richard Rost |
| Q: Good Morning and thank you for any help you may be able to offer in the following area. NESTED ... A: Which version of Access are you using? You shouldn't have any problems doing this in 2010 and I ... | ||
| Dynaically setting image property for detail section of a report. | 1/29/2012 | Scottgem |
| Q: Greetings, This is the first time using this site... I have a WinXP sp3 machine running Access ... A: Use both the ON Print and On Format event of the Detail band. Put code in like this: ... | ||
| Synchronizing Combo Boxes Based on a Many-to-Many Relationship | 1/27/2012 | Scottgem |
| Q: Scott - Per your suggestion, I bound my second combo box to the CSID field in the Invoices table, ... A: Try going into your table and changing the default value of CSID field (in the data table, not the ... | ||
| Access 2007 | 1/27/2012 | Scottgem |
| Q: (farzad wrote at 2011-02-19 08:34:23 hi dear all this is very simple to work in access you must ... A: The screen shots indicate that you need to do this a different way. You need to create a query that ... | ||
| Synchronizing Combo Boxes Based on a Many-to-Many Relationship | 1/26/2012 | Scottgem |
| Q: I am following up on previous questions/postings to you. Thank you for your most recent ... A: A bound control has its ControlSource set to a field in the form's RecordSource. This then ... | ||
| Formatting dates | 1/26/2012 | Scottgem |
| Q: Formatting dates: I need to display and enter dates in the following formats, as well as base query ... A: Thought I had answered this already. You can't set the form for the whole database. You have to set ... | ||
| Formatting dates | 1/26/2012 | Scottgem |
| Q: Formatting dates: I need to display and enter dates in the following formats, as well as base query ... A: Unless set on an database level, Date formats default to Windows Regional settings. You can use ... | ||
| MS Access | 1/26/2012 | Scottgem |
| Q: which function cannot be used for calculated controls in a report?¬¬ which control type do you use ... A: I don't know of any function that can't be used as part of an expression. There are functions that ... | ||
| Synchronizing Combo Boxes Based on a Many-to-Many Relationship | 1/25/2012 | Scottgem |
| Q: I am attempting to create 2 synchronized combo boxes where the values for each combo box would be ... A: First, yes that should have been a ;, sorry about that. Correct, you don't need the name fields in ... | ||
| Access 2007 | 1/25/2012 | Scottgem |
| Q: (farzad wrote at 2011-02-19 08:34:23 hi dear all this is very simple to work in access you must ... A: So you need do a query or Dsum that calculates the closing balance for the previous month and use ... | ||
| Migrate Access 2007 to 2010 preserving VBA coding | 1/24/2012 | Scottgem |
| Q: Could you please advise how to migrate DB from Access 2007 to 2010 in such a way that VBA codings ... A: If the DB is in an ACCDB format, there should be no need for a migration. Just open the file in ... | ||
| Lock control after data entry follow-up | 1/24/2012 | Scottgem |
| Q: Scott, I figured out the code that I asked you about a few minutes ago. The only problem now is ... A: If the fields are number datatypes, Access assigns a default value of 0 by default. You can remove ... | ||
| Copying Information into an Unbound Text Box | 1/24/2012 | Scottgem |
| Q: Scott, Your help in the past has been amazing, so I will ask for help from you yet again. I'm ... A: Is there a reason you are doing this with an unbound form? Seems to me it would be easier with a ... | ||
| Access 2007 | 1/24/2012 | Scottgem |
| Q: (farzad wrote at 2011-02-19 08:34:23 hi dear all this is very simple to work in access you must ... A: Your question is not clear. Balances are calcuated by adding incoming amounts and subtracting ... | ||
| Date freeze | 1/24/2012 | Scottgem |
| Q: I have a combo box called 'Status' with the following options 'Open' and 'Closed' . When 'Closed' ... A: The thing you left out is WHERE you put this code. It should be in the After Update event of the ... | ||
| Lock control after data entry | 1/23/2012 | Scottgem |
| Q: I have a question about an earlier answer of yours: Answer If Not IsNull(Me.controlname) Then ... A: Are you using your own control names? You are inserting the code in the right place, but if you are ... | ||
| Access Module problems | 1/23/2012 | Scottgem |
| Q: One of my users tried to access her db this morning and upon opening was greeted with a message that ... A: Well first, this is not good design. Its an invitation to corruption. The database should be split ... | ||
| Attachment dialog box controls | 1/23/2012 | Scottgem |
| Q: In Access 2007, is there a way to disable the "remove" button from the attachment dialog box, but ... A: I don't think so, but I don't like the Attachment data type. Instead I create an Attachment table, ... | ||
Using MS Access
Answers by Expert:
Scottgem
Top Expert on this page
Expertise
I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience
I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations
Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
©2012 About.com, a part of The New York Times Company. All rights reserved.