Search results

I had a similar problem when WinXP users began using my Win2K Database. As far as I remember I just imported all of the Forms, Reports, queries etc. into a new database which fixed the problem. Out of curiousity - Are there any new OS versions accessing your db? Regards, Patrick

You can use the VbNewLine Constant. = "Title" & VbNewLine & Date() HTH, Patrick

Looks like just what I'm after. I'll give it a go. Thanks again, Patrick.

Thanks for your suggestions dcx, Like music to my ears - making it really easy is right up my street, I can be pretty flexible on the partitions - could you elaborate some more on how you'd use the Partition Function? Thanks, Patrick.

Hi, I have a query showing Support response times in days. It returns the amount of days for each record in the database based upon the DateDiff of two dates. I'd like to be able to view this information based upon criteria, I.e. I want to see a count of records between 0 And 50, between 50 And...

Just before I leave.. Here is another quick n' dirty example which uses a Dlookup to get the Client name from the table. Each time you want to change the Client Name just change the Client name in the table. If you Open the Report you'll see what I mean. Is this a solution?

The problem seems to be with assigning values to controls on Reports in general. I'll have a look into it for you. If I don't post back this evening I'll post tomorrow morning. Regards, Patrick.

There is always a simpler way.. If you have a look at the quick n' dirty attached example you'll see. If you set the ControlSource of the Report textbox to a textbox on the form from which you are opening it then it works. Hopefully this'll do the job for you.

Give me a minute & I'll try to replicate what you are doing.

1. You don't need anything in the ControlSource of the TextBox - it is Unbound 2. The reason you are getting the second error is because you are performing an assignment statement in the general declarations section of the Module. try this out: In the Module, leave your Public strTownship as...

Have you got the code in the Report_Open event? I.e. Private Sub Report_Open(Cancel As Integer) txtTownshipName = strTownship End Sub

If you declare a Public variable in a Module then the contents of this variable will be available to all of your reports. Public strClientName as string Declares a string variable called strClientName In each Reports Report_Open event you can assign the value of strClientName to a textbox on...

Go to Tools-Options & check 'Show Hidden Objects' This will show any hidden items in the db window. HTH, Patrick.

I'm Sorrrrry Can you feel the sincerity? Look in the mirror. :D

And I thought we were pals.... :D

[YourReportName].FilterOn = True Should turn on the Report Filter HTH, Patrick

Something to bear in mind is that you cannot trap errors in macros. If you wish to trap these errors you will have to convert your macros to VB. Just to explain a little bit further the concept of Error handling; When an Error occurs the 'Err' object is called. The Err object contains...

Slightly?????? There were spam posts on every board including one which was, as far as I remember entitled 'I Win' which stated that you were the latest poster on every board. That REALLY got on my nerves. As far as I remeber it was then that I called you an Illiterate muppet :D

Sorry.. But I still think you're a Muppet. :cool:

Hi Len, I had a similar task, what I did was create list boxes for each of the criteria. In my case 'Project', 'Assignee', 'Status' etc... The Report contains static fields but the query returns only relevant information based upon the criteria selected in the lists. I did this by writing a...