Search results

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

Yes I'm using the = sign, just like in the example I posted. Start over huh. I'm certainly glad I wasn't 95% finished with it (where's that emoticon for dripping sarcasm?). I'll give that a whirl. Sure would like to know where I went wrong. I'll try to pay close attention to the names...

Pat I really appreciate your helping with this. As far as I remember I didn't embed any spaces. I picked those names off a list that was included in the expression builder. Obviously I did embed spaces, but I don't recall it. And when I tried picking the names directly from the table, I got...

Thank you so far. I'm making progress in very small strides. I did make a query that doesn't make a table, so I'm counting every success. That Access Help is next to useless for someone at my level of proficiency, by the way. I used the following expression in the Field column of my...

I like the paid through date idea. I've been doing it the other way. The criterion for membership is having paid your dues. Dues are due on January 1 for the next year. If you pay on December 31, dues are due the next day (theoretically if I want to be a jackas*s about it). Remember I'm...

I'm a babe in the woods on Access. I have a club membership db that I'm moving from FilemakerPro, so I'm starting over with many of the fields. I have a field on a form that figures out whether the dues are paid and iif they are, it pastes in the word, "Member," otherwise, "Non-member." When...