Recent content by bwelmers

If you find out I would love to know. I have just about the same problem right now.

Hello Randy, I can sortof take a stab at it. But mostly I can say that I do similart kinds of things - mostly making combo boxes that use info from a parent form in the query and it does work for me though I have to do all the coading for it right in VBA. it will not let me do it in the...

Yap that is what I am doing. you just gave me an other slight question. I am going to guess that by creating the SQL dynamically you are using the SetRecordSource property. Is it possible to use it from a form that opens the Report? I will leave the project working the way it is for now. That...

So waht you are saying is that in the perfect situation it would be better to send the data request through a stored porcedure? What I am doing with the DoCmd.OpenReport function is opening a report that is based on a View. Having done some more work with it since the initial post, I think that...

I am using access 2000 and SQL server 2000. I am really trying to use access data projects for it since that looks like it will run a whole lot better.

First post ever so a little background on my access skills: I am a self-taught coder who has created a number of access databases before. Skill level somewhere around advanced to expert (no one else in the IT department can help me with access related questions) I am currently developing a...