Search results

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.:(

Hi again! That did work up to a point- THANK YOU But the result is the answer needs to be multiplied by 100 to get the correct answer. example- My answer is .3351598 and should be £335.16. but the records with a multiplier are correct. If I were to delete one of the '/100' in the formula...

Hi again RG, Sorry to be such a pain! This is what I am using- =IIf(Forms!frmBillCheck!frmlElectricRates.Form!MeterMultiplier<>0,[DayUnitsUsed]*Forms!frmBillCheck!frmlElectricRates.Form!DayUnitCost*Forms!frmBillCheck!frmlElectricRates.Form!MeterMultiplier/100) This produces a blank control...

Thanks for that RG but it didn't work. I have notices that my Main form is not updating. I tried to do the calculations in my main form but I keep getting #Name error. The calculations work when I put them in the controls of the subform using the subforms of both BillInput and Rates (except...

If the MeterMultiplier is zero- I still want the other values to calculate an answer- ie, UnitsUsed x UnitCost divided by 100 as the unit cost is in pence per unit and I want the answer in £'s. I have a form-BillCheck with a 2 subforms, one Rates the Other BillInput. The MeterMultiplier is in...

HELP! I am having problems with a calculation where one of the values is sometimes zero. Part of the calculation is a 'MeterMultiplier' which can vary from customer to customer, however sometimes the value is zero. The calculations work fine as long as the MeterMultiplier is not zero. When...