Search results

Solved it. First, don't store pictures as attachments in the table to minimize the size of the database. Instead, have a field to store the entire file path to the target image, but use a text field (NOT the hyperlink option). In query design view, include the field which contains the file...

Do you store the path to the pictures as hyperlinks in your table? If so, when you design the report with the query as its record source, do you use an image control to return the file at that path?

I am generating a report that has a Select query as its record source. The query takes its data from a table that has an attachment field in it. In the attachment field, there is only one file per record and it is stored as a JPG. How can I query the table to retrieve and show this...

I seemed to have tracked the problem to the Join operation in the query (it took a fair amount of effort to be able to write that sentence). I trimmed the Query down to search just one table and my data showed up. I then edited the data again with what I thought was my problem form, and it...

Oh, boy, that would not have occurred to me. Thanks for passing along that nugget! Could that possibly explain why the query is not finding these records? Then to save the updated record, does the user just need to exit the form (assuming Access will save it automatically on close)? Thanks much.

Thanks for the feedback, Bob, and I may have to steal that technique for future assignments. In this instance, though, the form is only used to edit existing records. Even if the user doesn't change anything, there will be something to save. Somewhere between saving the edited record and...

Thanks for the reply. I double-checked my form and my combo-box was unbound. I edited a record using the form, then closed the form, verified the changes were made to the right record in the table, then opened the form back up to edit the same record. All the data came back when I did...

I've hit an unexpected snag in producing a report. I have a table with 15 structures (records) that have a number of metrics (fields, e.g., location, condition, size, etc) associated with them. I created a form that I can use to update an individual record; the form is populated with a...

Thanks, it might be a rush to judgment on my part but I think I understand that.

I initially chose not to have the Asset ID as a field in the Maintenance Cost table since I'd have to enter the Asset ID with each record (fields would be Asset ID, Maintenance Item, Quantity, Unit, and Unit Cost), and every book I've picked up on Access tells me to avoid duplicate data at all...

Question for clarity - You referenced a one-to-many relationship between the tables. How would link the two tables if the maintenance cost table has no other fields in common with the main table, aside from the field that holds the Asset ID? I tried using the Edit Relationships menu, and...

Thanks! The linked table is an option I hadn't considered yet. I have much more experience with Excel and tend to approach Access problems with Excel solutions. I will definitely try this.

I'm relatively new to Access, so I'm wondering if my goal is impossible or just solved in a different method. All suggestions welcomed. I have a database that includes an attachment field which is currently populated with Excel workbooks. These are not massive workbooks and contain only two...

Thanks! I think I'm wasting time by worrying about the users perception of the table. I think with a central switchboard and task-specific forms to edit data or generate reports, end users will never need to see the table. Your suggestions make a lot of sense. Thanks again.

Thanks for the prompt reply. In the Property Sheet for the form, the Record Source is populated with the title of the main table. Is this equivalent to the form being bound to the table? I've seen the term in other posts and found it confusing since all my reference books only referred to...

I'm a newbie to Access 2007, so let me apologize in advance if this question is extremely basic. I have a table where I use a form to allow users to enter data to create a new record. I added a button to the form for the user to click when they are done entering all the required data. I've...

Greetings to all! I hail from Richmond, Virginia in the eastern part of the US. I have been a practicing structural engineer (bridges, not buildings) for the past twenty years and am currently in the employee of one of the largest engineering consultants in the US. In my spare time, I am a...