Search results

Dave, here's a copy of the implementation with your suggestion (attached). Thanks a bunch, I think this is definitely moving in the right direction. Let me know if you think of anything I should be doing differently if you want, keeping in mind that this is still a work in progress. The main...

A last resort option for this problem I can think of would be to place an image of the date picker button on the form in its place, and programmattically deploy the date picker when that button is clicked. Someone has to know something I don't know about this, so fire away. :)

Hello all, Is it possible to keep the date picker button (adjacent to a date field) visible at all times? I see the options in the property sheet of the date field for never showing it and showing it for dates, but there is no option for that particular property to be always visible. I am...

Thanks a bunch, Dave. This gave me a few ideas that really help. I'll post back with issues/successes after I get things together over here.

I am creating a database to keep pest scouting records in order to determine which pests are above my company's thresholds - to make recommendations for combating these pests. Scouts are sent out into fields to search for these pests. They require different information based on which pest they...

What would be the norm for a situation in which each type of entry requires different parameters? In my case, I am recording pest scouting records. Each pest requires different information to be recorded based on the formula used to determine that pest's percentage of infestation for a given...

This wouldn't change the layout of every instance/record of the continuous form the same way Child.ControlNumber.Height = Value would change the ControlNumber.Height for each record when performed from the 'Parent' form? i.e. Changing this from the current event of the individual record will...

Ok, so before I waste the afternoon trying to accomplish something impossible in Access: Is it possible to have a continuous form with a control layout that is determined by the value of a control in a current record without changing the layout of the rest of the controls on the other visible...

I have a report which details the cost and amount of chemicals being applied to a farm to combat target pests. This report is grouped by [Target Pest].Value which ends up displaying the report as a groups of records grouped on individual values from [Target Pest]. This is the expected and...

If anyone else is still interested in helping with this issue. Is there a way I can get these calculations to be performed prior to the report level, like in a query that I can reference from the report?

Well, I really appreciate your attempt at helping me anyway. Thumbs up.

It is my impression that Len(Combo50) defaults to the Len(Combo50.Value). Len(Combo50.Value) would not contain any commas for this calculation to work (and would only contain the first value of the values selected in a multivalue field), which is why I used Len(Combo50.Text) to specify that I...

The whole Len/Replace mess is my method of determining the amount of entries in a multivalued field. -- Count the amount of commas, and add 1 to determine amount of entries. So the field containing "Mummy Berry, Phomopsis" would do this: Len("Mummy Berry, Phomopsis") = 22 Replace("Mummy...

See what I'm saying?

That does return a value in report view, but the (Len()-Len(Replace())+1) of Combo50 returns 1 in all cases. Even when there are multiple values in Combo50 separated by commas - This is the reason I went with the .text value for that part of the function. Since this is showing that the Len()...

Here you go! The error is occurring in report "Spray Cost by Pest." In control [Text21]. Hopefully you're using A2007 or higher, because this DB relies heavily on multi-valued fields. What I'm trying to accomplish is somewhat of a weighted average for the cost of applying treatments per pest...

I'll give it a shot. There's tons of records in the DB, as it's been in use for a year now. So, I'm going to make a copy and clear out the sensitive information, and replace with some dummy info.

I attempted changing the field name [Cost/Unit] to one without special characters, and this was not the problem. There must be something we're missing.

My concern is that this control is gathering data from the .text parameter of other controls that is not populated until the report is generated. Therefore, the .text values may not be available/would be null at the time of calculation. Any way I could trigger a requery or other refresh method...

I hear that, but isn't true that the calculation wouldn't work correctly in the other views if it were an invalid name, i.e. the data is being referenced properly?