Search results

I'm hoping not to have to go into the table, though, for usability. I've done some more digging since I posted and I think I've found an answer. I see that Access 2010 has an option to limit selections to the list, and then either pop up a form, or kick off the Not In List event. I think I...

I hope this is an easy one... I have a combo box that's got it's rowsource linked to a table, and when an item is selected, it updates the field associated to it in the combo box's control source. But there are times when the value I need isn't already in the rowsource table and needs to be...

That didn't seem to make any difference. I still get the same error. Any other suggetions?

I have a database that I wrote a few years ago in Access 2000 originally. It has a form with some command buttons to open reports with data from the current record displayed in the form. Here's the code for one of the buttons: Private Sub AcceptanceLetter_Click() Dim strReportName As String...

If you're using the * in your count function, that's probably the issue. Have it count a specific field or fields if there isn't one that's unique. I've used this and it works great. ="Total: " & Count([FirstName] & [LastName])

I think this might be fairly simple, but I'm at a loss as to how to do it. In a report, I want to set a text box's record source to the value of a field name in another table like this: CurrentData.ControlSource = DLookup("[CurrentTEC]", "[tblCurrentTEC]") There are times when the value of...

This might be hard to explain, but I'll do my best. I'll keep my example simple and say that I have a report with 2 group values, Leader and Support, each with 1 detail record within it: Leader -Mary Support -Bill I also have a table that's not part of the control set for the report. Let's...

I'm trying to do something simple...to set the background color of a report textbox based on the value in that box. I've got a bound text box showing the value of a field MasterContactID. For this example that value is 2166. I want to compare that value to the value of a field in another...

I'd like to build an update query, but it's a little complex and I can't wrap my head around it. I have a table with, for this question, we'll say has 2 fields: ID and Experience. The Experience field has 1 of 6 possible values in it for each record. So the table may look like this. ID - -...

Thanks a lot pbaldy! My report is doing exactly what I wanted. You were a huge help, and I learned a few things along the way. Much appreciated!

Any chance you could reattach my sample DB that you created this report in? I think it would help me make sense of what you did.

Yeah, that could work. How'd you do it? Thanks!

I tried adding the RecommendedFor column to the crosstab query twice, once as a groupby and once as a column heading, but it gave me multiple records for each person. I stipped down the database to leave only the tables, queries, and reports in question, and attached it to this post. I put...

That looks like it's close to what I want. So I set up a crosstab query to use event number as the column headings, so I get a column heading for each event, and I set the "Recommended For" column to be the value and to count. But that just counts the number of records that have a value in...

I have a database that tracks recommendations for people. So one of the tables contains a person's name, what they're recommended for, and the event number that the recommendation came from. e.g.: John Doe, Head Honcho, 75 John Doe, Head Honcho, 74 John Doe, Head Honcho, 74 John Doe, Head...

This might be a tall order, but here's my question. I have a database that I've been asked to create that tracks name/address/phone, etc. I've created it with Access 2007 and it's nearly complete, but now I've been asked to add login security to it. The login isn't so much to keep people out...

That's a good idea. But I don't really know how to do it. If you've got some sample code, I'd look into it. For now, I just set up a field to store the location of the picture. Then when each record is opened, it checks to see if there's a value in that field. If not, it then checks to see...

It's because I create the database and manage the frontend, but someone else does the data entry and consequently manages the backend. I don't have easy access to the backend. Right now I can know that I need a picture for the new record Jim_Smith, and so I can create the picture file for him...

I've got a database that tracks name/address/phone, etc for a large group of people. I've recently added the ability to include a person's photo on the forms and reports. I've done that by saving the photos with the naming convention of [firstname]_[lastname].jpg and then using VBA, the...

Perfect! I knew there had to be an easy answer. Thanks.