Search results

one more little detail. for some reason this setup works for the paths that i used sql to copy over from the old field. When I try to add a new path manually to the new field, the image won't populate on my form. I setup the control by adding an image box to my form and setting the control...

apparently I haven't been doing it that way because I like doing things the hard way :P I just made a few changes per your recommendation and then deleted the VBA code and everything works great! Thank you!

Thanks Pat. I'll keep it in mind.

Hi RainLover, I changed the code as you suggested and also changed the name of the label to NoLabel.bmp. This seemed to work for now :) Maybe the space was causing problems. I'll keep an eye on it and post back if I run into this issue again. Thank you!

The coded solution didn't give me the option to add the image when there is one saved on the record. imagepath = a field in my table. When the field is populated, it is the path to find the image that needs to be used on the report. When the field is not populated, it uses a default path...

Thank you Mike, The problem is that the image is different depending on which record I'm calling up. Each record has a path saved with a unique image to that record. It needs to be displayed on the report that corresponds with the record.

The reason for the code is that the images are not uploaded to the database. I did this to prevent the database from getting too bloated and running slowly. At the time that I set this up, I was under the impression that I would need code to achieve this. I should research it again though and...

Now it's saying that I've entered an expression that has no value: debug.print me.imagepath

I haven't done that yet, I am not too familiar with debug techniques. Something I need to remedy :) Where would I type 'debug.print me.imagepath?

Thanks Pat, that looks pretty nifty. Unfortunately our IT department is pretty strict about downloads and 3rd party software. Is there a second best option that doesn't require a download?

I have a piece of code that I'm using to display an image on a report based on a path saved to each record. the code is: Option Compare Database Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If IsNull(Me.ImagePath) Then Me.ImgPic.Picture =...

I've reading up on how to make my form controls change size / position as my form is resized / loaded on a computer with a different resolution. Several of the tutorials out there suggest putting code on the "on resize" property of the form. When I looked at the Northwind database to try to...

Worked perfectly, thank you :)

I'm trying to set the control source for a control on my report that describes the number of portions that goes into a box. Sometimes there is a specific number of portions per box and sometimes it's a range. When the number of units is specific, then it is entered into the MasterCaseMinUnits...

In my mind, the rotation should be able to go on forever. It should not be random. the two lists should stay in the same order with one of them shifting each job up or down a level each month so that everyone gets a new job each month for 7 months until month 8 when the job assignments will...

I have two tables. the first is a table of names, the second is a table of jobs that need to be done. I need to develop a job list that assigns a job to each person and then rotates the jobs every month so that everyone gets a new job each month. there are 7 people and 7 jobs. Each person has...

After I clean everything up, I do plan on changing the data type yes. The new field was pretty easy to add and update fortunately. I was able to use a query based on a different description field to determine if the unit of measure should be oz, lbs, etc. That part is all done. Right now...

This is a sample of the data. there are over 700 records that need to be updated. The data isn't formatted in a perfectly consistent manner unfortunately. the logic I conjoured up in my mind was either to remove all instances of the string 'oz' and all instances of the string 'lbs' from the...

I have a weight field that I've been populating with the weight and the unit of measure. I want to seperate those into 2 different fields. I've created a new field called UnitofMeasure and now I need to go back and remove all the instances of 'oz' and 'lbs' from the first field. Is this...

I have 2 tables that are joined by a many to many table: tblProductInfo - ProductID tblProductLinerMM - PLProductID (FK to [tblProductInfo].[ProductID]) - PLLinerID (FK to [tblLiner].[LinerID]) tblLiner - LinerID I have a range of products that each use 2 liners. An inner liner and an...