Search results

Just to add some more wood to the fire: There is such a thing as an OLD and a NEW Testament. Are these "10" Forum commandments part of the OLD Forum Testament? If so, can I hand in a change request, for 100 commandments as part of the NEW Testament? ha ha. just joking. I think the effect of the...

No-No: No backup? One of the 10 commandments? Have you tried Compact and repair? I would make 2 backups first. (maybe it's silly, but I would do it) Then try compact and repair one version in Access 2007, if no result try it with the other version in a non-trial version 2010? You can never tell...

Suggestion: make a "Total query" and use that as the report source, instead of using a detailed report and hiding all duplicates?

Tinkerbell Tinkerbell, you are a sweet lady I can tell. It's a name we all know so well. Was it Peter Pan or William Tell? I'm sure it's Peter for whom you fell. Welcome you I shall, To this Access Fairytail Forum well.

Hi The solution is in Excel. In Excel you can go a certain cell then select data...import external data.... import data. Then select the Access database... select the Table Student_Final_Result. (Maybe you need to change some settings in Excel before it works). Finally the data will be imported...

Create a Continuous form using a wizard: -Select Form New -Select Autoform - Tabular -Select the query -Select OK The form is created for you. Now check the design view of the form to learn how it is set up.

Try this link: http://www.everythingaccess.com/tutorials.asp?ID=Build-a-search-criteria-form You can even download a sample to learn from. It should answer all your questions.

I understand what you are asking, but it takes a lot of explaining. I will help you step by step to build what you require, you can find my mail in my contact info. I'm willing to lead you to your goal. Send me a mail and I will guide you through it all. Let's find out which lure leads to the...

If I understand correctly, your query is set up fine and you now made a form from that query but you only see the first record on your form. When you move to the nect record in your form you see the next record and next picture but you want all records on your screen together. If so then you...

In a table: Not that I know of In a Query: Yes In a Form: Yes In a Report: Yes Is changing to an "Input Form" an option?

You need to save a Query as a Make Table Query. Then when you RUN the query (Or use Macro "Open Query"), the query will not open, but the table will be created.

Create the query I mentioned including the locked price and the up to date price. A better name for the table would be TblPriceHistory. I will get back to this when you have created the query and replied to my previous question in my previous post.

A Form is based on 1 Table or on 1 Query. Basic steps for Tables,Queries,Forms and Reports: 1 Basis of all data = Table 2 Make relationships between Tables 3 From Table(s) you make Query/Queries to get required data 4 From 1 Table or 1 Query you make a Form 5 From 1 Table or 1 Query you create...

Hi, There is a way. You could save data to an extra "TbQuoteHistory" for example. Due to your question, your Access design skills are average, so I'll tell you how to do it without too much programming language: 1: Create a Query that contains all the values you need, don't forget todays date...

You want to Filter a form, to my understanding. Try this: http://allenbrowne.com/ser-28.html

It's exactly what you said Brian, I just gave it another approach. I'm trying to explain it in "the requestor's level of understanding".

Hi, Try this... (I think I understand): In the Query delete your Query on the right [QyCardTransactions] this is probabaly overdone. Then make make your Quer7 a "Totals query" and Groupby [Type] and Sum [Price]. Run the Query

[Business] refers to an object/fieldname in your statement. It is not a field but a value so do not enclose it in [] but use "Business" instead. When you have changed it,you must Find the column in the recordsource of your drop down. (This is the problem) Add the column between the (). Remember...

Because you based that report on a table. You must base that report on your query. Do you know how to base a report on a query?

Hi, That means "Business" is not in column 1 in the query of your drop down. (Check the query: The first column is usually Zero, so don't count that). Now you must enter the correct column number inside the (). If you know in which column "Business" is in your drop down query, then you enter...