Search results

I am using Access 2000 so that eliminates one of the possibilities. I will try to to explain this w/o boring you to tears. This database is on a network. When the users at our plant use the database there are no problems but the user that receives the error is located at another plant. That...

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.

Ross - I hope that this might help you out, I tried to email you but I do not know if it went. If you need further explanation just let me know. Private Sub Print_Click() Dim objWord As Object Dim objExcel As Object, X Dim strFile As String Dim vntIndex As Variant, strValue...

I basically have the same set up. I have a table that has all the employee info (user name and ID). I use a query to get my current user(), this query shows both the strName and userID. On my form I have a hidden text box which uses =DLookup("[strName]","qryUserID") I then pass the value...

Topher - I finally got it figured out! I now have a completely functional listbox that cycles through and prints each Word or Excel file that is selected. Just wanted to thanks for all the help!

We have several documents (well over 100) in Word and Excel. I am in the process of making a print dialog form where user's can choose a department and it will show all the documents that apply to that department. User's will be allowed to select one, a few or all documents (word and excel)...

I think that this article might be to run Excel macros instead of Access macros. The title says Run Excel Macros Through Automation so I am assuming that it is for Excel, but I tried it anyway and I could not get it to work. Thank you so much for your assistance, I really appreciate it. Do...

I have tried changing it for Excel but it gives me a runtime error 438 "Does not support object". The rest of the following code works with the objExcel.PrintOut commented out. Thanks for the ideas though. Any other suggestions? If Right(strFile, 3) = "xls" Then Set objExcel =...

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...

Thank you so much. That was exactly what I needed.

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...

A default value will not work because the values are not consistent enough. What I mean is when one person fills out the form they may need 10 forms (with minor changes, i.e. qty might be 1080 on 9 and on the 10 form 975) but the next user very possibly will have totally different info for 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?