Search results

Had another look and after much googling and reading from the guide, I managed to get something working. Might be rough, but is doing the job I think Private Sub Command20_Click() Dim stEmailRecips As String Dim stSubject As String Dim stSQL As String Dim db As DAO.Database Dim Rs As...

Hi markk Thanks for the response. In all honesty, I am looking through google to get info, I picked up a book from the library on Access for Dummies lol but doesn't go into detail for Emails. I am trying to sort this myself without any help as I did with the website!. As for the database, the...

Any further help Markk m8? Cheers

I got a little progress after playing around with it Full Code Private Sub Command19_Click() Set cdomsg = CreateObject("CDO.message") With cdomsg.Configuration.Fields .Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 'NTLM method...

Hmm had another look Am I right in thinking that I'm looking at the code you put up as two seperate codes and in fact they are actually one code? Instead of me trying to put .to Select etc It should actually be .TO dim rst as dao.recordset set rst = currentdb.openrecordset( _ "SELECT...

Right OK, so where would I put that code you gave an example off? Also the select statement you did, was I right tibiae where username = username?

Hmm ok lol Error I get is the server rejected the address, error 553.5.1.2 or other puncuation after the email address. js5sm6331236wid.11 gsmtp I think its failing because there is nothing in the VB telling it to get the Username from table Invoices first. then to look at User and locate the...

What I am missing lol? It's been years since I last used Access. Can you break it down further Markk? Cheers

That looks good. Kinda almost identical to php and mysql scripting. So to form the "to" part for the email it would be: .To = "Select [Email] FROM Users WHERE Username = [Username]" and would it put your other part of the code "open a recordset" directly under this?

Hi Markk Had a look at CDO and that looks far better for what I need. I have several forms / tables as mentioned above but I will run the code on each form so I can add in the email message what table has been update to make it easy for customers to navigate too. What would be the correct...

Hi Markk Thanks for this, will have a look at it after the kids gone to bed. I have found something the appears to be working manually in Macros. I was able to setup "SendObject" and left most fields blank apart from the Subject and Email Message, I was able to set this as OnChange. It does...

Hi Markk Sorry I posted it in the wrong forum and thought I could delete the Macros one but couldn't Years ago I built a DB called Pyramid Databank with help from this site and I remember some had found something for SMTP, It was 2 files that you would put into windows\system32 folder that...

Hi guys I use Access 2007 as a front end to Mysql and would like to be able to send an automatic email somehow to a customer when data changes. The DBase is setup with Username as the key field and every other table uses this, tables are Users Appointments Invoices Estimates Payments Pictures...

I got the hyperlink section working in Ms Access instead of uploading a file, and using a link to my sql using ODBC 5.1 Driver I can see the link in a dynamic table, but it's not clickable?

Hi Spike Mysql does store the file within the DB but I am looking at changing this to just store a reference to the file stored in an FTP Directory, but haven't spoken to anyone yet for help on changing this in MYsql?

Hi Guys I am attempting to use MsAccess 2007 as a frontend to Mysql hosted by myself. Everything so far has worked correctly until I come to the upload picture part. I have this section working correctly with the website, I select the PDF file I want to upload and click submit and it is...

Added that sql into the query and works great, only problem... I cant delete the records that I select.. The option to delete is greyed out?

That looks perfect thank you. I didn't setup the excel price list, this is sent to me by the supplier so it is there ref numbers. Went I imported into access I created a new I'd field which is set to primary key Thank you again

Forgt to mention that the table source is imported from an excel doc

Access has appointed its own indexed I'd called I'd, the one that has duplicate entry's is my product ref. The Id is unique, product ref isn't. So I need something like Delete all From mytable field: product ref & price Where price is lower ?