| Subject | Date Asked |
|
| joint queries | 11/17/2008 |
Q: I would like to ask the question about jointing queries for instant: if i have 2 queries like this ...
A: Use the UCase and Format functions: SELECT UCase([Ingredient]), [Unit], Format([cost], ...
|
| joint queries | 11/17/2008 |
Q: I would like to ask the question about jointing queries for instant: if i have 2 queries like this ...
A: You need a union query. Here is an example of the SQL that you will need to past in a SQL view of ...
|
| Selecting a value in a subform | 11/14/2008 |
Q: I am currently working on an interface for my database. I have two forms - Soldier_Information and ...
A: Try adding the word Form: Forms!Soldier_Information!History_Subform![Form]![Reason] = ...
|
| Automatically Filling in Data in access | 11/14/2008 |
Q: In Microsoft Access, I have a PART NUMBER column and a COST column. I have a part number that is ...
A: Mark, Two ways to go: 1) Make a form. Place a button on the form. Place this code on the click event ...
|
| sorting two fields togther in the same database | 11/13/2008 |
Q: I am building a database for couples addresses and other data. I want to build a report that lists ...
A: Your report design area allows for sorting and setting the sort order of the fields. The icon on the ...
|
| question | 11/13/2008 |
Q: I add a pviot chart to a report and it works fine just when I change the color and run the report ...
A: The color should not change unless you have used some kind on Conditional Formating built into ...
|
| Type Mismatch Error | 11/12/2008 |
Q: Bob, First and for most thanks for taking my question! I can't figure out why I keep getting a "type ...
A: If you really want to delete the records matching your WHERE then replace ...
|
| peramiter query | 11/12/2008 |
Q: I have a form based off of a peramiter query and when there is no answer for that query the form ...
A: Erik, You can open a recordset on the form's recordsource first to check if any records. Code: Dim ...
|
| Query for specified number of records | 11/12/2008 |
Q: I am working in Access 2003. I constructed a select query that tells me how many times in the past ...
A: Gaye, Yes, in the query on the missed times column set the criteria to: >=5 or >4 both will work. ...
|
| Access 2007 | 11/10/2008 |
Q: Hey Bob, My name is anthony and I am trying to build an access database that is going to use combo ...
A: Anthony, You need to feed the city combo box from a query that is filtered based on the currently ...
|
| Count with date question | 11/6/2008 |
Q: How can I create a query that gives me a count of records by date? i.e. I have 5 records for ...
A: John, Group by on date and do a Count() on it in a Group by query. Bob Heifler MyAccessProgram.com ...
|
| MS Access 2003 | 11/6/2008 |
Q: Bob, I was hoping you could give me some insight on a query I need to make in Microsoft Access ...
A: Navid, Create two new columns that only contain the short date. Make the query a Group By and use ...
|
| Edit Record | 11/4/2008 |
Q: I am creating forms for data entry for folks very unfamiliar with access, so I want them to be ...
A: Jeff, The property sheet of the form has a property called "Cycle". Set this property to "Current ...
|
| Query | 11/4/2008 |
Q: I need to add the records in each column for a total. So for one of my columns, I have a bunch of ...
A: If you make your query a Group By and use the Sum function built into this type of query, it will ...
|
| clear form field | 11/1/2008 |
Q: I am having trouble withthe this code: 'Clear all the controls in the Form For Each ctl In ...
A: It is clearing data from fields in a record that is still going to be existing after the code runs. ...
|
| MS ACCESS MACROS | 10/31/2008 |
Q: I need to attach a macro to a command button to open a web site stored on the hard disk
A: Charles, Here is some simple code to do this: Place this code in the Click event of this control ...
|
| Trasfer text/Copydata | 10/28/2008 |
Q: I have two questions it would be greate if you could answer both. Question1 Is ther another way to ...
A: Mo, The solution is the same for both questions. Linked tables, local tables, linked to text files ...
|
| EMPTY QUERY MSG BOX | 10/26/2008 |
Q: I have a form linked to a query that searches for an account number. I would like to display a ...
A: Adrian, You could write a function that opens a record set on the query and if it finds records, it ...
|
| Creating a Table | 10/26/2008 |
Q: Here's a specific question then. For one of my fields, I used the Yes/No option. However, how do I ...
A: Sonam, You would know because on your form that is bound to the table, you might have created a ...
|
| Answering yes/no to question dictates a new form | 10/24/2008 |
Q: I have seen on another database that depending on how you answer an initial question (either yes or ...
A: Sue, Place the following code in the AfterUpdate Event of the yes/no field ("MyYesNoField"): if ...
|
| access reports | 10/23/2008 |
Q: I have a form with a data grid. the data grid is then populated with results according to the user ...
A: Ali, It requires a button with code behind it to request the parameters or criteria for selecting ...
|
| loosing decimalplaces when exporting to text file | 10/23/2008 |
Q: when I am exporting a number from a query to a text file, such as 0.06543 it exports into the text ...
A: Colin, Try converting to a string using Cstr([The numeric])before export. Bob Heifler ...
|
| Access Query Parameter | 10/21/2008 |
Q: I am trying to run a query for a table with employee training dates. I need the query to prompt me ...
A: Sherri, >Date()-31 is the criteria to use in the date field. To get a query to prompt you for a ...
|
| Record length within a record field | 10/20/2008 |
Q: I have a large database in which I need to do some name parsing, in one of the record fields I can ...
A: Chris, Use the Len() function to get character counts. Bob Heifler MyAccessProgram.com Find example ...
|
| Licence Renewal Form | 10/17/2008 |
Q: I was wondering if you could tell me, is there anyway I can create licence renewal form/page in an ...
A: Clayton, Icon can be replaced. The version of Access determines how. A lookup table that stores ...
|
| Drop down | 10/16/2008 |
Q: I am trying to autofill fields in a form based the choice of a drop down box.
A: MJ, On the AfterUpdate Event of the combobox just reference the different columns in the combobox, ...
|
| Freezing/Change control | 10/16/2008 |
Q: I want to prevent users entering/altering information into a form once it has been completed. Users ...
A: Austen, Yes, locking a control on a form will prevent the editing of the data contained within that ...
|
| Freezing/Change control | 10/15/2008 |
Q: I want to prevent users entering/altering information into a form once it has been completed. Users ...
A: Austen, There is a way to tell if a record that the user is on is a new record or an old one that is ...
|
| clearing bound combo boxes | 10/14/2008 |
Q: I have a for with 4 bound combo boxes and 2 unbound text boxes used for searching a record. I want ...
A: William, The code is this: [NameOfComboBox] = "" Bob Heifler MyAccessProgram.com Find example ...
|
| audit trail disaster | 10/3/2008 |
Q: . i realised yesterday after a day of endless debugging with no success that the allen browne ...
A: Zug, If you are in Access 2000 or later this line needs correcting: Dim rstMain As Recordset should ...
|
| QBE using dates | 10/2/2008 |
Q: I am new to Access and I see plenty of dates that are specific, but I want to create a QBE that ...
A: Robert, You can use Date()-7 a criteria for query column on a date field would have: >Date()-8 Bob ...
|
| Access | 9/29/2008 |
Q: I am a creating a Access program for my company here and one of the reports that I am supposed to ...
A: Saurav, You can use the IIF() function in derived columns in your query. Status One ...
|
| MS Access Data Table | 9/27/2008 |
Q: I have made a table listing movies to rent, including title, director, year, etc. After I have ...
A: Bill, I do not know how you would do that, but you could just create a status field and have a ...
|
| future date calculation | 9/26/2008 |
Q: I have a business form used for employee discipline. There is a field for entering a date of ...
A: Woody, Create a table of current year holiday dates to be skipped. Create a function that loops ...
|
| calculated field | 9/24/2008 |
Q: how to add a calculated field to the query that multiplies the other number field by 50?
A: Neesa, Place this at the top of a blank query column: Calculated_Result:50 * [Name of other number ...
|
| Access Queries | 9/24/2008 |
Q: I need to design a parameter query for a database using customer, product, and rental date tables ...
A: Joseph, If you use brackets in the criteria row of a query column it will pop up when the query is ...
|
| Default value | 9/22/2008 |
Q: i have a field "Sent Date", then i want to set default of my field "Expected Return Date" as 6 days ...
A: This is not a question that I can quickly answer in this email because it requires some steps that ...
|
| Access in network | 8/29/2008 |
Q: I've already developed a VB.net application with ms access as backend locally i.e. not in a network. ...
A: Parameshwaran, First get a hardware/network person to create your local area network. To allow ...
|
| Sorting data in Report by month | 8/29/2008 |
Q: I have been our electricity charges by month for last couple of years. And, when I run the report, ...
A: Saurav, You could use the Access built in function called Month() that accepts a date and returns ...
|
| Using query in access | 8/26/2008 |
Q: I face a difficulty in using query in access. In my case, for example, there are two queries A and ...
A: Howard, Use the NZ()function to convert the null or missing value to zero. NZ([Item#]) If [Item#] is ...
|
| Exlude Status from Report | 8/25/2008 |
Q: I need to exclude a status from showing up in my final report. The report should only show "open", ...
A: Carly, Exclude all but "Open" using this criteria in your status field of the report's query: "Open" ...
|
| Prompting a user for password upon trying to open a form | 8/25/2008 |
Q: I am trying to prompt the user to enter information upon click a form to open. I want to setup the ...
A: Delores, The InputBox() function displays a prompt in a dialog box, waits for the user to input ...
|
| scrolling through a form | 8/22/2008 |
Q: I have a really long form. It is probably three times the length of the my computer screen from top ...
A: Jed, A form has a property called "Cycle" change it from "All Records" to "Current Record" so you ...
|
| MS Access - IIF, AND | 8/22/2008 |
Q: is it possible to modify this formula =IIf([covtype]="PI" And ...
A: Ven, You could try " N/A " padding the right and left sides. Bob Heifler MyAccessProgram.com ...
|
| MS Access - IIF, AND | 8/22/2008 |
Q: is it possible to modify this formula =IIf([covtype]="PI" And ...
A: Ven, Use another nesting of IIF to check for a zero using NZ function. You might also test on NULL ...
|
| Adding zeros to a date m/d/yyyy to mm/dd/yyyy | 8/22/2008 |
Q: I have for formats of dates for my Access database mm/dd/yyyy which is fedd to the DB via and ASP ...
A: Adam, Use the Format() function in Access. Be sure to use two of the letter m and d to ensure the ...
|
| Backend security | 8/21/2008 |
Q: Bob, How can I use ADO/DAO in code instead of using linked tables to connect to the backend while ...
A: Jin, ADO has a connection string available. On line help gives you the arguments. For spelling, set ...
|
| Printing a form | 8/20/2008 |
Q: I have a form created to be a profile for a member in an organization. My problem is that I want to ...
A: Wayne, Create a query of the information and pass a criteria to it that limits it to the member ...
|
| Spatial query in access | 8/19/2008 |
Q: I am trying to develop a simple tool that will allow me to spatially query point data from a map ...
A: John, I know of no built in tools however there might be some 3rd party ActiveX, just Goggle it. I ...
|
| formatting issues | 8/19/2008 |
Q: I am having issues formatting a date in a text box in a report in access. (2007) For some reason ...
A: Katie, Make sure the table field is using Date/Time data type and that the formatting at both table ...
|
| expressions | 8/19/2008 |
Q: I have a table that lists people who have vistited my business and a start time in my table. The ...
A: Tammy, You can use the Format() function on the date/time field. You can create two derived columns: ...
|
| The Refresh Command Button | 8/16/2008 |
Q: I am at present, converting all my old programs to VBA, especially macros. However I have come up ...
A: Terence, You will still have to click or double click on the label and use the events to trigger ...
|
| running serial number | 8/15/2008 |
Q: i am in the middle of developing a barcode recording db. User will input product code, quantity and ...
A: Iota, Parse out the last four characters Right([SN_Field],4) then Convert to integer ...
|
| Multiple click events for textbox control in vba | 8/14/2008 |
Q: I am trying to create the following: Action Wanted: With each click cycle thru “X”, “V”, “” Form ...
A: Rachael, Use the Click OR OnClick event of txtTest using this code: Access 2002/2003 Version ...
|
| Setting a Temp Variable | 8/13/2008 |
Q: I have multiple querys that hit several SQL DBs. The only criteria I need is a from and to date. ...
A: Steve, Set two public variables then use a function to get their values. Declare the two public ...
|
| need a query in MS-Access | 8/12/2008 |
Q: i create a table called empnames. it's having name like: krishna subhash. form this i want to ...
A: Krishna, Use this: Left([FirstName],2) & Left([LastName],2) Bob Heifler MyAccessProgram.com Find ...
|
| help with making expression for company | 8/10/2008 |
Q: i have ms access 2007 and i have a form and i need to make a expression or code that does as ...
A: Dash, Private Function CalculateTheMoney(TheEndDate as date, TheStartDate as date)as currency Dim ...
|
| Creating a button to link to a report | 8/7/2008 |
Q: I am trying to create a button from a form that links to a report. How can I do this? Thank you,
A: Pooja, After you place the button on the form, find the event property called OnClick. Use the three ...
|
| Searching a record by the value in a field, then going to that record | 8/6/2008 |
Q: We are sorry, but Richard Rost wasn't able to answer yourI want to be able to change from the ...
A: Steve, VBA can open recordsets. Be sure to add reference to DAO library. Dim RS as dao.recordset ...
|
| assigning record information as a controls caption property | 8/2/2008 |
Q: i have a database in which there is a table having only two fields; Airline_Code and Airline_Name. i ...
A: Rajiv, Reference the 2nd column of combo using the column property. [NameOfLabel].caption = ...
|
| access question | 8/1/2008 |
Q: I think what my question will probably be fairly easy for you since you're the access professional. ...
A: Tonya, A quick easy way to have a popup user request for criteria data is to place a bracketed ...
|
| Auto Population | 7/31/2008 |
Q: Good Afternoon! Is it possible to have one field auto populate another field based on the data in ...
A: Jennifer, One way that I do this sort of thing is the following: 1) Make a query that contains in ...
|
| custom toolbar | 7/30/2008 |
Q: I'm working in Access 2007. I have a form that I want the user to be able to do a search on by using ...
A: Rachel, The microsoft site has tools to help you customize the ribbon, however you can add shortcuts ...
|
| Access | 7/28/2008 |
Q: Is it possible to show the "keyword" entered by the user? Something like: You searched by: "XYZ" ...
A: Rick, One way is to set up a public variable to store the selection criteria. A simple function can ...
|
| MS Access | 7/27/2008 |
Q: Is there a way to make check and tick boxes where you can only select one box for a field without ...
A: Use option group and use this on form or report: Assumming value 1 of option group is true and 2 is ...
|
| i am not sure if you recieved my previous email | 7/25/2008 |
Q: basically i have created a form which i thus used the "control sauce " to type in this formula =[sub ...
A: Laura, One way would be to add a VAT field and a "VAT Used" field (Yes/No)and on the form show the ...
|
| INSERTING IMAGES IN MS ACCESS FORM | 7/24/2008 |
Q: I have a form for inputing staff details.I have a botton which brings up the dialog box to select ...
A: Henry, Let's say your picture control is called Image85 and your textbox control that stores the ...
|
| Adding an edit record function to a form - follow up | 7/24/2008 |
Q: Many thanks for the code, it works a treat! What I'm hoping for is to only "grey" out certain fields ...
A: Glyn, Individual form controls can be disabled or enabled using the enabled property. ...
|
| i am going to repost my question again to you | 7/23/2008 |
Q: this was my originalmy name is Noor i am using a access in the company i work in. basically i am ...
A: Noor, You have not communicated the actual calculation formula, but here is a free video tutorial on ...
|
| Adding an edit record function to a form | 7/23/2008 |
Q: I'm currently running a database in Access, using a form to show the data. What I'm looking for is a ...
A: Glyn, This is going to be a long answer full of code but you can do it. First make a button control ...
|
| Access Tabs | 7/22/2008 |
Q: I have 5 tabs on a data input form, all reading from the same very large table. I want to separate ...
A: Tim, First copy your fields from big table to 5 new tables and create append queries to populate ...
|
| table data formating access 2007 | 7/21/2008 |
Q: I have data from a form being stored in a field in a table. The problem I have is that the data ...
A: Stan, VBA is needed. See the Round and the Fix functons. Bob Heifler MyAccessProgram.com Find ...
|
| Duplicate data check when transferring from Excel to Access | 7/11/2008 |
Q: I have an Excel spreadsheet that needs to be transferred to Access on a daily basis. There are four ...
A: Terry, This is a big question if you are a beginner, but rather than just reject it, I will get you ...
|
| Irs forms and access | 7/11/2008 |
Q: I am by no means an access guru, however for my job I have managed to make a relational database and ...
A: Joni, Once you have all your Access tables and data entry forms created, you will create an Access ...
|
| Time functionality in query | 7/10/2008 |
Q: I'm building an Access 2003 database to audit security access using card swipes. I need to calculate ...
A: Arnanda, Sure, just add cint(Format(ClockedInDateTime, "h"))> 23 to the criteria of the query that ...
|
| access | 7/10/2008 |
Q: how do I enter keywords to query the database and see the results?
A: Hluphi, You create a query and enter a keyword in the criteria of the column you want to filter on. ...
|
| validation or control based on prior field value | 7/9/2008 |
Q: I need to disallow entry into a particular field on a form based on the value of a prior field being ...
A: Terry, You will use the lock property of the field you want to disallow entry in. Place this code ...
|
| query | 7/8/2008 |
Q: I am trying to create a query that will grab data from between specific dates from closed and open ...
A: Marta, If you want both open and closed (yes/no) then do not add any criteria on this column in your ...
|
| Display user name | 7/8/2008 |
Q: Is there a way to add a button that by clicking on it will display the user name in a given field? ...
A: Wes, I have used the following code from this programmer: ---Posted by Dev Ashish--- ...
|
| multi choice combo box | 7/8/2008 |
Q: Iam designing a database in access 2007 for volunteers i want the combo box in the task page to be ...
A: Jodie, You can use this in a not shown column in a query for the criteria and the value. It's the ...
|
| Order by second-to-last character | 7/7/2008 |
Q: I'm working in Access 2000 and need help with the 'order by' in a form. I have an id code that is 5 ...
A: Patty, Mid([ID],6,1) will isolate that digit. Bob Heifler MyAccessProgram.com Find example files ...
|
| Access Help Required (Please) | 7/7/2008 |
Q: I have 3 fields in my database, Program ID, Order # and File name. File name is number upto 10 ...
A: Roopesh, This will give you the value for your new field: Left([FileNameField],5) Bob Heifler ...
|
| MS Access Form - Where is the data source? | 7/5/2008 |
Q: Good evening! I have been staring at an MS Access 2003 Form and for the life of me cannot ascertain ...
A: Andrew, I am not sure I am clear on all that you want. If you want one or two conditional logic ...
|
| MS Access Form - Where is the data source? | 7/4/2008 |
Q: Good evening! I have been staring at an MS Access 2003 Form and for the life of me cannot ascertain ...
A: Andrew, When you are viewing the form design, find the windows upper left corner square. Click on it ...
|
| access 2003 school database | 7/2/2008 |
Q: We use access 2003 to do health screenings for kids at schools. We acquire the students' ...
A: Sophia, I and others have used the Dlookup() function to check if a pre-existing field value, in ...
|
| Calculating fields stored in bound fields | 7/2/2008 |
Q: Bob! So glad you are here to help me. I brought in some data from Excel that was doing automatic ...
A: Cindy, You will want to trigger your calculation code from all bound form controls that are involved ...
|
| Form_Timing | 7/2/2008 |
Q: Bob, I am using MS Access 2003 (VBA) and am having trouble with the following code. I have a ...
A: Janet, Private Sub Changes_AfterUpdate() Select Case Changes Case 1 ' Assumming value 1 of the ...
|
| MS Access Help | 7/1/2008 |
Q: Hey bob, I am trying to create a section of my current database im working on where I input ...
A: First a few questions: How are you ensuring that the correct General Service ID is being entered in ...
|
| Changing data type with a macro/code | 6/30/2008 |
Q: I want to use a macro/code to change the data type of an imported xls from numeric to date. I saw ...
A: Heather, Using this code requires a code library that needs to be referenced by using the Tools menu ...
|
| Concatenation and unique id | 6/30/2008 |
Q: Bob, First off, I appreciate all the time you put into this sight. I am trying to make a field ...
A: Jasson, Re: "everything but the ID shows up" If the "ID" is the autonumber then it probably is not ...
|
| making a field required | 6/29/2008 |
Q: I have one form where ordering information is entered, but everything can't be entered at the time ...
A: Ray, The Now() function will data and time stamp for you. You can use it in the default property of ...
|
| how to search last number | 6/27/2008 |
Q: i create a table (EmpMaster) with an index of employee id number (empno) type: Integer example is: ...
A: Mart, I have tested this SQL for you. Just start a new query and use this. Be sure to replace with ...
|
| Access Macros | 6/26/2008 |
Q: Bob - How do I create a macro in access and assign it to a button so that when I click the button, ...
A: Aurora, Place this behind a button's OnClick event and be sure to fill in all the < > spaces: Dim ...
|
| Option group parameters for query | 6/26/2008 |
Q: I'm trying to pass a parameter to a query to select records where the field to test holds a Yes/No ...
A: Michael, Using sql statements that are executed will work. Stored queries are optimized and run ...
|
| Option group parameters for query | 6/26/2008 |
Q: I'm trying to pass a parameter to a query to select records where the field to test holds a Yes/No ...
A: Michael, You can place this code in the after update event of the option frame: Select case ...
|
| MsAccess | 6/25/2008 |
Q: how can store multiple rows in Ms Access form
A: Raj, A continuous form view will display multiple rows or records of an Access table. Entering data ...
|
| Concatenation and unique id | 6/24/2008 |
Q: Bob, First off, I appreciate all the time you put into this sight. I am trying to make a field ...
A: Jasson, Create a field "FullID" and "NumericID" Make the first a text and the second an autonumber. ...
|
| Access 2003 | 6/24/2008 |
Q: I had a client database that contained approx 500 records. About half of the records are duplicated ...
A: Gail, Yes, give each detail record a number that corresponds to a client in the client table. ...
|
| Programming Question | 6/22/2008 |
Q: I'm dealing with a rather common problem but since I have never had to program MS Access before it ...
A: Maggy, I can answer the first part here. First use the file menu "Get External Data" and link to ...
|
| Access Query | 6/21/2008 |
Q: I am trying to create a select query from an Access Database to generate a list of all equipments ...
A: Furgan, Make it a group by query and use Max()function to get the last date. Max([NameofDateField]) ...
|
| calculating age from table in ms access 2003 | 6/20/2008 |
Q: hye..I'm creating a web-based app using ASP VBScript in Dreamweaver MX 2004 and a databaase in MS ...
A: Liana, This calculation would need the birthdate as a date data type. The years plus decimal ...
|
| Access 2000 - Option Group | 6/19/2008 |
Q: I have only been using access for a couple of weeks so please forgive the question... I have created ...
A: Cath, There is nothing built in to do this but here is some code I just created that will work. I ...
|
| adding feilds in a form | 6/19/2008 |
Q: i am new to using access and i need to solve a problem. I have created a very basic data base for ...
A: Cassi, If you do not need to store this calculation you can just add a text box in the form and make ...
|
| query problems: currency, duplicate results... | 6/18/2008 |
Q: First I'd like to say THANK YOU SO MUCH for your "myaccessprogram.com tutorials, i would have never ...
A: Deborah, Make your invoice a report and sub-report(for detail lines) The main report just pulls the ...
|
| Exclusion | 6/17/2008 |
Q: I'm working with a database and want to creae a query that will exclude selections that meet ...
A: Michael, In the query designer screen, you can create columns that are based on the result of other ...
|
| Adding a drop down list to a report/query prompt | 6/16/2008 |
Q: I have several reports that when run, the user is prompted to end the Project Name. In the database ...
A: Lisa, I have an example file to send you. Send your email address via my contact page. Request ...
|
| Moving through a table's records in VBA | 6/16/2008 |
Q: I have the following stored SELECT query, which I intend on running as VBA code with the DoCMD ...
A: Travis, Open a recordset and loop through all the records with this code: Dim rs as Dao.recordset ...
|
| Autofill Fields | 6/14/2008 |
Q: I use a combo box to select an item number, this then auto fills several other fields on my forms, ...
A: Carl, First see if data is storing to table. If not, bind the form to the table and ensure the ...
|
| use record set and textbox data to send email | 6/13/2008 |
Q: I'm using a form command button to send an email with a specific subject. It's working fine. But now ...
A: Leslie, Re: The cc on mail. Try this: Dim olApp As Outlook.Application Dim olMail As MailItem ...
|
| Quick question about running a expression builder code | 6/13/2008 |
Q: I am running a database that requires for data to be entered in the same record of the same table ...
A: Matthew, How about an update query to set the "=Round(Timer()/3600,3)" and have it run after the ...
|
| select query to filter instead of Dlook up | 6/13/2008 |
Q: i'm basically trying to create a button in which restricts access to certain users. i've managed to ...
A: Just add additional data to your password user table and store the permission data for current user ...
|
| select query to filter instead of Dlook up | 6/13/2008 |
Q: i'm basically trying to create a button in which restricts access to certain users. i've managed to ...
A: Jonathan, Add two unbound textboxes LogInUserName and LogInPassword then place this code in an ...
|
| Saving data from unbound textboxes | 6/11/2008 |
Q: I have a form with a lot of unbound textboxes. I would like the data entered into the textboxes to ...
A: Justin, That is the purpose of bound textboxes or any bound control on a form. Just bind the form to ...
|
| Outlooks Contacts fields into Access database fields | 6/10/2008 |
Q: I use Access to input data and create documents used for legal case processing. Much of the data in ...
A: Keith, Use a query of your link to Outlook to populate your Combobox with all the fields you want. ...
|
| MS ACCESS info windows | 6/9/2008 |
Q: i am using update command to be update one tabl filed from another table field, and is working ...
A: Atanas, Use docmd.setwarning false After code runs, set to true Bob Heifler MyAccessProgram.com ...
|
| Auto-fill Problems | 6/9/2008 |
Q: I have a table that includes Consultant Employee information. I.e. Consultant ID, First Name, Last ...
A: Gregory, Use the after update event of the combo control and do this [First Name Control Name] = ...
|
| Foreign names entered in records are re-spelled by computer | 6/9/2008 |
Q: I made a database for members of an international community, but when i enter names such as "TEH", ...
A: Benny, Microsoft Access versions before 2007 allow stopping of automatic corrections that occur when ...
|
| Microsoft Access: How do I calculate the grand total sum using Auto-populated fields in a subform? | 6/8/2008 |
Q: Microsoft Access: How do I calculate the grand total sum using Auto-populated fields in a subform? ...
A: Shani, First make some new table fields and place them on the form. These are your additional bound ...
|
| Microsoft Access: How do I calculate the grand total sum using Auto-populated fields in a subform? | 6/8/2008 |
Q: Microsoft Access: How do I calculate the grand total sum using Auto-populated fields in a subform? ...
A: You do not want unbound controls in the subform records. If you make them bound controls, that store ...
|
| Tab oder and query | 6/6/2008 |
Q: I have 2 questions- I hope it is ok to ask 2 at the same time. If it is not, let me know. 1) Tab ...
A: Irina, 2nd Q. Take out the like and the & "*" and have the query just reference the form as in : ...
|
| Combo Boxes | 6/6/2008 |
Q: I'm writing a database for work using dependent combo boxes using the following code: Private Sub ...
A: Wendy, Have you tried a group by on the query that feeds the first combo? Bob Heifler ...
|
| ms access, login access privilege to buttons using VB | 6/5/2008 |
Q: i have created a database for a company using ms access 2007. I created a simple login where users ...
A: Ashadur, In a module write/paste these four lines: Public UserLoginID as variant Public Function ...
|
| ms access, login access privilege to buttons using VB | 6/5/2008 |
Q: i have created a database for a company using ms access 2007. I created a simple login where users ...
A: Ashadur, Store in a public variable the name or id of the person that passed your current login. ...
|
| building an Access form | 6/3/2008 |
Q: I would like to create a form that pulls from separate tables. Is there a way to do this? Right now, ...
A: Julie, Unless the two tables have a one to one relationship that allows you to create a query on ...
|
| Run time error 3021 ( No current Record) | 6/3/2008 |
Q: I was trying to diplay records which calls SerialNumber Sometimes it's working but when the record ...
A: Jay, Use this line of code after opening the recordset to see if any records. If rs.eof and rs.bof ...
|
| pasting excel data into a form field | 6/2/2008 |
Q: My customer service team uses a form (Access 2003) to, among other things, store and track sales ...
A: Leslie, First use the file menu, get external data feature. Here you want to link to the Excel file. ...
|
| Access database lock | 6/2/2008 |
Q: Bob I have develop a small scale Application in Access. But problem is there is security in my ...
A: Ahmed, Access prior to version 2007 allows for full security. You set it by going to tools on the ...
|
| ms access and last week | 5/30/2008 |
Q: would u please check out the following problem I have a current date. i am using it in the qurey ...
A: Lancer, If a query with your date field being called "DateField" you would use this in the field ...
|
| Addition in a form? | 5/30/2008 |
Q: Bob, I'm trying to add 3 text fields with their summation displayed in a fourth. Here's a more ...
A: Adam, Store the three fields to table (3 controls bound to a table). Assuming data is stored in a ...
|
| Using Comboboxes to link to reports | 5/29/2008 |
Q: Bob, I'm trying to create a series of reports from the information in three tables. Each table is ...
A: Adam, You create a query that uses all the data tables you need. You join the tables on (Relational ...
|
| connect access table with external pdf files | 5/28/2008 |
Q: i have a folder in my desktop which has 50 pdf files. i want to search in an access form (by ...
A: Nick, There is a table field data type called hyperlink. If you create a hyperlink field, place it ...
|
| extracting data drom Access 2007 tables | 5/27/2008 |
Q: I have a very simple Access 2007 database -- there is just one table in it. This table has about a ...
A: John, Create a group by query. Group on "Insurance Company" and sum on "Amount Appealed". Set your ...
|
| Storing images in MS-Access database | 5/27/2008 |
Q: there is a VB application through which images are stored in access database. If that image's ...
A: Zephyr, Access has an image frame control. Let the wizzard get you to choose one image to populate ...
|
| New issue, login script problems | 5/26/2008 |
Q: Sorry to bother you again. I have a new issue. Here is what I am working with/on: I have a table ...
A: James, The dlookup function allows you to enter a where clause after the domain.Just look at the on ...
|
| Can't Update Field | 5/24/2008 |
Q: I have an Access database to track when I send proofs to clients. I have two tables - tblCustomers ...
A: You will have to write an update query to the single tblProofs to update that field. You could ...
|
| If statement | 5/23/2008 |
Q: I am working on a database in which I'd like to convert the negative numbers I receive from the ...
A: Sergio, Use this in an empty column of your query. ...
|
| Update Message Box | 5/23/2008 |
Q: I'm using the DoCmd.RunSQL method to update and insert a few records. When the method is executed, ...
A: Heather, Add docmd.setwarnings False before the DoCmd.RunSQL and add docmd.setwarnings true after ...
|
| ms-access | 5/23/2008 |
Q: how to convert ms-access file to exe file
A: Venna, There is no way to convert an Access program to a .exe file by using Microsoft Access. ...
|
| MS Access Database? | 5/22/2008 |
Q: I created a Database using MS Access, Table 1 named PurchaseRequest contains 80 Records with 30 ...
A: Sher, Access Version 2000 or greater has a 2 gigabyte limit per table or per file, which ever comes ...
|
| Access report generation | 5/21/2008 |
Q: I have built a fairly simple database and have within it a couple of simple forms what I would like ...
A: Brendan, It's possible to write code that looks at what is in a text field and conditionally execute ...
|
| Autonumer using Dmax | 5/21/2008 |
Q: Hei I have a small problem and I cant't find the solution - I have a form in whitch I have placed a ...
A: Lars, Add this code to first check if the form already has an id by only running the code if the ...
|
| Prompting for field name | 5/21/2008 |
Q: first. thank you for offering free help. second.. to get straight to the point! Ive been asked to ...
A: Adam, Create a form where the field name, desired column heading name, and the table is requested by ...
|
| Forms - Calculations | 5/20/2008 |
Q: I have created a form thats using a table I need to add 3 fields together which i use this in ...
A: Alan, You first need a field in both the table and the form to accept the result of the calculation, ...
|
| Greater than function in MSAcess | 5/19/2008 |
Q: I have steup a select query in which I have a criteris to find out the no. of days between two ...
A: Neil, Add a new column to the query and use this to derive a true if date difference is greater than ...
|
| Report Color Change | 5/19/2008 |
Q: Basically I have the following: Table Query Form Report On the form I want to have three buttons ...
A: James, There is an event in your report design called On Format. You would place your code here. So ...
|
| Calculating Percentages of a Count Query? | 5/19/2008 |
Q: Please help! I am trying to write a query that will be on a report showing the percentage of repeat ...
A: Lucia, Try using the first query in a second query that divides the results of each field by total ...
|
| access | 5/15/2008 |
Q: on a form, I would like to have a user to fill in two text boxes first. If the user fill in either ...
A: Laura, Place this code on the after update event of both text boxes. if not ...
|
| automatically bring up a form for users. | 5/14/2008 |
Q: Good day Bob, I have two questions for you. I am in need of help with MS Access 2003 (VBA) running ...
A: Janet, Access, all versions, let you set the start up form you want to open when the Access file is ...
|
| Passing and Retrieving Data from Combo Boxes to Forms | 5/14/2008 |
Q: I have a problem with my combo boxes and forms. I have a database that I would like the user to be ...
A: Stuart, First create a query, call it MySearchQuery that will populate the new form or the existing ...
|
| Table is not showing form Expression results | 5/13/2008 |
Q: form design I have a Field The box contain calculations. I am calculating check box values. The ...
A: John, If you have a storage field for the result, call in [mystoragefield], you can write code on ...
|
| security | 5/13/2008 |
Q: On an .mde database, how can I stop users viewing and changing the dign of tables, queries, forms ...
A: Rob, Access versions lower than 2007 have security, see on line help, that you can use. Version ...
|
| Windows User Name in Access 2007 | 5/9/2008 |
Q: I am not sure what else I can say.. I was trying to get a field in a form to automatically fill with ...
A: David, fGetUserName() can be placed in code, or source of unbound textbox. or fGetUserName()placed ...
|
| Windows User Name in Access 2007 | 5/9/2008 |
Q: I am not sure what else I can say.. I was trying to get a field in a form to automatically fill with ...
A: David, This is the code I use with no problems on a wide area network. If a user can not access ...
|
| Updating Reports without Creating New Ones | 5/9/2008 |
Q: I'm building a database for someone with limited Access experience. I would like to build all the ...
A: Elizabeth, If the report is based on the table that was just updated by a form bound to that table, ...
|
| Multi criteria query | 5/8/2008 |
Q: I am desperately needing help with this query. Basically, I have 4 criteria that I want the query to ...
A: Irina, The like ... * sql looks fine. It's the and and or problem that you need to address by ...
|
| today's date updates in table access 2000 | 5/8/2008 |
Q: I am creating a database for my work, and I need to have a constant 'today's date' in one of my ...
A: Scott, Use the Date()function and place it in the table for form and the default, see default ...
|
| compare & replace | 5/8/2008 |
Q: "Hi Bob, I would like to ask a question related to compare and replace action. I would need to ...
A: Silvie, You could use the Dlookup() function in an update query. This would lookup the desired ...
|
| Storage limitation of Access Database | 5/7/2008 |
Q: I have one question about the storage limitation of Access Database. I know the database file cannot ...
A: David, The limitation is for a single file (all tables) or a single table. I do not recommend ...
|
| log in | 5/7/2008 |
Q: i have an Access Database that i have created and i'd like to design a form that will only give ...
A: Festo, Create a user name and password table. Make a login form asking for these two and a button. ...
|
| More than one parent form for one subform | 5/6/2008 |
Q: I am facing a problem in identifying the parent form for a subform as I have one subform with 2 ...
A: Aparna, You can use this code to see if a form is closed: If SysCmd(acSysCmdGetObjectState, acForm, ...
|
| Report Help | 5/5/2008 |
Q: Hope this won't be to confusing. I use MS Access 2007, I’m working on a report in which I need to ...
A: Suzanne, Instead of doing it manually, you could learn how to create a function that created a ...
|
| Ms-Access Rounding Up to the next $5 mark | 5/2/2008 |
Q: I would like to Round UP a field in my table which contains values with and without decimals so e.g. ...
A: Karim, Access has a round function. The 1 tells the function to round to 1 decimal place. ...
|
| MS Access Button | 5/1/2008 |
Q: I am using Access 2003. I have created a button with the intent of it opening a form built from a ...
A: Stacy, Create the button to open the subform using the wizzard where there is an option to open form ...
|
| parameter value | 5/1/2008 |
Q: I am trying to insert the criterion ">6" in a field defined by: formula 2: DateDiff("m",[seizure ...
A: Moataz, Replace: formula 2: DateDiff("m",[seizure date],[formula]) With this: formula 2: ...
|
| Time intervals | 4/29/2008 |
Q: I'm trying to setup an access databae to function as an appointment tracking system however i seem ...
A: Carliste, Use a combobox with list values of the times you want and set limit to list to true. You ...
|
| Table Design/Normalization | 4/28/2008 |
Q: I'm trying to figure out how to design and normalize tables for a 2007 MS Access database that will ...
A: Lou, First create your three tables of crime, sub, subsub Add Date of crime,Officer (name, rank, and ...
|
| MS Access 2007 | 4/27/2008 |
Q: I am trying to write a VBA module that contains Message Box. I have done it many times before in ...
A: Nick, Try msgbox "test" No parenthesis. Bob Heifler MyAccessProgram.com Find example files at: ...
|
| MS Access | 4/25/2008 |
Q: i am working on a module where i am using multiple combo boxes which lookup different fields of the ...
A: Idris, Using the after update event on the first combobox you will have to reset the record source ...
|
| Count number of updates on a record | 4/22/2008 |
Q: I am building this basic database for a bank which will keep track of loan applications. The ...
A: Imran, This depends on how you are undating the re-received field. That is the point in time when ...
|
| MS-Access | 4/20/2008 |
Q: Just wanted to know your opinion I'm planning to develop a multi user application which is used by ...
A: Sachin, Create a user table and an login form. The table could store user preferences metadata and ...
|
| Counting Y/N in a Report | 4/17/2008 |
Q: I need help on how to write an argument to count the number of y's and n's in the Footer section of ...
A: Beverly, In the detail section of the report, create an unbound textbox called "Y_Count" If the ...
|
| expression to only show first 2 numbers | 4/11/2008 |
Q: I need to show only the first two numbers in a 6 number field. Can it be done?
A: Jean, Use a text box control on your form: If the table field name was [MyField] then the code would ...
|
| Access 2000 field list | 4/11/2008 |
Q: I received a database from a client who asked me to add some fields to a table. No problem there. ...
A: Dale, Look at your new form's property called RecordSource ant select the table or query that the ...
|
| Text box in a form | 4/11/2008 |
Q: Can I use a data from text box in a form from last record as default data in text box in a form ...
A: Robert, Yes, one way would be to use the Access Dlookup function. Access help will show you how to ...
|
| Creating a Unique Value Check across Multiple Fields | 4/9/2008 |
Q: I have a table which i want microsoft access to check that there is no duplicating data across 3 ...
A: Alan, Go to the table's design view, select the 3 fields, then use the yellow key icon button at the ...
|
| link msword files with access prog | 4/3/2008 |
Q: i created program for followup of orders, all the details available on the program, but i want to ...
A: Make a hyperlink field and use a follow method to have the user follow the address of it. Bob ...
|
| Calculated field | 4/1/2008 |
Q: How can the result of a form field's data source expression be captured in the database attribute? ...
A: Vinson, If you are calculating something that you want stored in the [Age] field you would simply ...
|
| Calculated field | 4/1/2008 |
Q: How can the result of a form field's data source expression be captured in the database attribute?
A: Vinson, Please define "database attribute" for me. Bob Heifler MyAccessProgram.com Find example ...
|
| Saving and editing data in table | 4/1/2008 |
Q: I have a table with such fields: Book, Book_author, Book_year. And now I am interested in making ...
A: Dennis, You should not have to press a save button if each field control on your form is bound to a ...
|
| ms access | 3/31/2008 |
Q: what are the business applications of MS ACCESS?
A: Nash, They are limited only to non-internet use of less than 10-15 concurrent users. I personally ...
|
| Saving and editing data in table | 3/31/2008 |
Q: I have a table with such fields: Book, Book_author, Book_year. And now I am interested in making ...
A: Denis, Create a query on the table then use the form wizzard to make the form. Drag a command button ...
|
| copy textbox value to 2 fields in table on being primary key | 3/29/2008 |
Q: This is what i am trying to do: I am trying to copy the value in a textbox, possibly the first 10 ...
A: Chris, Here is the concantenation string: [PrimaryKeyName] = "0" & Left([FieldName],10) Bob ...
|
| criteria from form to query | 3/28/2008 |
Q: I have a query and want to establish criteria based on a combo box from a form. When I leave the ...
A: Chris, Use this in the criteria of the query: Like Pick List]![Combo17] & "*" I suggest a better ...
|
| new field | 3/27/2008 |
Q: I want to create a new field for customer numbers. I do not want to use autonumbering as I want to ...
A: Margaret, If there is more than one user adding a new record within the same minute, it gets more ...
|
| Access renewal report | 3/27/2008 |
Q: I have an access 07 database with the Asset template of which I have all our offices IT assets ...
A: Adam, Use this criteria in the RENEWAL DATE field in the query: <= ([RENEWAL DATE] - 30) to see all ...
|
| Inserting blank in number field in table | 3/27/2008 |
Q: I have a user who needs to insert blanks (can't do nulls) in a number field if the source is blank. ...
A: Dick, The numeric data type of size integer or long integer will accept a null value via an append ...
|
| MS Acess | 3/25/2008 |
Q: i have designed a query i need to pull result of this query from 1/03/2008 till today
A: Place >= #1/03/2008# in the criteria of the date field. Bob Heifler MyAccessProgram.com Find ...
|
| Parts Lookup using two criteria | 3/22/2008 |
Q: In order to look up a PartID and Price for a Part, I would like to use two unbound Combo Boxes to ...
A: Brian, Use the afterupdate event on the 1st combo box to reset the recordsource of the 2nd. My ...
|
| Auto resize line in report | 3/20/2008 |
Q: I have put two textboxes in detail section of report. One contains category and another contains ...
A: Sandip, Take out the box and place the line above not below so the memo can grow without hitting ...
|
| Checking names in tables | 3/18/2008 |
Q: On the access database i am trying to do the following, I need to check if the data being appended ...
A: Yu, Create a select query and on the Column 1 field set the criteria to: (NOT "budget") AND (NOT ...
|
| Access 2007 - Comma delimited field | 3/16/2008 |
Q: Is there a simple way to split a comma delimated field into seperate fields? For example, all of ...
A: Anita, Write a function to parse out your values using such Access functions as instr() and mid() ...
|
| query to show date greater than first then show less than | 3/16/2008 |
Q: I have a query where it pulls everything that is greater than current date but after those are ...
A: Jeff, That would be a separate new query with the less than sign < Date() instead of the > sign. ...
|
| unique number using combination fields | 3/16/2008 |
Q: I need to create tracking numbers for projects, by combining information from multiple (3) user ...
A: Martin, In the form's code module write a subroutine : Sub TrackingNo() [TrackingNoField]= ...
|
| Storing calculated values? | 3/15/2008 |
Q: It is my understanding that it is not good practice to store calculated values in a database. I have ...
A: John, You make a good point. Follow your correct evaluation on this and reject data that does not ...
|
| Query Help | 3/14/2008 |
Q: First some background, I have two tables called 2007 Grid and 2008 Grid, in these tables I have a ...
A: Suzanne, You would use append queries with the criteria you specified. I have free video tutorial on ...
|
| How to count Y and N in a report | 3/14/2008 |
Q: In an Access report, I am trying to count the number of projects that are covered with bond monies ...
A: Beverly, Make a derived column is a query, just insert a new column. Place this type of code at the ...
|
| Invalid Service Code | 3/14/2008 |
Q: I have a Microsoft Access table named "Good Service Codes" that has two columns. One is called ...
A: Looking for a null value in the outer joined table, the table with the join arrow pointing to it, ...
|
| Access 2007 | 3/14/2008 |
Q: I have built an access 2007 database for my company regarding fuel purchases for each vehicle in the ...
A: Derek, I suggest a field that contains last recorded mileage. When a new value is entered in ...
|
| Invalid Service Code | 3/13/2008 |
Q: I have a Microsoft Access table named "Good Service Codes" that has two columns. One is called ...
A: Douglas, If your left outer join is including all records from Excel source and only ones that match ...
|
| generating invoices in access | 3/13/2008 |
Q: i have a clients table for the different companies, an epmloyeees table which has employee details ...
A: Link your customer, invoice header, and invoice detail tables in a query that feeds a report grouped ...
|
| Non-Matching value in SAM Testing | 3/11/2008 |
Q: I am doing SAM testing, SAM will not let me use Unmatched query wizard. I don't know what it wants? ...
A: Robert, You can exclude "Smith" by placing this in the criteria row of the field that contains ...
|
| other transaction aside from orders | 3/7/2008 |
Q: i sure you're very much familiar with the northwind database of ms access. i have the same database ...
A: Joan, Yes you will need a separate table for each area that requires many entities that will relate ...
|
| Query Date | 3/6/2008 |
Q: I would like to view employees in a report grouped by month. I am somehow failing to do this in the ...
A: Pride, Use the Month() function: Month[DateField] Use a report grouping based on this derived query ...
|
| linking a form to a Word document | 3/6/2008 |
Q: I am a relative beginner in database use and design. I am currently attempting to build a fairly ...
A: Jennifer, Word's mail merge has linking ability to a saved query in Access. Just set the criteria of ...
|
| Access Sorting Query | 3/6/2008 |
Q: Sample Table: Name Fruits Purchase_Date Benson Orange 01/02/2008 Benson Apple 03/03/2008 ...
A: Keith, If you use three separate fields in you table that store person, fruit, and date separately, ...
|
| Linking nested levels of data | 3/6/2008 |
Q: I hope you can help me. I've created a db for hardware tracking. I have one main table called ...
A: Donna, You need a , a join table which stores many to many relationships. This table stores the ...
|
| This record has been changed by another user since you started editing it. | 3/5/2008 |
Q: The problem that I have is that I created a form in MS ACCESS which has a liked table in MYSQL and ...
A: Elaine, You get this message when someone else has started an edit or has locked temporarily the ...
|
| Calculating sales tax | 3/5/2008 |
Q: I am from the UK and have created a database that works fine except for one thing. Our VAT rate (or ...
A: I handled that with string manipulation techniques using the following functions. cstr() ...
|
| Calculating sales tax | 3/5/2008 |
Q: I am from the UK and have created a database that works fine except for one thing. Our VAT rate (or ...
A: David, If you want to round two 2 decimal places, 2 digits to the right of the decimal point, you ...
|
| ms access | 3/3/2008 |
Q: what are the ms acccess features
A: Varma, For Access 2000-2003 here are the features: http://support.microsoft.com/kb/823089 For the ...
|
| Auto fill from a combo box | 3/1/2008 |
Q: I have populated a combo box on a page, with an ID number, Last name and First name. When you click ...
A: Mike, The visibility of the first column is controlled by the column widths property. To get a ...
|
| Date and time functions | 2/29/2008 |
Q: I have created a simple database for tracking trouble tickets in our office. I need to keep track ...
A: How is the elapse time computed now? Is it in a report query or is it updated with an update query? ...
|
| Date and time functions | 2/29/2008 |
Q: I have created a simple database for tracking trouble tickets in our office. I need to keep track ...
A: Steven, If you were to store the Start and also the End DateTime, then Running a DateDiff() function ...
|
| Checkbox Problem | 2/27/2008 |
Q: I've got a form in an ADP file that has a SQL table as it's record source. I open the form with a ...
A: Rebecca, A yes/no boolean field in Access uses -1 as the stored value for true and 0 for false. In ...
|
| Making an event for a specific text imput | 2/27/2008 |
Q: If you can help that would be great. I am looking to know if you can set an event up for a specific ...
A: Glen, Set your combo box "MyComboBox" limit to list property to true. There is an event called ...
|
| MS Access 2003 | 2/27/2008 |
Q: I am working to create a database that tracks our mortgage clients loans My goal is to create a ...
A: Miller, Place this code in the after update event of [ComboboxOne]: [ComboboxTwo].Requery Base the ...
|
| Last entry made to form | 2/26/2008 |
Q: Just wondering if it is possible to add a field to a form that records the record ID and the date in ...
A: Carla, The table that your form is bound to should have a unique record ID field, I use autonumber ...
|
| Forms | 2/26/2008 |
Q: i have designed a database to store employee details and the company assets e.g. laptops associated ...
A: Collen, First make sure your search controls are in the header section of the form. Leave the Record ...
|
| How do you set up a database for a questionnaire? | 2/25/2008 |
Q: I'm building a database for my questionnaire. I really don't know what to do. I want to make a form ...
A: Rizky, Create a table with three fields, Question Number ( Number data type of Integer or Byte size, ...
|
| ComboBox- selecting records | 2/24/2008 |
Q: I have a ComboBox that lists all active jobs- approx 200 records at any given time. The dropdown ...
A: Pass the first column's value to your query. This working example file will help. ...
|
| replacing autonumber | 2/24/2008 |
Q: i have been reading through a variety of tutorials for replacing access's autonumber, but none of ...
A: David, The Dmax() function can lookup the last, biggest number for you. The only problem you could ...
|
| Importing text | 2/23/2008 |
Q: Imagine one single text file that contains two different fixed-width databases such as the ...
A: Dirk, Good question! Create a link to the text file and don't worry about field/column names. ...
|
| a number of questions.... | 2/22/2008 |
Q: I am currently building a database for the company I work for. I have a computer programming ...
A: Since you are doing multiple criteria at once, I suggest you build SQL statements from what has been ...
|
| Updating data via query | 2/22/2008 |
Q: MS Access 2003, SP3 here I've got a table, imported from a txt file. It has header records, 1 to ...
A: You can create Alias field names for any columns in the select query that is using the linked text ...
|
| Updating data via query | 2/22/2008 |
Q: MS Access 2003, SP3 here I've got a table, imported from a txt file. It has header records, 1 to ...
A: Todd, Try linking to the text file. You can call the link the by the same name each time, even if ...
|
| Filtering selections on a form | 2/21/2008 |
Q: I am trying to create a seminar registration form with the following features. I would like a ...
A: Brodie, In the criteria of the query that feeds the second combo box you can point to the firstcombo ...
|
| GETTING THE MAX VALUE BETWEEN COLUMNS | 2/20/2008 |
Q: I'm new in using access. How do i get the max value from different columns in the same table as a ...
A: Noah, Create a derived column in a query: All_Values:Value1 + Value2 + Value3 ... Then make it a ...
|
| Appending Records | 2/20/2008 |
Q: I am trying to use an append query to append individual records from one form/table to another. I ...
A: Let's say the form has a field that identifies a unique record in the table that is the form's ...
|
| creating a drop down list in a query | 2/19/2008 |
Q: I am trying to create a monthly report, which can be broken down into regions areas by allowing the ...
A: Replace your criteria with a function you create to retrieve a Region value that you have set ...
|
| Multiple criteria in DLookup() | 2/19/2008 |
Q: I have a query called “Finishes” which stores the finishes for each room. E.g. Each room has a ...
A: Here is a much better approach. Use dropdown lists (Combo boxes) on your data entry form that is ...
|
| ms access - appending tables | 2/18/2008 |
Q: need to create one master table of 11 individual timesheets. the excel files are identical as far ...
A: You will need to link to the Excel files and using the link append the data to your Access table ...
|
| Access Query utilizing another table | 2/18/2008 |
Q: Using Access 03. I have two tables in my database. The first contains records on individuals (name, ...
A: Place both tables in a query. Join on last name and make it an outer join to table with just last ...
|
| dlookup | 2/16/2008 |
Q: This is an amazing forum and helped me so much with excel, now I'm trying to tackle access Please ...
A: It looks right but you could test it in an unbound text box first. You might want to even send ...
|
| microsoft access assignment | 2/16/2008 |
Q: i have 3 tables , one is customer, and the other two are order and product.how do i design an ...
A: Dee, Write a query that joins the three tables and supplies all that you want on the invoice report. ...
|
| Some help with MS access | 2/15/2008 |
Q: Is it possible in microsoft access to create several new records at once within a sub form based on ...
A: The answer to both questions is yes. They both require some coding. Bob Heifler MyAccessProgram.com ...
|
| Bring up reports in preview mode | 2/15/2008 |
Q: I would like to creat a button to bring the user back to the previous screen. Not sure what the On ...
A: Place this as the last line of code on your close or back button. DoCmd.Close acForm, "NameOfForm" ...
|
| Bring up reports in preview mode | 2/15/2008 |
Q: I would like to creat a button to bring the user back to the previous screen. Not sure what the On ...
A: Use: DoCmd.OpenReport "ReportName", acViewPreview Bob Heifler MyAccessProgram.com Find example ...
|
| Command button to return user to previous screen | 2/15/2008 |
Q: I would like to creat a button to bring the user back to the previous screen. Not sure what the On ...
A: If the previous screen is a form and you know it's name use: Docmd.openform "NameOfForm" If it could ...
|
| Combo box Null value - plus linked text boxes | 2/14/2008 |
Q: The issue I am having is two fold. I will try to break it into its component parts. Table 1 ...
A: Suleman, The error: "I get the error stating i cannot have a Null Value." is caused because you have ...
|
| MS Access | 2/14/2008 |
Q: I have a table of projects and one field is the customer name. I want to use a lookup table to ...
A: Ruediger, To order the displayed company names alphabetically in the combo box use a sorted query as ...
|
| acsess | 2/14/2008 |
Q: Basically I got a database and when i click on the products button the valuse is then added to a ...
A: Nin, Place a function on the after update event of the controls that would contain possible ...
|
| query | 2/14/2008 |
Q: I want to select a query which may return quite a few records. If I want to see only the last 5 ...
A: Copy the query and convert copy to a Group By query See greek sum symbol on tool bar. Use the Avg ...
|
| Combining Text Fields in Access | 2/13/2008 |
Q: Heifler, I have a table set up with 4 text fields of description for an item (sizes of the fields ...
A: Create an append query to populate your final table. Concatenate the 4 fields like this ...
|
| Input Form | 2/13/2008 |
Q: I have a database with two tables Customer info and Orders joined by a customerID key. What I'm ...
A: Invictus, So what you want to do is: Automatically fill in form information when an id to another ...
|
| Office Access Report | 2/13/2008 |
Q: I have created a table and form to record data for a simple survey. I have created options for each ...
A: Make a Female derived column FemaleCount:IIF(Gender = 2,1,0) Make a Male derived column ...
|
| MS Access query problem | 2/13/2008 |
Q: i need some help on how to use "if" statements in MS Access using queries. i am making a database on ...
A: Rafaya, Iif(date()>[contract renewal date]-31,"YES","Your message if not true") Bob Heifler ...
|
| Appending Records | 2/13/2008 |
Q: I am trying to use an append query to append individual records from one form/table to another. I ...
A: Elizabeth, Assuming you are executing docmd.openquery "Name of Query" on a button onClick event, ...
|
| Expressions in forms not showing on table | 2/12/2008 |
Q: I know that the question has been asked about why expressions made in forms dont show in the tables. ...
A: Glen, You need a bound control that will store the calculated value, for example total price. This ...
|
| Wizard | 2/11/2008 |
Q: When I click on my toolbox to add a button or subform. The Wizard doesn't automatically run. Why? ...
A: Janet, Find the toolbar icon of a wand with what look to me like stars below the wand. This will ...
|
| query | 2/11/2008 |
Q: query to list all database names in MSACCESS not the table names.I need to retrive the database ...
A: I just wrote this code for you and tested it. You could store the Access file name to a table by ...
|
| Incrementing Document ID Number without using Autonumber | 2/7/2008 |
Q: I am not a programmer but have managed to pickup some VBA code. My Question is I developed a small ...
A: Paste this code in a new module. If you want to set a form's text field to the next highest ...
|
| Incrementing Document ID Number without using Autonumber | 2/6/2008 |
Q: I am not a programmer but have managed to pickup some VBA code. My Question is I developed a small ...
A: Create a single text field (LastNo) - single record table. Enter 2700 in the record's LastNo field. ...
|
| Display data instead of ID nr | 2/6/2008 |
Q: My software is MS Office 2003. I have an Access database with a table with several lookup fields ...
A: Ermelinda, You will have to replace those form controls with combo boxes that hide the 1st column ...
|
| Updated Record Alert | 2/5/2008 |
Q: I was wondering if its possible to have a msg box pop up before a form loads that advises a user ...
A: Sure Natalie, You write some vba code on the form activate event that opens a record set on a query ...
|
| Forms - using postcode to populate other fields | 2/5/2008 |
Q: I am designing a database in which I need to fill out a series of geographically defined areas based ...
A: Chantil, You could use a combo box control on the form to automatically fill in the form's ...
|
| Combining Fields from Multiple Tables in Access | 2/4/2008 |
Q: I have multiple tables of contacts(2003Contacts, 2004Contacts, 2005Contacts, etc.)that each have a ...
A: Jeff, You need to create a union query. Make a separate query for each table, but give alias column ...
|
| Access 2003 Field List | 2/4/2008 |
Q: I built a form with an imbedded subform using the forms wizard. I have since added fields to the ...
A: Al, These new fields do not appear in your field list because they are not part of the query or SQL ...
|
| DSum | 2/4/2008 |
Q: I am creating a stock control database, in the database i will ultimately need to update the ...
A: Gareth, You named this derived column "Expr1". If you are appending this summ value, the append ...
|
| How do I print information just encoded in a form? | 2/4/2008 |
Q: I am currently developing an application using Access 2003. I need to print (that is, print the ...
A: Edwin, You will need to create a report based on a query that is filtered to the current record you ...
|
| Update question | 2/1/2008 |
Q: I have the following code Dim db As DAO.Database Set db = OpenDatabase("DSSW.mdb") Dim rs ...
A: The first problem I see is that you have set rs to two different sources and only the second source ...
|
| Subform | 2/1/2008 |
Q: Any help!!!! much appreciated...... I have a main form which is build up with a subform. The form ...
A: Jamil, Place this code in the OnClick event of the button on the record in the subform: ...
|
| Make Table Query adding a count field | 1/31/2008 |
Q: Using Access 2003, I am trying to create a Make Table Query which not only extracts sorted data from ...
A: Pete, You could store your last number used and the current date in a separate table. Then write a ...
|
| Help Ms 2000 | 1/31/2008 |
Q: To simplify : I have one table , consisting of 4 fields. The first field is named CustomerName and ...
A: Place criteria in each date field with the date you want that must match all 4 date fields. If you ...
|
| switchboard related... | 1/29/2008 |
Q: I am working on a .mdb that someone else had done(I am new to ms access). I needed to change a text ...
A: In form design view |
ALL MICROSOFT ACCESS DESIGN AND PROGRAMMING QUESTIONS -