Replies

Thank you for your interesting suggestion. I will definitely process it in the future because it has many advantages.For the time being i am having troubles with the design. Is it possible to call the before update event in the subform in a datasheet view, only if the control button TglUnitprice is not pressed ? I mean to set an If clause in the before update event ? If you answer me that it is not possile, then i will have to reconsdier my whole design

kind regards

solar

Clicking on the unitprice itself is not possible because of the befor eUpdate event. It is true, i can write the new price in it, but then i cannot update it, i am given this warning message from the BeforeUpdate event and i am thrown out of the line.And also, i didnt mention it to you, but i have locked the control Unitprice so the user should not change the price unless he uses the control on the main form, and in the Onclick event of TglUnitPrice i am unlocking the unit ptice too.I cannot suggest myself any way out of it, i can only describe to you in full detail what we are doing and what i want is to get it working.So i will be grateful for any advice, i could also change the whole approach only to get it working. Thank you in advance
kind regards
solar

This command button is very important to me, only i cannot explain it well, since the importance is lost in cutting off the real database.The function of this button is the following. After i choose a product, then the control appears and if i want to change the price, on clicking the button i go to the control untiprice and there i can manually enter another price, not the price that is calculated automatically.However i cannot go to this control since the message appears due to the before update event in the subform.This before update event is also important to me.Please help me solve this problem.

How can i transfer the value of the eee field programatically.? When i have a blank table i have to move by hand from the first position, write eee and only then my code works.I want to do it programatically as :
Public Function UpdateCompanyname()
Dim sqlstring As String
sqlstring = “UPDATE TblClients SET CompanyName = ‘eee’WHERE Clientid = 1”
CurrentDb.Execute sqlstring
End Function
Of course with a blank database it will not work, but is it possible to do it by code ?

Thank for your precious help ! And now everything is just fine ! I got everything in order and my code runs smootlhly

the following command is not effective :
Dim SQL As String
SQL = ” INSERT INTO TblClients ( Clientid, CompanyName )SELECT [Clientid]+1000 AS Expr1, [TblClients].CompanyName FROM TblClients;”
CurrentDb.Execute SQL

yes , yes, i ran with Run and it works ! Can i make an sql and then run the command ” Currentd,execute sql ” ? How should i do it, since it is not a simple sql ?

Thank you for your reply.Please help me because this is so important for me.First i cannot find the Run button.I cannot see it . I also went to view/toolbars/customize and selected everything about query but could not find the Run button..Is there a way to acomplish with with an sql and then use the command CurrentDb.Execute SQL.It will also be much easier for me to convert all the tables.
I need to begin my tables with a new autonumber, while leaving the old autonumbers as they are.For example i have a table beginning with 5000. Now i want to add a new autonumber beginning with 500000 but not delete the numbers with 5000.So my aim is to place a new autonumber.
Thank you for everything

solar

i did it but again i failed.But i am sure i havent done something properly

Thank you for that. I immeditely tried it with success !

What a good idea ! It saves so much time and efforts !

The names of the months stay visible on the option box. What i mean is the labels above the control where the result of the option box is shown. When i choose a month, the result appears on the control of the form. I want, above this control, to have a label for each montn. The label for january with name M1, shoulkd be made visible only when the option january is clicked.But when i clik on another month, the label for january should be made invisible. When i click on another month, only this label should be made visible. For me it is very difficult

kind regards

It just works fine.Thank you

Thank you ! works great !

Yes Hans, everything is OK now. My report shows the right figures !!!
Thank you !