Search results

Have done this another way, now: two images one over the other, one stretched and one on zoom, with the following in the Format event of the Detail If Right(PhotoAddress, 3) = "bmp" Then Me!bmpImage.Visible = True Me!jpgImage.Visible = False Else Me!bmpImage.Visible = False...

I have been given a set of photos to use in a report. The 900 or so files of type *.bmp are all distorted and so I'd like to set the Size Mode under Format to stretch. However, all the jpeg files (about 200 of them)are fine, so I'd like to set the Size Mode to Zoom. I'd like something like...

I have a report which shows photos in four columns. The photos are grouped with a group header. I'd like each new group header on a new page (no problem) but would like it to go right across the page and to start on the left hand side of the page (no luck). At the moment, if the last photo is...

Will look up Zoom boxes, thank you - I haven't heard of them! Using the [Forms]!etc didn't work - it couldn't find the field forms - or didn't upport this method - depending on where I put the code Thanks for the help -am on my way to look up Zoom

I have a form containing a subform. Each line of the subform contains a memo field "Notes". There is inadequate room on the subform to enter data into this section so I'd like the current record's "notes field to be duplicated asd a field on the main form. Can anyone help me do this,please? I...

Just another request for any help with this one - I'm still drawing a blank in books, the help files, the web... Does anyone have anything that might help me get going on this? An example to look at that works would be good. Please excuse my persistence in reflagging the problem Many thanks

I have a table in which each record contains assignment results for an individual. I want to create a scattergraph plotting the value of one field (ETot)for each record against thae vale of another (MTot). I can do this in Excel but I am drawing a total blank in Access - I get the total of...

Thanks - that was an interesting that I can use elsewhere. The trouble is in the example I gave, I need the list alphabetical by surname and can't have it grouped by [Ability level].

I'm setting intStandardCount(1 to 4) to zero in my report header and then have the following in On Format for the detail If FormatCount = 1 Then Select Case [Ability level] Case Is = "B" intStandardcount(1) = intStandardcount(1) + 1 Case Is = "I" intStandardcount(2) =...

Thanks, Travis - this doesn't quite fit what I have done but maybe my structure is poor here. I wanted to avoid a subform (for the sake of appearances) and so have a table with fields: name (lookup from main participants list) and then the successive question numbers so that students enter 1,2...

I have a form which gathers student choices (1,2,3 or 4) for each of 10 different questions. I want to know how many of each response there is for each of the questions so I can put this into a report. I want to get: Question1 - 3 people answered 1, 4 answered 2... Question2 - 5 answered 1...