Search results

Ok Alright, it still is not working. I've sent you a .doc that has some of my data fields in it. and a .jpg to try to attach. good luck. thanks for all your help.

here's a new one when i entered that and i tried to view the report in layout view a box came up saying "enter parameter value" with a large blank to fill in.

with that the program still says that i am missing an operator.

thus because my images name is LS11. the code is If Dir("S:\Jobs\9322\36-JCSA Pump Station Survey\Shapefiles\ArcGIS\" & [UNITID] & ".jpg" <> "" Then LS11.Image = "S:\Jobs\9322\36-JCSA Pump Station Survey\Shapefiles\ArcGIS\" & [UNITID] & ".jpg" LS11.Visible = True end if

I don't mean to be if i am. I'm place this "If Dir(S:\Jobs\9322\36-JCSA Pump Station Survey\Shapefiles\ArcGIS & [UNITID] & ".jpg" <> "" Then imgFileLink.Image = S:\Jobs\9322\36-JCSA Pump Station Survey\Shapefiles\ArcGIS & [UNITID] & ".jpg" imgFileLink.Visible = True End If" in the box next to...

I think i fixed the Extra ( error now it tells me that there is a "Syntax error (missing operator) in query expression '[If Dir(S:\Jobs\9322\36-JCSA Pump Station Survey\Shapefiles\ArcGIS & [UNITID] & "].[jpg" <> "" Then imgFileLink].[Image = S:\Jobs\9322\36-JCSA Pump Station...

If Dir(S:\Jobs\9322\36-JCSA Pump Station Survey\Shapefiles\ArcGIS & [UNITID] & ".jpg") <> "" Then imgFileLink.Image = S:\Jobs\9322\36-JCSA Pump Station Survey\Shapefiles\ArcGIS & [UNITID] & ".jpg" imgFileLink.Visible = True End If

Microsoft Office Access Extra ) in query expression '['Image = If Dir(My Directory & [UNITID] & "].[jpg") <> "" Then imgFileLink].[Picture =My Directory & [UNITID] & '].[jpg" imgFileLink].[Visible = True End If]'. I know that is not the exact query you gave me, but i had to substitute station...

the program says that there is an "Extra (" in the query. Moreover, is there a specfic place i should put all of the images. andrew

OWNER ID LOCATION ADDRESS UNITID JCSA LS 1-1 Jamestwon 1607 1861 Jamestown Road LS11 There is an example of some of the information. i have a photo called LS11.jpg and a map LS11.pdf or it can be a map LS11.jpg which ever works.

photo Yes. each station has a photo and map that are stored as the stations name.

even with the the dbf sorted the image that i insert still appears the same. . .

I have a .dbf spreadsheet and some photos and maps. Listed in the spreadsheet are 76 or so stations. each stations has a different photo and map. I want to be able to have one page in my report devoted to each station. On the report page would be a photo, a map, and all the important fields in...