Search results

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?

Hello: I have a crazy problem. I have been trying to put a simple combo or list box on a form that pulls the 12 months from a table. So....my problem is...I can see the months alright, but...I can't select. I have this problem with both the combo and the list. Is there some kind of form...

Thank you for your reply.... your help is appreciated. In the meantime, I've decided to go another route (FOCUS) for some of this - because of the way our disparate databases are already set up. thanks again, Arpeggione

I have most of my data in DB2 tables which I am linking to. However, there are a few pieces of data I am gathering from text files. I put them into a little Access table and tried to JOIN with a DB2 table field. My query died.... Is Access amenable to joining different types of tables? If...