Recent content by funominal

I'll think about that as another option... it's a slight variation from what I've done, which is use a combo box with a table where I've just put the names of queries and tables in it, and used the Left(3, name) function against the selection to determine if the name selected was a tbltablename...

I'm using it for data entry and viewing summary data via the datasheet subform (better for some cases than form view as far as viewing is concerned). I'm also using datasheet view because I have so many tables & queries... otherwise it would be too many forms. I have built in some security...

Thanks. That sounds like a good idea for the long term, and for maximum flexibility. I would like to do it, but not sure if the time coding would be worth it in the short term, so will probably make some forms for the main screens (maybe 10 or so). I may reapproach this later when I have more...

No because I want to use a dynamic record source that could be from any of 100 different tables or queries... I don't want to have to place controls on the continuous form specific to the fields of each table/query. like I said, I'll probably have to form some main queries like Company, Orders...

I was told that apparently you have to place controls on the form and bind them for a datasheet to work... but this seems like a form to me, not a datasheet. I ended up using the ObjectSource property to assign a table or query to the datasheet rather than using an underlying SQL statement for...

Yes, still interested. I did a workaround, but really would like to solve this. Want to pass a control by reference. Public gctlMyControl as Control ' declare var as control type in global module Set gctlMyControl = Me!mycontrolname ' set at form module PrivateControl (gctlMyControl) '...

I've run into the same issue... any recent thoughts since this thread was from 2002? I'm certain Access is designed to pass controls by reference, but it doesn't seem to be working for me either. Here's the code that isn't working (get an error on the function call line stating that I need an...

Thanks, I'll give that a try. Someone suggested that because I have no controls on the form that I'm using as a subform with a datasheet, that it can't show anything...that I must put controls on it... this kind of defeats my purpose of having a dynamic form that can be generated for summary...

Datasheet problem: Just moved to Access2000. I created a new database with a new datasheet form. My datasheet in my form shows I have 9 records (from a table) by showing the navigation bar, but the datasheet itself is blank!! Well almost blank, the datasheet area is dark gray, with no...

Well, that's just what I'm trying to do, and was unable to do with Access2000, and now Access2002. Interesting...after your email, I decided to create a new database with a new blank main form, with a datasheet subform, and try it anew... amazingly I didn't get an error message, which leads me...

Any ideas?? I have set subform recordsources before, but am getting errors now. I even tried upgrading to Office2002, not helping. I have searched Access forums, and they all seem to recommend using the same syntax that I'm using here. I opened an old Access database with the same syntax, and...