Search results for query: *

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

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

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

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

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

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

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

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.

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

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

Thanks, Jeremy. I appreciate the help. Jeremy

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!

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

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

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

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