Recent content by Arpeggione

Simon: I tried the Source object and it doesn't work either. I think this has something to do with the way things are displaying. I have this working correctly in another screen in 2007... thank you for your comments. karen

I am converting an app from 2003 to 2007. In my app, I set the recordsource of a subform, then requery and a few records should show up. It works in 2003, but not in 2007. However, my query works in 2007 - the records are just not showing up in the continuous forms. subfrmCtnr.recordsource...

Three years later....just a note... Thank you EraservAP - your answer does the trick! regards, Karen

Hi: I can secure my application on the front end according to UserGroup - who gets what, etc - with vba. However, unless I secure the backend, people can go into the directory (if they're inclined) and open the tables directly... But...if I lock down the tables directly for some groups -...

John: yes, thank you....you are right...this might help me. I will give it a try. Karen

Hi: I've got a form with a subform on it. I'd like the user to be able to make this subform smaller or bigger by clicking and dragging (like a window). Is it possible to do this for a subform container - and if so, how? thank you! Karen :)

that's it! Forms!frmEditSystem!TransSubCtnr.Form.RecordSource = mySQL it works! thank you Bob - I tell you these containers are so confusing..... Karen

well, when I try the dot I get: application-defined or object-defined error.....

more information....the subform is actually in a container on a tab control on the mainform. the name of the container is TransSubCtnr.... I've got the "syntax for main/subforms" table in front of me.....I'll bet I should be referring to the container instead of the subform?

Dim mySQL As String mySQL = "blah blah"... I did have this working when I had the procedure in the form_load event and a button, but wanted to put it into an outside module as I am using it in two places... do you need any more information?

Hi: I think I am using the code per Bob Larson's (BTAB) wonderful website (his site has helped me immensely) as follows: Forms!frmEditSystem!subfrmLineswitches.Form.RecordSource = mySQL this code is setting a recordsource for my subform from a module outside the form. I get the error...

From Karen: Never mind! I actually got this to work in the Open Event.....somehow, I had to redo the open event. It didn't take the first time. I also had to set the LinkChild and LinkMaster fields in code. thank you to the writers above! Karen

Hi: I am reading the above and am trying to do something similar (I think). I have the following code: Me.Controls("subrptEventFaultsCtnr").SourceObject = "subrptEventFaults", but I still get the error 2191 (can't set a source object after print preview....) so...what event of the report...

about updateable recordsource To Bob: Thanks for your post. I've tried both the list and the combo pulling data from a simple table of months and typing in the twelve months. In both cases, I can't select a month. When you say form's recordsource, do you mean the recordsource for the...

is enabled, and is not locked... this is why I'm stumped....thanks for your reply....any other suggestions?