Search results

I have two tables with a one-to-one relationship. I’m using a form and subform to allow the user to enter data. When I test it by adding data in the text boxes on the main and sub forms, I find that a new record is added to the table bound to the main form, but not to the one bound to the...

Hi Rain, Again, many thanks, Henry

Hi Rain, Thank you very much for all the time you spent on this problem and for your patience. I have learned a great deal through the process. I did a little looking and I found that the Number of Columns property was set to 1. When I set it to 2, I was able to see the program names. Now I...

I checked. The caption lines for both tables are blank.

Yes, I deleted tblLookuptoAgyPgm and also frmEditAgysAlt. I wanted to clean up the DB, so I only kept the two tables you named, tblAgencies and tblPrograms, the form, frmEditAgys and the query, qryAgyPgrm. All of the other tables, queries, etc. that remain relate to other parts of the DB.

Hi Rain, Thanks for sending it. The table, tblLookuptoAgyPgm, is the one I created ealier on. It was the one that the alternate version of the form was bound to. I deleted it, along with the alternate version lof the form, before I sent you the last version of the DB (I just checked again, and...

Hi Rain, Thanks. I tried to read and print the image with three programs (word processor, paint, and presentation), and none of them made the type readable. I even tried a magnifying glass. No luck! Could you send it again? Henry

Hi Rain, I tried viewing and printing the image with three different programs (word processor, paint and presentation), and none of them made the type readable. Could you send it again. Thanks, Henry

Hi Rain, I guess I'm more confused than before. I'm looking for combo boxes within the tables and I'm not seeing them. You're not telling me to change the combo boxes on the form to text boxes, so where do I look for the combo boxes that are causing the trouble? I'll be out of contact for a...

Hi Rain, Thanks for looking at the DB so quickly. I got rid of the table called tblLookuptoAgyPgm. I also got rid of the table called switchboard items, which isn't being used. Now I'm confused. So far as I can see, there is only one lookup left, and that's AgencyFK in tblProgram. I don't...

Hi Rain, Thanks for taking another look. When I put ProgramName in the first column and AgencyPK (with the criterion statement) in the second, the combo boxes work properly. When I reverse it, and put AgencyPK in the first column. it doesn't work. This is what happens: When I try it with just...

Hi Rain, thanks for all of your posts. I had to work through them a couple of times, but I think I’m getting it. Part of my confusion about lookups is that when access displays a foreign key in a table it calls the field Lookup To _____. I read the link, and think I’m clear, although the...

Rain, Thank you very much for your corrections and for redoing my DB. I have some questions, though. You substituted a text box for the second combo box. That would allow the user to add a program name, but not to delete or to correct the name of a program that is already in the table. How do I...

Hi Rain, I tried to follow your instructions, but I couldn’t make it work. I started with the AgencyProgram table, and I broke it out into two tables: tblAgy and tblPgm. Each of them now has an autonumber primary key. I used field names with the suffixes PK and FK to designate primary and...

Hi Rain, Again, thanks so much. I see I have some work to do. I found the paper on naming conventions and printed it. I need to work through the changes. Actually, something interesting happened here. I used Analyze to create the tables from an original table with both fields. Analyze named...

Hi Rain, Thanks for looking over the database. I’m attaching a zipped file. I haven’t looked at the link yet. It took a while to sanitize the tables. Aside from deleting fields from one table, I had to change data in another one. There are two forms that relate to the problem. They are...

Rain, thanks for your new instructions. I tried to follow them, but I’m not sure I did correctly. I started with my original table, called AgencyProgram, which has three fields: ID, AgencyName and ProgramName. I used Analyze to create three individual tables. The main table is...

Thanks, Rain. I think I understand it, except for storing the Primary Key from the Combo's Record Source as a Foreign Key into the Form. Where do you store a primary key in a form? Since there are two tables, and each has its own primary key (both are Autonumbers), which one do I use...

The form is unbound. I was setting up a menu system, but it didn't occur to me that this form isn't a menu. Should it be bound to the query that unites the two tables (one to many relationship)?

Thanks Rain, By row source, do you mean the data property or the table? The table has data, and the combo boxes populate as long as they are unbound. The problem occurs when I specify the table and the same field as control source. I just noticed that I'm using a query as the row source and...