Search results

That's it! Thank you!!!

No error, but now I see only the last name in the combo box, not "last name, first name". :(

Forms!frmRSC!sfrmRSCDisclosures1!Speaker.RowSource = "SELECT tblDisclosures.DisclosureID, tblSpeakers!SPNameLast & ", " & tblSpeakers!SpNameFirst AS SPNames FROM tblSpeakers RIGHT JOIN tblDisclosures ON tblSpeakers.SpeakerID = tblDisclosures.SpeakerID;" The comma in the expression SPNames is...

I guess I should say that I have conflicting goals here - I use the same form for adding new records and editing existing ones. When I create a new record, I need the combo box to show the record with the most recent date, but when I edit records, I need the date shown that as entered, not the...

Hello, I have a subform with a combo box. The data for the combo box is limited to show only the record with the most recent date - and when I go to look at the row source list, it does show only the most recent record - yet whenever I select that entry, it pulls up the older data. Why is...

No, the events, or programs, are run several times a year, so the disclosures are not one-time affairs. I think what I've come up with works; I just need to figure out a way to limit the selection of available disclosures to the most recent one when entering new programs

It is valid for a maximum of 12 months, although sometimes new ones are submitted before that.

I may have stumbled upon a solution... How does this sound? Instead of linking tables Speakers and RSC in RSC-Speakers, I'll link tables RSC and Disclosures, which consists of the fields Disclosure ID, SpeakerID and DisclosureDate. Table Speakers would then be in a one-to-many relationship with...

What if I deleted the direct link between speakers and disclosures? Then all I'd have was a relationship between disclosures and the join table RSC-Speakers, and the connection between disclosures and speakers would be indirect, via this table. I believe this system would be able to show...

Ah, too bad; I figured a picture would work better than me trying to explain things. :) So let me try to describe my setup in more detail then: I have a table RSC with RSCID; a table Speakers with SpeakerID; a table Disclosures with DisclosureID, SpeakerID, ConflictID and DisclosureDate; and a...

Hello, I need to re-design my db but it's a bit tricky, for me anyway. Attached you'll find a screenshot of the relationship window for illustration. The part that I need help with is the relationships between RSCs, speakers and disclosures in the top right part of the window. I need to model...

Excellent. Thanks a lot.

Thank you! I actually got it to work on my own because there's even a wizard for this. I must have... overlooked it at first. :D [button code]: stLinkCriteria = "[ComSupID]=" & Me![ComSupID] DoCmd.OpenForm stDocName, , , stLinkCriteria Where can I fit in the acDialog though so that I get a...

Hello, Can't get this to work, hopefully someone can give me a hand here. I have combo box on my form that loads some data into a subform. I may have to edit that data, so I put a command button next to the combo box that launches a form that I can use to edit the data with. So far so good...

Ah yes, that makes sense. But how exactly does it work? One Praise/day? Week? Or does one have to commend x people before one can add more reputation to the first person?

Sorry, this isn't exactly an Access question, but I was trying to add to the reputation of people who've been answering my questions and got an error message that I had to spread some more reputation around before I could give anymore to this particular person. I assumed that every time I...

Thank you! I "fixed" my problem by pretending to create new records until I went past the last existing ID, but maybe I have a bigger problem here; I'll have to run Allen Browne's code. I can't find the seed information though, where exactly is that hidden?

Oh really? That is weird. But my problem is different - it's re-creating existing numbers. In other words, I already have 1- 400 [with some holes].

Hello, I just noticed something very strange - in a table of mine, when I create a new record with the form, the autonumber is an existing number. Say the last record had ID 400, then the "new" record is assigned an autonumber ID of 300. Of course, record creation fails that way. But with...

Fantastic. Thank you very much.