Search results

I am getting the following run time error 3042 - Out of MS-DOS file handles. Can anyone give me any suggestions or point me in the right direction? I have searched the Microsoft site and few others but to no avail. Thanks in advance.

Does anyone know how to automate printing with Excel? I have this code to print Word documents that are chosen in a listbox and I am needing to adapt this for excel also. Any help is greatly appreciated. Dim objWord as Object Set objWord = CreateObject("Word.App") objWord.Documents.Open...

I am using a listbox to select items to print out. The listbox is controlled by the input of two other combo boxes. My problem is that these items I need to print are Word or Excel files. My listbox allows the user to select one or several different documents and they may be all Word or all...

I am currently using this code DoCmd.OpenReport stDocName, acViewPreview, , "Desc = '" & Desc & "'" in a report to print preview only where the Desc matches the form to the report but I want to add another condition, example PartNo. Can anyone help me out? I have looked at my SQL statement...

I have a checkbox on a form and when I enter new data into the forms I want the box to not be marked (false) but when I close it I want the box to be marked (true). I am doing this for the purpose of being able to print the report that pertains to the form and only print the forms/reports that...

I am currently using Microsoft's code for autofilling specific fields in a form set by the fields in the previous form. I have a very elementary understanding of VBA and was wondering if someone could offer me some suggestions. When I open the form I want to go to a new form but I want all...

I have posted this question a few weeks before but the response that I got does not seem to work for me. This is the scenario, I work in a factory and there is a form that people have to fill out when they find a problem with parts. They have to complete one form per basket and occasionally...

When I place the dot in front of name and deptno in the above code it comes back Compile error:Method or data member not found. Thanks [This message has been edited by LynnaM (edited 05-17-2001).]

I am using an input box to set the number of copies for my report to print out. My problem is the form that the report pertains to has a an ID but when I print out the report I need the ID plus an additional ID. I thought about just adding the page number of the report behind the ID but with...

I am using this code DoCmd.OpenReport stDocName, acPreview, , "ID = " & frmID to print the current form that is being viewed but I want to possibly print several copies of this report, how would I write the coding for this?