Search results

I'm wanting to hide the error code that results from creating the report this comes from for those years where actions and records haven't been recorded/entered yet. As it is now, since the Action2 will be empty, I get the #NUM! error message. I'd like not to see that.

Wow...that was interesting. I went back in and looked at my textbox names and discovered that at some point I may have decided to use those symbols to further describe what's in the textboxes themselves. I have changed all the names to eliminate those symbols. I must've been asleep when I did...

Wow...once again I'm ecstatic about how quick you folks are to reply. :) Thanks a bunch! I corrected the issues with brackets and closing parentheses, and still end up getting my error message like I was getting before (#Num!). Here's the updated formula...

I have a database which, among other things, tracks specific actions over time. Within this database, I have pages that run percentile statistics comparing specific actions (noted here for privacy as Action1 and Action2), within specified years. When there are records where both types of...

I can't answer this poll because none of the options fit my view of the Divine. Of course, as a Panentheist/Pagan/Wiccan/New Thought/Reiki Master/Labyrinthian/Unitarian Universalist, it's a bit difficult to make a statement that DOES meet my view. :) I like the words that I first heard from...

I have, and was thinking that was the way to go. But the challenge is that I don't have fields in any table or query called "Year" or that only have the year itself in them. I didn't see any way in their structure to create a crosstab query that pulled the year out of the date and, perhaps...

In this database that I've been working on for some time, I have a series of four actions that take place and fields that track the dates for these actions. I have created summary queries, using IIF and Totals (Sum), to pull out a number of how many of each events occur in each year. I also...

I saw and was replying to a question similar to this, but it appears that my responses, etc., were overlooked because the initial question was something like six years old. If I'm breaking protocol by listing it again, I apologize. I have a dashboard which I have set up to open a form in...

Thank you for your tireless effort at answering my questions. I really appreciate it. Is [RecordPK] an aspect or property of a control, or is it a field name that I need to change? It appears to me that this might work as far as displaying information already stored in the table. But if...

Guess I was sleeping when I read your response. Sorry about that. You are right.

First of all, I understand that creating a control that shows all the options is one way to do it. I'm trying to find out if there is any way to have a control show only those options that have been selected. Second, I'm really at a loss to understand the obvious distaste at best for what...

I suspect I already know the answer I'm going to get on this, but I thought I'd ask anyway. I have a form with about 30 controls. I organized it carefully so that all the controls show on a single page. It actually looks really good. However, several of the controls allow multiple values...

I'm not sure if this helps, but I used the newly built-in multi-value functionality. In creating both the table where the info is stored and the form that I use to gather the information, I used a list box, either typed in the values I wanted or had the listbox read from a table, and on the...

I have added a button onto my main database dashboard to open a search form in "Filter by Form" mode. I used the macro builder to set it up. It appears to be working very well. I am not able to add some buttons onto the form and have them run the filter process, but the "Toggle Filters" button...

Compact and Repair. ``````` I take this to mean just do it now? :-)

Thanks for your help and the reminder on backing this up. I've got it in a few places backed up...unfortunately the security level here at work doesn't allow me to use a USB drive or other removable media. About Compacting and Repairing. I haven't done that yet. At what point is it best...

I hope that my comments earlier didn't seem rude. I apologize if they did and re-state here that I am in awe of and grateful for you folks who take your time out to answer the questions that us users have. While one expects required fields to be required to have entries in them for editing...

Sorry, CJ London, perhaps you're not the person to be responding. I fully understand what "being clearer" means. The terms you request clarification for are straight from menu commands, etc., in Access. Can someone else who knows this program please respond?

Re: Required field suddenly needed during filter Wow...I guess I'm confused. I don't know how to be any more clear. And I don't see another place to go for this. It's directly related to forms. When I do a filter by form if the criteria I'm searching by doesn't require a particular field that...

I have a form that I have opening in Filter by Form mode. It WAS working flawlessly, at least it was opening in that mode. It IS still requiring me to click on Toggle Fields once data is entered into controls to filter by, but that's another issue (I wrote a recent comment, but haven't gotten...