| Subject | Date Asked |
|
| 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 ...
|
