Search results

Thanks Boyd, Brilliant, it is just what I wanted, thank you very much. David It seems odd that that is not suggested in the help file examples produced by Microsoft!

Can anyone see the error I am getting in this expression in a query: LastNo: DMax("[BookingFormNo]","DetailNewQuery","[Organisation] = " & [Organisation]) I have a [BookingFormNo] field in the "DetailNewQuery" Query which also has an [Organisation] field. There are about 40 Organisations...

Hi, I have given your problem further consideration and wonder whether a query might not give a better result. If you inserted a new column in the query called, say, Renew, with the following syntax: Renew...

Actually I should also have mentioned that you probably need to do condition 1 -30 and condition 2 -60 since the test is made in the order of the conditions and if it is the other way round condition 2 will never arise, again sorry for the error.

Yes it would, but if you use the < sign (I think it might be the > sign and I'm too tired to work it out, try it by trial and error) it would work for all dates that are less than (or more than) the appropriate amount. Sorry, I should have mentioned that. David

One way would be to use the Conditional Formatting and highlight the various fields when the date is within 60 days of the finish date. In design View of the report, right click on each field that you want to highlight, and chose "Conditional Formatting" then in the resulting Conditional...

Thank you Allan, you are a star. I was sure that it was something like your suggestion, but I could not work out the syntax. Brilliant, it works perfectly. Thank you. David

Hi, I have an unbound text box into which I insert some text and a date, specifically: ="We will keep the date pencilled in until " & [DateEntered]+15 & ". If you would like a firm booking please, before that date, either pay the Discounted Amount or the Booking Deposit." However the...

I have tried several times to upload the amended database, but even though it is within the size constraint, it will not upload. If you care to let me have your email address I will email it to you. David

James The first problem that you must sort out is which fields in the two tables you want to compare. I think it is the field called "Low Proforming" in the table "05 Target Turn Rate" which is a text field although it only holds numbers, and, probably, the field "Turn 12 month" in the table...

Hi, This is similar to my problem at http://www.access-programmers.co.uk/forums/showthread.php?t=165892 I solved it by entering in the criteria line under the relevant field: Like "*" & [Enter Criteria] & "*" It then matched the criteria I had entered with any string part of the relevant...

Thank you everyone for your help. I have now resolved the problem by inserting the following code in the criteria under the [Organisation] field in the relevant query: Like "*" & [Enter Organisation's Name] & "*" It works and solves both my problems. First, if I just hit enter when the...

Thank you all for your help, which has been greatly appreciated, but I have now resolved my problem by the simple insertion of the following in the criteria for the [EventDate] field under the appropriate query: >[Enter Start Date] Or >Date()-1 It works! I had previously omitted the > sign...

Thank you very much. I did look at your attachment but it is far too far advanced for me to understand. I tried looking at the various Forms in Design View to see if that would advance my understanding, but as I did not know for what I was looking I did not find anything to advance it. I am not...

Hi noboffinme, I appreciate your help, but it is not the ability to see all records that is the problem, that I can always do by removing the restriction as you suggest, it is trying to ensure that all records are shown with the restriction in place, i.e. without having to alter the underlying...

I tried it, but came up with a message box that said "Microsoft Office Access can't find the object 'Me.' If 'Me' is a new macro or macro group, make sure you have saved it and that you have typed its name correctly." That shows how limited my experience is on using code. I haven't a clue...

Thank you very much for that hint on Date() rather than Now(). That is appreciated greatly. I have never tried the remainder of your suggestion in the past, but will give it a go. The problem I can see arising, however, is that how do I get it to work for a Report rather than a Form? Thanks

Hi, I have a database with a limited number of Organisations in a field called [Organisation] and I usually need to see what only one of the Organisations in the field has entered against it, so I use the expression [Enter Organisation's Name] in the criteria line of the Design View of the...

Hi, I am no good at programming access code, but reasonable at designing an access database to produce what I require using its inherent design criteria in the Design View of a query. However I have hit a stumbling block which I would like to overcome, if at all possible. I have a date field...

Thanks - I got round the problem by making the calculation a different way, but thanks anyway. David