Search results

When I click a button on my switchboard, it opens a Contacts form with a list of contacts. The contacts form source is controlled with this code: Private Sub Form_Load() Select Case intWhichForm Case 1 Me.RecordSource = "qry1" Case 2 Me.RecordSource = "qry2" Case 3...

Thank you. :)

Whenever the focus switches to my switchboard, I want the calculated fields on it to be updated with the up-to-date values. They have dcounts based on queries. What event do I use and what code to update the values? Thanks, Dave

What a fantastic solution! Very clever. Thank you! I couldn't work out how to do it. I love it when someone does an innovative solution like this. It is almost art! :)

I agree that would be a good solution, but I don't have that option at present. What alternative method could I use to filter the data? I am thinking that maybe there needs to be some type of grouping going on using a totals query. Or perhaps bringing in another table and use a join to get...

I am not sure that is quite what I am looking for. Consider the following data: Customer, Date, Activity Type 1, 1/1/10, Mailshot 2, 3/1/10, Post Out 4, 4/1/10, Mailshot 4, 6/1/10, Mailshot 5, 7/1/10, Post Out 1, 8/1/10, Post Out The filtered list should not show Customer 1 because they have...

I have an Activity Log table with the following fields: ActivityID Customer Date Activity Type Details Contact Success I want to filter for Customers where there has never been any "Post Out" entries in the Activity Type field. I can't just do a filter for Post Out because it would then show...

I have two Queries that I would like to join and I presume I need a Union Query. 1. Me.RecordSource = "Jon Outsourced Contacts Requiring Touch" is what I use for the Form RecordSource. Do I need to create another Query or do I put SQL as the RecordSource? 2. I want the records displayed to be...

Thanks Bob for your excellent suggestions. We are waiting for the beta version of vBulletin 4.0 publishers suite to come out and might go for it early, without waiting for the most stable release. It is a huge task, since we will have to recreate the entire site structure. But, I think it is the...

You were right Brian, got it working. But think I should add 3 instead, to take it into 4 months. Clever solution and mucho thanks.

I'm not getting much joy with that. Are you aware that it is a text field? Do you mean put... =Format(DateAdd("m",4,Date()),"mmmm") ...in the criteria field?

It is just those who are expiring 4 months ahead. So yes, at this point in time, I just want March expirers. At least that is what the client is currently saying! lol

I have done this, but get a null error. How can I prevent that? Query criteria: =MonthIn4([Month Contract Expires]) Public Function MonthIn4(txtMonth) Select Case txtMonth Case "January" MonthIn4 "May" Case "February" MonthIn4 "June" Case "March"...

namliam, I didn't go for your original idea because as you stated, it needs a real date. But the client has only the month as text. Therefore, my suggested solution would work but yours wouldn't, unless I changed the field or data entered. But I appreciate all help given.

What about the method I suggested. Can you see any reason why that would not work?

Well, maybe I need to do something in code perhaps? e.g. if the current date was November, I would need to filter by November+4=March. So maybe Select Case statements that return the month to filter by and have a function in the query criteria. Would that work?

Let me clarify what they want after further conversation. The field will just show the month. e.g. January, February etc. The field is "Month Contract Expires". And I think they want to find out which are due in 4 months time. They look like annual contracts.

I have a client with a text field with the month written in it. But they want to create a Query where they can search for records over 4 months old. What do you suggest I do? Thanks, Dave

Is using DCount too slow? Is using some other method faster?

I have a Switchboard where I want to have 3 values displayed, which are the results of 3 separate queries combinations. #1 is based on Query A2 which is base on Query A1 based on Table A #2 is based on Query B2 which is base on Query B1 based on Table B #3 is based on Query C2 which is base...