Search results

Working now Cheers!!! Thanks for replying Mike. =DCount("[ContactID]","qContactsHist") worked fine, I'm now able to see how many records are returned in the report. Just one more question though, can I make the count unique? Currently it is counting all the instances of ContactID. I think it...

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

Thanks Hi Ziggy1, Thanks for the reply. Yes I could do it as you suggest but I would like to do it this way as there are more criteria I want to add in and I think (though I must admit I'm not really sure) that this method will be more flexible. I think it has something to do with recordsets...

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

Thanks guys just what I needed glad to know your out there!

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

Thanks for that I tried placing it on the OnError event of the form but it does not seem to work. I still get the same message. How do I find out what the error code is for a particular message?

Thanks for the advice RuralGuy could you just be a little more explicit or point me to a page that explains exactly how to do this. Cheers

Thanks for that Pat it worked a treat! No more duplicates. Just a small secondary issue, I was wondering whether it would be possible to replace the Access warning message with something a bit friendlier like - "Sorry, you are already booked in for this course" Is this possible?

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

Cheers for that RuralGuy the DCount() worked just Dandy! Many thanks.

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