Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MissTinSC
  • Order by date
  1. MissTinSC

    Subform will not allow Record Additions

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

    Subform will not allow Record Additions

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

    Change Field to a LookUp

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

    Printing full name of an abbreviated state name

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

    Event ID 4000

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

    Relationships Problems

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

    Populating a text box from a combo box

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

    Populating a text box from a combo box

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

    Populating a text box from a combo box

    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)...
  10. MissTinSC

    Populating a text box from a combo box

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

    IIS5, SMTP, CDONTS failing to send

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

Part and Inventory Search

Back
Top