You are here:
- Home
- Computing/Technology
- Business Software
- Using MS Access
Using MS Access/Questions Answered by Expert Julie Misson
| Subject | Date Asked |
| MS Access Date Expiry Alert | 2/3/2012 |
| 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 |
| 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 ... | |
| code ranking | 2/2/2012 |
| 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. ... | |
| Using a dropdown list to change criteria | 1/17/2012 |
| Q: I have an query containing sales orders of 100+ customers. I have to create a dropdown list to ... A: Just need a bit of clarification. Is it the Customer's Full name you are searching by i.e. Joe ... | |
| Not Able to Open Access Database | 1/5/2012 |
| Q: I am not able to My Access Data Base, It shows me error like "The change you requested to the table ... A: Did you try holding down the shift key, when you attempt to open the database as mentioned above. ... | |
| Not Able to Open Access Database | 1/2/2012 |
| Q: I am not able to My Access Data Base, It shows me error like "The change you requested to the table ... A: Many thanks for the question. This means the table or form is set up incorrectly. Without seeing ... | |
| Tying Fields Together in a Form | 12/29/2011 |
| Q: I have been working to tie two fields together in a form; 'Tasked' and 'Date Tasked'. The first is ... A: Many thanks for the question. For the first part of your question. You will need to write a bit of ... | |
| access & formulas | 12/28/2011 |
| Q: i have 3 date fields--date issued, date service effective and date completed. often the date issued ... A: that is clearer. Try the following: expr: IIf([DateWanted]<=[DateCompleted] And ... | |
| How to display names instead of record numbers in Access 2007 report? | 12/28/2011 |
| Q: I have designed an Access 2007 database which uses drop-down boxes to select information from tables ... A: Many thanks for the question. That access does this is a bit of a pain, but easily fixed. Open ... | |
| access & formulas | 12/23/2011 |
| Q: i have 3 date fields--date issued, date service effective and date completed. often the date issued ... A: Many thanks for the question. Sorry but I am not sure what you are trying to do with the fields, or ... | |
| Lookup wizard | 12/16/2011 |
| Q: I have used the lookup wizard in a table for "employees". I have manually created the list using the ... A: If you have previously created the form, then created the list in the table, the only way you will ... | |
| Updating Quarterly Dates - Ongoing | 12/14/2011 |
| Q: I am building a database, and am running into some issues. I have a client list that have sporadic ... A: Not sure why it is not working for you. I tested this out on my date data, and all the 4 months for ... | |
| Updating Quarterly Dates - Ongoing | 12/13/2011 |
| Q: I am building a database, and am running into some issues. I have a client list that have sporadic ... A: Many thanks for the question. Try the following. Create a query: Add your date field and pull out ... | |
| Changing datatypes | 11/21/2011 |
| Q: I'm fairly new to MS Access. My colleague has created a table which has around 200 fields and about ... A: Many thanks for the question. Try the following. Copy the table and paste it back, choosing ... | |
| ACCESS FORM CONTROL DOUBT | 11/17/2011 |
| Q: I am making a budget database .I have a form named M_PIPING, this is based on the table M_PIPING;I ... A: Many thanks for the question. Unfortunately you cannot have an expression in an 'bound' text box. ... | |
| Thanks | 11/15/2011 |
| Q: I am a CPA. Can you please show me an easy (non SQL) way to do the below? Long way is better than ... A: Many thanks for the question. I have changed your question to Public so it can be shared with ... | |
| Autofill form in Access 2007 | 11/11/2011 |
| Q: In my database I created a form to enter data into a table. I would like 4 fields to autofill once ... A: Many thanks for the question Are the fields you are autofilling text boxes or drop down boxes. If ... | |
| Access 2007 | 11/10/2011 |
| Q: In MS Access 2007 when a record is modified in a form, I need a popup text box to appear so I can ... A: Many thanks for the question. Try the following and see if this works for you. Create a table with ... | |
| Find Maximum and Minimum of 5 numbers | 11/6/2011 |
| Q: /Mrs./Miss I'm a starter of MS Access. I would like to ask a question. How to find maximum and ... A: Many thanks for the question. I know you mentioned using the if statement, but probably not the ... | |
| Form set up and script | 11/2/2011 |
| Q: I am intermediate in database design but relatively inexperience at code and VBA. I have a question ... A: See if the following works for you. Create two tables. The first table will have MainID - ... | |
| Form set up and script | 11/2/2011 |
| Q: I am intermediate in database design but relatively inexperience at code and VBA. I have a question ... A: Many thanks for the question. I hope I have understood it correctly. Just to make sure... ... | |
| Access Student attendence | 2/15/2011 |
| Q: I am making a student evening attendence database to use in our school. I have one table with ... A: What you really need to do is to goto a new record. By saving the student no and renetering you are ... | |
| Integrity Violations | 2/12/2011 |
| Q: I am working on a database with 2 tables – Contacts and Comments. I want to capture the comments my ... A: The problem will be the user ID - you will need to pick this up from the form. So Access knows ... | |
| ms access2003 | 2/10/2011 |
| Q: i have got the average(from the calculation using ms access) mark for one subject(example: ... A: Can you send me a copy of the formula you have tried (exactly). As I tested the above and it worked ... | |
| MS Access query | 2/10/2011 |
| Q: My question is related to query Table1: Room Master RoomNo. Windows 25 5 26 7 27 ... A: Many thanks for the question. I think I understand what you are asking. Note, I can not see module ... | |
| placing label in page of MS Access 2000 form | 2/9/2011 |
| Q: how do I place a label (and textbox, etc.) inside a page (or subform?) of a MS Access 2000 form? ... A: Many thanks for the question. I am presuming by a page you mean the form - correct me if I am wrong ... | |
| Report with search engine | 2/8/2011 |
| Q: I am so new to Access. I am working with the 2007 database and I have been asked to create some ... A: Many thanks for the question. I am not sure I am fully understanding your question, but try the ... | |
| Monthly Reporting Tool Using Access | 2/2/2011 |
| Q: We need help with MS Access. The Need: We would like to develop a tool to track and monitor ... A: Mahad, Thanks again for the question. Not sure if I am fully understanding your question, but I ... | |
| placing label in page of MS Access 2000 form | 2/1/2011 |
| Q: how do I place a label (and textbox, etc.) inside a page (or subform?) of a MS Access 2000 form? ... A: Many thanks for the question When working with a tab, you have to make sure the tab is selected ... | |
| ms access2003 | 1/30/2011 |
| Q: i have got the average(from the calculation using ms access) mark for one subject(example: ... A: try the following: Grade: ... | |
| Access 2007 - Page Footer Issue | 1/29/2011 |
| Q: Why would the page footer show after the last detail line, instead of at the bottom of the page ... A: I had no idea about this, but did a search, and saw your question come up elsewhere - with an ... | |
| Counting values in a colunm from a query in a form | 1/27/2011 |
| Q: I have developed a data base which keeps track of what fire vehicles are at fire. Each fire vehicle ... A: Many thanks for the question. Try this: =DCount("[Category]","qryApplianceCount","[Category] = ... | |
| New Database | 1/26/2011 |
| Q: I have a dtabase of cutomers' names, addresses and orders.The names and addresses stay same every ... A: I sent an answer a few days ago but all experts sent me to an error page, so obviously is did not ... | |
| Monthly Reporting Tool Using Access | 1/23/2011 |
| Q: We need help with MS Access. The Need: We would like to develop a tool to track and monitor ... A: You seem to be heading in the right direction. Well done. Looking at the above, the only change I ... | |
| Split Function to parse out delimited fields into rows | 1/21/2011 |
| Q: I am designing a DB and I need to be able to split delimited fields. I know the code isn't too crazy ... A: Either way with the Nulls, if it is easy to sort the data and delete the nulls prior to import, then ... | |
| query | 1/21/2011 |
| Q: Scott: Using the query >#01/01/2007# I now have every physician who has used the service in the past ... A: Many thanks for the question. To do what you ask: When in the design view of the query, right ... | |
| Access 2007 Customized Form Printing | 1/18/2011 |
| Q: Not being an Access expert by any stretch, how do I print a typical form BUT WITH A RESTRICTED OR ... A: Many thanks for the question. The easiest way to do this is to create a report based on the same ... | |
| Split Function to parse out delimited fields into rows | 1/16/2011 |
| Q: I am designing a DB and I need to be able to split delimited fields. I know the code isn't too crazy ... A: Try the following. First of all, where to put your code; we will add it to a command button. Add a ... | |
| About Ms Access | 1/8/2011 |
| Q: .., I am Mirkhalid from Azerbaijan.I need your help about sending e-mail from ms Access .I know VBA ... A: I used to use SMTP - but ran into all sorts of strife. I now use a product rapidSMTP.com - which is ... | |
| Replacing #Error | 1/6/2011 |
| Q: I am having issues with a calculated field on a query in MS Access. I am calculating percentages and ... A: Many thanks for this question. I thought I had the answer on my website: ... | |
| enabling/disabling tabs | 10/18/2010 |
| Q: I am working on a form with several tabs. Depending on a required entry in the first tab, I would ... A: Add the following code, to the after update event of the field that has the value you wish to use to ... | |
| Cumulitive field with 2 id's and lots of data | 10/14/2010 |
| Q: I have a table with the following fields: id,date,value I need a query that outputs a cumulitive ... A: Sorry for the delay with this, i did send a response immediately but it must not have gone through. ... | |
| database | 10/12/2010 |
| Q: How can i create a fomulae using design in a form object to give a total? A: I am not sure I understand fully the question, but try the following: Add an unbound textbox to the ... | |
| Global Procedures in Access 2003-2007 | 10/10/2010 |
| Q: I created a database and forms with VBA procedures which all work fine, but I'd like to move some ... A: A couple of things you would need to do. Copy into a module. Change any private ... | |
| Cumulitive field with 2 id's and lots of data | 10/9/2010 |
| Q: I have a table with the following fields: id,date,value I need a query that outputs a cumulitive ... A: Many thanks for the question. Will a report do? Or do you specifically need a query. If a report ... | |
| Access 2007 query criteria | 9/23/2010 |
| Q: I am trying to narrow down my results in a query using criteria in multiple fields (4 criteria lines ... A: Many thanks for the question. Try the following (should be able to do it on the one row, but access ... | |
| MDE File useage | 9/20/2010 |
| Q: Does a computer need to have Access installed to run an mde file? Thank You A: Yes it does, unless you have a runtime licence, that you can distribute with your database. See ... | |
| Disable security prompts for macro | 9/14/2010 |
| Q: Julie-- I've been wracking my brain and poring over google for hours for a solution for the security ... A: Many thanks for the question. Sorry I have not replied earlier. if you have not already found the ... | |
| access drop down lists and then email | 9/13/2010 |
| Q: I am trying to produce a database that has the function to send emails however, I want the user to ... A: Many thanks for the question. Try the following: Add this code to the after update event of the ... | |
| Subsampling abundance data | 9/10/2010 |
| Q: I am an intermediate Access 2003 user with no experience programming in VBA. I have been able to ... A: To pull the random numbers, create a new table, the same layout as tblIndividual, but with no ... | |
| alphabetizing a dropdown menu | 9/10/2010 |
| Q: I have created a form where one field is populated from a drop-down menu. When I originally created ... A: Many thanks for the question. To do this: Right click on the drop down box Select Porperties ... | |
| Conditional Formatting date range problems | 9/9/2010 |
| Q: I am making a report based on a query. In the query there is a date field (representing Baseline) ... A: Many thanks for the question. I presume you are using Conditional Formatting for this?? Right Click ... | |
| IIF statements in reports | 9/8/2010 |
| Q: I am using Access 2003 and I am an intermediate user. I am trying to create a report that prints a ... A: It looks correct to me.... What are the names of your textbox? Check that they are correct Right ... | |
| Macro enabled WORD template from Access | 9/8/2010 |
| Q: I am trying to open a macro enabled WORD 2007 template from Access 2007. The problem I am having, ... A: Try the following: Private Sub Command4_Click() Dim LWordDoc As String Dim oApp As Object LWordDoc ... | |
| Subsampling abundance data | 9/7/2010 |
| Q: I am an intermediate Access 2003 user with no experience programming in VBA. I have been able to ... A: Then this is what you need to do, to get the data as individual records in a new table. Create the ... | |
| Drill down in Access 2002 | 9/5/2010 |
| Q: I have a large music library on my computer. I have all the music info in an Excel spreadsheet ... A: Set up two combo boxes (in the first instance). Make sure you choose a field in both combo boxes ... | |
| Convert a field | 9/3/2010 |
| Q: I would like to create a new field that would tell me the actual grade a student is in if her were ... A: Many thanks for the question. You would need to do this is a form, and as it is a calculated field ... | |
| Subsampling abundance data | 9/2/2010 |
| Q: I am an intermediate Access 2003 user with no experience programming in VBA. I have been able to ... A: Many thanks for the question. I am not sure if I fully understand it. Just to double check With ... | |
| Access VBA Text formatting | 9/1/2010 |
| Q: I have a VBA module which sends an email/ or a group of emails from Access to Outlook, however I ... A: Many thanks for the question and my apologies for the delay in getting back to you. To do this you ... | |
| Making columns into rows | 5/28/2010 |
| Q: Is there a way to make columns into rows from the following: John x y z Jane x y z ... A: Many thanks for the question. What you need is a Union Query. As you have not given me the names ... | |
| Summing in a Report | 5/27/2010 |
| Q: I am having trouble in Microsoft Access combining names in one form and summing yes/no responses in ... A: Many thanks for the question. I am not sure if I fully understand your question, but try the ... | |
| Using an unbound control to update default value of bound control | 5/26/2010 |
| Q: As an Access 2007 newbie I have created a simple table to capture invoice information. In the table ... A: Many thanks for the question. Try putting the following in the unbound text box in design view - ... | |
| microsoft Access 2000 (well 97) autopopulating records | 5/25/2010 |
| Q: I have a sub form that I want the users to enter some data into, but I always want them to enter at ... A: Many thanks for the question. Yes it is possible to do what you ask. You could do it with an ... | |
| Access Querying | 5/23/2010 |
| Q: In Access 2003, how to query student test database with multiple years of data. I only want records ... A: Many thanks for the question. To do what you ask. Build a query with the fields you require. Then ... | |
| Required Top Values | 5/21/2010 |
| Q: I have a table with many columns in MS access. There is one column of branch name and other column ... A: Many thanks for the question. Try the following (cannot guarantee it will be any quicker) Create ... | |
| Calculation in a Report | 5/20/2010 |
| Q: I have a report that list the total number of "Reviews" completed by Provider. What I would like to ... A: D Try the following: =IIF(IIF([Status] = "PT",3-[#PR rec'd],6-[#PR rec'd])<0,0,IIF([Status] = ... | |
| Calculation in a Report | 5/18/2010 |
| Q: I have a report that list the total number of "Reviews" completed by Provider. What I would like to ... A: Many thanks for the question. Try the following: =IIF([Status] = "PT",3-[#PR rec'd],6-[#PR rec'd]) ... | |
| If statement in access | 5/15/2010 |
| Q: X= (A-B)/C I need to include an if statement for the above formula that says: if B is null make it ... A: Many thanks for the question What you probably need is more likely to be the Nz function as it ... | |
| Open a form on an specific date(field) without filter | 5/14/2010 |
| Q: Table: tblAppointments Fields: AppDate and AppClient AppDate format: dd-mm-yyyy I have several ... A: Many thanks for the question. To achieve this you will need to write a bit of code. Not sure how ... | |
| Calculate and return accurate age | 5/13/2010 |
| Q: I have been trying to use a query to return the accurate age of someone in years. However, the ... A: Many thanks for the question. Try the following: Age: Fix(DateDiff("d",[DOB],Date())/365.25) I ... | |
| Reordering level | 5/11/2010 |
| Q: i am creating a database that needs to have a re-ordering level...how do i achieve that? A: Many thanks for the question. I am not sure I fully understand. Do you mean that you have stock, ... | |
| Extracting data from a field in Access 2007 | 5/7/2010 |
| Q: "I have a field that contains both the City and State, I am able to create another field with just ... A: I see you re-sent the question in :0) To do what you ask, you will need to do it in a query. Build ... | |
| shortening module | 5/6/2010 |
| Q: I wrote this modeule which adds coordinates and habitat info to a location, in this example BPN. It ... A: Many thanks for the question. I presume this information is in a table somewhere? If that is the ... | |
| Microsoft Access 2007 | 5/5/2010 |
| Q: I have a City field that includes the State, I need to create a separate field for the state, and ... A: I need more information. Can you give me an example of how the data in the field looks? Give me a ... | |
| Automatic emails. | 5/4/2010 |
| Q: I have a database that creates tasks. When a person creates a task (in the task form) they can ... A: Many thanks for the question, yes, what you ask can be done. For your query - in the criteria row ... | |
| Unique Drop down values | 4/6/2010 |
| Q: Its probably a daft questions but; I have a drop down menu that looks up all of the values in a ... A: Many thanks for the question. To do what you ask, open the properties for the form > Data Tab > ... | |
| Double Click | 4/4/2010 |
| Q: I have a switchboard that opens at the beginning with a button for employees, I also have a products ... A: I will try to explain this for you in more detail. On the button on the Switchboard to open the ... | |
| IF condition in MS Access - Queyr | 4/3/2010 |
| Q: I have the below 5 colum in the Table A 1. RNumber 2. Present 3. Date 4. Amt1 5. Amt 2 And I am ... A: Many thanks for the question. You would do this in a query. Create a new select query, using the ... | |
| Photo Print/display | 3/30/2010 |
| Q: I have an inventory DB each item has it's own photo (linked-just the photo file name path) the ... A: Nagy, Put the following code on the report Detail Format Event, even on continuous reports Note: I ... | |
| Double Click | 3/28/2010 |
| Q: I have a switchboard that opens at the beginning with a button for employees, I also have a products ... A: Many thanks for the question. Not sure if you have written code for opening your corms, or you have ... | |
| Access Query/Pivot for the descriptive datas | 3/23/2010 |
| Q: I have access table having thousands of data like this.... Month Requirement 1/1/2010 Bolt ... A: Many thanks for the question What you need to try is a crosstab query. Query > New > Crosstab ... | |
| Programming against duplicates | 3/22/2010 |
| Q: I'm working on a MS Access database after years of working on a private database. Anyway, I'm trying ... A: Many thanks for the question. Try the code below. Note: Change Surname to Last_Name Change ... | |
| help n access 2003 | 3/21/2010 |
| Q: Respected julieMisson! Hay! I am zulfiqar from pakistan and need in urgent help in ms access 2003. I ... A: Many thanks for the question. Not sure if I can help. As I cannot create the same error. When I ... | |
| Consolidation DB | 3/20/2010 |
| Q: I was wondering if you could help me in creating a MS Access DB , someone suggest that it could sort ... A: Many thanks for the question. Yes please send me a sample and I will see if I can assist. If you ... | |
| Create Year Comparison Data | 3/19/2010 |
| Q: I would like to create a report from a query for 12 months comparison. I get the report show 12 ... A: Many thanks for the question. To do what you ask you will need to use a crosstab query. Go to ... | |
| How to Go To Most Recent Record in two Synchronised Forms | 3/17/2010 |
| Q: I use a macro to open two forms which are synchronised when they both open. (please note they are ... A: Andrew, Many thanks for the question. Try using the Bookmark and RecordsetClone functions. i.e. ... | |
| using Wizard for forms | 3/16/2010 |
| Q: I am taking an online course for Access 2007. I completed the entire course with assignments. For ... A: Many thanks for the question. This is difficult as I have not had any problems with installation of ... | |
| Report Exporting | 3/13/2010 |
| Q: I notice that 2007 has this facility. Thank you Peter A: Many thanks for the question. This site will be able to help you. ... | |
| If then expression | 3/11/2010 |
| Q: I work with pieces of equipment that are described alphanumerically in a field called TRF. Examples ... A: Many thanks for the question. Yes you can do what you ask. Build a query adding the fields you ... | |
| Using Months as the Range in a Table | 3/10/2010 |
| Q: I have a table containing each month (Jan, Feb, Mar, etc) and a percent associated with each month. ... A: Many thanks for the question. Yes this is possible. Try the following. If you can add another ... | |
| Autofill? | 3/9/2010 |
| Q: Autofill? I am not sure if this is the feature I want so I cannot necessarily search to see if it ... A: Many thanks for the question. I hope I have understood your question correctly. If so, try the ... | |
| stock and inventory | 3/8/2010 |
| Q: .expert i have tables ; producttable (field - prodname, openingstock) purchasetable (field - ... A: Many thanks for the question. Yes you can do what you ask by using a query,although you may have to ... | |
| Forms / Subforms | 3/7/2010 |
| Q: I have a Products Form with a Stock Transactions Sub Form attached, is it possible to to make the ... A: Many thanks for the question. In short - No sorry :0( But in long - there are a couple of ... | |
| Please help | 3/5/2010 |
| Q: I have two tables in my access database, Customers & CustomerBills. Now i want to find out those ... A: To do what you ask, first create a query (I am presuming you know how to do this, but let me know if ... | |
| Photos In MS Access | 3/4/2010 |
| Q: I am running a number of databases designed MS Office Access 2000. A couple of them require ... A: Many thanks for the question. Can you send me the code you are using for the report? And I will ... | |
| Please help | 3/3/2010 |
| Q: I have two tables in my access database, Customers & CustomerBills. Now i want to find out those ... A: Many thanks for the question. I need a bit more detail before I can answer this question. i.e. ... | |
| Unique Order Count | 2/27/2010 |
| Q: I have create a query with the ORDERID, ITEMSKU, REVENUE and I am looking to get a distinct order ... A: Many thanks for the question. To get a distinct record, i.e. only 1 one record for each occasion. ... | |
| If and Then statements | 2/24/2010 |
| Q: I have a form that has 2 combo boxes in it. Of the 2 combo boxes one of them HAS to have information ... A: Many thanks for the question. Try changing this code: If IsNull(D2D_Lobs) Then MsgBox "D2D or ... | |
| Counting tasks late or on schedule | 2/23/2010 |
| Q: I have 2 tables (Planned and Actual Table Planned TaskName (text - required field - use to match ... A: Many thanks for the question. First query would be those that have not started their task by ... | |
| Query Macro | 2/22/2010 |
| Q: Hey, I am doing coursework and am trying to run an Update query from a Macro. I have done this but ... A: Many thanks for the question. Try the following: In the Macro, before the query is run add the ... | |
| Compare two date and put the value in a different colum | 2/19/2010 |
| Q: How would i compare two date and put the latest date in a specific field. Field1 Field2 ... A: Many thanks for the question. You will need to do this in a query. Create a query by following the ... | |
| Access Macro message | 2/18/2010 |
| Q: I have a macro that opens a query, goes to a field and then tests the field with "Not ... A: Many thanks for the question. You will need reference the query as well as the field: try for the ... | |
| Numbering | 2/16/2010 |
| Q: I am using Access 2000. I am trying to create an automatic numbering system to use within a report ... A: My apologies for not being clear. In your invoice table that you already have, change the invoice ... | |
| Using Mid String Query | 2/14/2010 |
| Q: I have this table in my database. Within it looks some thing this: 281-1_2 CELL:326-CDM:1-AP ... A: Many thanks for the question. To do this you will need to use an update query. Which I presume you ... | |
| identifying lowest prices for products | 2/13/2010 |
| Q: I have an access database table I call 'Process' with about 10,000 rows describing products and 30 ... A: Many thanks for the question. This is not as straightforward as you would expect it to be. Access ... | |
| Unable to edit records in search form | 2/12/2010 |
| Q: I have search form that is created based on a query. The query has 2 tables called maintable and ... A: Many thanks for the question. The problem (obviously as you have mentioned) is the third form. It ... | |
| Numbering | 2/10/2010 |
| Q: I am using Access 2000. I am trying to create an automatic numbering system to use within a report ... A: Many thanks for getting back to me. Have you tried, just using the autonumber data type? This will ... | |
| checking to see if a record is currently being edited | 2/8/2010 |
| Q: I'm modifying an Access 2000 database I designed. I'd like to know if there is a way in VBA to check ... A: Many thanks for the question and my apologies for the delay. Try the following: ... | |
| Columns in a form | 2/7/2010 |
| Q: I have a continuous form which has 2 data fields and 100 plus records In order that I can see all ... A: Many thanks for the question. To do what you ask, you will need to add 2 or 3 subforms to your ... | |
| Numbering | 2/5/2010 |
| Q: I am using Access 2000. I am trying to create an automatic numbering system to use within a report ... A: Check that you have the code in a Public module and not a form module. Module > new Otherwise, try ... | |
| MS Access database question | 2/4/2010 |
| Q: I am a new access user and have a very basic knowledge of this program. I am trying to build a very ... A: To do what you I suggested then: First as mentioned previously: Add an unbound text box, to store ... | |
| MS Access database question | 2/3/2010 |
| Q: I am a new access user and have a very basic knowledge of this program. I am trying to build a very ... A: Many thanks for the question. I see you are in Canada, I am currently visiting Vancouver from ... | |
| MS Access | 2/1/2010 |
| Q: I am currently working with an access query that provides different results of different property ... A: Many thanks for the question. OK, hopefully I can explain this clearly. Try the following Build ... | |
| SendObject macro | 1/28/2010 |
| Q: Julie, I have a database that 30-40 people use daily. Once a month the first person to log onto the ... A: Many thanks for the question. There is another way around this by using SMTP rather than outlook. ... | |
| MS Access 2007 | 1/27/2010 |
| Q: I have been trying to modify the free online from MS 'inventory' database. Essentially, I can add ... A: My apologies for missing this. Too late at night :0) I suppose. Yes you can do what you ask. ... | |
| MS Access 2007 "inventory" online template | 1/22/2010 |
| Q: I have been trying to modify the free online from MS 'inventory' database. Essentially, I can add ... A: Many thanks for the question. The problem lies with the query. To fix this: Open the form in ... | |
| ms access query | 1/20/2010 |
| Q: how can i group time and date in a query? A: Many thanks for the question. You can do this by formatting your dates and times differently. i.e. ... | |
| Running reports | 1/19/2010 |
| Q: I have 4 reports. 4 of the reports are of employees. I want to create a check box/drop down box in ... A: Many thanks for the question. My apologies for the delay in answering your question, I have been ... | |
| Calculations in Queries | 1/18/2010 |
| Q: I can't seem to fix something simple. I'll reduce things to the basic problem. I have a ... A: Many thanks for the question. I hope I have understood it correctly. The easiest way, but I am not ... | |
| separate multi-recordset in 1 field to columns | 1/17/2010 |
| Q: I am a novice Access user and not a DB but, in need of help. I am trying to develop a query to ... A: Many thanks for your question. I think what you need to use is a crosstab query. This option is ... | |
| Access 2007 command button | 1/14/2010 |
| Q: I have a form that I want to add a command button to, this command button would open up another ... A: Many thanks for the question. To do this: Make a query based on the table that the original form ... | |
| Update Table/Query | 1/11/2010 |
| Q: Hi i have 2 tables with data in. The primary key of one table [employee] is the foreign key of ... A: OK I will try again :0) sorry but there was no mention of a form in your question. To do what you ... | |
| Update Table/Query | 1/8/2010 |
| Q: Hi i have 2 tables with data in. The primary key of one table [employee] is the foreign key of ... A: Many thanks for the question. To do what you ask, you will need to firstly create a relationship ... | |
| Access - filter by form | 1/7/2010 |
| Q: I would like to run two commands when a form opens. Filter by form and clear grid, so as to start ... A: Many thanks for the question. To do what you ask, you will need to write a small amount of code,to ... | |
| 2 answers in a combo box | 6/23/2008 |
| Q: I have a drop down box how can I get 2 answers to take in one drop down box. At this time it will ... A: You cannot do this in a combo box, but you can in a list box, but unless you have Access 2007, this ... | |
| Insert Time in Header | 6/13/2008 |
| Q: How can I display the time as well as the date in the header when I run a print out from a query? A: Many thanks for the question. I do not know how to do this, the only thing I can think of is to ... | |
| Access 2003 - Creating a command that woul appending a Group of record to another table | 6/12/2008 |
| Q: I am trying to create a command button that would appending a Group of record to another table. Can ... A: Many thanks for the question. I am presuming you are going to append the records by using an append ... | |
| Displaying Photos in Continuous Forms | 6/11/2008 |
| Q: I am fairly new to Access 2000 and am creating a database of my photos by storing filenames rather ... A: Many thanks for the question. It is the nature of continuous forms to diplay unbound items as the ... | |
| ms Access 2000 VBA | 6/10/2008 |
| Q: I Have A Access 2000 Database running with several Tables. The one Table is only a lookup Table and ... A: Many thanks for the question. Try the following: Right click on the city combo box >Select ... | |
| Run time error '13' type mismatch | 6/3/2008 |
| Q: can you tell me why I am getting Run time error '13' type mismatch in code below but query works if ... A: Many thanks for theCan you send me the complete code, this may help. I am also not sure what you ... | |
| Access database lock | 6/2/2008 |
| Q: Julie I have develop a small scale Application in Access. But problem is there is security in my ... A: Many thanks for the question. To do what you ask, try the following: Type in 'Security' in the ... | |
| generating a random number with variable range | 4/17/2008 |
| Q: Need to generate a random number between 1 & total records. Table Name is: LBH Primary key is: ... A: Many thanks for the question. Try the following: RandomNumber: Int(DCount("LBHID","LBH")*Rnd()) ... | |
| Form Based Parameter Query | 4/14/2008 |
| Q: I'm attempting to build a form based parameter query, but am getting a bracketing error every time I ... A: Many thanks for the question. Have you tried putting in your own brackets i.e. same as for the ... | |
| Open 2 same reports with different criteria | 4/9/2008 |
| Q: I'm trying to generate 2 reports within a form but with different criteria. Below is part of my code ... A: Many thanks for the question. I am not sure I can help, I tried a few things to make this work but ... | |
| dates in msacces | 4/8/2008 |
| Q: sir, my task is inserting record using sql statement. my shortdate format is dd/mm/yyyy. in table ... A: Many thanks for the question. I often have this problem as I live in Australia. VBA handles all ... | |
| VBA Code | 4/6/2008 |
| Q: I cannot quite find the right syntax for this code to append a new record in one table with data ... A: Many thanks for the question. I can see a few errors (I think), this is not how I would have ... | |
| Select Last 6 | 4/5/2008 |
| Q: I am trying to make a database for my golf league. My only problem is that our handicaps are based ... A: Larry, Many thanks for the question. OK. Try the following. I cannot think of anyway to do this ... | |
| Display count results in textbox according to selected item in combo box | 4/4/2008 |
| Q: Basically,i want to keep track/count of how many times an item is selected from combo box and put ... A: Many thanks for the question. Not sure if I am missing the point of your question, but are not the ... | |
| MS Access link 2 mdb files | 4/3/2008 |
| Q: I created two programs on two different mdb files(followup and supplier details), I want to link the ... A: Many thanks for the question. The easiest way to do this, it to add a hyperlink to your form ... | |
| Basic Delete Query Trouble | 4/1/2008 |
| Q: I am new to access and I am having trouble with a delete query; I shall list my tables so as i can ... A: Peter, Many thanks for the question. Because you have many tables in the delete query, it does not ... | |
| FORM STRUCTURE | 3/31/2008 |
| Q: I am working to build a form to enter new records in tables. But the form i created only enter ... A: Khalil, Many thanks for the question. If you build a form by following the wizard, you will get to ... | |
| Subforms | 3/29/2008 |
| Q: I am half way through doing a database to hold complaints I have a Client Table Primary Key ... A: Many thanks for the question. I am not sure if understand fully. Just to check, in your ... | |
| Combining 2 tables | 3/28/2008 |
| Q: I have 2 tables that comes from an accounting software( dbf files). the first one is the ... A: Yves, Many thanks for the question. No it does not matter that the invoice no has a different name ... | |
| calculating the sum of several fields | 3/27/2008 |
| Q: I have been trying to calculate several fields into a category called others. I am getting a query ... A: Many thanks for your question. I am not sure I fully understand what you are asking. But I will ... | |
| Select Last 6 | 3/26/2008 |
| Q: I am trying to make a database for my golf league. My only problem is that our handicaps are based ... A: Many thanks for the question. You can do this easily by individual golfer. Just set up a query, ... | |
| sql count | 3/25/2008 |
| Q: I have a form that simulates the generation of random numbers, so that evaluators can evaluate ... A: Many thanks for the question. I think you need a GroupBy in your SQL, Try the following: strSQL ... | |
| Record source | 3/24/2008 |
| Q: I need to change the record source in a sub form A: Many thanks for the question. To do this, with the form in design view right click in the upper ... | |
| Creating a survey in Access 2000 | 3/23/2008 |
| Q: I am new to access and need to create a survey. I have several questions with "Yes" or "No" ... A: Shirley, Many thanks for the question. What you need to use (most likely) is a list box, then ... | |
| Sum only positive or negative values | 3/22/2008 |
| Q: I have 15 columns that have either positive or negative values. I need to have 2 extra columns that ... A: Miguel, Many thanks for the question. I hope I have understood the question properly. To do what ... | |
| Incremental count | 3/20/2008 |
| Q: I have an query with different people sort by name and by date. So it looks like this : John ... A: Many thanks for the question. This can be done in Access - but it does take coding to achieve. If ... | |
| DLookup on Combo box | 3/19/2008 |
| Q: I would like to do a Dlookup on the value displayed in a combo box. This is what I currently have ... A: Many thanks for the question Try the following: =DLookUp("reportname","dbo_comp","comp_id = " & ... | |
| VBA code syntax | 3/17/2008 |
| Q: I have a question, I am trying automate the appending or updating of an excel sheet into a table in ... A: Many thanks for the question. Try the following: Public Sub sFieldNames() Dim dbCurr As ... | |
| MS Access 2000/ Images | 3/13/2008 |
| Q: I am a novice in this field. Successfully created HOA DB to access and search improvements by ... A: Bob, Yes there is. Allen Brownes Code is the best: http://www.mvps.org/access/api/api0001.htm ... | |
| Conditional hide of detail section in report | 3/11/2008 |
| Q: I have designed a report in ms-access. In detail section I have given record numbers for each ... A: Many thanks for the question. One option is to use conditional formatting: Right click on the ... | |
| Computation question | 3/9/2008 |
| Q: Good ..., I have a table with 3 (single, fixed, 2 decimal) fields. I have another table with 1 ... A: Ken, Many thanks for the question. You would be on the right track using the IIF statement. Are ... | |
| access | 3/8/2008 |
| Q: I have never actually used access so brand new at this. I am trying to decide between using access ... A: Many thanks for the question. The short answer is Yes Access will help you do all of this, but ... | |
| Setting Up Reminders Based on Date Field | 3/7/2008 |
| Q: I've been told that ACCESS 2003 can be programmed to pop up a reminder when a certain deadline is ... A: Paul, Many thanks for the question. Not sure if I have enough information, but I will give it a ... | |
| On Hand to Beginning Inventory | 3/6/2008 |
| Q: Date Add Sold 3/1 100 3/1 25 3/2 50 ... A: Many thanks for the question Try this, For your create a report with the fields you have I presume ... | |
| Union Query | 3/5/2008 |
| Q: I am quite sure the query below is not quite right, I am trying to create a union query with three ... A: Many thanks for the question. Your Union Query should look like this: SELECT [ID],[DEPT],[NAME] ... | |
| retrieve field properties? | 3/2/2008 |
| Q: i have knowledge in java,sql and i am new to access.. with this i need to retrieve data from the ... A: Many thanks for the question. You can do this, but will need to write a bit of VBA to achieve this. ... | |
| Duplicate Entry | 3/1/2008 |
| Q: I have a database with 3 fields. My problem is I can not have duplicate data entered into either one ... A: Many thanks for the question. You are on the right track. The Micrsoft Site explains how to do ... | |
| Access Report with Formula | 2/28/2008 |
| Q: I have an access report based off a query. I would like a formula in the report that states the ... A: Dianne, Many thanks for the question. Yes this is possible. Try the following: Add an unbound ... | |
| How to query and print report | 2/23/2008 |
| Q: I have six text boxes on a form from which i run queries but all queries only open the table. How ... A: Joseph, Many thanks for the question. I am not exactly sure what you are asking, but I will ... | |
| Real time changes in Access | 2/22/2008 |
| Q: I have an Access 2007 Database that I am going to split in order to share across a network. My ... A: Charlie, Many thanks for the question. You do not need to close and open the database for the ... | |
| calculation of fields | 2/20/2008 |
| Q: its easy to do a summary if they are separate records but what if they are 4 different fields on the ... A: Anthony, I have not had much experience in standard deviation and I am not sure how you want your ... | |
| Fill Textbox from CBO results | 2/19/2008 |
| Q: I have a query in my database that pulls the following data from the respective table in the ... A: The problem is the & " " & - it will always have a space value therefore will never be null. Try: ... | |
| Fill Textbox from CBO results | 2/17/2008 |
| Q: I have a query in my database that pulls the following data from the respective table in the ... A: For the combo box, just check you have the correct number of columns. Right click on the combo box ... | |
| Attaching a PDF file to a record in Access 2003 | 2/4/2008 |
| Q: How can I attach a PDF file to a record. This PDF file would only be related to that record. A: Dee, Many thanks for the question. To do this, add a new field of hyperlink data type. Build a ... | |
| Production vs. Test Code & Data | 2/2/2008 |
| Q: Julie, I am at the stage now where I want to have a database of production tables & code and a ... A: Many thanks for the question. The best option is to split the database Toolbar > Tools > Database ... | |
| Please Help | 1/31/2008 |
| Q: ... I have one table and 4 fields . The first field is named , CustomerName and the other three is ... A: Many thanks for the question. Try the following: In the first criteria row of the first date ... | |
| Report Question | 1/30/2008 |
| Q: I have a table that has certifications tied to employees, I am trying to build a report that has a ... A: Many thanks for the question. The problem is - that all the certificates are in their own seperate ... | |
| VBA Find date | 1/29/2008 |
| Q: Hope you can answer this one. I have an application in ms Access, Using VBA : in even number ... A: Many thanks for the question. Try the following: I put this on a command button. Private Sub ... | |
| ms access question | 1/28/2008 |
| Q: could you recommend the best way to provide a unique numbering system in a multiple-user ms access ... A: Many thanks for the question. Not sure if there is an easy solution to your question. A couple of ... | |
| MS Access reports | 1/27/2008 |
| Q: and if so how it could be done? I have a query that contains a list of boat park spaces and the ... A: Steve, Many thanks for the question. Yes it is possible. Try adding subreports to your main ... | |
| Dlookup and IIF and Select Statement | 1/26/2008 |
| Q: As On selecting the combobox button value and entering the password I want to open different forms. ... A: Many thanks for the question. Not sure if this will solve your problem - but this line of code: ... | |
| relationship btw a form and subform | 1/25/2008 |
| Q: I have a main form (stud_details) also I have a subform called (pay_det_sub). I want to create a ... A: Jamil, Many thanks for the question. Yes you are correct, you need to add the Numbus field to the ... | |
| from Ms-Access | 1/24/2008 |
| Q: i have 4 objects, i want do the summation, like a+b+c+d=f like this, how we are write the query and ... A: Laddu, Many thanks for the question. Create a new query > Query > New > Design View In the first ... | |
| Date Query | 1/23/2008 |
| Q: I'm trying to create a query that pulls the most recent date from a table. The table is pretty much ... A: Sherri, Many thanks for the question. Try the following: Create a new query, by following the ... | |
| Forms | 1/22/2008 |
| Q: Hallo, I have a form (Qual_hist) with a field named Institution. Also, I have a table with all the ... A: Jamil, Many thanks for the question. Make sure the school_code is the primary key for the school ... | |
| Forms | 1/21/2008 |
| Q: hallo, I have two forms, from one form I can navigate to the other form. What I want to do is ... A: Jamil, Many thanks for the question. Yes you are correct, you can do it in the Default Value ... | |
| stLinkCriteria | 1/19/2008 |
| Q: I am having some problems on the following code. What am I doing wrong? Can you see a problem? Dim ... A: Many thanks for the question. I think your problem is this line of code. stLinkCriteria = ... | |
| transferring data between tables with common fields | 1/18/2008 |
| Q: I have a contact table (1,000 records)with an empty 'birthdate' field. I have a second contact ... A: Nancy, Many thanks for the question. Try joining them on all 4 common fields. If you cannot do ... | |
| How to Run Queries from Module | 1/17/2008 |
| Q: I would like to know " How to Run Queries using function in Modules using MS Access". A: Aditya, The simplest way of doing this is using the following line of code Docmd.openquery ... | |
| Multiple lines of input | 1/16/2008 |
| Q: Julie, I have 2 tables with a one to many relationship and I have a form to input the data. I began ... A: Ken, Many thanks for the question. I think your problem maybe that the subform is single entry. ... | |
| ACCESS CODING HELP | 1/14/2008 |
| Q: I have a query that has a criteria in it to search for a name, when i click from the menu to search ... A: Many thanks for the question. I am presuming you have a command button on your menu to run the ... | |
| Query | 1/12/2008 |
| Q: First of all I hope you have a good day. At ms access I've two tables; employee and list. Employee ... A: Many thanks for the question. You actually did not add the criteria, but try the following anyway ... | |
| Dates | 1/11/2008 |
| Q: I am wanting to know if there is a way of creating a table of dates for a specified year. I was ... A: Many thanks for the question. You will need to write some code to achieve this. I am not sure if ... | |
| Access formula | 1/10/2008 |
| Q: I am encountering a problem in form(textbox). I am trying to display the value of each individual ... A: Is NetPrice - linked to an underlying table/field or is it an unbound text box? As it is the result ... | |
| Too many pages | 1/9/2008 |
| Q: I have a scanned form that I have placed several subforms on. I have tried to create a "Print ... A: Not sure if it will be a problem or not. The primary key identifies a field in your records that is ... | |
| Calculated field Query | 1/8/2008 |
| Q: I work in a bank. I made this database for keeping records of different companies that are availing ... A: Many thanks for the question. A couple of possible scenarios (some of them may seem obvious) Check ... | |
| Switchboard Error | 1/7/2008 |
| Q: Hey, I will start by explaining the situation. I have a database that needs to be able to import ... A: Many thanks for the question. I do not know the answer from the top of my head, I may need to have ... | |
| Too many pages | 1/5/2008 |
| Q: I have a scanned form that I have placed several subforms on. I have tried to create a "Print ... A: Many thanks for the question. Try the following: With the form open File > save As > then choose ... | |
| Re: Code Error | 1/2/2008 |
| Q: Hallo, I have a subform which is built up of a field called Session (this field has values such as ... A: Many thanks for the question. I suggest try using the recordsetclone, rather than the form. the ... | |
| I need help ASAP | 12/31/2007 |
| Q: i am doing a stock control system just like a sports shop which buys new stocks which adds in to the ... A: many thanks for the question. I am afraid, this is too complicated question for the likes of this ... | |
| Sorted by date | 12/1/2007 |
| Q: I am building a database in which I entered customer info in order of the dates I served them. Now, ... A: First of all my apologies in the lateness of this reply - I misjudged my holiday dates and I was ... | |
| How to claculate Due date?? | 10/5/2007 |
| Q: I am developing a program in ms access to keep the track of premium due dates of Insurance policies. ... A: Many thanks for the question. Normally one does not store calculations such as the premium_due_date ... | |
| lookup queries | 10/4/2007 |
| Q: I am trying to take 'charges' directly from my 'charges' table to my invoice form. At the moment I ... A: Jess, Many thanks for the question. I am not sure I understand your question fully. If I have - ... | |
| Error 3709 in Access | 10/2/2007 |
| Q: I recently moved my access database from one sever to another and have come up with an error for one ... A: This is an extract from my Newsletter: My best guess is that you have a corrupt record. Can you ... | |
| problem using Access tab control | 9/29/2007 |
| Q: I am creating a form with a tab control on it (I only have 2 tabs in the control), and I am putting ... A: Jim, Many thanks for the question. My apologies for the delay in replying. Make sure you have the ... | |
| Shared Access File | 9/28/2007 |
| Q: I set up a basic .mdb file for a client. It has three linked tables to another .mdb file. Problem ... A: Shiree, Many thanks for the question. My apolgies for the delay - just have not had as much time as ... | |
| filter textfield | 9/26/2007 |
| Q: I have a combobox and textfield in a form.This combobox retrieve data from table.Let say the ... A: Maz, Many thanks for the question. First make sure the price is in the query for the combobox. To ... | |
| Linking textboxes on a form | 9/25/2007 |
| Q: I have one textbox on a form for entering a customer # and I want to have it to where on that same ... A: Many thanks for the question. To do what you ask you will need to write a bit of code. With the ... | |
| Converting row data into columns | 9/24/2007 |
| Q: I am a first time MS Access user. I have to convert the data from row format to column. The data is ... A: Jude, Many thanks for the question. What you need to do is build a cross tab query, but first we ... | |
| getting the right cost for purchased itens | 9/21/2007 |
| Q: I have a problem on extracting the right prices of a product. Hope you can help. The price of a ... A: Tiago, Many thanks for the question. Hope I have understoood your question. You could extract the ... | |
| MS Access Data Input | 9/20/2007 |
| Q: I am attempting to design a Form based on a pre-existing non-MS Access. Up to forty rows of data, ... A: Mark, Many thanks for the question. I think I understand what you are asking. You wish to store ... | |
| access query | 9/18/2007 |
| Q: Create ONE query which will:- Ask for and accept a maximum price from the user, with the cue ... A: Ugur, Many thanks for the question. To do what you ask, in the criteria row of the query type the ... | |
| masaccess photo restore | 9/17/2007 |
| Q: I have an msaccess database containing pictures of different kinds. The database is getting too big, ... A: Harrie, Oops, some times I miss the obvious. Try the following - you will have to do it one at a ... | |
| Access Reports | 9/14/2007 |
| Q: Can you advise if I can group data by selecting more than one field as a primary group header. I ... A: Jo, Many thanks for the answer. Yes you can group by more than one group header, but each record ... | |
| Email addresses into outlook | 9/13/2007 |
| Q: I came across this reply by you to someone elses question. ... A: Liam, The short answer is yes you can do this. Note: This code will open an Outlook mail message ... | |
| Trying 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: Alexander, Many thanks for the question. I am not sure if I fully understand your question, but I ... | |
| masaccess photo restore | 9/11/2007 |
| Q: I have an msaccess database containing pictures of different kinds. The database is getting too big, ... A: Harrie, Many thanks for the question. To do this. Add an extra field to your table - and call ... | |
| Access VBA Dates and OnClick Event issues... | 9/9/2007 |
| Q: I have two questions about the Access VBA programming: First: I have a list of availability of ... A: Can you send me the SQL in question, so as I can have a look and see if I can determine the problem. ... | |
| Access VBA Dates and OnClick Event issues... | 9/8/2007 |
| Q: I have two questions about the Access VBA programming: First: I have a list of availability of ... A: Yuri, Many thanks for the question. My guess is you are in a country where the date format is ... | |
| Access Module - modification | 9/6/2007 |
| Q: I am using this module that calculates elapsed time but am just learning this I am wondering if ... A: Esther, Many thanks for the question. How do you know it is a holiday? Are you talking about ... | |
| Inserting date from ascii files into access tables | 9/5/2007 |
| Q: I have the date in dateformat 'yyyymmdd' (ex: 20070905) in the ascii file, with no spaces in ... A: Sailaja, Many thanks for the question. I would import it as text/number into one table, then ... | |
| Expression typed incorrectly error message | 9/3/2007 |
| Q: I am trying to embed a subform into a tabbed form and this all looks OK in design view, but in form ... A: Jodie, Many thanks for the question. This may refer to the query either the subform or form is ... | |
| Criteria reference within a Query | 9/2/2007 |
| Q: I am attempting to use a textbox on my form as a retrieval argument in a query. In the query, I ... A: Many thanks for the question. I maybe asking the obvious, but do you have this in the criteria ... | |
| bringing up a photo related to a record | 9/1/2007 |
| Q: This is my first Access 2000 form & I need to add a photo of a product, the path to the photo ... A: Stephen, Many thanks for the question. My apologies for not replying sooner. I think I understand ... | |
| date calculation | 8/31/2007 |
| Q: I want to be able to calculate payment due dates over a period of a loan. Loans can require monthly, ... A: Samantha, Many thanks for the question. My apologies for not replying sooner. The simple answer ... | |
| Counting values in a colunm from a query | 8/30/2007 |
| Q: Im trying to create a report to count a sales persons figures for a month. I already have a query ... A: Many thanks for the question. My apologies for not replying sooner. Not sure where you are trying ... | |
| Vlookup function in Access | 8/29/2007 |
| Q: Like we are using Vlookup in Excel, i have got two tables more than 90,000 line items which I need ... A: Ravikumar, Many thanks for the question. My apologies for not responding sooner. In Access the ... | |
| ms access | 8/28/2007 |
| Q: I have an Access database which is being used to track patients. I have a patient admission date ... A: Kevin, Many thanks for the question. My apologies for not answering sooner. Try the following: ... | |
| Multiple "iif conditons" in MS Access | 8/27/2007 |
| Q: .!! I am using MS Access 2003 and I have 4 fields in a MS Access Table, viz, Area, Time_started, ... A: Ahmed, Many thanks for the question. My apologies for not getting back to you sooner. Try the ... | |
| msacces 2000 print/visible text box and label | 8/26/2007 |
| Q: I am printing bills (forms)...the data comes directly from a table in the db...I have a text box ... A: Neil, Many thanks for the question. My apologies for the tardiness in my reply. To do what you ... | |
| lookup question | 8/22/2007 |
| Q: i have a table with 2 column and another table with 4 columns. i am trying to get it to use the data ... A: Wayne, Many thanks for the question. Not sure where you are using this, I need to know this for it ... | |
| Averaging Time durations | 8/21/2007 |
| Q: I have both Starttime and StopTime fields in a query and am using this expression to get the ... A: Steve, Many thanks for the question. Because you have used the Format function - you are correct ... | |
| expressions use in Forms | 8/20/2007 |
| Q: I am a novice user -- I have set up expressions in my Form to do some simple calculations, but the ... A: Gary, Many thanks for the question. It is best not to store calculations in a table. see Allen ... | |
| Simple Calculation | 8/18/2007 |
| Q: I have had a lot of experience with Excel but this is my first use of Access and I apologize for the ... A: Rick, Many thanks for the question. My apologies for the delay. I am presuming you are doing this ... | |
| Query from Recordset | 8/17/2007 |
| Q: I know MS Access quite but not much. I am using Access 2000. What I want to do is to use DLOOKUP ... A: Many thanks for the question. My apologies for the delay in replying. Have you tried opening the ... | |
| Access Reports | 8/16/2007 |
| Q: I have an Access application and the user may want to view serveral reports at once (Pressing the > ... A: Paul, Many thanks for the question. As far as my understanding goes, if you click on the print ... | |
| Create a case-sensitive password | 8/15/2007 |
| Q: My application requires a logon. The username and the password are stored in the access db. I want ... A: Steven, Many thanks for the question. Access does not do this easily. To do this you will need to ... | |
| Simple Question | 8/13/2007 |
| Q: trying to make a query in Access (2007) calculate a group of people's ages, have a DateDiff function ... A: Darin, Many thanks for the question. Try the following syntax: NumberYears: DateDiff("m",[Passport ... | |
| length of entered text in MS Access | 8/12/2007 |
| Q: I am trying to make a database to house issues that occur during my working hours at my job, but ... A: James, Many thanks for the question. If you have not changed text from 50 characters to 255 do so ... | |
| inventory control | 8/11/2007 |
| Q: I'm an accountant and just started a new job. One of my tasks is to figure out an inventory system ... A: Rob, Many thanks for the question. Access does have a high learning curve, but the advantage is ... | |
| Text box value linked to combo box | 8/10/2007 |
| Q: I'm absolute novice with access. I have form with 2 boxes a combo and a text box. The combobox has 2 ... A: Richard, Many thanks for the question. To do this you will need to write a bit of code. Right ... | |
| form security | 8/9/2007 |
| Q: i am new to access and i am designing a database for a nursing home. I have a form called user menu ... A: Dil, Many thanks for the question. Microsoft Access has inbuilt security - type in security in the ... | |
| MsAccess - Mouse Scroll Event and Keyboard Switching | 8/7/2007 |
| Q: I developed a small database program on MS Access for Arabic and English Data Entry and Search. In ... A: Sher, Many thanks for the question. I am not sure how to change the keyboard from one language to ... | |
| finding sum for a group in a report and the total sum | 8/6/2007 |
| Q: I ve a excel worksheet containing telephone expenses of my company having fields last name, first ... A: Jisha, Many thanks for theFirst import the Excel file File > Get External data > Import Then ... | |
| VBA Assistance to stop duplicate records | 8/5/2007 |
| Q: I am working on an access database currently and running into an problem, where once the user clicks ... A: Shondelle, Many thanks for the question. I cannot see an obvious reason why there would be me ... | |
| Filtering fields | 8/3/2007 |
| Q: I am trying to design a form with multi-select list boxes that will allow users to select certain ... A: Adrian, Many thanks for the question. This is actually quite complicated. Access does not store a ... | |
| Access Mail Merge into Word | 8/2/2007 |
| Q: Julie Here's my dilemma! I can't figure out how to mail merge data from multiple tables in Access to ... A: lamar, I was going to suggest a query, but see that you have already tried that. A couple of ... | |
| order product button | 7/20/2007 |
| Q: I work with Access 2003 and have a database with products in a producttable (partnr, devicetype, ... A: Roy, Many thanks for the question. I hope I have understood correctly. The easiest way to do this ... | |
| invalid argument | 7/17/2007 |
| Q: Our database has been working fine until yesterday. When I search using the binoculars, Access ... A: Steve, Many thanks for the question. My best guess is that you have a corrupt record. Can you ... | |
| PivotChart Help | 7/9/2007 |
| Q: I just started using access and was trying to make a PivotChart of some data for the company I am ... A: Sean, Many thanks for the question. Try the following: Build a table with the following fields ... | |
| Internet & SendKey Function | 7/8/2007 |
| Q: I want to add a direct link from an MSAccess form to a specific internet URL, and simultaneously ... A: Don, I am sorry, but you probably need ASP help here. Try this thread: It may shed some light for ... | |
| Adding photos at data entry time | 7/7/2007 |
| Q: I was asked to build a database for a diving team, and I did't start with it yet. One of the things ... A: Mousa, Yes this is possible, but it is easier with the earlier versions of Access i.e. pre 2003 (I ... | |
| Access | 7/6/2007 |
| Q: Is there a way to find the number of weekdays between two dates? I want to exclude weekends and ... A: Many thanks for the question. You are correct, there is no such function in Access. The best code ... | |
| need code to send emails using SMTP in ms access | 7/4/2007 |
| Q: I need working code to send emails automatically using SMTP. I need to send an email by looping ... A: Lucky, Many thanks for the question. I used to use SMTP - but ran into all sorts of strife. I now ... | |
| Parent to multiple children relationship | 7/3/2007 |
| Q: I am trying to set up a relationship between a parent database and multiple children, i have a main ... A: Shawn, Many thanks for the question. I must admit I have never tried to do this. You could try ... | |
| Add a control to a form using VBA | 7/2/2007 |
| Q: I want to add a checkbox to a form using VBA. I try the following DoCmd.OpenForm ... A: Many thanks for the question. I made some slight alterations and it worked when I tested it. Hope ... | |
| Access - database for tracking points from shows | 7/1/2007 |
| Q: I have created a database to be used to track and tally points earned from horse shows for year end ... A: Audra, Many thanks for the question. To do what you ask, you will need to use a look up query. ... | |
| switchboard | 5/9/2007 |
| Q: i have this problem about my switchboard.. supposedly, the default switchboard opens when you open ... A: MJ, Many thanks for the question. Check your start up option. With access open in design mode, on ... | |
| report Output to word template | 5/6/2007 |
| Q: I cannot export report to word template in VBA coding. Export to new word document is ok. Can you ... A: Many thanks for the question. This is the code I use (Not all will be relevant to you, but ... | |
| ranking tasks | 5/4/2007 |
| Q: Hm..another way i thought of is this: i want to have a unique record ranking and somebody had ... A: Many thanks for the question. I think I will need to have a look at your database, to instruct you ... | |
| MS access problem | 5/3/2007 |
| Q: I have this database which stores the electric consumption of our plant. i have this two fields: ... A: Many thanks for the question. Try the following: Build a query based on your two fields. In the ... | |
| MS Access Forms | 5/1/2007 |
| Q: Here's my scenario. I have a products form with fields say F1, F2, F3 and F4. Now I want to create ... A: Many thanks for the question. If all the fields are all text, then try the following: Build the ... | |
| clear fields | 4/18/2007 |
| Q: good pm. i have an add data form, every time i save the data that i just saved remain in the data ... A: Enrico, Many thanks for the question. I am ansering this question from an Internet Cafe, as I am ... | |
| date lock | 4/17/2007 |
| Q: is there a way i can lock my date in my main form that it could not be access? because every time i ... A: Enrico, Many thanks for the question. Try the following: Right click on the date field, select ... | |
| Field Calculations | 4/13/2007 |
| Q: I have a query that returns two rows and I would like to perform the calculation on the 2 values ... A: Rich, Many thanks for the question. I am answering this whilst away, so do not have access to ... | |
| Using VBA modules in another access database | 4/12/2007 |
| Q: I have 2 databases (a, b) serving different purposes, and I would like to use some of my vba ... A: I must admit I have never tried to do this, I just copy the code. I did a bit of a google search ... | |
| If statement within query | 4/11/2007 |
| Q: I have a if statement that returns #Error as the result. What I'm trying to do is use ... A: George, Many thanks for the question. Try not having the talking marks "", outside Expr1 and 4 If ... | |
| order by clause | 4/6/2007 |
| Q: I created a table as below: Region District Territory Customer_Name 60 42 ... A: Anitha, Many thanks for the question. You will also need to add the Customer_Name to the order by ... | |
| Date &Time (- minus) Date &Time!! | 4/5/2007 |
| Q: 1.In Column A there is a data of Date & Time. (As below. Data -) 2.In Column P there is an ... A: parantapkumar, Many thanks for the question. How is this information stored in the table? Is ... | |
| Multiple field index | 4/4/2007 |
| Q: Is there a way for me to create an index based on the values of multiple fields? I have a table with ... A: Paul, Many thanks for the question. In design view of the table, you can higlight both the fields ... | |
| Adding only what is in current form | 4/3/2007 |
| Q: The database I designed is used for shipping purposes so all the information is input into the form ... A: Kerri, Many thanks for the question. I need more information, before I can answer. Are you ... | |
| 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: ATS, Many thanks for the question. Your SQL looks OK to me (try removing the ;), but what you need ... | |
| Dcount syntax problem | 3/30/2007 |
| Q: I have this query below working working when the STUDENT_NO field data type is number. Can you ... A: Many thanks for the question. Try the following: SELECT Count(*) AS Stu_Count, Sum(FEE) AS Stu_Val ... | |
| disabling warning message prompts | 3/29/2007 |
| Q: i have a command button that deletes all the content of a temporary table: DoCmd.RunSQL ("DELETE ... A: Many thanks for the question. To do this type the following before the SQL DoCmd.SetWarnings False ... | |
| Question | 3/28/2007 |
| Q: I have two variables X and Y. Value of X are like a,b,c,d,e,f,g,h,....etc...and values of Y are 0, ... A: Vinayak, Many thanks for the question. Try the following: In the query section of Microsoft ... | |
| help on ms access | 3/27/2007 |
| Q: Im just a beginner in ms access and i hope i dont sound too dumb with my questions. =) im creating ... A: Jmak, Many thanks for the question. I am not completely sure that I understand your question. if I ... | |
| Problems with unexpected parameters | 3/26/2007 |
| Q: Good morning, I've been attempting to multiply 2 fields together to create a gross payment field ... A: Ana, Many thanks for the question. Where are you trying to do this, in a form? query? or a ... | |
| on querry | 3/24/2007 |
| Q: Goodafternoon I have the 2 following queries. The 1st one shows top 10 lines on the client who’s ... A: Many thanks for the question. Try the following: Create a third query in design view, adding the ... | |
| SubReports within Reports | 3/22/2007 |
| Q: In my Subreport is it not displaying the page header. Just the main reports page header is shown. I ... A: Sulabh, Many thanks for the question. Sorry but you cannot do this. I did though find the ... | |
| Fill a text box based on combo box value | 3/15/2007 |
| Q: I have two tables: TblMain and TblSource. TblSource holds the ship to information which includes: ... A: Leslie, Many thanks for your question. Try the following to complete the textbox: First of all ... | |
| MS Access | 3/14/2007 |
| Q: Goodafternoon. Could I ask you one question concerning MS Access? I have two tables. A table with ... A: Ivan, Many thanks for the question. I need a bit more information though. Is there an identifier ... | |
| Query | 3/13/2007 |
| Q: I have created a simple participants/workshop database. There are many workshops (30) so in the ... A: Alison, Many thanks for the question. By listing all the workshops as seperate fields, with a ... | |
| report summery | 3/7/2007 |
| Q: i need to write a summery report with 2 lines the first one is the date and the second one is order ... A: Mike, Many thanks for the question. Yes this can be done - try the following: Add an unbound text ... | |
| MS Access | 3/5/2007 |
| Q: I need to covert one page at a time from my form in to a (pdf)record. So I email the record to a ... A: Many thanks for the question. Try the following site. http://www.lebans.com/reporttopdf.htm This ... | |
| MS Access Forms | 2/28/2007 |
| Q: I am trying to understand an application that was created by someone else. When I open this file ... A: Nick, Many thanks for the question. Try holding down the shift key whilst you open the database. ... | |
| Document | 2/26/2007 |
| Q: Is there possible I can export a table design file as fieldName, Datatype and Description. Thank ... A: Jane, Not sure if this is what you are looking for, but try the following: Tools > Analyze > ... | |
| Add a Count | 2/25/2007 |
| Q: Julie: Thanks so much for what you've helped me with so far. It is working--to a point. The ... A: Bonnie, Try the following: To get rid of the the label Text29, just click on it to select it and ... | |
| msaccess | 2/22/2007 |
| Q: How do i open file type access lockfile 9.Whenever i try to open it iget no response. A: Many thanks for the question. You should be able to open the *.ldb file with notepad to view the ... | |
| Add a Count | 2/21/2007 |
| Q: At the bottom of each page of my Access report, I would like to add a COUNT to tell me how many ... A: Bonnie, Many thanks for the question. This proved to be not as straight forward as thought it ... | |
| Filtering by Date ranges but excluding weekends | 2/20/2007 |
| Q: Is there a way to have a query pull only dates on a rolling 20 day time frame, but that excludes ... A: Al, Many thanks for the question. Yes you can do this. Try the following: In a query in design ... | |
| Cubic Capacity | 2/19/2007 |
| Q: Julie - I would like to calculate the cubic capacity of a box - say it measures 0.860 long, 0.530 ... A: David, Many thanks for the question. Not sure what the problem you are experiencing is, but I get ... | |
| Default value for first record set | 2/15/2007 |
| Q: I have a text control called "MSO" that has a custom auto number assigned to it from a VBA After ... A: Many thanks for the question. Try to use Error Handling. For example, change your code to the ... | |
| Calculation Question | 2/14/2007 |
| Q: Good Morning: I created a form that sums up the product counts of my main table (i.e. dinner plates ... A: Salina, Many thanks for the question. First of all build a query, adding the table that contains ... | |
| Generate Random LIst | 2/13/2007 |
| Q: I am building a database for a hospital. My employeer has told me he wants in the program a small ... A: Many thanks for the question. To do what you ask, you need to randomly select the staff from a ... | |
| Linked forms for a large table | 2/10/2007 |
| Q: I have a very large table. I use forms for data entry. My forms are broken down by category within ... A: Victor, Many thanks for the question. When you add the command button to the form and follow the ... | |
| Not Operator for multiple records | 2/8/2007 |
| Q: I am trying to create a query for multiple fields. For example in 1st field I need to return all ... A: Sherri, Many thanks for the question. This is what worked for me (presuming I have understood your ... | |
| AUDIT TRAIL | 2/6/2007 |
| Q: MS ACCESS at my company is a desktop software located on a network server) I received this site from ... A: I have had a look at the audit database. The code on the form is for the command button on the ... | |
| Option Group to set Criteria for Query | 2/5/2007 |
| Q: I have an Option group with the following 4 selections: Open, In Process, Closed, and All Status. I ... A: Alex, Many thanks for the question. I think you need an IIF and a Like statement try adding it ... | |
| random sampling | 2/2/2007 |
| Q: I need to select 5 random samples of checks disbursed for the month. How can I use access to provide ... A: Susie, Many thanks for the question. To do what you ask, you are going to need to write a bit of ... | |
| Form issues after "Filter with Comboboxes" | 1/31/2007 |
| Q: I just read a question you previously answered back on 6/11/2004 regarding "Filter with Comboboxes". ... A: Joe, 2004, wow that was a long time ago. I am not sure what I wrote - there could have been a typo ... | |
| access 2000 | 1/28/2007 |
| Q: I'm using window xp. I just made a membership list in access 2000. I would like the birthdays to be ... A: Anita, Many thanks for the question. To do what you ask, build a query by following the query ... | |
| ms access | 1/27/2007 |
| Q: "hello, i have a problem in ms access. i have a db which has names of customers,in my work ask from ... A: Katia, Many thanks for the question. It maybe a good idea to make a copy of the database before ... | |
| Conditional objects in Access | 1/26/2007 |
| Q: I have a field in a table that is checked yes or left blank. I have placed an object ( a colored ... A: Many thanks for the question. To do what you ask: With the report in design view, right click on ... | |
| question | 1/25/2007 |
| Q: I work with rate codes, sometimes 1 customer will have 2 rate codes for the same acct. I only want ... A: Dianne, Many thanks for the question. Are you creating the database yourself? If yes, then: If I ... | |
| Rolling Up Data | 1/24/2007 |
| Q: The only thing is, I want to show the values that are in the 'practice area column'. That's why ... A: Ken, OK, I think I understand what you are trying to do. Try the following: You will need to ... | |
| Rolling Up Data | 1/23/2007 |
| Q: Here's my question. I have 2 fields in my table: Customer Number and Practice Area. I have over ... A: Ken, Many thanks for the Question. I am not sure if I fully understand your question but I wil ... | |
| Multiple Updates In One Update Query | 1/22/2007 |
| Q: This answers my basic question. Are there any limits to the number of update criterias? I would ... A: Keith, Thanks for getting back to me. 200 maybe a bit of a stretch for the IIF statement. Cannot ... | |
| unbound combo box | 1/21/2007 |
| Q: How can i load my table data into unbound combo box using VBA code. I am using front-end back-end ... A: Rady, Many thanks for the question. Try the following: '***** Dim strSQL As String strSQL = ... | |
| Multiple Updates In One Update Query | 1/18/2007 |
| Q: I am only a "basic" access 2000 user but I would like to create an Update Query to update multiple ... A: Keith, Many thanks for the question. First of all an Update query updates your records and it ... | |
| Calculations Between Table Records | 12/20/2006 |
| Q: How can I make calculations between fields of the same table ? Record (n) = Record (n) - Record ... A: Paulo, Many thanks for the question. Just to make sure I am on the right track. Do you wish to ... | |
| Concatenate | 12/19/2006 |
| Q: I am trying to combine text from 3 columns into one. I open a query and the table with the data in ... A: Many thanks for the question. Try the following: Check the spelling. Enclose the field names in [ ... | |
| ms access | 12/18/2006 |
| Q: I have developed an application in .net by using ms access. How multiple users can access a single ... A: Many thanks for the question. I am not sure what you are asking though. The way Access is set up, ... | |
| IF Statement | 12/17/2006 |
| Q: I have one file in my table thats either going to be a 0,1,2 or 3. In my report, if its a 2, I want ... A: Kim, Many thanks for the question, try the following: If Me!FieldName = 2 then ... | |
| Date & Time | 12/16/2006 |
| Q: I have a simple table (Date, Time, Agent, Notes) that I need to automatically enter the current ... A: Steve, Many thanks for the question. The easiest way would be to add this once information is ... | |
| database problem | 12/13/2006 |
| Q: Good moorning, I would like someone help me with a problem I have with Access. I have a selection ... A: Maria, Many thanks for the question. To do what you ask, you will need to do this in a few steps: ... | |
| "Word"-to-"Access" macro | 12/12/2006 |
| Q: I have a very simple table in "MS Word" (all fields are text fields) and I want to transform it into ... A: Vladimir, Many thanks for the question. Not sure if I can help greatly. You cannot import a table ... | |
| MS Access report | 12/11/2006 |
| Q: How do I create a report wherein I combine two queries into a report that shows one query on top and ... A: Odie, Many thanks for the question. To do what you ask. Open a report in design view (i.e. do ... | |
| DSum | 12/8/2006 |
| Q: I have a database with two related tables: 1. tb_main_potatees 2. tb_main_stems The tables are ... A: Carla, Many thanks for the question. What you need to do is to create a Totals Query - to do this, ... | |
| Set Primary keys for a table | 12/6/2006 |
| Q: I need to know how to set a primary key for a linked table table in vba. A: MO, Try the following: Public Sub createPKI() On Error GoTo ErrHandler Dim db As ... | |
| word quantety | 12/5/2006 |
| Q: I did adatbaise for Telegram using and i have afild name ( Note ) ( Memo type )so i need the code ... A: Many thanks for your question. Try the following: Open the Modules section of Microsoft Access and ... | |
| adding a phone # | 12/4/2006 |
| Q: I have an table with addresses in it some times there is no phone number in the excel file I import ... A: Mike, Many thanks for the question. I am not sure how you have the Macro set up to do this, but ... | |
| How to use Access | 12/3/2006 |
| Q: I am taking my last class at Indiana Business college at Fort Wayne In. Due to some problems I was ... A: Many thanks for the question. Try the following site: ... | |
| RunSQL doesn't like my SQL | 12/2/2006 |
| Q: Why am I getting an error message saying that RunSQL action requires an argument consisting of a SQL ... A: Many thanks for the question. .runsql takes only action queries DELETE UPDATE INSERT Try the ... | |
| importing sybase data | 11/29/2006 |
| Q: how can i import sybase tables to ms-access database using vb programming A: I am afraid, I do not know much about Sybase, but did a bit of research for you. See the following ... | |
| Password protect a table | 11/28/2006 |
| Q: How do I password protect one table in the database? A: Joanne, Many thanks for the question. There is no way that I know to password protect just one ... | |
| User login and password | 11/27/2006 |
| Q: I need you to help me with a code for user login, password in Access and where a user will be able ... A: Haneesh, Many thanks for the question. The easiest way would be to use Microsoft Access's built in ... | |
| SetFocus | 11/26/2006 |
| Q: How do I SetFocus (in the code) to a textbox, without it selecting the text, if there even is any ... A: Many thanks for the question. Try the following: Me!FirstName.SetFocus Me!FirstName.SelLength = 0 ... | |
| Tables and Data | 11/25/2006 |
| Q: I have an idea bank which need to have reserves stored by quarter. This information will be entered ... A: Monika, Many thanks for the question. Just to clarify - you want idea 101 to increment ... | |
| user tracking | 11/24/2006 |
| Q: i want to add a feature in my inventory database in which it will track user login, time and date of ... A: Many thanks for the question. Is there Access security on the database, or is the logon a general ... | |
| 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: Mo, Many thanks for the question I am presuming the field containing the dates is of date/time ... | |
| Creating a query | 11/21/2006 |
| Q: I have a table with two fields (columns). The first field contains a unique ordinal number for each ... A: Vladimir, Many thanks for the question. To do what you ask try the following; Create a query with ... | |
| DB Normalization | 11/17/2006 |
| Q: I have a database designed by someone else. I tried to normalize it and represent the related data ... A: Athalia, Many thanks for the questions and my apologies for the delay in my reply. Q1 As you make ... | |
| Relationships, PKs, FKs, and Lookups | 11/16/2006 |
| Q: I am rather new (6 months or so) to MS Access and am kind of confused about something when it come ... A: Dalia, Many thanks for the questions. My apologies for the delay in getting back to you. Q1: Ask ... | |
| Query calculation | 11/9/2006 |
| Q: i have aproblem when i make the query it was to slow to calculate the data, and even sometime it ... A: Jafet, Many thanks for the question. Yes, using the D Function (especially using many of them) can ... | |
| How to make this query? | 11/8/2006 |
| Q: I have a table with many rows (lines). Each row has several boxes (fields). The first column ... A: Many thanks for the question. Try the following: In the criteria row of the query for the field ... | |
| Stop Watch Time Format In MS Access | 11/7/2006 |
| Q: Good morning Julie, Please can you explain to me how to create a field in MS Access that would ... A: Charlie, Access date/time datatype only stores hour:minute:second because it stores a date as an ... | |
| Access | 11/5/2006 |
| Q: I am using Access 2002. I have an association of clubs. I have a table for clubs with club ID and ... A: My apologies for the delay, this proved a bit trickier than I expected :o) Try the following: ... | |
| search textbox help | 11/4/2006 |
| Q: Please help me and explain clearly as I am slowly learning the code and would like to understand how ... A: Mike, Many thanks for the question. To do what you ask: Add four unbound comboboxes to your form, ... | |
| Ms Access Report | 11/3/2006 |
| Q: I need to create a report for missing value with 5 variables in Ms Access. Data as id var1 var2 ... A: Jane, Many thanks for getting back to me. Try the following: Build a query based on the table, ... | |
| Combine fields into one field | 11/2/2006 |
| Q: Let's say I have these tables: table#1 fields: Name, areas, date table#2 fields: Name, areas, date ... A: Mike, Many thanks for the question. To do what you ask you will need to build a union select ... | |
| Calculate the sum of selected records from a table | 11/1/2006 |
| Q: Total newby when it comes to access so im hoping someone can put me in the right direction. I am ... A: Many thanks for the question. I am not sure if I have completely understood your question, but if I ... | |
| uppercase | 10/23/2006 |
| Q: could you please help me i have tried the > character in the input mask to try to set all the data ... A: Many thanks for the question. To achieve this, use the 'Key Press' event for each field and add the ... | |
| Combining field entries | 10/22/2006 |
| Q: I have address1, address2, town, county, country entries. I want to join them into one entry with ... A: Many thanks for the question. To do what you ask try an IIF statement i.e. FullAddress:[Address1] ... | |
| CHECK BOXES IN FORM | 10/21/2006 |
| Q: I have a database used for accountability and i have a form that is set with many subforms on it. I ... A: Chuck, many thanks for the question Add a command button to the form without using the wizard, ... | |
| 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: Jeff, Many thanks for the question. To do what you ask: Add the following code to the on click ... | |
| Update query | 10/19/2006 |
| Q: In Access 2000 I have a table (Table1), in which has multiple fields. But I only need two, the Dept ... A: Many thanks for the question. I think what you need is a query, rather than a table. I also think ... | |
| Validation Range of Date in Form | 10/18/2006 |
| Q: ------------------------- Thanks for your answers. It works well. I got another question if you ... A: Cathy, Many thanks for the question. By default, Microsoft Access saves data automatically when ... | |
| Counting Records | 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: Many thanks for the question. To do what you ask, try the following: Add an unbound text box to ... | |
| Multiple Entry fields | 10/15/2006 |
| Q: I am developing a database populated with information from technical reports and I need to know how ... A: Gregg, Many thanks for the question. The best way to handle this would be to have a subform set up ... | |
| Validation Range of Date in Form | 10/13/2006 |
| Q: How do you validate a user to enter the date in between 1. 16/09/06 - 30/09/06 only 2. ... A: Cathy, Many thanks for the question and my apologies for the delay, I have been having a few ... | |
| decimal places in access 2000 | 10/11/2006 |
| Q: I have built a table with a field called time extended the data type is number, field size is long ... A: Many thanks for the question. Try the following format in the table (note if you have added this ... | |
| Update Query | 10/10/2006 |
| Q: "In our school database a table has a text field named “Class” that specifies the class in which a ... A: Many thanks for the question. To do what you ask, the easiest thing would be to build an update ... | |
| Sharing Access | 10/6/2006 |
| Q: I have a database which needs to be accessed by other users. The database should be accessed by all ... A: Many thanks for the question. Will the users be accessing the database over a network, i.e. will ... | |
| date query | 10/4/2006 |
| Q: I am trying to write a query which will filter my records to show those records whose dates fall ... A: Jim, When you created the Totals of query, the date field that you have asked for the Maximum date ... | |
| Concatenate like excel in Access | 10/1/2006 |
| Q: I have outgrown Excel and trying to work with my data in Access. I need to do to things 1) I need ... A: David, Welcome to Access. Unlike Excel, Access will not store the above numbers in a table, but ... | |
| Relationships | 9/30/2006 |
| Q: Since a record can have more than one relationship, if you Enforce Referential Integrity on the ... A: Many thanks for the question. Referential Entegrity is usually used for one to many relationships. ... | |
| Update Querry MS Access | 9/29/2006 |
| Q: Update one column based on the criteria of another in another EX Column a. Latitude D600 Column ... A: Mike, Many thanks for the question. To do what you ask: NOTE: make a copy of your table first in ... | |
| date query | 9/26/2006 |
| Q: I am trying to write a query which will filter my records to show those records whose dates fall ... A: Jim, Many thanks for the question. What you will need to do is write two queries. Create your ... | |
| database | 9/24/2006 |
| Q: I was wondering if you can give me some suggestions in how to create a databae using microsoft ... A: Sue, Many thanks for the question. I have recently done this for one of my clients. The code ... | |
| Unwanted blank lines in Access Reports | 9/22/2006 |
| Q: I am using Access 2002, but I think this problem would be the same with any version.... Can you ... A: Leanne, Many thanks for the question. To get rid of blanks lines in a report do the following: ... | |
| Updating a calculated field on an access form | 9/21/2006 |
| Q: I'm a "rookie" when it comes to Access. Please can you assist with the followingQuestion I have a ... A: Ibukun, Many thanks for the question. Try the following: Right click on the combobox and select ... | |
| text box | 9/20/2006 |
| Q: I am a beginner at access and have a question that I'm sure has an easy answer. I have a text box on ... A: Jeff, Many thanks for the question. As easy as this seems to be it isn't. You will need to do ... | |
| Access 2000 | 9/16/2006 |
| Q: I have created a table list of names and addresses in Access, from that I used Label Wizard to ... A: Jackie, Many thanks for the question. I presume you are happy to do this manually. What you will ... | |
| Northwind command buttons | 9/15/2006 |
| Q: How do you get the same command button as in the sample database Northwind. The one where its ... A: Sulabh, All I know is that these new types of buttons appear in Access 2003. What version of ... | |
| show fields base on selection options | 9/14/2006 |
| Q: Great, understand now. Would you be able to advise whether I can replace PreferredPrice with a ... A: KC, Many thanks for the question. I am not sure I understand it fully, but if I do, then the ... | |
| show fields base on selection options | 9/13/2006 |
| Q: I intend to set up two tables. One with Items, Price1, Price2, Price3; another with Item, Quantity, ... A: Many thanks for the question. To achieve this build a query, with both the tables, linking them by ... | |
| query or macro? | 9/11/2006 |
| Q: I run a membership database & am faily good at most things, but I have been trying to figure out if ... A: Ken, Many thanks for the question. To do what you ask, you will have to run an 'Update' query. To ... | |
| extracting data | 9/5/2006 |
| Q: I have a address database with dates in it I need to create something to extract the info by date ... A: Mike, Many thanks for the question. My apologies for the delay in responding. You can use a Macro ... | |
| Table looking up itself | 9/3/2006 |
| Q: My brain is hurting on this one.. Hope you can help. I have a small manufacturing business. I ... A: Don, First of all my apologies in my delay in answering this. I am sure I can help you, if you ... | |
| MS Access 2000 sorting and grouping of report | 8/30/2006 |
| Q: Is it possible to have different field to sort depend on the group in MS Access 2000? for example: ... A: Mark, Many thanks for the question. Yes it is possible, but you will need to write some VBA and ... | |
| Spreadsheet Transfer into Access | 8/29/2006 |
| Q: So I know how to use the Transfer spreadsheet function in Macro form and VBA, but what I really need ... A: Many thanks for the question. What you need is the code from the following site: ... | |
| List numbers | 8/28/2006 |
| Q: My name is Ivan - I am a student from Russia. I have a table of about 300 rows – a database of ... A: Many thanks for the question. I am sure this can be done, but I will need your data to test out my ... | |
| Strange query problem | 7/26/2006 |
| Q: I forgot to say that I already tried the syntax using the # signs and still not work. Sorry. Truely ... A: Frans, OK Attempt two. The correct SQL code to append data to a table is: INSERT INTO tblCustomer ... | |
| form size & more | 7/25/2006 |
| Q: Actually I tried that and it didn't work for registries that have blank fields. Anyway I was ... A: Mike, Below is an example of SQL, that I used for a similar thing: It is reasonably complicated as ... | |
| Parameter Reports | 7/24/2006 |
| Q: I have a form that is based on an invoice number. I want to have a button on the form that will ... A: Maureen, Many thanks for the question. To do what you ask: In the query for the report, you will ... | |
| Strange query problem | 7/22/2006 |
| Q: I exeperience strange query problem. I have a table with structure like this (call this table ... A: Frans, Many thanks for the question. I think the problem is with your date syntax. Try INSERT ... | |
| Specific Data from a record set | 7/21/2006 |
| Q: I'm trying to developing a report to display data in a "cross tab format. A query generates the ... A: Dan, Many thanks for the question. My sincere apologies, but I am not sure what you are asking. ... | |
| form size & more | 7/19/2006 |
| Q: I'm almost done with my database, I only have a couple of things I hope you can solve. 1. I can't ... A: Mike, Many thanks for the question. Well done with the database. 1) Try setting your subform to ... | |
| null error when using a datepicker | 7/17/2006 |
| Q: I making a database that will use date pickers but every time I click to go to the next form I get ... A: Rafeal, I will need to have a look at the database to see what is causing the error. You can send ... | |
| Last Updated Column in MS Access | 7/12/2006 |
| Q: I have a database of people and their details (addresses, telephone numbers, emails etc.). I need to ... A: Avril, Many thanks for the question. You can only update this field, via a form, you cannot do it ... | |
| Serial Numbering | 7/9/2006 |
| Q: I am new to MS Access, I created a Product, Product Category and Supplier List as follows: Products ... A: Sher, Many thanks for the question. First the question about the AutoNumbers - once you delete an ... | |
| nicrosoft access | 7/7/2006 |
| Q: I want a form to automatically open when you open the database(HOW) THANK YUO. A: Many thanks for the question. To open a form automatically when you open the database: With your ... | |
| hyperlink | 7/4/2006 |
| Q: I have this form where you can link the database to another database where I have all the tables. ... A: Mike, Many thanks for the question. The following link will display some code to do this: ... | |
| Ms Access | 6/29/2006 |
| Q: I have a form for viewing and data entry. I want to give a password so that only if the password is ... A: Many thanks for the question and my apologies for the delay in getting back to you. You can either ... | |
| split column | 6/28/2006 |
| Q: I have a column which has the values like below 35ø11.283973S 35ø12.762998S 35ø07.891144S ... A: shah, Many thanks for the quesiton. To do what you ask, open a query in design view and add the ... | |
| Slow running on shared folder on network | 6/27/2006 |
| Q: Iam a novice ACCESS user & have a ?. I recently installed a project tracking database on a shared ... A: Randy, Many thanks for the question. It is a bit of trial and error as to what the problem is, ... | |
| Access 2000 | 6/26/2006 |
| Q: I have a form that is based on a table. My form includes 2 synchronized combo boxes that work well. ... A: Adrienne, Many thanks for the question and my apologies for the delay. The problem is the first ... | |
| input trans, update master, output histrans files | 6/25/2006 |
| Q: Yes, we will be doing this many times and would be lovely if it can be done by just pressing a ... A: Andy, My apologies for the delay in getting back to you. I am having a few computer problems, but ... | |
| input trans, update master, output histrans files | 6/24/2006 |
| Q: Im using ACCESS 2003 and got an inventory transaction (issue/receipt) input file containing the ... A: Many thanks for the question. Just a few points of clarification - do you need to do this just once ... | |
| Time tracking | 6/23/2006 |
| Q: I would like to know if there is any way on a form that you can type in a number e.g. 1234 press ... A: Steve, Many thanks for the question. To do what you ask, create a table that will keep this ... | |
| How to create a PopUp Alert box when a criteria is meet in a calculated field | 6/22/2006 |
| Q: I would like to create a popup alert box when a criteria is meet on a subform. I know how to do the ... A: Delores, Many thanks for the question. To do what you ask: I am presuming the Total is calculated ... | |
| Host(Computer) Name | 6/21/2006 |
| Q: I need a query to find a computer name.Using Sql Server We can find Computer name like " select ... A: Jebasingh, Many thanks for the question. To find the current user then it is: = CurrentUser or ... | |
| multiple page form | 6/20/2006 |
| Q: I am trying to create a multiple page form. Used to do this all the time. But been a while and ... A: Carol, Many thanks for the question. Surprisingly I have not created multipage forms, though I ... | |
| Modification of forms | 6/19/2006 |
| Q: How to create and modify forms designed in acess A: Many thanks for the question. If you need to get into the design section of an already built Access ... | |
| Reset index to 1 | 6/14/2006 |
| Q: I have a table which primary key is set to Autonumber. I have populated my table with data, but for ... A: Athalia, Many thanks for the question - I think the following extract from one of my Newsletters ... | |
| mdb size | 6/12/2006 |
| Q: I was programming my database when I realized the size of the mdb archive was 167 mb!??? I don't ... A: As you build a database and create items, move things around, delete items ete Microsoft Access does ... | |
| Invoicing at access | 6/10/2006 |
| Q: Can you show me please how to make invoices using Microsoft Access. Thank you for your attention A: Many thanks for the question. This is reasonably complicated to answer as you have not given me ... | |
| User Perms | 6/9/2006 |
| Q: I have created User groups, users and assigned permissions as necessary. When I set the Admin ... A: May, I am not sure why your switchboard stopped working. You could try to reset the permissions in ... | |
| Subform Conditional Formatting | 6/2/2006 |
| Q: A simple question but I will be suprised if there is a solution. I have a checkbox in a 'continuous ... A: Viv, I am not positive about this. I do have some conditional formatting code, but it is a long ... | |
| message box location | 6/1/2006 |
| Q: Goodafternoon Julie, I have been struggling for a while now with the next issue, i wonder if it is ... A: Jeroen, Many thanks for the question. My apologies, but I do not know if this can be done. I have ... | |
| Access Code | 5/30/2006 |
| Q: I have started a database for employees to use to document future vacation times as a communication ... A: Jan, My apologies for the delay in getting back to you. I did try, but All Expert kept going to a ... | |
| Invoice in Access | 5/28/2006 |
| Q: I have a small business and I want to automatically print my invoices to my customers. How can I ... A: Many thanks for the question. My apologies, but this is way to complicated for me to tackle here. ... | |
| Access Code | 5/28/2006 |
| Q: I have started a database for employees to use to document future vacation times as a communication ... A: Jan, Many thanks for the question. I am not sure if I fully understand your question - do you wish ... | |
| record edit form | 5/25/2006 |
| Q: How can I create a Form to edit records? I mean, I don t want the form to add any new record, I want ... A: Mike, Many thanks for the question. To do what you ask, you will need to change the form's ... | |
| MS Access - Command Button Macro | 5/24/2006 |
| Q: I am using MS Access 2002 and I've built a one table database with about 50 different fields and ... A: Michael, Many thanks for the question. Microsoft Access should do this automatically for you. On ... | |
| MS access | 5/21/2006 |
| Q: What are the advantages and disadvantages of MS Access over MS Excel from the viewpoint of data ... A: Greg, Many thanks for the question. Access comes into being if the there is lots of data or the ... | |
| Date() | 5/18/2006 |
| Q: In a given date format as 12/02/2005. I want to saperate year value 2005 from the given date and use ... A: Wahed, Many thanks for question. What you are looking for is the DatePart function. To do this: ... | |
| Access 2000 | 5/16/2006 |
| Q: Is there a way to convert numbers to currency in a query? I'd like to use either a make-table query ... A: Many thanks for the question. If you right click on the number field which you would like to ... | |
| Open runtime in design view | 5/15/2006 |
| Q: I need to open a ms access runtime db in design view. How do I get it open in design view instead ... A: Joe, Many thanks for the question, my apologies for not answering you earlier. If you have Access ... | |
| check box | 4/15/2006 |
| Q: i've placed check boxes in a form to enable users to select fields they would like to see displayed ... A: Marelle, Many thanks for the question. I am only guessing, but I think possibly the cause of your ... | |
| Database Report Generators | 4/12/2006 |
| Q: Do you know of any inexpensive REALLY SIMPLE to use database report generator programs? We have ... A: Bruce, Many thanks for the question. I obviously use Microsoft Access, specifically the queries ... | |
| Importing a csv file into Access | 4/10/2006 |
| Q: Thats awesome... it worked first time! Now,I'm hoping that you may be able to help me with a couple ... A: John, I am glad it worked. For the first question change the False to True in the following line ... | |
| Importing a csv file into Access | 4/6/2006 |
| Q: I need to import a csv file into Access, make a table out of this using select criteria and then ... A: John, Many thanks for the question. To do what you ask. Add a command button to your form, do not ... | |
| Access 2000 -Choices for answer buttons | 4/4/2006 |
| Q: I am attempting to update an Access 2000 datatbase form that currently has a toggle button to record ... A: Julia, Many thanks for the question. Yes you can have a triple state on a toggle button. To set ... | |
| VBA Enable function | 3/29/2006 |
| Q: I am trying to enable a button on a form in Access based on the value of a particular field. The ... A: Nick, Many thanks for the question. I would use the after update event Try the following code: ... | |
| Filtering a lookup | 3/27/2006 |
| Q: I have three tables: 1. Project 2. Tasks 3. Timesheet The 'Project' table consists of two ... A: Gorden, Many thanks for your question. My apologies for the delay. I have been having trouble ... | |
| Forms | 3/23/2006 |
| Q: I'm trying to build a Rental Management Database for a property holdings company. The difficulty I'm ... A: Marelle, Many thanks for the question. I am not sure if I have understood your first question ... | |
| Passwords in MS Access | 3/22/2006 |
| Q: The code I have used is: Private Sub Option6_Click() 'Attached to On Click event of Option6 ... A: Leanne, Make the following changes see '*change this line' below, then add the code to the onclick ... | |
| Passwords in MS Access | 3/21/2006 |
| Q: I am a novice user (so need good instructions!). Can you please tell me how I can password protect ... A: Leanne, What is the code you are using for the forms? If you have got this to work for forms, it is ... | |
| MS Access 2000 | 3/10/2006 |
| Q: How do you change the date and time format in Access to the standard international format? Access ... A: Marelle, Many thanks for the question. Access will use whatever date format you have set on your ... | |
| ' Find the record that matches... | 3/7/2006 |
| Q: ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone ... A: Karen, Is there a Primary Key field that you can use to find the record, rather than a non primary ... | |
| Using combined text values from multiple fields to create new dataset | 3/6/2006 |
| Q: Example of what I'm trying to do. There are 3 fields (Activity, Participants, and ProgramName) on ... A: Mike, Many thanks for the question. I think the problem you maybe having, is that you have added ... | |
| Sum the age of a group of people | 3/3/2006 |
| Q: Julie, I have a group of people - I know their Date of Birth, so I can get their age by using date ... A: David, To do what you ask, build your report, Then in the footer of the report, add an unbound ... | |
| Photos inserted as OLE objects | 3/2/2006 |
| Q: I am using Access 2003. Sometimes when I place Photos in my form as OLE objects the photo appears ... A: Sheldon, Many thanks for the question OLE object will display graphics of certain types with no ... | |
| updating fields in table via command button | 2/28/2006 |
| Q: i need serious help with my access project... im designing a database for videoshop for loans in ... A: adeel, Many thanks for the question. My apologies for the delay in getting back to you. You can ... | |
| I want to limit transactions... | 2/27/2006 |
| Q: I want to limit transactions into a ms access database eg not more than 100 transactions.How do I ... A: Boeti, Many thanks for the question. I am not sure if I have usnderstood completely but here goes. ... | |
| City/County Table | 2/24/2006 |
| Q: I would like to be able to enter the city name in one field and have the next field automatically ... A: Leon, Many thanks for the question. I am presuming you have a table, that lists all the cities, ... | |
| Access | 2/20/2006 |
| Q: Is there a way to make multiple dropdown lists on a form pull seperate records from the same table? ... A: Alma, Many thanks for the question. First of all my apologies in my delay in getting back to you, ... | |
| Access Queries | 2/18/2006 |
| Q: I have a table of Forenames with fields for Name and Gender. I also have a query using this table ... A: Alan, Many thanks for the question. My apologies for not replying to you sooner. Yes you can do ... | |
| Access 2003 Dynamic Recordset | 2/17/2006 |
| Q: I am trying to populate a subform with records from another table using the id on the mainform. A: Ian, Many thanks for the question. First of all my apologies for my slow response. You will need ... | |
| Uploading an image from MS Access | 2/14/2006 |
| Q: I am builing an application in MS Access for a friend of my. If he's in MS Access in a form I want ... A: Many thanks for the question. The first 3 are all possible, the last - uploading to a website I am ... | |
| ADO Recodset | 2/12/2006 |
| Q: ok i have a very lengthy question but i want to ask first if there is a tutorial about this using ... A: Rami, Many thanks for the question and my apologies for the delay in getting back to you, I have ... | |
| Action Queries from macros | 2/11/2006 |
| Q: I'm running Access 2002 and it tells me that I cannot call an action query from a macro without ... A: Cat, Many thanks for the question and my apologies for the delay, I have been away from my computer ... | |
| criteria for calculated fields | 2/10/2006 |
| Q: Julie, I am a new MS Access user. I have just put together an inventory database that keeps track ... A: Amanda, Many thanks for the question. I am not sure if I have understood your question correctly, ... | |
| How many entries can be put into one database? | 2/9/2006 |
| Q: I want to find out if it is possible to put 517,000 entries into an access database. Thank-You A: It should be no problem. A table can be upto 1gb in size, therefore it depends on the size of each ... | |
| linking access pages/widows to make full application | 2/6/2006 |
| Q: I am intending to create a databaseb in ms access, the question is how do organize my front-end, so ... A: Idrisa, Many thanks for the question. The easiest way to do this is to create an unbound form. ... | |
| Access queries | 2/4/2006 |
| Q: I want to use a select query for a report that uses records from two tables. The two tables are not ... A: Terry, Many thanks for the question. The problem with using unrelated tables, is that every record ... | |
| Opening Word documents in Access | 1/31/2006 |
| Q: I am using Windows 200 Pro & M.Office 2000 I have recently finished creating a database and I am ... A: Craig, The easiest way to add word documentation in Microsoft Access is to add a hyperlink to the ... | |
| Creating a table from anothe Table | 1/30/2006 |
| Q: I am using windows XP and office XP. I am working on a project to enter records in a table and then ... A: Ritchie, Many thanks for the question. The easiest way to do this would be to build an append ... | |
| Access 2000 | 1/27/2006 |
| Q: I want to create a delete query that removes all the records for a particular person with certain ... A: Adrienne, Many thanks for the question. This proved to be a bit of a challenge. You will need ... | |
| I have a database of seven... | 1/27/2006 |
| Q: I have a database of seven tables and the first table has a one-to-many relationship to the second ... A: Rich, Many thanks for the question. Try this: Build 7 append queries. The first append query ... | |
| Calculating data from subform | 1/27/2006 |
| Q: I'm in the healthcare industry (work at a hospital) and create databases for different departments. ... A: Karen, Is a report an option? Follow the report wizard adding the tables and fields you want ... | |
| Normalisation | 1/25/2006 |
| Q: At the moment I am studying normalisation. I know that I have to identify repeating groups to get to ... A: James, The question I ask myself are: Can one item have many relationships of another and you do ... | |
| ms access 2000 coding | 1/24/2006 |
| Q: I sincerely hope you can help me. I'm trying to retrieve the item values in tables, i.e. I'm trying ... A: Louw, Many thanks for the question. Try the following: Dim db As Object Dim rst As Object ... | |
| Access Split performance | 1/23/2006 |
| Q: I developed a database application in Access 2000 and placed it on a network shared drive. I was ... A: Jay, Many thanks for the questio I often run into the same issue. I find the following site very ... | |
| Table design | 1/19/2006 |
| Q: Hey Julie, I am building a database for a client and am having some trouble with the design of my ... A: Kevin, Many thanks for the question The #Physician and total number of employees relate to the the ... | |
| Access help | 1/18/2006 |
| Q: i am currently having problems on one part of my projects, the loan form. simply i have created a ... A: Many thanks for the question. You are correct - your calculation seems fine #Name ususally means ... | |
| Access 2000 Query criteria | 1/17/2006 |
| Q: First - thanks for sorting my Between Problem. Solution worked a treat. I now have the query ... A: Try the following: Like "*" & Forms!NameOfForm!NameOfCombo1 & "*" instead of the plain ... | |
| Access 2000 Query Criteria | 1/16/2006 |
| Q: I am trying to teach myself Access. I have made a Query which gets info. from a Form. This is ... A: Alan, Many thanks for the question. If I have understood your question correctly, I think what you ... | |
| Updating one field from nother | 1/15/2006 |
| Q: I hope I can explain this to you without complicating it too much! Basically, I have two database ... A: Craig, Many thanks for the question You are almost there Try the following (ie replace the + with ... | |
| Tab Control | 1/13/2006 |
| Q: I'm working on a screen design with the following criteria: Form Name: GUI Objects: cmdButton1 ... A: Steven, Many thanks for the question. To do what you ask, the syntax you are looking for is (this ... | |
| Forms/linking tables | 1/11/2006 |
| Q: Julie, How would I create a form using multiple tables using the wizard? Thanks, Natasha A: Natasha, To do this, follow the wizard, and when you get to the first window, choose the first ... | |
| Add multiple records | 1/10/2006 |
| Q: I am using microsoft access for the first time, to develop a call desk program. My problem is that i ... A: Many thanks for the question. Yes you can do this. First a couple of questions, to make sure I am ... | |
| FORMS - Data saving | 1/8/2006 |
| Q: I have several form on which results are calculated dependant upon the values of fields within a ... A: Peter, Many thanks for the question. First of all, I need to say that the value of calculated ... | |
| Multiple records update | 1/7/2006 |
| Q: I have a database with training records in it and they each have several categories within. ... A: Bruce, Many thanks for the question. To do what you ask, add a Yes/No field to the client record. ... | |
| Forms - New Record Entry Problem | 1/6/2006 |
| Q: Julie, Unfornately thats the problem, the option to enter a new record is greyed out. I have no ... A: Natasha, My apologies for not understanding the first time. The most likely reason is the tables ... | |
| Append | 1/2/2006 |
| Q: I have 4 files, 3 excel files and one .MDB i created. If I had an email address I can send these ... A: Tim, Many thanks for the question. I think what you are looking for is the TransferSpreadSheet ... | |
| Forms/Subforms | 1/1/2006 |
| Q: accept for one thing;I can't get it to turn red or bold even when using conditional formatting. ... A: Peter, What have you written in the conditional formatting. Can you do a page dump - (Print Screen ... | |
| Ms Access | 12/30/2005 |
| Q: I've been using Excel to make order form for my restaurant Home Delivery. Is there a way to store ... A: Royston, Many thanks for the question. Yes you can do what you ask. I am afraid the question ... | |
| Table to be incorporated into Access DB | 12/29/2005 |
| Q: I have Excel Table in which the columns indicate nozzle size, the rows are pipe size and the ... A: Pat, Many thanks for the question. I have had a bit of a think about this. Microsoft Access ... | |
| calender | 12/28/2005 |
| Q: How can I link an activecalender to my database for the date A: Ton, Send your email address to jmisson@iprimus.com.au I will send you an extract from VBA ... | |
| Update records | 12/27/2005 |
| Q: I have a table with a SSN field. Data is shown as a text with the following format:123456789. My ... A: Many thanks for the question. You will need to use the left, right and mid functions to achieve ... | |
| Forms/Subforms | 12/25/2005 |
| Q: I have a form with a subform attached. Subform is called Products Subform and the main form is ... A: Peter, Many thanks for the question. To turn it red or bold, use conditional formatting - found on ... | |
| Query Two Databases | 12/24/2005 |
| Q: Julie. After I sent my question, I thought of this, too. This is a good idea. However, I'm ... A: Joe, Many thanks for the question. My apologies for the delay, I decided to have a few days away ... | |
| Query Two Databases | 12/23/2005 |
| Q: I am (still) developing with VB 6.0 and MS Access 2000 on Win98-R2. Is it possible to ... A: Joe, Depending on the other database (if it is Microfosft Access or other compatible database), ... | |
| MS Access 2000 | 12/20/2005 |
| Q: I have an "Image" control on a form which shows a photo. I also have a "PictureField" text box that ... A: John, Many thanks for the question. The code I use, I cannot take credit for, but can be found on ... | |
| reports | 12/19/2005 |
| Q: I have been using Access for years but not so much in the past 2 years and forgot a basic reporting ... A: Joanne, Many thanks for thre question and my apologies for the delay. To do what you ask. Add an ... | |
| ms access and outlook | 12/16/2005 |
| Q: I have a field in a database on a form that holds the email address. I want to either double click ... A: Karl, Many thanks for the question. I have recently done this for one of my databases. I chose to ... | |
| Add today's date into table field with a command button | 12/15/2005 |
| Q: I'm busy with a database for our school. On my 'Absenteeism' form I need to insert today's date ... A: Stefan, Many thanks for the question. To do what you ask. Add a command button to your form, but ... | |
| ms access backup tools | 12/14/2005 |
| Q: we need to know if there's a tool for backup & restore database access,to put it into my application ... A: Paul, Many thanks for the question. There is no tool that I am aware of; but that does not mean ... | |
| Print multiple times | 12/12/2005 |
| Q: I have made a form in an Access Database. I created a button to print the results of the form. My ... A: Many thanks for the question. To do what you ask you will need to add a bit of code to the code ... | |
| MICROSOFT ACCESS HOW TO CREATE A QUERY | 12/10/2005 |
| Q: My database table have 17 fields. field 1-5 always have data. field 6-17 may have a numeric value or ... A: Farrah, Many thanks for the question. To do what you ask. Open the query in design view. In the ... | |
| question | 12/7/2005 |
| Q: i have two questions, 1. Can I publish a MS Access 2003 Database into internat. it contains forms . ... A: You cannot publish Microsoft Access directly to the Internet. i.e. you cannot use the forms. You ... | |
| Querying an Access database | 12/6/2005 |
| Q: I have a database which holds records of films. I would like it to open with a form that allows me ... A: Gary, My sincere apologies for the delay with this reply. Life has just been too hectic. You have ... | |
| designing forms | 12/4/2005 |
| Q: i help out at a local junior football club, we need to keep records of coaches, managers helpers etc ... A: The easiest way to do this is to make the border of each field white. You can do this by clicking ... | |
| table,field>other table,field | 11/30/2005 |
| Q: I have the following problem.I just began my first database project and am hopelessly lost. I have ... A: Christian, Many thanks for the question. What you need is a sub form instead of a combo box. The ... | |
| UPDATING AGE | 11/29/2005 |
| Q: I inputed a formula to calculate the age from a birth date, and it worked on initial input. ... A: Many thanks for the question. I am presuming you are using this in a form? I am also presuming ... | |
| Access 2000 | 11/28/2005 |
| Q: I'm a police officer in Indiana and I'm creating a database that we can link a person to several ... A: John, Many thanks for the question. This can be simple or difficult depending on the databases. ... | |
| Using access to send email | 11/23/2005 |
| Q: I have a group of church volunteers (about 400) and I need to send them emails. The group is ... A: Ed, Yes it can be done. There are a number of ways and you may need to do a bit of VBA coding to ... | |
| Autofill | 11/19/2004 |
| Q: I hope you can help me with the following problem; In my database I have a namefield(clients) and a ... A: Jasper, Are you doing this in a form? Or a Query? Try the following archived Newsletter, to see ... | |
| Saving a calculation in a db field | 11/17/2004 |
| Q: I have made a rather simple access database (I'm a beginner) but now I have a problem: I have made a ... A: Hans, Many thanks for the question. I hate to tell you this, but it is not accepted practice to ... | |
| Microsoft Access 2000 mailing labels | 11/10/2004 |
| Q: When I create mailing labels, the leading zeros of zipcodes disappear. For instance, 07202 becomes ... A: Syl, Many thanks for the question. The most likely problem is that you are storing the post code ... | |
| MS Access | 11/9/2004 |
| Q: I am developing a Dbase in Access that will calculate an employee TimeIn/TimeOut... They R ... A: Brian, I think I need to see the two database in order to help you. Is there any possibility of ... | |
| making an .exe file of a database | 11/6/2004 |
| Q: I have made a database for a friend and I would like to burn the data on a cd. Is it possible to ... A: Kim, You cannot turn an Microsoft Access file into an .exe file. The person you are sending the ... | |
| Students course database | 11/2/2004 |
| Q: I have build a database that will reflect each course the student has taken within a module. To be ... A: Beth, You need to create three tables. One with all the information about the students. One with ... | |
| Access | 11/1/2004 |
| Q: I'd like to merge the contents of two fields. One field is DeptCode and the content is a number eg. ... A: Barbara, Many thanks for the question. To do what you ask. Build a query by following the wizard, ... | |
| Filter report | 7/22/2004 |
| Q: I have made a report based on a query but this report comprises in 80 pages(contain 500 records, ... A: Rajesh, Many thanks for the question. I have covered this in my free newsletter. Please find an ... | |
| One Row | 7/19/2004 |
| Q: I created a report that shows data I want perfectly but the problem is that I can need data to ... A: Krystel, Many thanks for the question. The easiest way to do this, is the second option of moving ... | |
| Week Number questions | 7/17/2004 |
| Q: Julie, I wonder if you would mind helping me with these two problems I have regarding dates. 1)I ... A: Dave, Many thanks for your questions. 1) To do this in a: Table In the format section type ww ... | |
| Resizing the Application Window | 7/16/2004 |
| Q: I tried to repond to your answer but got a "maxed out" message. You're are on the right track. I ... A: Steve, Thanks for replying. I think the following website has the answer you are looking for. ... | |
| Auto change | 7/15/2004 |
| Q: Misson, I already built an access application that works perfectly but now I need to change field ... A: Donnie, Many thanks for the question. I have extracted the following from Microsoft Access Help ... | |
| Access application Setup | 7/14/2004 |
| Q: I develop a application using Ms Access. I want this application have setup option that I can easily ... A: Razzack, Many thanks for the question. I think what you are asking about is the Microsoft Access ... | |
| Access locking. | 7/13/2004 |
| Q: How can I lock all access application that nobody can't see my design view. ... A: Razzak, Many thanks for the question. Goto Tools, StartUp and choose not to show database window. ... | |
| design issue | 7/10/2004 |
| Q: I have these tabels Books : title, Book Author, Book Publishing Date Borowing: Borrower, Book title ... A: Krystal, If you do not use the ID field you will need another field that you can set the Index ... | |
| Resizing the Application Window | 7/9/2004 |
| Q: I have a small database that use two forms and a print macro. The forms are both small and will be ... A: Steve, My apologies for the delay. I am not sure if I have fully understood your question. I am ... | |
| access 2000: how to write query to use parameter from form | 7/8/2004 |
| Q: I would like to create the following, but have no idea how to do it. I have a crosstabs query that ... A: Sheree, Many thanks for the question. I have the answer to this as a part of one of my tutorials. ... | |
| DLookup | 7/5/2004 |
| Q: "If more than one field meets criteria, the DLookup function returns the first occurrence." Is there ... A: Krystel, The best way to do this is to use the dMax function as part of your filter. i.e. an ... | |
| Open a form and run a macro automatiacally | 7/2/2004 |
| Q: I have created a form with command buttons that runs marcos once you click, yet I want to be able ... A: Geaorge, Many thanks for the question. To do this you need to set your Macro to occur on the 'On ... | |
| Need 'parameterized and silent query' | 6/27/2004 |
| Q: expert: Sorry if this could be a long message, but in order to be clear I need so. I have a query ... A: Yuri, Many thanks for the question. You need to refer to the fields on your form. This form ... | |
| Access function | 6/24/2004 |
| Q: I have a question for you, please. Does MS Access have a function which will convert all upper case ... A: Andy, Many thanks for the Question. If you visit the following URL (My archived Newsletters) I ... | |
| Database Question | 6/23/2004 |
| Q: I have a database that is suppose to add hours to jos, subtract hours from jobs and transfer hours ... A: Lisa, It depends on how large it is. (You could winzip it, this would reduce the size) The other ... | |
| MS Access | 6/22/2004 |
| Q: Is it possible to change an already created Access database from single user to multiple user? the ... A: Mike, Many thanks for the question. I am presuming you did not create the database. I am guessing ... | |
| HTML within a field | 6/20/2004 |
| Q: I am trying to create an html script like the one below BUT I would like the seperate field in the ... A: Lance, I am not sure if I understand the question fully. Am I correct in presuming you wish to ... | |
| time in access 2000 | 6/19/2004 |
| Q: I want to make a som of a time feeld but i can't get the time above 23 hour i'm looking for a time ... A: Johnn, Many thanks for the question. Try one of these (Change the [TimeExample] fields to the ... | |
| multi-select list boxes | 6/18/2004 |
| Q: I want to create a form that has three list boxes, one for Event Type, another for Event, and lastly ... A: Ray, Many thanks for the question. I am sure I can help, but I just need to know what you wish the ... | |
| Message error | 6/16/2004 |
| Q: I keep getting this message and then the program shuts down. What can I do to stop it? "This ... A: Joan, Many thanks for the question. I am sorry, but I am not able to help on this occasion. I ... | |
| SQL | 6/14/2004 |
| Q: i hope u will help me out with this question also. i have 2 table which do not have primary keys. ... A: mrithya, Many thanks for the question. Try this: Create a query, but do not use the Wizard, ... | |
| filter with combobox | 6/11/2004 |
| Q: In my database I have a combobox(1) on a form. How can I make a button which opens a combobox(2) ... A: Dave, Many thanks for the question. I think the answer you are looking for is in one of my ... | |
| maximise report | 6/10/2004 |
| Q: how do i make that report of Maximised when it is opened? thank you A: Anthony, Many thanks for the question. To do what you ask: Open the report in design view Open ... | |
| Designing a Database | 6/9/2004 |
| Q: I'm completely new to Access, I'm learning some of the basic concepts to the software and now I'm ... A: Horalia, Many thanks for the question, I nearly put it in the 'Too long and involved' section as my ... | |
| Information Message | 6/7/2004 |
| Q: Some queries will not open when dbl clicked. For those that do open an information message appears: ... A: Julia, Many thanks for the question. At a guess I would say code is being called from the query ... | |
| how to update exchange/outlook 2000 using access 2000 mdb | 6/5/2004 |
| Q: I have an access 97 database that runs an autoexec macro that updates an address book on our ... A: Jeff, I am not positive I can help, but I am happy to have a look to see if I can detect the ... | |
| Ms Access Log In Using Query | 6/4/2004 |
| Q: i am trying to make a fantasy database.. where a user can make his/her own team. but before they ... A: Junaid, Many thanks for the question. By a query I am presuming you mean a table. To set up what ... | |
| wat r these codes? | 6/3/2004 |
| Q: i wanna know what r these code for? Function IsLoaded(ByVal strFormName As String) As Boolean ' ... A: Sudha, The following is a function, that checks whether a particular form is loaded (open). ... | |
| text box moving left using VBA | 6/2/2004 |
| Q: Misson how do i move a text box some steps to the right? i tried this: Me.txtUSONLY.Move 30 but i ... A: Many thanks for the question. I think the code you are looking for is the following: Me!Text0.Top ... | |
| Microsoft Access locking Database | 6/1/2004 |
| Q: I'm fairly new to using microsoft access and I've got a problem. I'm supporting a previously made ... A: John, Many thanks for the question. I am not sure if I have understood the question fully, but I ... | |
| Count function | 3/4/2004 |
| Q: I have a question about counting records in a report, with access 2000. I want get a total of each ... A: Sam, Many thanks for the question. The following is an extract from my free wweekly Newsletter. I ... | |
| Versioning with the help of database | 3/3/2004 |
| Q: Hai, Can u tell me whether versioning of records can be maintained within the database. That is if ... A: Keerthi, Many thanks for the question. Yes you can do this, but it will require coding and the use ... | |
| how can I link 4 tables? all... | 3/2/2004 |
| Q: how can I link 4 tables? all of them have the same headings. I will like to create a new table with ... A: Ingrid, Many thanks for the question. You will need to build a Union query to achieve this, in the ... | |
| Checking for a none blank field in a continuous form | 2/28/2004 |
| Q: I have been trying to confirm that a field has a persons initials in it before allowing a tick in ... A: Alan, Many thanks for the question I am presuming you are using an unbound check box, this always ... | |
| Database versioning | 2/27/2004 |
| Q: Hai, Can you help me in knowing about database versioning? I need to implement it in a project, to ... A: Many thanks for the question. I am not positively sure what you mean by versioning. I am taking a ... | |
| Secure Access | 2/25/2004 |
| Q: I have stored some important data in Access table. I set password to the database. But I have heard ... A: Mesa, Thanks for the question. You can use the security wizard in access. I have covered this ... | |
| Forms | 2/23/2004 |
| Q: Im having problems entering new records into forms. It keeps beeping at me when I click on the field ... A: Curt, First of all, my apologies for my lateness in replying to you. Is your form based on a query ... | |
| Refreshing a Form | 2/21/2004 |
| Q: I have a form that has one sub form. The form is based off a query and calls for a prompt to enter a ... A: Bob, Many thanks for the question. You will need to use the Requery function. Where you put this ... | |
| Formula for calculating School year | 2/17/2004 |
| Q: I need to create a formula for calculating the school year of a child off their age. School year 1 ... A: Robert, Many thanks for the question. My apologies for the delay. To do what you ask: I did try ... | |
| MS-Access Database Design | 2/15/2004 |
| Q: I am trying to create a simple assignment database for my company which is a professional services ... A: Jeff, Many thanks for the question. I apologise for the delay in answering. I think what you are ... | |
| Newbie.. Forms Help | 2/14/2004 |
| Q: While using MS Access Form, all I want is to preserve the old value of the text field whenever being ... A: Jason, Many thanks for the question. Do you just want to save this value when the form is open, or ... | |
| Table as a SubForm | 2/11/2004 |
| Q: Good morning, Julie. I had to mention that I had once taken a two-day Access class at CompUSA years ... A: Kenly, Well done with the database thus far. My apologies for the delay in getting back to you. ... | |
| exporting and importing data back to access | 2/10/2004 |
| Q: I have an access table containing budgets (income and expense accounts each with budgetted amounts) ... A: Kathy, My apologies in the delay. Just checking that the information being added are new records, ... | |
| selecting list of tables from database | 2/9/2004 |
| Q: i want to select the list of table names from a database in MS-Access i used the query "select name ... A: Ravindah, I am not exactly sure what you are wish to do with the tables, but the following sites ... | |
| Multiple Queries | 2/5/2004 |
| Q: I have a table of song titles and the corresponding structure relating to the title of the song. The ... A: Jonathon, Please find an extract from my Weekly tips Newsletter. It should point you in the right ... | |
Using MS Access
Answers by Expert:
Julie Misson
Top Expert on this page
Expertise
My area of expertise is Microsoft Access 2000-2007. I have been building microsoft databases for the past six years. I would be competent in answering questions from novice Access 2000 users to the more advanced including VBA. If I cannot help, I am more than likely be able to point you to websites that can.
Experience
I have a Microsoft Access business where I build database for small businesses. These are usually one off designs, where there is no off the shelf software avaliable to meet the business needs. I also teach Microsft Access to beginners. I am the owner of the www.simply-access.com website.
Education/Credentials
Self taught in Microsoft Access.
Have done some units in normalisation and SQL, but most of what I know I have learnt from books originally and more recently the Internet.
©2012 About.com, a part of The New York Times Company. All rights reserved.