Search results

I'm creating mailing labels, I have customers all over the world and I will be using the same query to create all labels. I need the query to only give me the country name if it is not England, Scotland or Wales. Will Access let me specify this? If so, what do I tell it to do? Is it something I...

Apart from the top ones, the rest of the data is moving up so it isn't in line with the labels anymore(if you see what I mean). It is still spaces out and the space between the two columns stays the same. It is quite hard to explain and it would be hard to demonstrate I think. I was hoping it...

I have sorted this issue out now, just made the width a couple of mms smaller. :rolleyes::o Ref the main problem; I have also tried using a template file but it just seems to ignore this... :confused:

Bear with me, I'm still learning. If you have been following what I have been posting in other sections you will know that I have been trying to export labels to Word. Long story short - it was pointed out that I didn't need to export to Word, however after consultation with my End Users it is...

I think I've worked out why, Access will not recognise my custom labels, they are 2 across by 4 down but when I put the emasurements in it gives me 2 across by 3 down. I have a template in Word that I normally use and it works fine. Is there any way I can tell Access to put 4 down. Plus, when...

Could somebody please have a look at my DB (attached). Following on from this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=177617 I've 'tried' but I think I've failed miserable and I just can't get it right in my head! I can't yet think like a programmer - is there a...

Ah ha, there's the vital piece of information I have been overlooking! :o I've been too long working with Excel! :eek: OK, so my End User wants to see the labels before they are printed but not necessarily edit them(out of interest - could they edit the labels or would it have to be in Word to...

:o I should've explained, I don't know how to do it, generally! I know how to create labels, using the reports tool but I don't know how to create the code to make a report read a query and then export to Word. :o:o

We have custom address labels and I have saved these as a template in access, so when I use the label tool in reports I get the right size, I just need the user to be able to do it by pushing a button on a form as apposed to going through the report route(as they see it).

I apologise if this topic has been answered before.. I'm creating a database for a set of end-users who are unskilled in Access. I need to create a custom form for them to be able to create labels from a set of criteria they pick - I already have the queries I would like to use, would I be able...

I apologise if this topic has been answered before.. I'm creating a database for a set of end-users who are unskilled in Access. I need to create a custom form for them to be able to create labels from a set of criteria they pick - I already have the queries I would like to use, would I be able...

I apologise if this topic has been answered before, I tried to search but I get a blank page. I'm creating a database for a set of end-users who are unskilled in Access. I need to create a custom form for them to be able to create labels from a set of criteria they pick - I already have the...

Thanks The Doc Man that's really helpful. :)

Thanks Paul, I feared that would be the case. Could you tell me how I would go about creating the query after I've done this?

Hello, I am creating 'searches' for users using queries and custom parameter forms. I have a large list of customers and the brands they take from us, I want to create a query and form to search for stockists of certain brands in certain areas(regions, counties etc). Now the easy solution...

Thanks for that. It looks very complicated :eek::o Haha! I'm sure I can work it into my database. :) Thanks again.

Hello again, So I have error handling in the code of my Custome parameter forms to make sure that the user does not get bombarded if they decide not to save an export. However, this obviously just corresponds to error number 2501. I would like to create a msg box that pops up when any other...

Thanks both, not sure what happened but I had 2 posts! Have put error handing in and is now perfect. Thaks again.

Thankyou Very Much :D

Hello I have a custom dialog box which has combo boxes to choose criteria for a query and then exports the query to Excel. The problem comes if the user gets to the 'Output To' save box but then decides to cancel I/they get Run-Time Error '2501': The OutputTo Action was cancelled which then...