Search results for query: *

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

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

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

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

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

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

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

Hey guys, I know that in windows to select the current screen shot you hit Alt- print screen. When i try to use this to select the top screen in Access it instead takes a screenshot of the entire Access window. Does anyone know of a way to take a screen shot of the top screen in Access...

Hey guys, I have a few tables: tblQuestion tlbCategory tblQuestionResponse Focus CategoryID QuestionID Question Page Text QuestionID CategoryID CategoryID Now I'm trying to setup a report that prints out one question from tblQuestion at a...

hey guys hows it goin??? i have a recordset that contains fields labeled: sentence1, sentence2, ... sentenceA, sentenceB now i'm trying to find a way to retrieve the values of these fields. obviously i'm goin to loop through the recordset for each field. however, i'm not sure how to specify...

hey guys, i have two tables tblCategoryResponse priority - 7 entries response - 7 entries tblQuestion CategoryID QuestionID Question QuestionType tblQuestionResponse QuestionID CategoryID Response - Response seqNo - Priority i want to try to do a cartisian product query to append to the...

hey guys whats up? i have a report that is grouped each page by a CategoryID a have a subreport that is linked child / master using CategoryID in this subreport is a text box and a another subreport that is also linked child / master using CategoryID for some reason the when it prints out...

i have a text box on a form that only is one line right now. the user wants the text box to expand as they enter data so that they can see the all the text when it goes over one line. the way it works right now they can only see one line at a time. if you need clarification just ask!! if its...

hey, i'm trying to run a query that uses null as part of the criteria. but i can't seem to get it to work. i've tried "sentence"=null isnull("sentence") amongst others... if i do a query with this as the criteria... len(sentence)>1 then i...

Hey guys hows it goin?? I'm almost done with a project and need a little help to wrap it up! I have a master report with about 7 subreports. I prompt the user for an InspectionID when they open the main report. Each of the 7 subreports is based on a query for a different datatype and I...