Search results

Ok. I am able to email the entire form using the DoCmd.SendObject. Is there now a way to just email the currently selected record on the form instead of emailing the entire 1000+? Thanks!

Given my very basic VB skill level, would it be difficult to code a routine that would pull the email address out of a field and automatically send email based on the contents? The last question I posed was a little over my head, so I'm not sure if this will be any better, but what the heck ;-)...

Hello All. I have written (rather sloppy) code to update two other fields on my form based on a selection from the first field. Example is below: If Engineer_Name = "Mike" Then Email_Address = "mike@nowhere.com" Primary_Responsibility = "Hardware" The thing is, I have tables already created...

Hi all. I am trying to figure out the code for the following problem: I have a "Closed Date" text box that I want updated to the current date and time ONLY when someone selects "Closed" from a combo box control on the same form. Anyone have any ideas how I do this with VB? I have what I...

So, I've been studying VB and I'm trying to do a simple update from one record to another-Ex. if I select "Elektrik" in one field, I want the email address in the next field I have to automatically select "elektrik@mindless.com" so I don't have to enter it. I figure out the right syntax (I...

Hi all. I have a database that I want to change the contents of one field based on the selection of a certain value. The first field is a combo box that has several choices ("New";"Open";"Closed"...). This is my "Master" field-to which the slave field should reflect changes. The second field...