Search results

The real question is why you would want to store a Total in your table. Each new entry in your subdatasheet would necessitate a completely unnecessary update in your main table. Totals can be calculated at will using current data, in forms queries or reports. So why store something which...

DoCmd.RunCommand acFilterbyForm is the key...

in access97, you don't need the DAO prefix. Just use Dim dbs as database. But ensure yiou have DAO 3.51 loaded under tools>References

Yes, but that holds true for any limited choice field. A simple update query can cope with most changes. Meanwhile the value is an adequate generalization.

Having given the matter some thought, I don't see a way in which this can easily be incorporated into a straight query, because a way has to be found to define the intervening months beween the dates and then count the number of days in each month. A function can handle it well enough though...

Underlying each of the forms is a recordset based on a table or a query. Probably some of the forms contain different subsets of the same table data. The facr that they are all similar in structure points to some common origin. (unless it's a poorly designed database) If you are just looking...

Let's take your example, then. You have 90 days =30 hours. so each ratio is Jan 31/90*30=10.33 Feb 28/90*30 =9.33 Mar 31/90*30=10.33 These don't yield the results you gave. (In fact, your sums total 30.05. ) How do you apportion the hours?

In table 1, you should have a unique primary key field. (NO duplicates, and probably set to Autonumber). Let's say this is called CustomerID. (THIS IS THE ONE SIDE) In table 2, you should have a field called CustomerID, which is a Long Integer. Duplicates are allowed. (THIS IS THE MANY SIDE.)...

An Access database contains Tables, Forms, Queries, Reports and code modules in one mdb file. You are probably referring to TABLES when you mention FORM DATABASES. Assuming this to be the case, how much commonality exists between the tables? How similar are they in terms of field name/types...

1. you can drag those little boxes aroiund in the relationship window and put 'em where you want. If there are lots of the critters, reduce their size. You only want to see the join fields usually. 2. You can have a YES/NO field in your Customer Table and set it to default to NO. There are no...

There was a closing bracket missing after 'released without changes'. Also, you didn't enter the full field name, you only had 'released' Try this: =Dcount("[Review_Result]", "Review_Object_Main","[Review_Result]= 'released without changes'")/Dcount("[Review_Result]", "Review_Object_Main")...

1.Create a new form. 2 Add a text field from the toolbox. This is an UNBOUND FIELD i.e. it isn't stored in a table. 3. Right click in the field (not the label) and select Properties. 4. From the list, select Format and choose Percent from the options offered. 5. Now go to the Control Source...

OK. Just base your form on a simple query from your table. Have two calculated fields. In the first one add this expression: =Dcount("[Review_Result]", "[Review_Object_Main]","[Review_Result]" &"= 'released without changes'"/Dcount("[Review_Result]", "Review_Object_Main") Label the field...

You are giving yourself problems here. The field you are trying to count has a YES/NO scenario. In other words, you could replace it with a tick box called CHANGES? and check the box if there are any changes. Then it's simple to count the the number of each type in a query. But you can still...

Please explain how you enter the hours. Does each entry for hours have an associated date? If so, you can use the Datepart Function in your crosstab to give you column headings (DatePart("m",[Hours])and use the sum of hours as the value.

Do you want to be able to choose a subject and display a mark sheet on demand, or display all the mark sheets together, by subject? If the former, you need to open a form WHERE: Mark is not Null AND Subject=Chosen Subject. You can do this with an SQL Statement or a saved Parameter query...

if a parameter query can't be used for this purpose, I have misunderstood what you are trying to do. Perhaps you can explain what you mean by "internally develop" and also expand on your table structure. Do you actually have field names LV01 through LV99 or are these in individual rows in a...

As this message refers to a non-existent name, have you checked for mis-spelt names or rogue spaces in your call or on the subform?

This sounds like an issue of udatability,ie relationships. Please explain how your tables are joined and how youy populate your combo

Yes. a simjple parameter query will do this where the parameter is defined as "LV"& ("the numeric portion"). How you define numeric portion depends on where you're getting it from. Is it entered manualy, picked from a list, or referenced from a form? Without this info. I can't be more specific...