Search results

Is is possible to combine two unrelated reports into one master report? If so, what is the best way to do it? rbrule

Thank you I'll try it

Hello, I have a form with two subforms. The subforms are created from two queries. When I search the main form, Access shuts down after two searches, with no error message. It did the same thing when the subforms were based on tables. Does anyone know why this happens, and what the fix is?

I have a crosstab query that shows the average product errors for each product each month of the year. Some products are not produced in certain months which leave null fields. The months with data show percentages of errors from 0.00% to 100.00%. I would like to have a summary column that shows...

Thank you all, your responses will save me a lot of time and aggravation. Happy Holidays!!!

Hello, I am trying to set up conditional formatting for a text box in a subform. the subform is in datasheet view the fieldname is [status]. I have entered the following code in the after_update property. I am looking for the background and text to change color under several different...

I set the default value for the status field to "available" in the table. I was trying to have it change to unavailable when a date was input through the form. My intent is for the data to be saved in the table, not just show on the form, like a calculated field. I suspect that I don't have the...

When setting up macros, what causes an Automation error?

Can someone tell me the correct macro condition, item, and expression to populate field # 1 with a word if field # 2 is null and populate field #1 with a different word is field # 2 is not null?

Thanks rural guy, I should be able to get there from here. You have given me many options.

Thank you, I appreciate your help

Is there a way to insert a calendar on a form from which a user can select a Month year and day similar to using the calendar on Outlook or Lotus Notes to set up or view appointments or meetings?

I have a table that contains two fields "status" and Date". I have set the status field to the default value "available". I would like the value of the status field to change to "not available" automatically when the date field is filled in. I believe I need a SetValue macro, but I have not been...

Thank you for your replies. We did what you both suggested, I reset my date format and created a calculated field to isolate only the date. However I still had the problem. It turns out that the date field was set as text instead of date and time. I was able to call up the data by adding either...

Hello, I have a query that I did not create, but I am now responsible for. My problem is that when I type a date into the criteria field to call up records I get no records. I know the records are there, because they come up when I take the date out of the criteria field, and open all records. I...

Thank you, I appreciate your help

Hello, I would like to put the first date shown in my query in my report header as well as the last date. For example the Header would read Report covering 1/5/06 to 4/17/06, and would automatically update depending on the first and last dates in the query. I used =First([date]) and =Last([...

Thank you for your help. I was able to solve my problem in the query that feeds the mail merge. I created another calculated field with an IIf statement that adds the suffixes. It was a simple solution, I don't know why I didn't think of it in the first place. Thanks again for your help, I...

Is there a way to format the day of the month as an ordinal number? For example instead of formatting the day as January 1, I would like to format the day as the 1st, 2nd, 3rd etc. day of the month. I need to do this in order to match the format of a contract that we want to use as a mail merge.

Thank you, I didn't think it was possible, but I wanted to get another opinion to make sure.