Search results

Thanks. At first glance, that could be exactly what I need. I'll start there check back as needed. I appreciate the help. Conor

I am quite new to Access. I am using Access 2007. I think I am dealing with a "classic" issue - including supervisor employee number on records and having them refer back to the same "Employees" table. I have searched the forum and found several references to "self join", but I cannot get any...

Shazam!! Works like a charm. Many thanks, Virginian.

Thanks, guys. Those sound like good techniques to put in my tool box. However, it seems that in the absence of a main/sub form arrangement, a random date, unrelated to today's date, cannot be maintained. Oh well... Thanks for your input. Conor

Hello forum, I'm a rookie looking for what I hope is a simple solution that I cannot find in help system. I have a data entry form with a date in a text box. I am entering one record at a time. I need to be able to change the date, but for multiple iterations, the date is the same. That is, I...

Thanks for going above and beyond. I dub you Sir Uncle Gizmo for service to the empire (and former parts of the empire).

I appreciate your hanging with me. I am such a rank novice that I need specifics. I'll try your approach. Can you tell me does this type of double referencing to a table have a specific name that shows up in the index of books on Access? Something like "repetitive referencing" or "circular...

This is my third go around with this issue. I've had input from several users, which I gratefully acknowlege, but I still cannot figure out how to do this. I've consulted Access help, books, etc. If this situation is covered, I don't know how to refer to it to find it in the index. I've tried...

Thanks, Banana!! I'm new, but I believe the key info is that I need combo boxes, and I believe that rules out creating the form with the wizard. That may sound simple, but it's one of those things that is not intuitive to rookies - or at least to me. I thought wizards could do anything. Isn't...

Thanks, Banana. If you like easy (?) challenges, how about looking at my post about 3 or 4 down the list about two team names? :o

Thank you, experts. The votes are in. Although I am missing the experience to assess some of the answers, its a unanimous decision - no lookup fields in DB tables. Now let me see if I can figure out how to mark this post as "solved". Again, many thanks for useful guidance. Conor

I am a new user and I am reading The Missing Manual for Access 2007 by Matthew MacDonald. He recommends the use of lookups fields on data entry forms (pg 162). I have received input from other users recommending against this practice, but for rather vague reasons. I wonder if a couple of...

Thanks for the input, Uncle Gizmo. I do believe I have a basic, workable DB design with a games table as you suggested. What I need is an answer to the specific scenario that I cited - my form returns the same name for both teams since both fields reference the same table. I am hopeful that...

A lot of sports involve two competitors (individuals or teams) at a time, so this question could apply to many sports. I want to display a simple form that has competing individuals or teams with both their names. Also other info like date or result, etc, but the names are the problem. I...

boblarson, Thanks for being interested enough to come back again. I believe the DB is attached. The instructions you sent were very helpful - necessary in fact. FYI, this is a 2007 DB, not 2003. I hope that is not an issue. As I said, I am a rookie. I understand that I know diddly. Nothing...

I'd like to thank boblarson for his reply, but it did not really help me. I'm not sure I can change the control source, because there is, in fact, only one table field for team name. The problem, I believe, is that I am trying to reference that field with two different team numbers - home and...

I apologize in advance for the likely simple-minded nature of this question. I want a simple database to track the English Premier Soccer League. Naturally I have a table "Teams" with team names and a unique autonumber as the key field. A "Games" table has game number (key field -...

I am working with Independent School Districts (ISD) in the state of Texas. The State is divided into 20 regions. Over 1000 ISDs are divided among those 20 regions. Each of the 1000+ ISDs has between 3 and several hundred individual school campuses. Each has a name, but as you would imagine...