Recent content by MikeDNova

Yeah something like that might work. But what I'm trying to do is call a function, set the global variable, then call then function again and remember the global. Maybe there's no easy way to do this in T-SQL.

Is it possible to use global variables in T-SQL? and how? if not, what's the common way to get around this problem? Thanks in advance! Mike

bump...

Hey guys, I'm trying to get a list of all the functions in my projects (added references) and ones already in access. And then maybe list them in a form or something. I'm having trouble finding a way to mimic the functionality of the object browser which lists all the available functions by...

thanks for the help guys!

Yeah i knew there would be a way of doing it with code, but i was trying to avoid that. I might have to anyways. Thanks Mike

Here's the deal, I have a query that is built off two tables. There is a left outer join from table1 to table2, and table2 has multiple returns for each record in table1. table1 table2 key --------------> key key key Now this means...

Hey everybody. I have 3 forms that all work the same. There is a mainform and a subform which are not linked. There are a couple combo boxes on the mainform that act to filter the subform. On the subform there is a list of records. When the focus is on the main form, and the user clicks on...

got it, had to refer to it as parent [parent].[form]![tblmaterialbomcomponent]![Plant] now just have to refresh... should be easy...

hey guys, i have a combo box on a subform that i want to use a query as the rowsource. the problem is when i try to add another control(combo box) as criteria to the query. I tried this which I believe should work but its not [form]![tblmaterialbomcomponent]![Plant] tblMaterialbomcomponent...

thanks!

I used the command button wizard to create an open form button to open a datasheet form. But when the form opens it is displayed as a single form, not datasheet. Anybody know what parameter to use or what property to change to open this form as a datasheet? thanks, Mike

Hey guys, Is there a way to specify a wild card of some sort, either in a macro or something that will allow me to delete all queries starting with a qry..... let me know if anyone has had any experience with this... thanks mike

ok, the reason i can't do this is that i have a whole bunch of text boxes that i want to do the same thing with. is this doable? there are about 16 text boxes at least that I want to use queries as control sources for... feasible or not??

I have a query with 4 fields that I am trying to use as a control source for a text box. I only want to use one field of the query as the control source. This is the line of text that I entered as the control source, "=[qryMBrickChurchillSel]![quantity]" whats wrong with this?? It...