Recent content by Manny64

Thank you for the feedback Francescina and MichaelRed. Sometimes I think I make things more complicated than they really are. You're absolutely right, Michael. That is the simplest way to resolve this. Thank you again to both of you for your response. Manny64

Note: This is Access97 on WinNT

This works for me: Dim stAppName As String stAppName = "c:\TestShell.bat" Call Shell(stAppName,1) Manny64

I'm using Access97 on WinNT and this works just fine for me: Call Shell("c:\program files\acrobat3\reader\acrord32.exe ""c:\manual.pdf""", 1) Manny64

You are absolutely right, Joe. I just learned how I could set the Share Name for a directory. Thank you very much. Manny64

I have an application where the back-end resides on a networked workstation, and the front-end resides on up to 20 other workstations on a Local Area Network. This application will be used in 17 other LANs where the back-end will be in one workstation per LAN. I was thinking of creating an INI...

Hi all, My application (front-end) is currently residing on individual workstations in a LAN. The back-end is on the server. We are currently experiencing way too much data corruption on the Unix Server. Apparently (I've been told by out tech people) MS Access and Unix dont mix well. As a...

This is exactly what I needed. Thank you, Joe, Manny64

Hello all, I have a Print button on a form that has an OnClick event: DoCmd.OpenReport "ILP_017", acViewNormal DoCmd.OpenReport "ILP_017a", acViewNormal DoCmd.OpenReport "ILP_022", acViewNormal Each report data source is an SQL query. Problem: When one...

I am currently using a simple batch file to copy the mde file from the server to the workstation. To give you a little more detail on what I am attempting to accomplish: -I have the back end on the lan server: (g:\group\all\ilp_data\ilpdata.mdb) -I have the front end on the workstation...

Hi all, I have created an access application (an mde file) and I now want to have a Setup program install it on a number of workstations. Is there a Setup application I can download or can I create one in access that will allow me to do this. Thank you, Manny64

Thank you for your response. Actually I resolved the problem by using the SELECT DISTINCTROW in the query for the Main Report. I don't know how to explain why it worked. It was suggested to me by someone at work. Perhaps for the benefit of others in this forum someone can explain it. Thank...

I have created a report and set it up as follows: -the MAIN REPORT consists of data from one table. (the criteria for the ID number being set in the query the report is based on ie. [Enter Case ID #:]) -the 1ST SUBREPORT contains related data (ie. ContactPersons related to the ID number) -the...

I meant IT WORKS (not "I works.") Manny64

You are a genius! I works. Thank you very much! Manny64