Search results

Pat, This is another problem I am having with the evaluation database you helped me on before. There are a series of qestions about employees that their bosses must answer with Outstanding, Very Good, Good, Adequate, Weak. The responses are stored as numbers: Outstanding = 1, Very...

I have a number of fields in a table that contain values ranging from 1-5. What I need to do is count the number of times each value is used in each field. I can do it for one field in a totals query by putting the field in twice and setting one field as "count" and the other as "group by."...

You could use dlookup as the control source. Coding would be something like this: =DLookup("[NameField]", "YourTable", "[EmployeeNo] = " & Me![YourTextBox])

Works great, Pat. Thanks.

I am working on a job evaluation db. I have a bunch of rating for which the values are drawn from a repeated scale. I.e. Rate this guy's work: Good Fair Bad Rate this guy's punctuality: Good Fair Bad I'm sure you get the picture. I am collecting those values using an option group and...

Perhaps you could use code to filter your results rather than a query. You could put this behind your Paid button: DoCmd.OpenForm "YourResponseForm" , , , "[Paid] = -1" Then behind your Late button put: DoCmd.OpenForm "YourResponseForm" , , , "[Late] = -1" etc.

I had to do something similar yesterday. There may be an easier way. I set a variable called TheDate TheDate = Format(Me![LetterDate], "Long Date") Then I used the variable instead of the field name: "I refer to your letter of " & TheDate & "blah blah blah."

Is the Paid, Overpayment, Late data in the same field in your table? If so, you could use a query as your record source for your response form, and use a Select Case statement to provide criteria for your query.

I use a second text box on the form and set its control source to: = "*" & [txtbox1] & "*" It then is used as the criteria in a field in the query on which the report is based. The query has to say: Like [forms]![YourForm]![txtbox2] [This message has been edited by Neal (edited 01-03-2001).]...

I've sent CampbelC a sample, but if anyone else tries this, please note that I forgot that there is an invisible field on the search form that is used to put * on either side of the search word. And that is the field used as the criteria in the query.

I'm not sure, but I think you can just write: DoCmd.OpenReport "Print Order Confirmation", acViewPreview, , "[InvoiceNumber] = varX"

Have you considered doing it the other way around? Put a text box on your search form. Use that text box as the criteria for the field you are searching in a query, but include the word Like (i.e. Like [forms]![yourSearchForm]![YourTextBox]. Put a command button on your search form that opens...

Can you just put the option group on the first tab and resize the second tab so that is also visible when that tab is selected?

I'm not sure how you open word, but I use this to open word and a specific object. I have two variables: Dim hotapp As Word.Application Dim hotdoc As Word.Document Then this code opens them: Set hotapp = CreateObject("Word.Application") Set hotdoc = hotapp.Documents.Open("P:\Editorial...

If you have a form with a listbox or combobox offering the available parameters, you use that box as the criteria in the query. i.e. forms!YourFormName!YourListBox. On the After Update event of the listbox or combobox, you write the code to print the report. I.e. Docmd.OpenReport...

You should be able to do that by using this in the query: Between forms!yourform![txtboxStart] and forms!yourform![txtBoxEnd]. I am curious how you populate those text boxes from a single calendar control. I though selecting a date would only return one value. If you select a second, it...

You just need a unique identifier for each person. The autonumber suggestion will work great, but if your table includes the person's social security number, you could use that.

I would used a combo box rather than a button. You would have to set up a table with only one field containing the names of your queries. Add your combo box using the wizard and select that table and field as the Row source. Then on the After update event of the combo box, I would put the...

I wouldn't think so. Did you put your validation stuff in the table itself? Maybe you should attach it to the control on the form. That way other controls linked to that field in the table will not be affected.

You could set the field's default as Date() and set the Enabled field to No.