Search results

Hello, I'm trying to update this movie database. The original was mostly a flat db, so I'm trying to do things the right way this time. Amongst other things, the db tracks if a movie is based on a book, and if so, what the title of the book is. The text field [OrigBook] basically has three...

Hello, I'm trying to update this movie database, and I need something to save me time, not to mention my finger. One field in this db tracks if a movie is colour or black/white. In the old/existing db, that was done with text - "color" and "black & white". I want to replace that with a yes/no...

Hello, I have a form that I use for searching. It takes all the records in the database and then people can type things they are searching for - numbers, dates, names, descriptions etc. - into a text box, and as they type, the selection window shows fewer and fewer matches. What I would like to...

Hello, This is very strange - one of my combo box-subform combinations isn't working right. When I initially select a name in the box the correct phone number shows up in the linked subform, but when I change the name, the number remains the same until I either navigate away and then back to...

I'd like to sort in my query - used to populate a combo box - first by name, and then by ID. Is there a way to force Access to sort in a particular order? It seems like it starts sorting with the first field that's to be sorted, but I want it to start with field 2 and then sort by field 1.

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...

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...

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...

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...

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...

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...

Hello, I have a query where I would like to include names from a name table. The problem is that I get this "ambiguous outer joins" error when I try to include it in my query. I have a main table, the name table, and a join table with the IDs from both of the other two tables in order to model...

Hello, I use my switchboard to launch a search form, which then starts another form to edit records. Everything works fine except that after I click on the record I want to edit, the switchboard window not only remains open, but also is in the forground in front of the record I want to work on...

Hello, On my main form, I have a combo box, and in its After Update event, I have code to execute an append query. It is intended as a one-time thing, to run when a new record is created, but I just realized that it is easy to trigger this more than once, which then of course messes up the...

Hello, I am using a command button on my form to start a new record. I would like that new record to show up in a way that the top part of the form is visible, and not the bottom half. I thought that if I set the focus to the first combo box on the form, I'd achieve my goal, but either I am...

Hello, This is my code: UPDATE tblSpeakers INNER JOIN [tblRSC-Speakers] ON tblSpeakers.SpeakerID = [tblRSC-Speakers].SpeakerID SET [tblRSC-Speakers].SpeakerID = 404 WHERE ((([tblRSC-Speakers].RSCID)=[forms]![frmRSC].[RSCID])); What I want it to do is take tblRSC-Speakers and change the...

Hello, I want to put code in the On Current event of a continuous subform on my main form so that when I click on different records and thus change what's shown in another subform right next to it, the second subform is hidden under certain conditions. Those conditions are the presence, or...

Hello, I have a table "Speakers". For each speaker, there can be more than one disclosure [say, in the table "Disclosures"]. Yet at the same time, only one of those disclosures is current, the others are old data that needs to be kept around for analytical purposes. When I link speaker and...

Hello, For the life of me, I cannot think of a way to make this work. :( I have this continuous subform, and I need to put additional fields onto it. The easiest way to do this would be to create single record sub-subforms, but that won't work because Access won't let me put another subform on...

Hello, Could somebody please tell me how to write my Where statement without specifically mentioning the exact name of the parent form? This is what I have right now: WHERE (((tblOptions.OptionsID)=Forms!frmBrowseApplications!sfrmOptions!OptionsID)); It works, but I'd like to get rid of...