Recent content by MarkyP

Hi - I think this can be quickly sorted. I use the following code in my query to merge together my customers details to 1 field: LeadName: [Title] & Space(1) & [FirstName] & Space(1) & [LastName] I want to do it for their address, what do i use instead if SPACE so that i get a NEW LINE each...

My query is a multiple table query across customer details, golf courses, hotels. As i build the query say with just customer details, then it is fine in that the customer details, name,address etc appear only once. The trouble starts when i want to know what courses they are playing at. If...

can anyone please please help?

Hi, I wonder if anyone can help? My email code is working fine in that it pulls certain info from my data base into an email. It also then merges it with a mailbody word doc template which has other text in it such as the ending of the message, my name, contact no and disclaimer text. The...

Nope - nice try - everythings ok in that I copied the ssql code from the query i wrote in to the module. The modlue still bears the right code but it has been stripped out of the actual query and i can no longer write it back in evenn if a start from a new design. What do you reckon - cheers Mark

I did about an month ago to get an automatic e-mail function working in module. I did some more quiries the other night and then pasted them in an application function in modules. I also copied the email code below the original e-mail code to run a differnt set of emails - (this might have done...

All of a sudden none of my queries work properly- all the criteria and calcs i had in them have been deleted?! Basic codes do not work any more e.g >now() ;between 1 and 30 etc If i try and write a new query using the same expressions and code they just don't like it - YET they were working...