Search results

Anauz Would you be so kind as to email me a copy of your resizing code I would be most appreciative. Bry

Got it sorted. It appears that access will only allow you to update data in a query if there are no more than 1 one-to-many relationships - my query had 5. This is proberbly down to bad programming skills, however i am not responsible for the design. I am the 4th person in my company to try and...

How do you update data in a field, when the form(containing the field) was based upon a query? I have many fields, half of them are for display purposes only, the other half need to be updated. Thanx, Bry

Got IT! - Thanks for looking at it everyone. I had to create a macro to do what i wanted, the converted it to VB, then i just pasted the code and BINGO! Thanks, bry - here is the code Private Sub Pipe_Material_LostFocus() If IsNull(Me.[pipe material description]) Then...

No, that doesent work either ott. I've tried many variations but seem to keep getting this message:- Run-time error '438' Object doesnt support this property or method Thanks, bry

Hi all, Can anybody help me! I have a main form called "network data form_2" with 2 subforms called, "Material subform" & "Pipe diameter subform". What i whant to do is for a control called "network info source" (which is on the main form) to get the focus when a field in "material subform"...

Hi, Does anybody know how do vertically align control boxes in access. I know that if you click the vertical tab in properties this will work but the orientation is still wrong, i need it another 180 degrees. Help please, bry

Hi Jack, I still cant get it to work, i get does not support property or method. If i leave the "Me." out it just crashes. Thanks anyway, bry. Private Sub Pipe_Material_Exit(Cancel As Integer) If IsNull(Me.[pipe material description]) Then [Forms]![Network data form_2]![network data info...

Opps! this is what i should have posted. Can anyone help - I need to pass control from a subform to the main form when the field is null. this is what ive got so far, the first part works but the reference to the field i want to jump to, will not work? Private Sub Diameter_LostFocus() If...

Hi, Can anyone help - I need to pass control from a subform to the main form when the field is null. this is what ive got so far, the first part works but the reference to the field i want to jump to, will not work?