Recent content by RichStone

My database has worked fine with no prompts for absolutely ages. I'm still running Access 2007 too. My issue is that when I close the database using 'DoCmd Close' on each open form until the final Main Menu is closed, I've suddenly started getting a prompt with the buttons 'Save record', 'Copy...

I have several reports that use colour on them and print to a colour printer. Some forms I created work fine but others that were created before I had the colour printer but I've now added colour into the design are still coming out in greyscale. How do I get the printer settings to save with...

SOLVED! I thought of that yesterday afternoon and placed the formula into the query. It worked! Thanks for pointing me in that direction. It does seem that sums can only be done on precalculated values in the entries.

Apologies for the lack of response. I was pulled from this task for a while, but I'm back onto it now. I came up with a better idea but still can't seem to get it to work. I have now created a numeric field for each entry that is calculated on loading and is either the invoice balance if not...

That's what I tried. First I tried the name of the query the subform is based on and when that didn't work I tried the subform name iteself which still didn't work. [PaidDate] is not calculated. It is either the textual date or UNPAID. That is why I just wanted to check whether it was UNPAID or...

Thanks for your assistance, but I'm still having issues... Firstly, the PaidDate field is for visual use only, hence it shows either a date that has been converted to text, or the the label "UNPAID" so that is not a concern. The date on the subform runs from a query and not a table. Basically...

I have created a subform that displays a list of invoices for the client the subform relates to. Each entry shows either the date the invoice was paid or the text UNPAID in a field. In the footer of the subform I have a counter for the number of invoices displayed and the sum of all invoices...

I know that this subject has been discussed a few time on here but I'm hoping somebody can help me with a more direct solution. I have a database sat on our work server and each user approved to use it has a shortcut to it on their desktop. I would like to ensure that only one person can use it...

Issue solved. I used some completely different code I managed to find in another thread. Thanks for everyone's help anyway!

Thanks for the reply. I have copied the code into the Load event and changed the references to those in my database but now I'm getting a compile error that says User defined type not defined and the code is paused on the Dim instruction. Any ideas?

My database records the reference of the last record opened in a field on the main menu. When the records are selected from the main menu again I would like the record with that reference to open first. I tried setting a filter but I then can't move to other records. What is the best method to...

Thanks for the reply. That's basically what I had already done although only on the detail part of the form. However, there now seems to be another issue in that the form flashes every time I hover over anything or go back to the space. Does this method of detecting the mouse movement cause a...

I'm trying to use a text box to display tooltips in whenever buttons or certain fields are hovered over. I have used the 'On mouse move' property to update the text box which works perfectly. However, I can't get the text box to clear when the mouse moves away. I have tried using the property...

Thanks for your reply. This appears to work fine for opening the document but always brings up a window stating there may be security issues and asking me to click OK to continue anyway. Is there any way to stop it displaying this?

I have a single document provided by a client that I wish to open by pressing a button. What is the easiest way to do this? I already have strings called PubPath with the path to the publisher document and PubDoc with the document name.