Search results

Thanks Rich, I haven't had chance to apply it yet but I will do so over the weekend and your solution is better than the colour idea anyway especially as I hadn't taken into account someone might have colour blindness Paul

How do I write an event procedure to change the colour of the title text of the tab control if the control contains some text,ie: Is Not Null so that it would indicate to operators that they need to click on the tab as it contains information

Thanks John your solution was absolutely spot on.

How do you set up the property for a field that contains an e-mail address so that it will open up outlook automatically and enter the e-mail address in the send to box - I have tried hyperlink but this will only work for web sites and also by creating a hyperlink/e-mail field but this has to...

Thanks, I'm sure what you have suggested will work.

I want to insert the name and address from the current record on a form into a Word document which contains mail merge fields. It is simple to use a query for mail merging multiple records but I have no idea how to insert a one off record. I know it has to be done from the Access end otherwise...

I haven't explained my problem very clearly. I want to insert the name and address from the current record on a form into a Word document which contains mail merge fields. It is simple to use a query for mail merging multiple records but I have no idea how to insert a one off record. I know it...

I have 3 note fields which are selected by a tab. Is there a way that I could use some sort of flag or indicator to indicate that the note field contains information. For example change the colour of the tab to red if the note contains information, it would save having to click each tab to see...

Can I write a query that will select the last (current) record I was in on an input form. So I can then put a command button on the input form that would run a macro which uses the query for complete an action for that record only.

The problem is the form IS the report and stores the information directly into a table rather than output through a report process, I will look at it but it may store both versions in the table which will be no good, thanks for your input.I may be asking for something that cannot be achieved, I...

This solution is perfect if you only want to send the report to the same output device every time but sometimes I need to send the report to a different device, so what I would like to do is put two command buttons on the report that you could select to send the report to different printers.

Thanks, I had seen an article on PrtDevNames and intended to follow it through as it seems to be exactly what I need, but it will need a bit of time for me to get my head round it and test it out as it is quite advanced stuff for me. But I am grateful for your help and pointing me to the...

Surely this would use whatever printer had been selected previously - what I want to do is get it to select a specific printer, for example I want to print a report that comes out on a HP printer in the back office and another report on a Brother printer in the front office so I need to specify...

This solution should be ideal, it will be a few days before I can get to try it out though, thanks for your help

What code do I need to use to get a report to print to a specific printer ?

Thanks but it doesn't solve the problem, because it would send the complete report which is about 500 pages not just the selected sheet and I need to send it by e-mail not fax, the other thing is that it needs to be done by pressing a command button as most operators would get confused with...

Thanks for pointing me in the right direction, you have put a lot in there which I will need time to get my head around, but I'm still not sure about using Snapshot to view the formatting as there are a lot of lines for sub-totals and calculations for working out taxes & I know RTF doesn't...

I have an input form which creates a quotation and normally I just print it off, I now want to be able to e-mail it, bearing in mind only the current record needs to be sent. I have tried expoorting it as a text, excel & RTF file but it comes out as columnar and nothing like what the form looks...

I have an input form which creates a quotation and normally I just print it off, I now want to be able to e-mail it, bearing in mind only the current record needs to be sent. I have tried expoorting it as a text, excel & RTF file but it comes out as columnar and nothing like what the form looks...

I have a form with 2 pages , the first page is an input to a table. I have created a Print Command button using the Printout macro command. I choose Selective rather than Print on the Printout Macro Command so that it doesn't print all the records stored in the table. However this option...