Search results for query: *

Thanks ever so much for that Roy, my database now works 100% perfectly now, better than I hoped it would from the off! Thanks for taking time to help me out and thanks also for the tips, I'm sure I'll be back! ;-) Stu!

Sorry for the late reply to this post. Many thanks to Roy-Vidar as my database is now working almost perfectly. It does everything I want it to. The only 'problem' I now have is when I update a record it returns errors when it creates a letter. As I am using a form to input data to the...

Thanks for that. What do I do if there is no text at all in a certain field though? This tends to return an error. Is there a way I can say something like this: If any field = "" Display nothing/or ignore If I can do that then it should work fine. Thanks again

Hi folks, Can anyone help? I am producing reports from a form linked to a database. The reports take the form of a letter and there there is an address displayed top left for the envelope window. The problem I have is that the address covers 5 fields (line 1, line 2, line 3, town, post code)...

I have tried this but it hasn't quite worked. It's actually a text box that I'm using to display the data in the form. The form is displaying the message "#Error" in the place where the name should be. The code I used was: =[First_Name] & " " & [Surname] ...as the control source for the text...

Hi Folks, Is it possible to display the contents of two fields in one label of a report? I have a database that contains names, addresses etc. A report can be produced which is in the form of a letter. Because I use the fields 'firstname' and 'surname', when I get to the first line of the...

Nowell, I could do with a few tips on how to do that, if you're able to provide them? Thing is, I did courses on all this at college but it's that long since I didn't it I can't remember for the life of me what I actually did! I suppose once I touch on a few things It'll all start to come back...

Hi Folks, I'm new to the forum but I need some help if possible. What I need to do is export some data from Access to Word to create a letter, which will be sent out to people that enquire about certain things. The table in access will merely have a persons contact details (name, address, post...