Search results

I've checked the forum but can't fand an answer to my particular problem. I'm getting this error on the following line of code: If (DCount("*", "qryEmployeeAvailability") = 0) Then I use this syntax throughout most of my db and don't get any problems. I've tried importing all items into a new...

Thanks, works great!

Thanks, I knew it needed to be referenced somewhere but I didn't know how to do it

I'm compiling a string which needs to display " at various points but vb obviously thinks this is the end of the string. How do I get vb to recognise it as part of a string and not the end of the string?

I've currently got a system that sends out emails using SendObject, but as they are only rtf there is very little room for personalising them. I've had a quick look on here about html emails and people are using: Dim objOutlook As Outlook.Application Dim objMsg As Outlook.MailItem Set...

I've tried to use the automated creation of a left join in a Access Query but it now thorws error 3258. I've attempted to split the SQL statement into two with no luck, can anyone split it for me please? SELECT tblCourseDetails.intCourseDetails, Count(tblBooking.intBooking) AS CountOfintBooking...

I've tried to create the left join but it now throws error 3258. How can I split my SQL into 2 seprate queries? SELECT tblCourseDetails.intCourseDetails, Sum(tblBooking.attended) AS SumOfattended FROM tblEmployee INNER JOIN (tblCourseDetails LEFT JOIN tblBooking ON...

Great,thanks, but it still omits the entrie record when no records are returned. Is it possible to display 0 so the course is completely ignored?

Is it possible to invert it to become positive? That would sort out another problem I'm now having. If any of the search criteria return no records, non of the results from the entire course are displayed. e.g. if everybody who was invited attends the course, the course is omitted!

Right, I've used the 'Group By' and 'Count' functions to work out the values as required, however attended, confirmed, etc are all yes/no and it counts the record for either answer (despite putting True in the criteria). What am I doing wrong? I've included a pic of the query >

I've developed a course booking system in Access and am now looking at creating a number of reports. When people are invited to a course they are asked to confirm if they will be attending, then an attendance record is kept. I'm trying to produce a report listing number of invites, confirmed...

Anyone? Some sample code would be perfect!

I'm currently using a very basic sendobject function to email employees when they are booked onto a course > DoCmd.SendObject acSendNoObject, , , Forms!frmMainBooking!frmFullEmployeeDetails.Form!txtEmail, , , "Booking Confirmation (Ref - " & intReference & ")", _ vbCrLf &...

Brilliant, thank you!

I think I know where you are going with this but how do I check each record from start to finish? I pressume I need something along the line of: While not at end of records DoCmd.GoToControl "intEmployee" If intEmployee = Parameter1 then DoCmd.GoToControl "intCourse" If intCourse = Parameter2...

Thanks for the reply but my query already runs fine and successfully finds if an employee is already booked on a course. My problem is telling my form if the record already exists. This is the code I have used when clicking the 'book' button (everything is bold is what I'm trying to achieve)...

I'm really not sure how to go about this. I'm creating a course booking system and when creating a booking I need to check for current bookings with the same employee and course id's (i.e. the employee is already booked on the course). The query takes the employee and course id's from a form...

Anyone? I can't seem to find anyway to return a true oe false value

Oh, and it would be preferable if I could get a return that is True or False if possible.

I've got a form called frmBooking that I want to search (proabably using DoCmd.FindRecord). It has 2 fields, 1 for employee id and 1 for course id (and a third which is the booking id). I'm using employee id and course id to create a booking record (to book them on a course) so I want to search...