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...

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 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...

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 &...

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...

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...

I'm creating a booking system for course and I'm using the following code to reduce the places available by 1 when someone else is booked on a course: SearchID = intCourseDetails DoCmd.OpenForm "frmCourseDetails" DoCmd.GoToControl "intCourseDetails" DoCmd.FindRecord SearchID...

I'm using the code Forms!frmMainBooking!frmBooking.Form!intCourseDetails = [intCourseDetails] to copy an integer from one subform to another. It works fine but I'm not sure how to initiate it. I've got 3 subforms, in 1 the user selects a course from a drop down box, this loads another form...

Is there any way of starting with a new record when a form is opened rather than record number 1?

Is it possible to apply an image to the background of a form or object in a form (such as a rectangle) rather than just a solid colour? If so, how?

Hi, I'm having some issues querying a sub form. I'm using a combobox (in a subform) which supplies some search criteria. I'm using the query Like [Forms]![Employee]![Course Subform].[Form].[Combo12] & "*" but its simply not working. Can anyone see any glaringly obvious mistakes?