Search results for query: *

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

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

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

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

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

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 #]...

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

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

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

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

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

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