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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by qitcryn

  1. qitcryn

    Simple form Question on Unbound textbox

    " Are you asking for the code to save the new record, update the view and clear the new record line? " The first...I want to enter data in the unbound text boxes and have data save to record set in the subform.
  2. qitcryn

    Simple form Question on Unbound textbox

    the data is contained in the table.. so heres what i have: Table: Customers Field: Cust # Field: Status (combo) from status table Field: Calldate Field: Paymentamount Field: Paymentdate Field: Followupdate Field: Notes This table is in a subform named; Customersubform. According to others, i...
  3. qitcryn

    Simple form Question on Unbound textbox

    Hello TheAceman1, I haven't tried anything, becuase i don't know how or where to begin. I don't know how to (or remember how to) have data entered in an unbound textbox, and populate to the field in a form. I've searched online, and i'm just rattled...So i put the project away for a few hours...
  4. qitcryn

    Simple form Question on Unbound textbox

    thread702-1309854 The previous tread help in adding a rom of unboind textboxes.. but now i need to know what coding to use on the unbound text boxes, so the data can be populated ?? So i have in the form called customers subform from a table called cutomers the folowing fields: -Combo box...
  5. qitcryn

    Query all but Filter !1

    thank you ,, thank you...the article helped out. :)) I actually.. I figured it out.. In the tables i have, i should have used Right join... So, the query looks at the aging and customers and shows all accounts in the Aging table and only last call made, whether a call has or has not been...
  6. qitcryn

    Query all but Filter !1

    wait...i forgot the call date SELECT Aging.[Cust #], Aging.[Sales Rep], Aging.[Customer Name], Aging.[001-030], Aging.[031-060], Aging.[061-090], Aging.[091-180], Aging.[181-365], Aging.[>>>-365], Aging.[Total Past Due], Aging.CURRENT, Aging.[Tot Outstand], Customers.[Cust #]...
  7. qitcryn

    Query all but Filter !1

    Thanks for your reply.. The SQl looks like this: SELECT Aging.[Cust #], Aging.[Sales Rep], Aging.[Customer Name], Aging.[001-030], Aging.[031-060], Aging.[061-090], Aging.[091-180], Aging.[181-365], Aging.[>>>-365], Aging.[Total Past Due], Aging.CURRENT, Aging.[Tot Outstand] FROM Aging LEFT...
  8. qitcryn

    Query all but Filter !1

    Needing help on this: I have 2 tables Aging & Customers The Aging Table has current account info.. The Customer Table has all calls to each account. I need a query to look at all the records in Aging Table & Customers Table and show me all Aging records that have been called & not been called...
  9. qitcryn

    Desktop Intelligenc Cell Formating

    Found the answer & looks like this <a href="mailto:joe.doe@yourcompany.com?&subject=Order Release Approval&body=Please%20provide%20the%20following:%20%0A %0ACustomer%20Number%20=%20%0ACustomer%20Name%20=%20%0AOrder%20Number%20= %20%0AOrder%20Amount%20=%20%0ASales%20Rep%20=%20">Email Credit...
  10. qitcryn

    Show record to be added first - How to

    101287(MIS - did you ever find a work around to this.. ii have the same issue..tring to have the blank (New *) record show 1st in the list not last or at the bottom. Thanks, Ivan
  11. qitcryn

    How can I open the default email editor in MS Excel?

    what if you want to mask the e-mail address to where the cell just shows someones name and not the coding?
  12. qitcryn

    Desktop Intelligenc Cell Formating

    I'm trying to format a cell to show e-mail as "Credit Deprtment" but the e-mail string is {Joe.smith at abc.company}. Need help with that, and would like the e-mail to populate subject field with "Credit Approval"....please help..
See more

Part and Inventory Search

Back
Top