Search results for query: *

I am creating Word documents (.doc files) that will be distributed to many locations using various printers. We want to set the documents to automatically print duplex without them having to be set to do so by the people printing the documents at the different locations. Is this possible to do...

Thank you so much. It worked perfectly!

I have a main form called frmShipping and a subform called frmUnits. I want to control how many units can be entered into the subform for a given shipping record, i.e. from 1 to 7. I don't want them to be allowed to enter more than seven records. Do I need to do this with a query in the...

My data type is date. I tried the code that AceMan1 suggested, but it still brought up everything. Any other ideas? Thanks!

I have a subform on a form. On the subform I have a details button. When I click on the details button I want to show the records for the current week. My linking fields are [lngEmpID] and [Monday]. My field [Monday] is the field I want to use pull the current record. My code is as...

This report is made up of several subreports. The original report was an Excel file with a lot of lines and boxes which I didn't want to recreate, so I copied the file and laid the data fields over the object. The top part of the Access report with the copied Excel file works just fine, but...

We updated the printer drivers for the printer and it's still not printing the entire report. It's printing the data from the subreport just not the OLE object of the subreport.

No, I have printed from two PCs to the same printer and received the same result. I have also printed from one PC and gotten good printing results on multiple printers.

No, I do not.

I have an Access report with subreports in it and it prints fine on several different printers, but on one particular printer, it doesn't display the subreport information in print preview or when I send it to the printer. Is this a Access set up problem or a printer problem? I've never had...

You are awesome! It worked like a charm. Thanks a lot!

I have added a Calendar Control 11.0 to my form. My calendar control is called IssueDateCalendar and it's control source is attached to the dtmIssueDate text box. I have been trying to figure out how to automatically update the dtmIssueDate field on the form when a new date is selected in the...

Where would I include this? In my SQL statement or in my query in the field? The field I am trying to count is a text field called txtSessionID. So would it look like this: CLng(NZ([txtSessionID],0))

I changed INNER JOIN to LEFT JOIN and it supplied zeros in my TOTAL column but not for the individual months. Any other ideas?

I have four ratings in a table, Excellent, Good, Fair and Poor. Sometimes for a given month, there won't be surveys for all four ratings, so I would like to display zeros in those ratings for that given month. Below is the current SQL code I am using in my query. Following the code is a...

Thanks for your help. I'm dumping the data into a temp table and I'm using the table instead of the query with the parameters. It works just fine. Thanks alot!

Thank you both for your help. This works great!

It is attached to a macro that is being selected by clicking on a button from the switchboard. Should I add an open form macro action before I run the query?

I created by form with the combo box and entered it in the query as you suggested. When I run the query I get the parameter box with the criteria: [Forms]![frmProductLineLookup]![cboProductLineCode] in the window. Should this be displaying the form that I created? I noticed that if the form...

I currently have a query that contains a parameter box. The problem is that there are many choices that could be entered into the pop up box. The users may not know the proper nomenclature to enter. Is there a way to generate an input screen with a combo box button so that they can select...