Search results

Although this doesn't seem to have anything to do anymore with the original Yes/No field issue, I too am wondering now - if I have a field in my db that could routinely be left empty, ie contain null, then should I redesign the db to store the information that might go in that field in a...

Ah yes, Craig, excellent points. I didn't make the original db, so I'm not sure what the intent was with regards to the books. I suspect it was simply to provide another bit of information. But searching for movies based on books is a very good idea. This was exactly the kind of advice I was...

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

Thank you, Craig, that was helpful. Regarding my yes/no field, thank you for pointing out this potential problem, but since no distinction is made between colour movies and movies that are both b/w and colour, I believe I should be fine. Most new movies are colour anyway, so I set the default...

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

Thank you. I actually saw this example when I searched the archives, but it didn't look like what I needed. But seeing the explanation now, I may be able to adapt it.

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

I haven't had any problems deleting active records, so that comment doesn't make sense to me. In fact, I *need* to click on the record on my [sub]form [continuous view] so that Access knows which one to delete. As Keith said, it would be best if you posted your code.

That compiler really is your friend. Although you've solved your issue, here's something I've run into a couple of times - I created my db in A2003, but in 2000 format [default]. I then changed it to 2003 format. The compiler found a couple of errors, but the oddest thing was that apparently...

All right, thank you.

Thank you. That was slightly more than I needed to know at the moment, but it sure was interesting. :)

Thank you, that works. Not sure why this was an issue to begin with though. Oh well, I'm just glad it's taken care of.

I have a similar problem, and yes, I put docmd.requery in the combo-box's After Update event, and it worked.

I'm not quite sure I understand your comment... Why would I have the same table open twice? I'm doing the exact same thing with other child tables, and there's it's working.

Yes, in the main table, there's a field called RepID. The combo box has that as its control source, and uses a query on the Rep child table [RepID, RepName, RepPhone] to pull the actual names. The same table contains the phone numbers, and the subform just shows those. The subform was linked to...

I don't have any code. This is just supposed to be a simple case of "select name, get phone number as well". The subform is called sfrmRepresentatives. I noticed that the ID that the subform is supposed to be linked on to the main form does not change when I select a different name in the...

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

Thank you.

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.

I found a solution - If Me.NewRecord Then... in the main form's Current event let's me specify different Select statements for adding vs. editing records.