Recent content by Tumby

I have a report in access 2003 that needs to be sent via email in excel form. I have 244 accounts that require this and most work fine except for a few. Trying to find the cause I noticed that in the table that controls the report, on the accounts that will not email in excel format, there are...

I have a report that is made up from a query using three different tables, Customers, Sites and Electricity. The report shows all data correctly but when it is sent as an excel sheet by email the data from Customer table is not showing. The headings are there but no data. What could be the cause...

Thanks for that but I don't know how to do that. Does code need to be written for the AfterUpdate event? I can't write vb.

I have a form with several date calculation. As follows: ContractStart- manually entered ExpiryDate - Selected from a calendar according to the contract time ReferBackDate - = DateAdd ("d", -180,[ExpiryDate]) ProposedNewStartDate - = DateAdd ("d",+1,[ExpiryDate]) All work fine except the...

My problem is- For the past two years it has been able to send an access report (via email) as an excel s/sheet. The last three new accounts will not allow this. I can see nothing wrong with the account set ups. I have tried all different ways of exporting the report to access with no...

I would like to thank you for all your help. I am sorry if I sounded ungrateful to Stephen I didn't mean to be. But it all sounded so complicated it scared me! However I will slow down, try what has been suggested and will not give up until I have cracked it. The sound of VB does scare me-...

Yes RuralGuy!

To-RuralGuy The boxes are as follows- MicroBusiness - a Yes/No box - check box with tick MEAC - a box which has a numeric value - bound MLessThan10Staff- a Yes/No box -check box - bound MLessThan2MillTurnover - a Yes/No box- check box - bound I'm afraid Stephens answer is much too complicated...

I have a form with the following boxes- MicroBusiness - a Yes/No box MEAC - a box which has a numeric value MLessThan10Staff- a Yes/No box MLessThan2MillTurnover - a Yes/No box The criteria for the MEAC box is- <55000 What I want to do is - If any of the last three conditions apply for the...

Thanks DocMan- I would prefer to do it on the form but thought it would be easier as a query, as you can tell I am quite inexperienced. I am using Access 2003.

Help!!! I have a form that has four input boxes - EAC : AQ: LessThan10Staff: Less2MillTurnover. I also have a box, MicroBusiness - which will display a tick if certain conditions apply. The conditions are- EAC = <55000 AQ = <200000 LessThan10Staff= a tick in the box Less2MillStaff= a tick...

Sorry RG but I just copied and pasted your formula and the missing part doesn't seem to be there. Where do I put the IIF(Test , TestTrue, TestFalse) syntax? I'm sorry to be such a novice you really have been very helpful and I do appreciate it. Thanks.

Thanks MS Access Rookie- I tried your formula but the form will not accept it- just jumps back to what I had before. I really do appreciate all the help this forum gives. With this forums help I completed my first database back in February, my client was so impressed with it- he's back for...

=IIf(Forms!frmBillCheck!frmlElectricRates.Form!MeterMultiplier<>0,[DayUnitsUsed]*Forms!frmBillCheck!frmlElectricRates.Form!DayUnitCost*Forms!frmBillCheck!frmlElectricRates.Form!MeterMultiplier/100*1000) Believe me, I did copy and paste. If I take out the 'frmBillCheck ' I get an #Name error.

:(That works fine for the zero MeterMultipliers but ups the cost by £1000 for the customers with a MeterMultiplier.:(