Recent content by new2access123

I have not seen a comment. What is your suggestion?

I have created a form containing a subform in datasheet view. This is my ERD. Form Select: SELECT ProjectToParticipant.ProjectID, Participant.ParticipantID, Participant.NameFirst, Participant.NameLast, Participant.NameMiddle FROM Participant INNER JOIN ProjectToParticipant ON...

I am brand new with Access so i know I am not seeing something and the answer is easy. I have created a record set (dbOpenDynaset) that brings together the client, project, test name and scores for a selected participant. (each of these is a separate table client, project, testname, scores and...

Great. Thanks for clearing that up for me.

I have a number of Access functions that I have created for an Access application I am working on. Is it possible to use those functions from an Excel spread sheet? For example, I would like to enter a value in cell A1 and have that value passed as a parameter to my UDF and have the UDF return...

Just to make sure I am understanding this correctly, for example, often times the control source of a combo box would be a field in a table other than the table in the row source of the cbo? So that when a selection is made in the cbo, the cbo value will populate the field specified in the...

I am teaching myself VBA and am creating a form in Access on which I use a combo box. I am able to return the desired value and hide columns etc. What I don't understand is the usefulness of the Control Source property . The Control Source property specifies what field in the in the Record...

That was the problem. I had the code in the wrong place. Your code works great. Thank you very much!

I am brand new to VBA so i will need a little help getting through this. * I pressed alt-F11 to open VBA * In project I select sheet1 * Pasted in the code. * Save and close VBA I return to the spread sheet. Column C is a column having 10 rows with numbers 1 - 10 in random order. The first...

I have been searching for a way to change the color of the autofilter button so it is more visible. I have found that can not be done. But there is a lot of code out there that will is said to change the color of the column head cell when it's filter is in effect. I have down loaded the zip...

Thank you for the feed back. It was very informative. I will do some research and be back for more.

I am an old FoxPro programmer (but have been out of programming for many years) and I have been through the Access basics that I have been able to find on line. So I can create tables, forms enter data the basics. I am learning VBA no problem there. Now I want to write some functions. I...