Recent content by rlowden

Thanks Ken for your advice. I changed the form so that it is based on a query (it had been based on the underlying table) and went from there. It was straightforward. I was away so I did not get to respond until now. Many thanks. Bob

I am sure this is simple, but I cannot figure it out. I have a table of Organizations related to a table of Staff members in a one-many relationship. They are linked by a unique identifier PartnerID. On the form showing staff members, I simply want to display data from the linked...

To George et al, Well, I think I am getting closer. I no longer get a syntax error with the following: strSQL = "SELECT DISTINCTROW ProjectNumber. " * " FROM tblProjects " & _ "INNER JOIN tblPartnerToProject ON " & _ "tblProjects.ProjectNumber =...

To George, Brent and all others helping with this. OK, I think I have the general idea about using a junction table, and I think I have a general idea on how to write the selecting SQL statement, but the syntax keeps tripping me up. So, I will restate my goal and show you what I've written, in...

To George and Brent, Thanks for your reply and the good instruction about normalization. So rather than trying to use the Instr function to overcome my problem, I have followed Brent's recommendation and set up a junction table. But please excuse my naivete, what's next? Now that I have the...

I have a table of organizations (tblPartners), each with a unique ID (PCode). IN another table I have a list of projects (tblProjects) that these organizations are involved with (in various combinations), and a field in that table which lists the various PCodes of the participating...

DEar Paul, Many thanks for your reply. YOur solution works like a charm, which leads me to another question. I used to program back in my dark ages, so the logic of the task is not my problem. My problem is that I can't seem to figure out how to reference things properly in VB, i.e. the...

This seems to me like it should be an easy thing to do, but I can't figure out how to do it. I want to set up an Event Procedure, so that when I double-click in a field, the value in that field gets appended to another field on the same form, separated by a semicolon (they are both text fields)...

Thanks for the help Maxmangion and Ken. I just found out that Access will only display .bmp without 3rd party support. That's a real bummer. I will look into your other suggestions. Bob

I would like to show pictures of individuals on a form. I know how to create an object which links to a picture when I click on the object, but I want the picture to automatically show when the record is opened. And related to this, will Access automatically resize the picture to fit the size...

Mike375, Thanks again for your reply. I tried it with the correct syntax you provided, and yes. It now works. Beautiful. You should know that my problem was not that I needed additional fields on which to select a unique record (the number I was using to match the forms was unique). The...

To Mike357: Thanks for your reply, but I just am not sure of the syntax in that "Where" statement. Assuming I use a macro, I just want to open a related form (with additional information) so that it points ONLY to the record I am currently viewing in a subform. If it helps to describe the...

I am an amateur with no Visual Basic training, but I'm trying to learn. Help appreciated. I have a standard form/subform with supporting tables in one-many relationship. The subform shows only name data for individuals from its supporting table (called tblMInfo); but I have another form based...