Search results

Hi Dave 28.02.10 doesnt work either basically if i set the system day to anything after 27.02.10 it doesnt work...the PC is set to UK date and time, any ideas ??...cheers Fi

Hi I have a report based on a union query, the date parameters for the report come from a form that opens with command button 'Print Report'. The dates are unbound and have default values of Date() and Date()-90 The report was working fine till this morning ie 01 March 2010, I changed the system...

thanks Kafrin...will try out a few things tonight, and hopefully come up withsomething...will post back..cheers Fi

Would this work do you think when creating new records ? essentially I want to be able to enter new records into the Main table that both subforms are based on from either of the subforms ??

Hi Joh024..thanks for your reply, afraid your suggestion is a bit beyond me at the moment...I am thinking about have 2 subforms that are either visible or invisible depending on the button clicked on the main form, but am having probs as I have the data for both subforms stored in the same...

Hi galaxio and kafrin...thanks for your replies, not the answer I wanted to hear though. :(..would have a suggestion to get round this ???...cheers Fi

Hi I had hoped to be able to choose from a combo on a continuous subform and by the selection make certain controls visible or invisible, it does do this however the selection in each new line on the form changes what is visible and invisible on all previous lines, is it possble to, by the...

Hi Neil...having read a few other posts I was beginning to think that this woud be what I would have to do, fortunately the DB isn't live yet so tis sort of change can still be done...I will continue to search for a way to do it though perhaps using VBA ?? thanks for replying ....cheers Fi

Hi, not sure the best to achieve this but think perhaps a Union query ?? I have an application table which holds the client name, intermediary name, adviser name and life insured name, the primary key on this table is ClientAppID Client Name and Insured Name are stored in tblClientMain and...

Hi..if anyone comes up with the same prob, other than finding a far better way to do the whole procedure;)...the way I got round it was by creating 2 reports essentially Page 1 and 2 with half the calcs needed, on each page, and with the print command button printing both pages one after the...

Hi..I used a tab control to do the various types calculations, essentially to make it easier to read in design view, the tab control itself is not visible for printing just the consolidated calculation needed for the end of each of the 10 years...bad idea ???

Hi..I have a report with 6 sub reports, each subreport contains a tab control with 200 individual calculations...probably not the best way to do this I am sure..each subreport calculates correctly and when I bring them together on the main report I can see all the calculations on screen...

Hi EZfriend and thanks for your reply ..I have tried your suggestion and it seems to be almost there, the new client is added to the list and frmClientMain opens at the new client but the msg box 'The Client is not currently listed.... ' keeps opening and when yes is selected adds a new client...

Hi I have this code from the following link http://www.access-programmers.co.uk/forums/showthread.php?&p=694123#post6941 which works really well , I would however like if possible to be able to open frmClientMain after the table has been updated with the new client at the new clients record so I...

Hi...I had more than 255 individual fields on the report each had an individual calulation in it, I am sure there must be a more efficient way to do this but dont have the experience to know how to go about it ...cheers Fi

Hi DCrake...many apologies for the messy code, the reason I said more than 255 individual calculations was that when I had more than this Access gave a message to say i had too many ?? does it sound correct that Access would not allow more than 255 individual calculations on one report ? cheersFi

Hi... I am working on a db which needs to illustrate the growth rate of an assurance product over 3 growth rates and for 10 years, introducers fees (it also uses IIf statements to determine whether the introducer fee is an amount of percent) and management charges are calculated on the value of...

Khawar..that's brilliant cant thank you enough...cheers Fi

Hi khawar..here it is if you start at 'frmClientPolicyLookUp' select client Smith click on 'statements' ths is the report that isnt working and which is based on your accounting DB sample...thansk for your help and if i can give you any more info please let me know .........cheers Fi

Hi Khawar...will do thanks having bit of diffs getting it smaller than 1400kb even when zipped though ...will get it sent asap..thanks again cheers Fi