Search results for query: *

Hi, I would appreciate some help. I have a subform called DII_ContractsItems with two combo boxes, cboChapter and cboSection. The cboChapter box displays a list of chapters from the tblChapters2011. Here is the sql for that combo box. SELECT tblChapters2011.Chapter...

Hi everyone, I have an excel spreadsheet with a column (P) that lists part numbers. I would like to write a subroutine that would copy the part numbers, one at a time, into cell $B$7. This would lead to two prices being calculated. After they are calculated, I would like the subroutine to copy...

Hi there, I have a computer with Access 2007 on it. I'm unable to open up an application that was created on Access 2000. Can someone please advise what i need to do to the settings to open up the older version. Thank you in advance for your assistance. Kind regards, Tess

Hi Everyone, I've created a report that currently is listing sales information, all orders and total sales for all customers. I have created a seperate form with a combo box that allows the user to select a company name from the list. Once a name is selected, I would like the report to only...

Hi Everyone, I have a Customer form with a combo box that stores company names. If there is a new customer, the user clicks on the add customer button which opens a new form to input the information for a new customer. When the Add Customer screen is closed, the combo box on the Customer form...

Hi Everyone, I have a form with an option group that has been assisgned the following values: 1-Active 2-Prospect. Can someone please let me know what I need to do to have the report display the words "Active" or "Prospect" instead of the numberical values that access stores in the tables...

Hi Everyone, I have a form called orders and a subform called Order Details. When I try to enter information in the subform, I'm not able to save the infomation. A message displayes stating, cannot add or change record as a related recorded is required in the tables order. The two forms are...

Hi everyone, I have a form named Orders by Customers and a subform named Order by Customers Subform. The form Orders by Customers has a field to store the total volume of sales called VolumeSalesDollars. I would like to store the total amount in this field which would be pulled by added all the...

Hi there, I have a form that lists customer information and displays the orders that have been entered for the customer. The form opens up with the fields blank and the user selects a customer name from a combo box to populate the information. I would like the form to open up to the first...

Hi Everyone, I would appreciate some help. I have a form that stores company name, contact information, shipping address, etc. All these fields are stored in one table. I changed the text field for the company name to a combo box so that the company name can easily be selected by the user...

Hi Everyone, I have created a form which uses a couple of combo boxes and limits the users response to one of the items listed. I need to revise this list by removing some of the current items and creating new ones. Can someone please let me know how I do this without effecting the records...

Hi everyone, I had a form that loads on double click if the user selects SC that worked fine. After making some changing to other fields, this form will not load. The changes should have no direct impact on the this field and the conditions it uses to open the form but every time I try to open...

Hi Everyone, I would appreciate some assistance here. I have created an access database which is being used at our office. I find that the file size grows rapidly and I'm just trying to understand how all this works and what I can be doing to keep the file size at a minimum. Currently, it's at...

Hi Everyone, I would appreciate some help on a problem I'm having with a query. The query displays case number, description, amount of transacation, etc. One case can be displayed in one or more rows if more than one payment was processed for the case. For example Case ID Payment Amt...

Good morning, I have created an access database which is being used at our office by a team of eight users for almost a year now. One of the users has been having ongoing problems with the application opening up very slowly and then once he is in the database, certain forms take a long time to...

Hi, I need some urgent help. I have four fields, txtAmount and txtBalance whcih are both unbound and formatted as currency. The txtAmount is populated by the user when they select an account from a drop down list. The txtBalance holds the balance after the calculation is made. The other two...

Hi Everyone I have a field named date that captures the system date, as per the date a file is opened. I have a second field named Follow Up Date. I need this field to show a date which is calculated by taking the system date that is stored in the date field and adding three business days to...

Hi Everyone, I would appreciate some help regarding accessing data from a list box. I have a form, View Accounting Codes, which displays an advisor's first name, last name and acccounting code. The first and last names are stored separately but concatenated when displayed in the list. I have...

Hi, I would appreciate some help. I've been struggling with this for two days now and I'm sure it should only take minutes but I haven't been able to find an example to solve this problem. I have a form called "Advisors", which displays an advisors id, first name, last name, and other...

Hi everyone, I have two tables, "Projects" and "Payments", that are joined by a "CaseID" field. I have created a form to enter the payment information for each project. All data entered in the form is recorded in the table with the exception of the Case ID which should be the same as that in...