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!

Register Log in
  • Congratulations Chriss Miller 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. jercsr

    Totaling Records based on Text Field

    Greg, I'm trying to get a total of all records with the same description. Thanks, Jeremy
  2. jercsr

    Totaling Records based on Text Field

    Hi, I have a table with a list of parts. Each record has a description field. However, when I query to total the records, the records with the same description are not being sorted and totaled. How do I total all of the records with the same description? Thanks in advance. Jeremy
  3. jercsr

    Saving Last Entries in Form

    Thomas, Thank you very much. I'll give this a try. Would you recommend this method over writing a record to a table? Jeremy
  4. jercsr

    Saving Last Entries in Form

    I have an unbound form set up, where a user enters info in three text boxes. They then open and print multiple reports, each of which picks up the information in the three fields they filled out. Is there a way to save these entries in the form, so that if the database or form is closed, they...
  5. jercsr

    Prompt User in Form One Time for All Reports in Database

    Greg, Can't thank you enough. I'll try both methods to see which seems to work best for the users. Thanks again! Jeremy
  6. jercsr

    Prompt User in Form One Time for All Reports in Database

    Greg, Sorry about the confusion. In most cases, a single user is going to open the database and print the reports for the project. Therefore that person only needs to enter a single record at the startup of the database for the "Project Information". How then do you create a "control" table...
  7. jercsr

    Prompt User in Form One Time for All Reports in Database

    Traingamer, Thank you too! I actually think option two might work best. Since each Project Task will be it's own database, I only want one entry for the Number, Name and Task for each database. If I pass their entry to a variable, then is it locked in until they edit the record? Thank you
  8. jercsr

    Prompt User in Form One Time for All Reports in Database

    HTH, Thank you. As an alternative, is there a way to simply lock a table to have a maximum of a single record. That way, if the Task changes, they can simply edit the record? If not, I'll try your idea.
  9. jercsr

    Prompt User in Form One Time for All Reports in Database

    Hello, I have a single access database with multiple reports. Common among all reports on the page headers are a Project Number, Project Name, and Task. Can anyone recommend the best way to have a pop-up form prompt a user one time for this information when the database is opened, and have...
  10. jercsr

    Overwriting Linked Excel Spreadsheet Causes Problem

    I have a table in Access 2002 linked to an Excel Spreadsheet on a network. The spreadsheet is created from extracting values from AutoCAD, and it needs to be overwritten each time the values are extracted. However, when I overwrite the Excel spreadsheet, Access now gives me an error that the...
  11. jercsr

    Allowing user to select Excel Spreadsheet to link to

    Thanks, Jeremy. I appreciate the help. Jeremy
  12. jercsr

    Creating New "Back End" Tables Daily

    Thanks, JeremyNYC. I'm going to experiment with that. By the way, I've seen your expert posts elsewhere, and I'm wondering if you have a comment regarding my question in thread700-658406. Thanks again!
  13. jercsr

    Allowing user to select Excel Spreadsheet to link to

    I have several Excel spreadsheets that are stored in seperate project directories. Is there a way to prompt a user in a dialog box or switchboard, or when they run the report to select or type in the Project number that they want to base their data from, capture their entry, and have Access...
  14. jercsr

    Creating New "Back End" Tables Daily

    Thanks both to Ken and DonQuichote for your helpful responses. Just for a moment, I wanted to touch on what Ken said: I would love to be able to prompt a user to enter a project number, and pass that information so that the report goes out and "finds" the necessary table. It would...
  15. jercsr

    Creating New "Back End" Tables Daily

    I have a question about linking "Front End" objects, specifically to constantly changing Back End tables. Following is a description of how I've set things up: I export data from an application, which creates a new MDB each time. The utility to export the data automatically creates...
  16. jercsr

    Picture in my report

    Message for scriverb: I followed the instructions for adding an Image control along with the ImagePath field, and provided the code in the OnFormat Event on my report. The good news is that the image specified in one of my records appears. The bad news is that the same image appears with...

Part and Inventory Search

Back
Top