Search results for query: *

I once had the code to double click on a cell (Excel) and it goes into the clipboard. How would I be able to double-click on a field to select it all and place it in the clipboard? Thanks

I'm going for On Dirty because I'm the only one entering data and everybody else gets a copy that can't be edited. Thanks for your help.

Thanks and that did work. But... :) But the date won't show up unless I actually save the record. Anyway to fix that? save when Tab is hit?

I kept reading about Triggers and what I'm trying to do is I want a date change everytime I update a record so I know when the record has been updated. Help? Thanks

I have the infamous Synchro combo boxes that when I select the Section of the person works in, their available titles show on the next combo boxes. So in my main form (frmMain) How do I keep the data in the current record? Everytime I go to a new record , either add or search...the synchro Combo...

I use the code below to send Form data in an e-mail. What this will do is transfer the current data and place it in the message body depending on what fields you have. Make sure you have the Outlook reference Private Sub M1_Click() Dim strEmail, strBody As String Dim objOutlook As...

wow, I didn't even know that. Thank you.

I am sooo lost here. Do I have the tables right (as described above)? Do I need a relation from SectionID (PrimaryKey) to fKeySectionID and is there some queries that need to be made? I guess I seen so many examples that I have blended in all of them and lost myself. So as I described above...

Thanks for your prompt reply. I'll read it over and give it a try. Hey...that rhymes!

I'm trying to follow other people's examples and also Microsoft's. Help? Two Comboboxes: Combo1 is Section and Combo2 is Title. There are 5 different Titles in a Section. ' ****tTitle (TABLE)***** ' iTitleID = Primary Key ' Title = name of combobox for Titles ' SM_Title = Name of title...

From a Subform within a Form, I am selecting persons, then I click on the report button to generate the Report of the list of people with other info. The report works but thier names and everything I have in the query is showing up twice. I only have the fields on the Report one time. Thank...

Thanks for your input. I'm learning tons of stuff here.

I'm stumped! Code follows: strBody = strBody & "(W) " & Left$(Work_Phone, 3) & "-" & Mid$(Work_Phone, 4, 3) & "-" & Right$(Work_Phone, 4) & Chr(13) strBody = strBody & "(C) " & Left$(Cell_Phone, 3) & "-" & Mid$(Cell_Phone, 4, 3) & "-" & Right$(Cell_Phone, 4) & Chr(13) & Chr(13) strBody =...

Yeah I did, no results. Any hints Thanks for your help by the way

I am producing an e-mail message to produce the contents of the current record from a form. When the Home, Work or Cell phone isn't present, the e-mail form doesn't work. Any suggestions? Code follows: Private Sub M1_Click() Dim strEmail, strBody As String Dim objOutlook As...

I entered the following and I get errors: Procedure Declaration does not match description of event... tMain is the main table and iSMRecord is the record number. Private Sub Mail4_Click() On Error GoTo Err_Mail4_Click Dim stDocName As String Me.RecordsetClone.FindFirst "[tmain] = "...

Yeah, that does help. Now, the e-mail message is going to be based off the current record. Do I base the command button off of a qry? Thanks for your help

I'm beginning to see there are tons of ways to e-mail from access... I have a db of 200+ clients with thier info, I would like to click on a button from the client form in that record to send an e-mail with thier data in the message, ie Name, address, other info. The message would be in text...