Search results

working version but lil glitch... strSQL = "UPDATE tblNotes SET tblNotes.[VisitorTrail] = tblNotes.[VisitorTrail] & '" & Me!txtUserID & " " & txtDLookupAuthorName & " " & Now() & vbNewLine & "' WHERE tblNotes.[NotesAutoId]=" & Me.txtNotesAutoID & ";" The code works fine. But i get write...

Search Helps... I wanted to Thank Jon for his brilliant donation about carriage return. A carriage return usually contains two characters: chr(13) for a carriage return and chr(10) for a linefeed. My code is now working and i have a carriage return between two fields. LastVisitor...

Where Clause... I tried following, It runs smoothly and data gets populated in a new record strSQL = "INSERT INTO tblNotes ([VisitorTrail]) VALUES('" & Me!txtUserID & " " & txtDLookupAuthorName & " " & Now() & vbNewLine & "');" How do I implement where clause Thanks = = = Wayne's Code = = =...

insert into sql error What is wrong with the following sql statement. Please see print screen for error. My Goal: I am trying to grab user id, user name and today's date into a memo field call VisitorTrail. I would like this field to grow. So, data is added to old data in the field. Also, How...

Got it.... Mid([ssn],1,3) & Mid([ssn],5,2) & Mid([ssn],8,4) It's now working with above code. Thanks for all the help and hints. THANKS THANKS THANKS

Both Method failed.... The last method (SEE ATTACHED PRINT SCREEN) Failed too. 444-55-6666 is now 444-55-66 Any idea ???

... From SSN, If I take the bracket of from SSN and then NewSSN is sorrounded by " and after runing the query it replaces all the ssn with NewSSN, the actual wording.

hmm, that did not work... Check out my print screen, May be i have it all wrong. But it's not working. It's prompting for NewSSN.

Hyphen or dash whatever you want to call, I need to get rid off it from my social security number. The field name is SSN. Replace([SSN],"-","",1,12,0) will NOT work because Access 97. Is there a remedy to replace - with nothing.?

Jack Rules.... Yeahhhhhh Re: Validate E-Mail Address... [Re: doran_doran] Posted on 08/11/04 01:03 PM Posted by babrandt - Utter Access Addict Posts: 134 - Loc: N. Virginia • Edit As I alluded to in your previous post, you might want to use the Like operator to attempt to validate email...

I found following article from this forum. But where would I plug the code in my existing code. http://www.access-programmers.co.uk/forums/showthread.php?t=30974&highlight=validate+e-mail+address === My Code === Private Sub cmdSendMail_Click() Dim db As DAO.Database Dim rst As...

on click Assuming you have a text box (name txtTimeStamp) on your form which is tie to some field in your table. You can create new field "TimeStamp" in your table. Private Sub Button_Click() me.txtTimeStamp = now() End Sub

Working Version.... Private Sub cmdSendMail_Click() Dim db As DAO.Database Dim rst As DAO.Recordset Dim Recipients As String Set db = currentdb() 'Set rst = db.OpenRecordset("tbltmpRecipients", dbOpenDynaset) Set rst = db.OpenRecordset("Select * from tbltmpRecipients...

New code... Thanks for the help. The new code is working like charm. However, if user put an e-mail address into the subform and take it out then is not working. I wonder why. The subform looks like it has one blank record. Beside that it's working. = = = New Code = = = Private Sub...

I am using following code to collect e-mail address from a subform to a text and then e-mailing them. I would like for system to pop a message "You must populate at least one e-mail address" when the recordset is empty. The following code puts all the records in a field call...

I am using following to send mails from my access database. But getting an error on following lines Session.Initialize () MailServerName = Session.GetEnvironmentString("MailServer", True) Set dbDirectory = Session.GetDBDirectory(MailServerName) Username = Session.Username Thanks in...

Genius WORK Hello Scottn, YOU ARE GENIUS. IT WORKS LIKE A CHARM. THANKS A BILLION FOR BEING SOOOO PROMPT AND HELPING ME.

Almost Working... Hi Scottn, We are almost done. Only last record is being pulled. Me.txtTotalRecipients is a text box on my form to save this. Code ============================================= Private Sub cmdSaveMail_Click() Dim db As DAO.Database Dim rst As DAO.Recordset...

Ok, I can gather all the e-mail addresses in my temporary table. Showing in the subform on a main form and they are not tie (form and subform). How can I get all the e-mail addresses together seperated by comma before hitting "Send Mail" button. Thanks My Lotus Note Send e-Mail Code which...

sure.... Put an Event after update which will e-mail the system admin (you may have to hardcode the e-mail address in your coding). You can find lots of article how to send e-mail on this forum. Good Luck.