Search results

I have a report currently grouped by one field name and sorted by a few others. What's the best way to change the group and sort options via VBA so I can make group/sort buttons for each field on the form? - OR - What are other methods of accomplishing this?

I've read a few posts that state it is not possible to have an unbound multi-value combo box (Access 2007). Many of my bound forms have multi-value combo boxes, and I understand many programmers dislike them as they break some formatting standard rules (or so I've read). Anyway, I have no...

Works great, thanks!

I have a popup box containing a button that, when pressed, adds/removes a few fields to the popup. When this happens, the buttons are moved down to provide space for the additional fields, and are no longer visible - you'd have to scroll or re-size the box to be able to see them. Is there a...

Worked just as planned. Thanks for your input!

Ok, that's what I was thinking - and what led to my desire for hard coding it the way I tried. I'll take a look at how I'm going to work this tomorrow. Thanks for the help.

However, I do not want to completely discount your last post. Perhaps I can just trigger a sub/function to change the re entry date for each field as a property of each field in the field information table based on the properties of the chemicals applied to each field if the re entry date...

The underlying records in the tables are to remain unchanged in order to comply with regulatory laws. The function of this report is to post record of when it is safe to return to a field based on the latest re entry date of all chemicals applied to that field. Whether or not I change all re...

farm8.staticflickr.com/7199/6849251393_fa8dbd9256_b.jpg All tables and relationships are at this url. I cannot post images or links yet since this is only my second post, so just copy and paste into your browser. Thanks, John

I'm currently creating a database to manage pesticide applications for a farm. Each pesticide application has an REI (Re entry interval) that restricts entry into a given field on the farm for a given amount of time. I've easily programmed the database to calculate the Re-Entry date based on...