Search results

Got that. Will that run the query automatically when the button is pressed. I would have the query linked to a report so I would want all information on the corresponding report to be displayed when the match is found. Any help on that?

For a new user to dlookup, what would that code look like if I wanted it to look in a form field and look through 3 queries for the result?

Would the dlookup be put in an event code?

I have a database that has several tables, each table has account numbers in them. I also have queries set for each table to bring in desired information. Is it possible to set up a form so the user can input an account number and depending on which table the account number is in, that...

I have a report that is broken down by regions. Each Region could have multiple entries for each. I would like to have a Summary at the bottom that counts each Region on the report and gives a total for the report. What I am getting is it counts each time there is an entry for the region. I...

On the mainform memo field it does appear, however in the subform field it does not.

Tried that but to no avail. It just seems to be on the subform where the scoll bar function does not seem to work. Is there a setting I need to adjust to get this?

That's correct, however in this subform field which populates from query results the scroll bar does not activate. In this box there are about 10 lines that do not show.

I have a subform on my main form that uses a query to display the information. On the query and subform there is a discussion field. I would like to put a scroll bar on this field so the user can scroll through the text since it could possibly be large but the scroll bar function does not work...

I have this selected but it does not appear. I have tried it on all of my subform fields and it does not appear on any of them. Any idea?

I have a subform that is populated by query results. In the query i have a field called Discussion that is just a free form field where the user can input any information. On my subform the field is not big enough to show all of the data if it gets large. Is there a way to add a scroll bar to...

I am in Access 97. The symptoms are first the limitations on the amount of text in a text formatted field which is 250 characters. The memo format is the only way I know of that will allow all the space a user could possibly need. The problem in this is when I go to my query for my subform...

I need for the entire filed to show. My database form contains information pertaining to conversations a user has with various regions. The discussion box would hold the contents of what was discussed and any additional information that was relevant. This discussion, entire discussion, would...

I have a field that is in text format that is used as a discussion box. This limits the user to 250 characters because of Access limitations. I have tried the memo format but that will not allow me to query off of that field. How can I have this discussion field with unlimited text capability...

I have a field on a table that is a memo field. I am trying to write a query to include this field but get the "Can't group on memo or OLE object. Any ideas on why and how can I query with this memo field included?

I have a form that is linked to a table. I would like to have a field on my form that has a control source of a query I have. There are cbos on my form that control the output of the query so I would like for the query to run after all 3 cbos have the data selected and then this form field...

Not sure what you mean. I am having trouble linking the form field to the query.

How can I get my form filed to return the results of a query that I have? For example I have my query set to use the month and year that are in my form in a cbo to get the desired results for Balance Growth. I want this Balance Growth result to show in my form field after the year is updated...

I have a combo box that contains the months. They appear in month order on the form but when I query, they are in alphabetical. How can I get this to be in month order on the query?

Sorry for so many questions but it is getting there. It will now accept my dates but when it appears in the cbo it is in date format then once selected changes to the month. Is there a way to get it to appear as months before it is selected?