Recent content by djcritter

Hello Any hellp would be appericated. I have a pass thorugh query that connets to a Oracle database with a where clause with a between start date and end date. I need the start date and End Date to come from a form within MS Access. Is this possible? if so how do I code the where clause to...

Hello I have a field called [Hours] If a user tries to change the [Hours] I need to check if any of these hours have been assigned to staff in another table. How do I get to run the query and use the value from the result of the query as the Minimum value? I would like to run sql and if the...

You could try using the IIF expression. Not sure if it will work the way you want it to but always helps me replace a null value with a figure.

Please help ME!!! I've got a data entry form with Bridge details and a separate form which contains all the construction data for the bridge. All data is stored in SQL server and the front end is in MS access. Since moving the data to SQL when a new construction is added to a bridge the data in...

That change did not work but thanks any way. I've changed the code a bit here it is now. Private Sub PHOTO1VIEW_DblClick(Cancel As Integer) Dim RetVal Dim PathToFile As String PathToFile = Me.PHOTO1Path RetVal = Shell("C:\Program Files\PhotoEd\PHOTOED.exe pathtofile", 1) End Sub

I've got the location of an image in a text box on a form and i have the image showing on the form in a image box but i want it to act like an OLE object so that when the image is double clicked it opens the image in photo editor. I can get photo edit to load but can't get the image to open...