Search results for query: *

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...

is there a way to make crosstab queries updateable??

hey guys, I have 4 tables t-shirt, size, color, and quote. the size, color, and quote tables all have foreign keys in the t-shirt table. I'm trying to do a query that will give me results formatted like this: (size1) (size2) (size3) (size4) Quote color quantity...

thanks guys!!!! i'll check it out!!

hey guys, i have three combo boxes with 2 columns each. the first is a hidden column that is the key, and the second lists either a color, size, or quote. i'm trying to set it up so that the user selects a color, size, or quote, and then populate another table with the respective keys, not...

hey guys, i have three combo boxes with 2 columns each. the first is a hidden column that is the key, and the second lists either a color, size, or quote. i'm trying to set it up so that the user selects a color, size, or quote, and then populate another table with the respective keys, not...