Recent content by new_guy_tom

I had a similar issue recently. Do you have the data as below: Example 1 Label Value Label1 100 Label2 200 Label3 300 etc Or Example 2 Label1 Label2 Label3 etc 100 200 300 I had the data as per example 2 and had all of my labels as sumOf I changed the...

I have tried split forms before and they are hard to get right in pop up so I have avoided them. you could try to set the height and width in the on load event Me.InsideHeight = 1440 Me.InsideWidth = 1440 The size is in twips with 1440 twips = 1 inch

Thanks guys. The backend and front end are linked together and the backend is on the network and password protected. The backend runs on the on the server and runs number of update queries from an external data source during the day, they run on the back end so that it does not interfere with...

Hi, I am trying to open a database with a password (I know the password) from another database however I cannot work out how to do it. I have been using this code to do this to open databases without passwords for a while. I am using Access 2007. Any help on how to do this would be great...

I need to lock the first row of data in a Form Datasheet View so that when the user scrolls down it always appears, it also has to stay there when columns are filtered. The reason for this is that the column headings are a number from a crosstab query. The first row contains the actual proper...

and the attachment

Attached is the problem I am having. The image control sets the picture size to the largest image as it runs through the records, so if the largest picture comes first it will set the picture size to this size for all following pictures. Maybe I could sort the records by image size and then...

Hi All, First of all, a big thanks to everybody that has contributed so far. Below is the code that I have found that does most of the job Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If (Me.length) = "0.0265" Then Me.Image18.Picture = Me.path Me.Image18.Visible = True...

Hi Everybody, Thanks for your replies. Maybe there is a code i can put in the onformat event. Just got to work out the code, any ideas? Regards

Hi DCrake, I can't seem to see these controls available for an image control however I can find them for a text box under the Format Tab in the Property Sheet. Is there any other way that you know of? Regards

Hi DCrake, Thank you for the info. When you say the control properties for the image are you refering to the the properties that can be changed in the Report design? If this is not what you are refering to please point me in the right direction. Regards

Hi whitee, Does the exported data in Word show 0 and -1 in the column that shows checkboxes in Access?

Hi All, I was hoping that somebody could help me and I apologize if this question has already been asked. I have a table which I plan to have an OLE Object or Attachment of of a .bmp file in. I want to display the .bmp images in a report which I can do however I want to to either grow or...