Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Manny64

    Can I create an INI file and retrieve values from it in Access?

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

    shell running a bat file

    Note: This is Access97 on WinNT
  3. Manny64

    shell running a bat file

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

    Shell Command and Windows NT...conflict?

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

    Using another workstation as a PseudoServer for the back-end

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

    Can I create an INI file and retrieve values from it in Access?

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

    Using another workstation as a PseudoServer for the back-end

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

    Problem: Report printing even if no records found.

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

    Problem: Report printing even if no records found.

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

    How do I create a Setup program for my Access application?

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

    How do I create a Setup program for my Access application?

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

    MS Access Printing multiple copies of reports when only 1 is requested

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

    MS Access Printing multiple copies of reports when only 1 is requested

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

    Problem when using 1QBF field as criteria for more than 1 query field

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

    Problem when using 1QBF field as criteria for more than 1 query field

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

    Problem when using 1QBF field as criteria for more than 1 query field

    Hi all, I need help in figuring out a way of resolving this problem... I have a Query-By-Form: Forms!qbfComplaints ...with multiple unbound fields: [qbf1] [qbf2] [qbf3] My query has the following fields and criteria: Field: [ComplaintID] Criteria: [Forms]![qbfComplaints]![qbf1] or...

Part and Inventory Search

Back
Top