Recent content by Itaiz

Thanks, If i correct Startup is under tools, and I can't see it in toolbar but only file, window and help. I tried to reset MenuBar but it didnt help. And its not only there, when openning new query the drop down command for Design View, SQL or Datasheet View is disappear and many others...

Hello All, I'm developing using access 2003, during develop somehow the menu bar lost many icons and tool bar also missing the tools and window etc. does someone know how to put it back, I tried with customise but with no success. thanks Itai

Thanks for reply Is this valid to access 2003, do you have an example

Hi All, I wolud like to control Datasheet properties in the code according to the values I get in datasheet itself. Is it possible to change color of one field or one row in datasheet? is it possible to change it through code? If its possible and someone have an example it will be more then...

Solved that, it was my mistake, I changed the record source in the mainform in code. Thanks anyway

Hi, I created a Main form which has Subform control in it. This Subform is link to DataSheet Form. The DataSheet Form has DblClick Sub which is working fine when I open the DataSheet Form only. But when I open the main Form and I dblClick on the DataSheet , Its not enter to the subroutine. Now...

I dont have SourceObject for a form, only for subform control, The name "subformCustomers" is refer to the control on the main form or to the form itself. I think you change sourceobject of the control from form to query. Thanks, Itai

This is very similar to what I did in the beginning. But instead of cut and paste labels, you can create this form as Datasheet form (use wizard) bound to your customer table/query (then you dont have to cut and paste labels). In my little project it is bound to query. Like you did its in a...

Not Good!!!! I must use a datasheet form in subform and not a query, because I use dblClick on Datasheet. it cant work with query. Please advice.

Greate it works, thanks

Oh, Sorry I know what you did, it's not a datasheet. good idea, I will check it.

i dont have such an attribute "Source object". I put it in record source. (did it in design) Itai

Hi All, I built a datasheet form based on query. This form is a sub form in another form and should present resaults for searching. for make it dynamic I change the SQL in the Qeury it based on. The query changed, but when requery the subform there is no change on it. The following code is the...