Search results

Okay I've searched the forum and have not found exactly what I'm looking for. I'm trying to create a query to show me records for a given year. The issue I'm having is that each record has (4) dates fields and each record can contain null values. Is it possible to do this in a query with...

Thank you for your help and patients with someone who hasn’t used Access in a long time. It worked perfect. Jerry:)

What field or where in the combo box does the code go?

I have created a query the gives me a supplier number and the supplier name. I want to use a combo box on a form to select the supplier number and be able to see the supplier name in a text field and store the information in a table. Can this be done?

Is there any way I can use a union query to solve this?

Is there away to join the attached 3 queries (Q-Scrap_Not_Recorded_2_Cav_Molds, Q-Scrap_Not_Recorded_4_Cav_Molds, Q-Scrap_Not_Recorded_8_Cav_Molds)? I need a single report or query that will give me the "scrap not recorded" based on the "shift code" and "process group" fields. I can run them...

Any ideas why my toolbar won't pop up?

I have several reports that I can't print because my toolbar that I created and put into the report properties section does not open up with the report like all my other ones. These reports all have a common difference. These reports are activated from a form where some criteria is selected...

Okay I see where the report properties was changed to a "pop up" . Thank you! I can't believe it was that simple. Thank you again

Extrem, How did you fix it? I didn't any difference in the code.

Where do you should the acDialog go? I tried a couple time and I get an error. Everything works, its just the silly report opens behind the switchboard and then I have to minimize the switchboard to get the report. The people on the floor think the report didn't run. Private Sub...

I have created two reports that I open after a shift code is selected from a combo box on a form. I want the selection form to close after opening the report so I wrote in a do command close in the command button but now the reports don't open properly. Anyone have any suggestions? Thanks, Jerry

I have a report that is filtered by choosing a number from a combo box on a form then a command button opens the form and hides the form. But the report opens up behind the switch board. Anybody have any idea why this particular report does this? My comand button code is below: Private Sub...

Report Not Working From Combo Box Bob, That is correct. The attached Db was not working properly. The shift code "200804030" has two "our part number" FC3080 and FC3090 but was only returning one. The problem was the way I had the report grouping. So your suggestion worked fine after I...

Thanks for your help Bob

Sorry, it is the shift code.

Report Not Returning All Data Bob, I changed the DoCmd as suggested but the report does not return all the data with the selected date code. I though it was the grouping in the report, but after changing that around it didn't make any difference. Any other suggestions? Jerry

-------------------------------------------------------------------------------- I'm trying to use a slection form (F-Select_Shift_Code) to select a date code from a combo box and open a report to show only the criteria slected in the combo box. I've tried variouse ways to do this and can't get...

I'm trying to use a slection form (F-Select_Shift_Code) to select a date code from a combo box and open a report to show only the criteria slected in the combo box. I've tried variouse ways to do this and can't get it to work. Can some one see why this isn't working please.

Thanks Paul and Wayne. I'm seeing many issues now. This was supposed to make my job easier not harder.