Search results

Hi Everyone, I need some help counting records displayed in a report. I have a search form that has two text boxes, txtStartDate and cmbCourseName. These values are passed into a search filter built in VBA which then passes everthing to a blank query that the report is built from. All this...

Can anyone help please? I have a search form that passes 4 parameterers to a query. In the query builder it reads: Like [FORMS].[frmCourseSearch].[txtCourse] & "*" >=[FORMS].[frmCourseSearch].[txtStartDate] <=[FORMS].[frmCourseSearch].[txtEndDate] [FORMS].[frmCourseSearch].[txtCourseID]...

Hi, this problem is probably very simple to solve but I can't seem to find an answer to it. I have created a search form that returns all records meeting the criteria back into the search form. What I want to be able to do is to display the records in a datasheet view. This is what I currently...

Hi could someone point me in the right direction for this one, I have a series of linked tabbed Forms. One of the Forms is mostly populated by Combo boxes which all work fine. My problem occurs when you go to add a new record and populate the form with the combo boxes but decide for some reason...

Hi can anyone help please! I'm writing a course registration Db. I have a have 3 tables at the moment tblContacts [ContactID], [FName], [SName], [Etc..] tblCourseRegistration[RegID] [ContactID][CourseID] and tblCourses[CourseID] [CourseName] [Etc...] These are all linked on a tabbed form. I...

Hi, newbie needs help! I am trying to make a courses registration database. I have 3 tables; tblContacts [ContactID], [FitstName], [LastName] [Etc..] [Etc..] tblCourseRegistration [RegID], [ContactID] [CourseID] and tblCourses [CourseID], [RegID], [CourseName], [StartDate], [AvailablePlaces] I...