Search results

report Forgot the dot.. Me.LS11.Visible = True I'm signing off now but if you are still having issues let me or someone else here know. Rick

reports If Dir("S:\Jobs\9322\36-JCSA Pump Station Survey\Shapefiles\ArcGIS\" & me.unitid & ".jpg" <> "" Then Me.LS11.Image = "S:\Jobs\9322\36-JCSA Pump Station Survey\Shapefiles\ArcGIS\" & me.unitid & ".jpg" Me.LS11Visible = True end if Try this.......

pics Assuming the image file you inserted into your report is called imgfilelink ... see attachment

Query? Why are you putting this in a query?

pics Mydirectory is where your pictures are stored. For instance "C:\My Document\MyPics\" Then in The On Print of your detail section of the report it would assign the image in your report the picture stored as "C:\My Documents\MyPics\LS11.jpg" where LS11 is your station field in your detail...

pics If Dir(MyDirectory & [station] & ".jpg") <> "" Then imgFileLink.Picture = MyDirectory & [Station] & ".jpg" imgFileLink.Visible = True End If If you drop an image field into your detail section of the report put the above code in the On Print section. Hope this helps

photo How is each photo and map assigned? By Station? In other words if the station is 001 is the photo stored on the PC as 001photo.jpg? 001map.jpg?

increment newidnumber= DMax("[idno]", "thetable") + 1 me.idno=newidnumber or something similar to the above where you have dimensioned the variable newidnumber

fields I would be surprised if the limit has changed. Either way, that is a LARGE number of fields in a table.

bookings Looks to me like your tblbookings needs to be related to your tblpayments by bookingid

check Try using the dcount function. This allows for a criteria which in this case would be "Yes". There should be plenty of examples in this forum for dcount

query Place a textbox in the detail section of your form corresponding to that number field from the query. Name it MyNumberField In the footer section of that form place a textbox with it's source set to : =sum([mynumberfield])

tables I guess I would have done this slightly differently where: A one to many relationship exists between class and attendees So for each class there are many attendees. That way a simple form with a dropdown box containing all employees could be used for doing a simple search on a query...

autonumber Actually the primary key autonumeric is behaving exactly how it should. Each time a record is added the number increases. Upon deleting records the autonumeric continues on where it had left off before the deletion. There have been many examples of resetting an autonumeric value in...

report In design view of your report under Sorting and Grouping set the grouping to Station Name with header and footer set to yes. I'm assuming each station has a unique name? Then place the other fields in the detail Section of your report.

combo Do you have your Limit To List property of that combo box set to Yes?

thumbs up I make sure all users are aware of stopping the Thumb drive before removing it. I had come across this on the internet some time ago..... When finished, you should stop the USB hardware service before unplugging the device. Note: Windows XP users can just remove the device from...

not in list Here's some code I used but can't remember where I got it from...but works On Error GoTo oops: Dim ctl As Control Dim strSQL As String Dim capitalizefirst ' Return Control object that points to combo box. Set ctl = Me.Event1 ' Prompt user to verify...

Columns Did you try going into page Setup in design view of that report and setting it to multiple columns?

color Does me.label1.forecolor=whatever work?