Search results

Bob, Thank you. It was so simple it's embarrassing. Randy

Linked Images in Report Can anyone help me with this please? This is the code I have in the report: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.Image1.Picture = Me.txtImage1Path Me.Image2.Picture = Me.txtImage2Path Me.Image3.Picture = Me.txtImage3Path...

I have a products DB with up to 4 images per product: (1) how it is packaged in the box; (2) how the boxes are stacked on a pallet; (3) the label that goes on the product itself; (4) the label that goes on the pallet. Not all products have all 4 images. I use linked images to display the...

Thank you so very much, GHudson. You are a lifesaver! :) Randy

I'm using GHudson's A Better Mouse Trap code. It works great. However, I added other code from http://www.databasedev.co.uk/image-form.html to get and save the path to image files and now I think there is a conflict between the sets of code. The Images tab on the form frm_CreateNewSpec is...

Bernard, Thank you. It has a lot more than I currently need, but I'll muddle through it and try to make it work. Randy

I need to create or adapt from a similar database a means to capture time (labor) spent on projects. I've searched for this topic, but have come up empty. Perhaps I'm just not searching on the correct search terminology. Here are the basic requirements: One department can have many...

Anyone else have any ideas? Any and all assistance is appreciated. Randy

The record is not being saved because it would create a duplicate. There is no longer any message displayed.

FoFa, That got rid of the type mismatch error. However, while the "save" button appears to be functioning as designed by GHudson, the record is not being saved...when clicking the "close" button, GHudson's code is warning me to save the record. It's a vicious cycle. Any other ideas? Randy

I don't understand why I'm getting this message. I have a form that is based on a parameter query. The user inputs an item number and the form opens in edit mode. The user clicks the "duplicate" command button and then changes the item number. I've incorporated GHudson's "A Better Mouse...

GHudson, Once again, a BIG Thank You. Like Lyndseyd, I'm also starting at the beginning with a fairly comprehensive project for my company. Sometimes it seems like I can get the hard stuff working, but miss the boat on the simple stuff. Randy

I have a macro in the On No Data event of a report that displays a message when the item number a user requests does not exist in the table being queried. Now I need to get the same functionality in a form. The form is based on a parameter query with only one criteria [Please enter item...

Mstef, Perfect...thank you. Randy

I need to trap an error if the user enters a item number that does not exist in the table. I created a macro for the OnNoData event and it works great when I test the macro by running the report from the Reports Objects list. However, when I run the report from a command button on my...

GHudson, Yes, it does have the tbHidden text box. Randy

Thanks you for the quick reply, GHudson. I applied your new code and this is what happens: Click "Save": Error 2110: Microsoft Office Access can't move the focus to the control tbHidden. Click "Undo": Run-time error '13': type mismatch. Click "Close": Run-time error '13': type...

AuditTrail and MouseTrap Problems I have a tabbed form that I applied GHudson's AuditTrail code to and it works well. I have another tabbed form that I applied GHudson's MouseTrap code to and it works well. Now I need to have both sets of code on the same tabbed form, and it doesn't work so...

GHudson, your Audit Trail code is great! Thank you for saving me from many sleepless nights. My database has a form for easy creation of a same-as-except record. The user performs a find on the target record then uses a "Duplicate Record" command button and proceeds to edit the appropriate...

I have a database that can be thought of as a Bill of Material database. I have controls for Assembly, ProductLabel and CartonLabel. ProductLabel and CartonLabel are both setup as combo boxes, getting their data from a common tblLabels. For a given Assembly, the ProductLabel and CartonLabel...