Search results

I have 4 queries that run and prepare a temporary table for which I then have a sales report generated . THis report has been active for over a year exactly as is but now the past week I am getting an error message that says "The expression is typed incorrectly or is too complex to be...

Re: Need more info on option 4 @Pat We are currently set up to access our database through terminal services. We are a small business with only 5 users. The problem I am hearing is that the terminal services connection is very slow or delayed and so the users are not tapping in during home...

I am using the Navigation form and I have a tab that has all the sales quotes for a particular salesperson. Because my salespeople like to work with paper I have created sub tabs which contain a report with the same information but filtered based as follows: this Month, this year, and Last...

JLCantara, Thank you for helping me, but I am sorry I do not see the prototype attached?

JLCantara, The answer is yes.....I have restructured my project per the request of Galaxiom so I now have 3 tables, the main table contains the material ID and the material description. The 2nd table is the vendor cost table which contans the material ID, the vendor name and the cost of the...

OK, I am gonna need your help with this. I am pretty novice when it comes to functions. Basically I need to find the value during the process of entering a new record. So I guess we should use the DMax function and then use the insert query? Maybe we should do one step at a time, can you...

Galaxiom, Thank you! I restructured my tables and I created a query called MaxValue, it is a totals query that gives the highest value. Now what I need to happen is the value that I get from this query, I need to somehow transfer that value into a table field and I am not sure what the best...

I have a material table, and each record consists of the following: ID Material Description Vendor1 Cost Vendor2 Cost Vendor3 Cost What I need to get is the highest number out of the 3 cost fields, so say I have one record (see below): ID: 7 Material Description: Colonial Casing Vendor1...

Thank you Pat and Spikepl. I appreciate your time.

OK Pat, I followed your instructions and I may not have explained what I need very well so I will try again. I created a mock DB with a phony contract and data. although I am using A2010 so I will not attach it. I am uploading 2 PDFs of the report with an example of what is does when it...

Thank you for the reply Pat. I am using A2010. I will try it out and let you know if I have any issues. Thanks! Shellyn

:confused: OK. I am not sure if I can explain exactly what I want but here it goes. We have a contract (Access Report) and this contract consists of many parts, the art I need help with is the product specifications section. We receive product quotes from several different vendors, via the...

Try this, open the query in design view, in the criteria for the date type the following: between [enter start Date] and [enter end date] Then run the query, you should see two prompts one right after the other, the first will ask for Start Date and the second will ask for the End date.

Thank you Shadow and kiwiman. It was the path to the backened.

I have a front end DB that will open fine on all computers except one. When the DB is opened, a prompt for the username and password appears. After the username and password is entered, they click the enter command button which then opens the Home Form. The Home Form has an OnOpen event with...

Thank you vbaInet, that worked!

I was closing the form and that was the problem. Thank you!!!!

I have a sales report that includes 2 sub-reports. The criteria is just simply to enter a Start date and an End date. I first have a dialog form open and I enter the start date and the end date and the query in the report gets the value from the form. My problem is that after the report is...

I have a main report and 2 sub reports. When either of the sub reports have no data, my main report calculation returns an error. I have used the Nz in all of my controls. unfortunately this is not working. I am using Access and my reports are based off of queries. My calculations are...

Hi! Thank you for considering to help me. I am trying to create a simple Send Mail button which is located on my contacts form. When you click on it Outlook will open and the email address will already be populated and the subject will be populated. I have this code from a sample database...