Search results

solved it.. with a little help from this page http://www.tech-archive.net/Archive/Access/microsoft.public.access.adp.sqlserver/2006-10/msg00120.html basically the @ parameters are left in the sql query. On the report set the input parameters property to similar to the following. @Driver...

zip in the help file and googling brought up very little

seems to accept the structure now James but it kicks with 'ADO:'cdate' is not a recognized built in function name. is their an ado equivalent?

thanks for the suggestion james but this erros with the following Error in list of function arguments: '!' not recognized. Error in list of function arguments: ')' not recognized. Unable to parse query text.

I tried changing the text from BETWEEN @StartDate AND @EndDate to Between [forms]![RPT Driver Criteria]![StartDate] AND [forms]![RPT Driver Criteria]![EndDate] but it will not accept the text stating your entry cannot be converted to a valid date time value

Hi.. I have the query below setup in my access adp project. It works, ok but rather than have the standard prompts I want the sql stored procedure to use the details from an unbound form. I have the form setup but unsure of the sql code. Does anyone know how to achieve this? SELECT...

many thanks for the help chaps... worked a treat.!

Thanks for your help guys.. sorry for delay getting back to you.. your suggestions worked a treat.. One last thing I'm slightly confused about that you may know about as I have this little search linked to the Onclick event of the calendar is the dtmDate value seems to be running before the...

thanks chaps I'll give this a shot..

I'm getting an error on the highlighted field as this in a different table called Jobspec not the holidays table dtmDate = Nz(DLookup("[Holiday Dates]", "[Holidays]", "[Job Date] = '" & Format(Me![Job Date], "dd/mm/yyyy") & "'"), 0)

nice one , thanks leigh,, I'll give it a shot

leigh how can i get the dtmDate value, I'm trying to find a record in my table holidays [holiday dates] that equals the job date field on my form

this is an access adp project, and I already have other ado procedures working so figure this isn't necessary re the format i removed this as it wasn't necessary so just have rs2.Find "[Job Date] = Holidays![Holiday Dates]" still the arguments error

hi thanks for the response.. the holiday table is in the same db tho Dim rs2 As ADODB.Recordset Set rs2 = Me.Recordset.Clone rs2.MoveFirst rs2.Find "Holidays![Holiday Dates] = [Job Date]" If rs2.BOF Or rs2.EOF Then Me.EditJobsfrm.Locked = False Else Me.EditJobsfrm.Locked = True...

Hi .. I'm trying to do something pretty basic (I think) and just wondering if anyone can help me.. I wish to search a remote table (holidays) that contains a list of dates for a date value that is given on my current form.. if its there I wish to lock the subform I have for editing.. but I'm...

Thanks Gizmo.. But I cannot do in 2 processes as this query is called from outside access i need to perform the action in one procedure..

Hi I am looking to return a value in a column of my query if the query returns no results, figuring this will need to be done with a stored procedure... does anyone know how to perform this the query i have is shown below that works fine if a job exists, all i wish to do is if no results are...

cool.. thanks for you help though leigh.... i'll have a good look around for something already out there.. sure there must be someone that has done something similar...

Thanks .. Leigh I have only this working on my .mdb at the mo, haven't created the server function yet.. The function and query I have for the .mdb are shown below. I need to re-create this if possible on my sql server.. The results of the query do not need to be updateable. Function...

.well I'd rather not convert as the database is built and runs ok.. the only problem i had, is i need to access the data outside of access [program called datapoint by presentation point] and a number of my queries are using a user defined function as criteria... as I understand it the ole...