Search results

Thank you for your help, that has worked perfectly, however now i am trying to rename the database and it spits out an error that it cannot find the back end but if i keep the old name is doesnt spit out that error. Any ideas?

Hi all, I have created a database which has been split the back end is on a server, and the front end has been sent to various users. We now have another company and instead of creating a new database i thought i could simply copy the one already created and delete that data ready for the...

Hi everyone, I have a form in my db called equipment, the form is set to a continuous for therefore all the text box's in the first row duplicate every time information is entered. This works very well for me. I have a field called MAC Address and this will only apply to the first item entered...

Thanks James, works brilliantly.

Hi James, Thanks for coming back to me, i keep receiving Run Time Error 424 With "If Me.Invoiced Is Not Null Then" highlighted??? I have tried this in the Forms on load event and the fields on click event and after update :-(

Hi everyone, I have a form called "Commission" in that form are two fields one called "Invoiced" and another "TelesalesCommission" The Invoiced field will have a date entered in to it, what i am hoping for is if the Invoiced field has data entered in it then the TelesalesCommission field...

Hi all, I have placed an unbound text box in my form and i am trying to get it to calculate a value, this is what i have put in the control source: =Nz([Amount],0)/([ContractPeriod],0)*5 There is an amount in the "Amount" field which i want it to then divide by the amount in the...

We have customers indeed that buy from us, items are purchased on a leased basis so if we sell for example 10 tvs at the cost of £100 per month for 36months in the equipment form will be the cost price so when it comes to work out commission we deduct the cost of the equipment from the total...

I have attached a sample database, all fields and forms have the same names in my DB, If you open Contacts1 form it has 3 tabs, the second tab equipment has a Total Box in the form footer which will total all the amounts entered and i want that value to be displayed in the commission tab under...

That sounds really complicated for me, i am a novice so is there any easy way?

Hi All, What i am trying to get is a value from one field in one form to another field in another form. The field has a control source of =Sum([TotalPrice]) the data is being saved on the form itself and not in a table. I have another form which will work out commission based on various...

Thanks for the great link, i have been researching and this looks like the best way to go however i am having difficulties knowing what i need to set my criteria to. I am a beginner in access so any help you can give would be greatly appreciated.

Sorry i wasnt really clear, I have a form called Equipment and in the footer of my form i have a a field with a control source of =SUM([TotalPrice]) this then provides the total of all the amounts in my form. I also have another form called Commission, inside that form is a field called...

Anyone have any ideas how i can make this work? the field has a =SUM([TotalPrice]) formula inside so my corresponding field has a Name? displayed not the value. Thanks for your help.

Hi Trevor, After searching online it appears that i cannot use the line "Set rst = db.OpenRecordset("Commission", dbOpenTable)" This is because my db has been split and i should use the dbOpenDynaset. I am going to give that a try but thought i would thank you for all your help.

Thank you so much by holding the shift down i managed to get in and delete the code. You are a life saver.

I have deleted the ldb files and rebooted but it is still not working.

Hi Everyone, I have a Split Database and i have been trying to arrange for one value in a field to duplicate in another, post is called ( Duplicating a value from one field to another) After...

It is set to DAO 3.6 and i have confirmed all the names of fields, forms etc but it is still bringing up the same error :-(

i am sorry but i have absolutely no idea where i need to look for this.