Search results

Good afternoon! I have an issue that is probably very easy to solve but can't seem to get it right. I am working in Access 07 and in the database I have attached, I have three separate tables that list market managers (tbl_MM), Chemicals (tbl_Chemicals), and Area (tbl_Area). One market manager...

Hi! I have a memo field that needs to be entered onto a form based on selection made in previous text boxes. When the memo field was a text field, it worked fine with [ProdNo].[Column](3) but now that I need the additional length that the memo field provides it brings in the memo field text but...

I had a working form but then my client asked for the form to be changed and with those changes my subform is not summing the totals in the footer properly. It is giving me a #Error message. My line total is working fine with the formula =([Size]*[Price])*[Qty] but when I enter...

I have a query that is based on two tables; main quote table and the product table. In the product table I have a yes/no box for if that product was purchased. What I want the query to do is run and display all the quotes that do not have a the check box checked; however, I want the whole quote...

I have a form based on a query that pulls quote numbers and lists what was on the quote as well as the prices. I want to add the order numbers to the quotes if the products were ordered; however, sometimes the quote is in two orders and I need to distinguish the quote between the two orders...

I have a form and a report that list a company name from the database but needs to have additional fields completed by that customer. We want to be able to have the form or report fillable electronically so that they can complete it and return it electronically. Is there any way that this can be...

Good day! I have a form that currently calculates a total based on the qty times the price; however, we want to add a field that lists a discounted price if applicable. What I need is the if/then statement I would need to use to have the total field look at the discount price and times that with...

Hi! I have a form with a subform that list out products and prices. One of the subform fields caluculates the total cost by multiplying qty*price. I would like to have a grand total of that on my main form would be prefered but everything I try is not working. Does anyone have any suggestions...

I have a form called frmQuote and a embedded form inside it called frmQuoteProd. I want to select a product from the drop-down menu and have a dlookup enter the product name into a new text box. Every way I do a DLookup I am getting an error. Can someone assist me in setting up a dlookup? I have...

Hi! I'm not new to Access but I am running into some difficulty when trying to get a report to show what I want. Here is what I am trying to do. I need to have a form where a sales person enters data (ie-quote) with potential client & product information. Right now the salesperson enters the...