Search results for query: *

Remou and TheAceMan1 -thanks for your replies to my question. You pointed me in the right direction and I was able to solve the problem. I had to recreate the Finance table to include an alumni id field that related to the AlumniDatatbl and AlumniID primary key. It is working. Thanks again for...

Help, please. I am trying to add a subform to a main form. The data for the main form comes from the ASlumnidatatbl. It is organized into "pages" on the main form. I have added another page onto which I have added a Financefrm subform. I used the wizard to create the subform to open, filtered...

I inherited an old DOS database and have been updating it through current versions of Access. Unfortunately, it has many quirks that need to be cleaned up. For example, data entry folks enter state abbreviations (this is not a Look up field)as part of the addresses. As you might imagine, there...

I have a database that uses postal abbreviations for states: az, ak, sc, etc. The user keys in the abbreviations. I am creating a report that lists alumni organized by state. I would like to be able to head each state section with the FULL name of the state (az- Arizona, etc). Is there a way to...

Dear Inusrat, I am looking for solutions to my SMTP/CDONTS problem which sounds like the problem you dscribed. Did you ever resolve the issue? If so, how? Thanks, MissTinSC

I have a db with several tables. Each table has a primary key autonumber. I have created a corresponding field for each table id in my MainData table (ie, Classid, parentid,...) I have used these to create relationships in queries, and in the relationship window) Problem #1:In the...

Oops! The problem is not completely solved...The data now comes from the Classtbl and shows up beautifully on the form... BUT ...it does not update the information in the MainDatatbl. Is there some code that will do this (flush the choices from the Classtbl into the MainDatatbl)from the...

Eureka! That did it, Ken. Thank you so much! Now I can move on! Yay! MissTinSC

These are, generally, the two tables involved: Classtbl ClassID (primary key) LeadTeacher Classroom Assistant MainDatatbl StudentID (primary key) FName LName Street City Phone Teacher (lookup) Class (lookup) ClassIds (long integer) Relationship is MainDataTbl: ClassIds...(many)...

I am having a problem and would love to have your help. I have a MainDatafrm that is built from the MainDatatbl. The MainDatatbl has a field for LeadTeacher and also ClassName. I also have a Classtbl that serves as the list table that enables a data entry person to select only the classes...

Check the Mail to: addresses to be sure they are properly set up. Syntax is quite important here. MissTinSc