Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MikeDNova

    T-SQL global variables

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

    T-SQL global variables

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

    I need to do the same thing the object browser does, or use it!

    bump...
  4. MikeDNova

    I need to do the same thing the object browser does, or use it!

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

    Tough query logic/problem... for the experts!!!!

    thanks for the help guys!
  6. MikeDNova

    Tough query logic/problem... for the experts!!!!

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

    Tough query logic/problem... for the experts!!!!

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

    Dr. Watson error when clicking on a scroll bar in a subform from main

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

    query as rowsource on subform

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

    query as rowsource on subform

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

    Open datasheet form from another form??

    thanks!
  12. MikeDNova

    Open datasheet form from another form??

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

    Deleting multiple queries all at once....

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

    Too Easy.... query as control source for text box question...

    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??
  15. MikeDNova

    Too Easy.... query as control source for text box question...

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

    Crosstab query un-upadateable??

    is there a way to make crosstab queries updateable??
  17. MikeDNova

    Need Query Help!! Tough!!!

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

    retrieve data from hidden column in combobox

    thanks guys!!!! i'll check it out!!
  19. MikeDNova

    retrieve data from hidden column in combobox

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

    query from hidden column in combo box

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

Part and Inventory Search

Back
Top