Recent content by lazynewt

Re: resolved. i had an error with my filter code. - f.Filter = "[DOB]=" & "#" & Me![DOB] & "#"Problem solved.

Im not sure if im explaining myself correctly or i might be missunderstanding. 1 main form = linked to nothing (this is just a blank form) subform1 = contans listed data from table1 subform2 = contains listed data from table2 i am trying to have 1 button per record in table1 that when...

is this wrong ? f.Filter = [DOB] = " & Me!subform1.Form!DOB"i can see the refresh but it doesnt seem to be filtering. :confused:

will that relate to specific record that the onclick button is in ? thanks

Hi guys i have 1 mainform and within this i have -subform1 ----this form contains listed data -subform2 ----this form contains listed data subform 1 has specific data which is [dob] which is pulled from table [customers] subform 2 also has data [dob] which is pulled from [apps] There is a...

Ok I figured i should be using Private Sub form_load(Cancel As Integer) Me.emailattribute = "1" End Sub instead but this only inputs 1 into the first record. i am trying to get it to imput 1 into every record the query returns....

- I have a query that checks 2 tablles and if the records email address in tableA match the addresses in tableb then it returns name,address,area,postcode,emailattribute of the records to a form. - the form on open event is Private Sub Form_Open(Cancel As Integer) Me.emailattribute = "1" End...

Thanks dmonney. I agree getting rid of the popup whilst maintaining security is a bit challenging. After some searching i found that mapilab have a free add on for outlook that fixes this issue. Heres the link incase your looking in future. http://www.mapilab.com/outlook/security/ thanks for...

ok i think im getting somewhere. This revised code will close the book if cell a1 = 1 if it does not equal 1 then it will send an email. Just need to check the ontime event and add the code you gave me dmonney. Also I will need to bypass that annoying warning outlook gives when sending an email...

Thanks dmonney i can see how that will work. Ill test it asap. on a side note this is the code im "trying to use to check cell a1 and ontime send an email. Im getting an error at Set rng1 = Worksheets("test2").Range("a1") code is Sub sendemail() Application.OnTime TimeValue("09:09:00")...

This is a bit of a mixed request. I have a button that needs pressing around 3-5pm every day. iF this button is not pressed by 5pm i want to send an email to 3 addresses as a warning "these can then be forwarded to sms's for a realtime alert. My idea so far is 1. if the button is clicked it...

ahh i c Thanks ErikSnoek. works like a charm. I just added the [data] tags to the php code and all is well. Still alot to do manually but im sure i can figure out how to make everything done automatically. Youve been a real help especially with the explenation. i know this code will come in...

hey ErikSnoek Its the carriage returns that im concerned about. I Can see what you mean and i will try this tomorrow. My only concern was that it wouldnt be valid csv. Ill post back and let you know how i get on. This is what im up against though this is the exact file From: dave Sent...

Hi ErikSnoek thanks for the help :). Whilst waiting for a reply here i decided to try handle things from the server side. I have modified the php script to output the form to a csv file. I am then hoping to send this to a folder on the network and use the code you have supplied. The reason for...

Hi ive got a php script sending me information in the body of an email. The info is kind of in csv format name,address,time,date I am trying to figure out a way to import this into an existing database. Can anyone help me on this? I can save multiple emails to a text file using outlook but...