Search results

Hi Rich No, its on a form not a report but I did use the Insert Date and Time function from the toolbar to put the date onto the form. Susan

Hi, hope you can help with what I am sure is a simple problem but has me stuck! I have a text box on my form to print todays date on the form =Formate(Date(),"Long Date") My problem is that when I review forms printed in the past this field, of course, shown the current date when I actualy...

Hi Tommy Sorry to be so long acknowledging your reply - I've been on hols! - Thanks very much for your help, the problem is now solved, cheers Susan

Hi hope you can help - I have created a parameter query to display all the data for one Company. The parameter query asks you to "Type Company Name". Seemed simple enough to me but my users are used to calling the Company by its short name ie Taylor Building instead of the full name Taylor...

Hi Carol Thanks very much - it's so simply when you know how!! Susan

Hello again, you are proving to be an invaluable asset now I've found you! Does anybody know if there is a way to change an ordinary form containing data from one table into a tab form. The data in the table is different for each contact, so there was no need to separate the tables, but can be...

Hi Rich Thanks very much - worked a treat! Susan

Hi, Could you help please. I have based a Report on a Query which contains a parameter prompting for a start and end date. What I am trying to do is include the start and end date (which are prompted for when opening the Report) in the title/heading of the Report ie Training from [start date...

Hi Joey Thanks for your reply, 'expense totals' is a calculated field on my main form, not saved, it just updates the calculation when you click on the 'Save Record' button. In fact I think I've cracked this database, at last. Just need to run it in parallel with the spreadsheet for a while...

Thanks so much for such quick replies. I have managed to overcome the problem by inserting a 'Save Record' button which recalculates the totals. (It also seems to make people feel better when they have actually physically saved a record) I'm sure I'll be back again with more queries before long...

Hi, I have just been reading the past few days and found an item that answers my question - in a round about way - by adding a 'Save Record' button I can update the Expense Totals field by clicking on the button. If anyone has a better idea I would still be interested. This will teach me to...

Hi, I have been stumped by a problem - I'm sure someone will have an easy answer. I have a Form with a subform the subform contains upto 4 items of expenditure and/or mileage expenses The main form has a Total Expenses text box containing the following : =[Expense Reports...