Search results for query: *

I found this answer in another thread, except I had to remove both ' Thanks

On my Switchboard form (frmSwitchboard), I have a listbox (lstRecords) that has 5 columns that are filled by a query that basically shows record informations, one of which contains record numbers. When the user selects on of these records, I want to open a different form (frmCAREntry) but I...

The Switch was what I needed...thanks.

I just needed to create a new text box and create the Switch Function in the control source. Thanks!

I have a report that is based on a query that gets a field from a table called "Reason." This field is a text field type. I have a text box on my form for which the data source is [=switch([Reason]="AD", "Print Ad")] but this returns #Error and I can't figure why.

is it possible to use a Switch function in a report? If so, how do I reference a value of the query that the report is based on?

I have a report that has different groupings by REASON CODE. The reason codes are stored as two digits, i.e. RA represents "Radio Ad." I would like the section headings in my report to show up as with the representative titles instead of the two digit representations. I am not sure how to...

I have a report that is grouped by week. The Footer for the week sections has totals for walk in customers and sent in parts. I would like for each line to look like the example I have provided. (Monday through Friday range) WALK IN SENT IN 6/14-6/18 54...

you're right...thanks

Is there a way to have the fields refresh without using a macro?

That works well, but it doesn't update on the screen when the name is changed. It shows up fine on the print, but not the screen.

Is it possible to reference the field using a calculation? Instead of calculating anything, it would simply display the value.

Fumei, I used your idea and I unchecked the "Fill-in enabled" for Appraisee2. It works great. Thanks

I have designed a Form in Word 2002. One of the Text Form fields is bookmarked as APPRAISEE. It is the name of a person and I would like it to appear later in the document. How do I insert another field that references what has been filled in the APPRAISEE field? Thanks

I have another question. I have seen code that dimensions the variable but then uses the createobject function... Dim xlApp as excel.application set xlApp = createobject("excel.application") Is the second line necessary?

I understand. I think that I like the early binding option!

Thanks Roy, What exactly does this do?

I am trying to Dimension an excel application Dim objExl as excel.application but I get the following error "Compile Error: User-defined type not defined" It seems that everyone else can use this, what is my problem?

I apologize to all from MT . . . I realize as I reread my post that it is not MOONtana

I would be interested to see some more folks try this to see how it behaves for them. (1) Create a combo box on a form that is based on a value list. For continuity sake, make the values US states. (2) Test the combo box with Caps on and Caps off. (3) With caps off, it will autofind/autofill...