Search results

I'm trying to add a DATEADD function to a field in a query. It works perfectly when using the stand access arguments for the interval (m, ww, yyyy etc) but when I try to use the field in a table as the interval value I get the error: ADO error 'dbo.evtqvwEventsCartesian.PeriodTypeID' not a...

I'm receiving the above error when running this code, can anyone tell me why it's not working? Set rstBook = GetRecordsetFromSQL("INSERT INTO jmr101.evttblPlacement ( perID, evtID, evtRoleAtEvent, evtNumPlaces, pmtDateAdded, pupYearGroup ) " & _ " VALUES (" &...

Hi, I'm trying to repair part of a database which was set up some time ago. When we moved on sql server 2005 the code below started throwing up this error: Runtime Error '3709' Requested operation requires an ole db session object which is not supported by the current provider. It's on the...

I have a form which includes details about events. There is a unique field: evtID. A button on the form opens a new form where users can view and add/edit evaluations from attendees at the event. At the moment the two forms are linked so that when you press the button to open the evaluation...

I've been left with a database designed by someone else and an import feature where data is imported from excel then checked for duplicates before being inserted into outtblPeople, is not working. I get the following error when the insert is trying to take place. The name "Sname" not...

I recently converted from Access 2003 to 2007 and now I'm unable to delete records in any of the table. Can anyone suggest why this is? Thanks, Lucy

Hi, I have a form for adding room bookings to event records. When I click to add the booking I get the following two messages: Error in GetRecordsetFromSQL Funtion: Number: -2147217865 Description: Invalid Object Name evttblBooking Followed by: Error in VB on evtFrmAddHosp Form: Error...