Recent content by Dchall_San_Anto

This is a db design question. I am starting over with the database I have been using for a couple years. All I've ever done with db's is use them and make minor modifications, so my questions are usually pretty basic. I got the file from a co-worker who lives in another town. He is totally...

So I guess there's no ideas on this.

The Northwind db doesn't do what I'm asking about. I want to do data entry via a subform. I would think this would be a common use and there would be more than one person familiar with the process. I've looked up Normalization. Normalization is what I'm trying to accomplish by asking my...

Or, to summarize, I am going exactly where you suggest I go. This thread is all about me being stuck getting there.

I'm using Access 2000. When I click the File menu to go to a recently used file, the entire path is shown. With my file system, the File drop down widow is about 50 characters too short to show the entire path all the way out to where I keep my database. Is there a way to shut off the viewing...

If nothing else it should demonstrate my ignorance of databases Didn't I tell you!! Thank you so much for the help so far. I should have said this earlier. And thank you for looking at the db and giving me the quick overview of the bigger picture issues. However... Please let me explain...

boblarson: did I lose you with the db?

I deleted 70 records and repaired it down to 288k. Hope this helps. If nothing else it should demonstrate my ignorance of databases :D

And another thing. I tried setting the LimitToList property to No and got a warning: The first visible column, which is determined by the ColumnWidths property, isn't equal to the bound column. Adjust the ColumnWidths property first, and then set the LimitToList property. When I make the...

Your rowsource for your list box is not set properly for the way you want it to work then. Set the rowsource query to only those on that deed. You can set the rowsource to have criteria that is based on the deed ID (or whatever key you are using in the record). After trying a few things, I...

When I set LIMIT TO LIST property to YES, then I can't enter new names. Is this an either/or thing or can I have both? When I change to a list box, then I see all the entries for the entire table on each record. That's not right. I just want to see the buyers and sellers for that deed.

I've been working on this for a few days and it seems I haven't made much progress. 1. The dropdown list defaults to display the autonumber and not the name. By fiddling around with the properties I finally got the drop down list to display names, but it still displays the autonumber. When...

Ooooh, people do have the same names...hadn't thought of that...'til now. I really like the idea of making the phone number part of the full name; however, these deeds go back to before the telephone was invented. Some are in Spanish from before Texas was a state. I need to think about this a...

I manage a self-made database of property deeds for my business. Since it often happens that there are multiple owners and multiple buyers of these properties, and that many of the owners and buyers are the same people from time to time, I think I can manage this database more efficiently by...

Okay. Well that was fun. I started a new form. I don't think I did it quite the way you suggested, but it led me to the source of the problem. I had a couple of false starts in making the button to find my membership. Apparently it wrote visual basic code for each false start and saved it...