Search results

CrossPost: http://www.accessforums.net/queries/query-two-tables-based-common-value-33246.html Please read here: http://www.excelguru.ca/content.php?184 See my response in the other forum.

I have saved some quotes that I like. Nothing is hard for the person that doesn't have to do it.--D.Lies Good judgement comes from experience but experience comes from bad judgements.--S. Port A sale is a gift until it is paid.--D. Zachmann Character is what you are in the dark.--W. Kiem...

This site may be helpful http://www.databaseanswers.org/data_models/index.htm

There is no relation between the forums. Many folks like you participate in several forums. Please read the link I provided so that you better understand why you need to identify crossposts. Alan

Cross posting: http://www.accessforums.net/forms/un-bounded-forms-33198.html Please read: http://www.excelguru.ca/content.php?184

Create the expression (calculation) in a query and make that query your record source for your report.

You should not be saving calculated fields in tables. Calculations may be made in forms, queries and reports. They can be determined as needed for any of these means to view them. Please read what Allen Browne has to say about storing calculations in tables. http://allenbrowne.com/casu-14.html

Dick On another forum, someone else is having the same issue, but it is advertised at Walmart -- look at this link. http://www.walmart.com/ip/Microsoft-Access-2010/14272897 Edit: Didn't read the whole thing. Says out of stock. But you might try your local Walmart and get lucky.

Dick, In addition to what Pat has offered up, here is a very good site about RunTime. http://hitechcoach.com/ Scroll down a bit once you reach the link. It is a very effective way to offer Access programs to clients.

I have several 2002 databases (.mdb) that I open and run on AC2010. I have never converted them and there is no need to have the earlier version installed. They will run just fine in AC2010.

Look to use the IN function in your criteria. http://www.techonthenet.com/sql/in.php

Have you unclicked the wizard icon, perhaps which disables it.

It look like you have an extra closed parens at the end of the Left statement that should be at the end of the SQL statement. Also, not sure if necessary in VBA, but usually SQL statements end with a semi-colon. alan

Congrats Paul.

Have you considered setting your form in Datasheet view? Look in the properties for your form in the format tab. Sounds like you are wanting your form to resemble a spreadsheet? If you are looking to have 365 fields in your table, it sounds like there might be a normalization issue. You...

Suggest you upload your db so that we can analyze and understand it completely. If you have confidential data, dummy it up. It is not necessary to post the entire db, but only enough data that we can determine what is happening. Run a compact and repair before you upload. Click on the Go...

Just to clarify, your report uses the query as its record source?

Welcome to the forum. We look forward to your participation.

It is possible that your db is corrupted. Suggest you run a compact and repair. If that does not work, then open a new db and import all your objects into the new db and try to use that one as your source for your mail merge. You will have to reset your connections (which may also be the issue).

Here is some background on runtime http://www.hitechcoach.com/